Last Updated: 2024-01-04
Tabular is an open table store that leverages the Apache Iceberg open table format. It allows Iceberg tables to be created and accessed by a variety of analytics platforms and engines, including Starburst Galaxy.
In this tutorial, you will learn how to configure a Tabular catalog in Starburst Galaxy.
Once you've completed this tutorial, you will be able to:
Starburst tutorials are designed to get you up and running quickly by providing bite-sized, hands-on educational resources. Each tutorial explores a single feature or topic through a series of guided, step-by-step instructions.
As you navigate through the tutorial you should follow along using your own Starburst Galaxy account. This will help consolidate the learning process by mixing theory and practice.
Tabular allows you to register for a free trial account. The best way to do this is to use a Google account. If you do not have a Google account, you can register for one here.
The Tabular trial account includes a default warehouse called sandbox
and a database called examples
with four sample tables in it.
Tabular makes it easy to sign up for an account directly from the landing page of their website.
Signing up for Google is the best way to set up a free Tabular account.
You can use any active Google Account.
Confirm that the Google Account you have selected is correct.
The first time you access Tabular, you must confirm that you aren't a bot.
Your Tabular account includes an organization name. By default, this is generated from the name of your Google Account.
The last thing you need to do before you can use Tabular is to create an access credential. Credentials provide organization members the ability to configure authentication between various compute environments and the Tabular catalog.
Later in this tutorial, you will use this credential to connect Tabular to Starburst Galaxy.
Credentials can be used for multiple purposes. In this tutorial, you're going to set up a credential that helps you connect Tabular to Starburst Galaxy. Later, we will use this to establish the connection between the two systems.
Tabular automatically generates the new credential.
Note: It is very important to securely save this credential for future use. You will not be given another chance to save it, and you will need it to connect Tabular to Starburst Galaxy.
New Tabular accounts include a default warehouse, known as sandbox
. You will use this warehouse in this tutorial.
The default sandbox
warehouse includes several databases inside it. Check out the examples
database to see which tables are included in it.
The examples
database includes several tables inside it.
examples
database. Now it's time to pivot over to Starburst Galaxy to begin the process of connecting your Tabular datasource.
Starburst Galaxy separates users by role. Configuring a new catalog will require access to a role with appropriate privileges. Today, you'll be using the accountadmin role.
This is a quick step, but an important one.
Sign into Starburst Galaxy in the usual way. If you have not already set up an account, you can do that here.
Your current role is listed in the top right-hand corner of the screen.
Adding a new Tabular catalog follows the same process as adding other data sources in Starburst Galaxy.
The steps below will show you how to start the process of configuring a new catalog.
Create a new catalog for your Tabular datasource.
Starburst Galaxy allows the creation of catalogs for a number of different data sources. In this case, you are going to create a new catalog in the Tabular category.
The catalog needs both a name and description. This ensures that you can find it later.
When you connect Starburst Galaxy to a new data source, it is necessary to undergo an authentication process. This helps ensure that you are connecting the right data source and that you have the appropriate permissions.
Now it's time to connect Starburst Galaxy to your Tabular account.
sandbox
is the warehouse name.Every new catalog connection includes a test before you connect it. This helps to ensure that you have input the correct credentials and allows you to quickly fix any problems before actually connecting.
You're almost there! Time to test the connection and then complete the process of creating your new Tabular catalog.
Starburst Galaxy allows you to configure your catalog in a number of ways regarding access controls. The most important of these involves granting write access or restricting the catalog to read-only access.
Take some time to consider whether you require write access, or whether read-only access will be sufficient.
Select the appropriate read access for your situation.
The catalog is now created, but you are not able to use it until you add it to a cluster. Clusters can include many catalogs. You can either add the new Tabular catalog to an existing cluster, or do this at a later stage.
You can add a catalog to a cluster at any time.
Congratulations! You have reached the end of this tutorial, and the end of this stage of your journey.
You're all set! Now you can query the data using Starburst Galaxy and Tabular.
At Starburst, we believe in continuous learning. This tutorial provides the foundation for further training available on this platform, and you can return to it as many times as you like. Future tutorials will make use of the concepts used here.
Starburst has lots of other tutorials to help you get up and running quickly. Each one breaks down an individual problem and guides you to a solution using a step-by-step approach to learning.
Visit the Tutorials section to view the full list of tutorials and keep moving forward on your journey!