×

Tutorial: Connecting Starburst Galaxy to Tabular

Last Updated: March 18, 2024

 

This tutorial will help you connect to Tabular from Starburst Galaxy, a managed SQL engine from the creators of Trino.

Prerequisites

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:

Tabular

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.

1. Click on the 3-dot menu in the upper left and select Create a credential

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

Copy the credential key and secret

Next, you’ll create a catalog in Starburst Galaxy that uses this credential to authenticate with Tabular.

Starburst Galaxy

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

Select Catalogs in the Galaxy menu

2. Click the Create catalog button

Select Create catalog

3. Select the Tabular tile

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.

Enter catalog details, your credential, and click Test connection

5. Click Connect catalog to continue

Once the connection test is passing, click Connect catalog to continue Galaxy setup.

Click Connect catalog when the connection test passes

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.

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.

Tabular’s sandbox warehouse is located in the us-east-1 region and can only be used with clusters in that region.

Add a cluster and continue by selecting Add to cluster

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.

Go to the query editor using the Query my data button

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!

Test out some queries

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.

Start Free with
Starburst Galaxy

Up to $500 in usage credits included

  • Query your data lake fast with Starburst's best-in-class MPP SQL query engine
  • Get up and running in less than 5 minutes
  • Easily deploy clusters in AWS, Azure and Google Cloud
For more deployment options:
Download Starburst Enterprise

Please fill in all required fields and ensure you are using a valid email address.

s