This tutorial will help you connect to Tabular from Starburst Galaxy, a managed SQL engine from the creators of Trino.
For this tutorial, you’ll need to have a Tabular account and a Starburst Galaxy account.
Both services offer free accounts that you can sign up for by clicking the links below:
In Tabular, you’ll need to create a credential that allows Galaxy to connect to a warehouse.
This tutorial will connect the
sandbox warehouse, which is hosted by Tabular and available by default in new organizations.
To use a specific warehouse, select it before moving on.
Select Create a credential
2. Add a name for the credential, “Starburst galaxy”
Enter a name for the credential
3. Click the copy icon to copy the credential to your clipboard
Next, you’ll create a catalog in Starburst Galaxy that uses this credential to authenticate with Tabular.
In Starburst, the first thing you’ll see is the query editor, with a menu on the left.
The first step is to add a Tabular warehouse as a Galaxy catalog.
1. Click on Catalogs in the menu
2. Click the Create catalog button
Select Create catalog
3. Select the Tabular tile
4. Enter catalog details, a Tabular credential, and click Test connection
Fill in the catalog details, including a name for the catalog in Trino and the Tabular warehouse name.
Use the Tabular OAuth credential you created in Tabular above to authorize the connection. When you’re ready to continue, click Test connection.
5. Click Connect catalog to continue
Once the connection test is passing, click Connect catalog to continue Galaxy setup.
6. Set up access roles and save
After adding the catalog, you can configure roles that have access to the catalog.
When you’re finished adding roles, click Save access controls.
7. Add the catalog to a cluster
To use the new catalog with a cluster, select one or more clusters in the drop-down. Then select Add to cluster.
sandbox warehouse is located in the us-east-1 region and can only be used with clusters in that region.
8. Go to the query editor
After adding the catalog, you’ll see a confirmation window. Select Query my data to navigate to the query editor.
9. Explore example tables
In the query editor, run
use examples and
show tables to list example tables in Tabular that you can query. You’ll see the
nyc_taxi_yellow table and other examples.
Congratulations, Starburst Galaxy is configured to use Tabular!
Next: Learn more about data warehouse features
Now that you have Starburst Galaxy set up to work with Tabular, you can learn more about data warehousing in Trino from the Trino and Apache Iceberg tutorial.
This tutorial was originally published on Tabular.