Metabase

1. Create an API Key

2. Connect Metabase to Select Star

3. Adjusting connections

1. Create an API Key

1. Click the gear icon (⚙️) in the top right, then select Admin settings.

2. In the left-hand menu, click on Settings, then Authentication.

3. Scroll down to the API Keys section and click the Manage button.

4. Click the Create API Key button.

5. Create a new API Key:

   • Key name: Give it a descriptive name.

   • Select a Group: Select Administrator.

Metabase will generate and display the API key. Store this key securely, you won't have access to it again later, and if you lose it, you'll need to regenerate it (which invalidates the old one).

2. Connect Metabase to Select Star

Next, you will add Metabase as a data source. Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.

Choose Metabase in the Source Type dropdown and provide the following information:

• Display Name: The name you want to give to your new data source.

• Url: The URL of your Metabase instance.

• API Key: The API Key generated on step one.

Click Save to proceed.

Choose Your Metabase Deployment Type

Specify whether your Metabase instance is cloud-based or on-prem.

Cloud

If you select Cloud, simply click Save. This option is also suitable for self-hosted Metabase Pro and Enterprise plans where Metabase manages its own database.

Upon saving, your Metabase metadata will begin loading automatically into Select Star. Please allow 24-48 hours for complete indexing, popularity score generation, and lineage mapping. Once synchronization is complete, you can start exploring your Metabase data within Select Star.

On-Prem

1. Create a dedicated PostgreSQL database user that Select Star will use to access your Metabase's internal database.

   Copy

   create user selectstar;
   alter user selectstar password '<password>';
   grant connect on database metabase to selectstar;
   grant select on table query_execution to selectstar;

2. Provide details of the PostgreSQL database where your Metabase instance stores its internal information. After entering the database credentials, click Save.

Your metadata will begin loading automatically. Please allow 24-48 hours for complete indexing, popularity score generation, and lineage mapping. Once the synchronization is complete, you can explore your Metabase data within Select Star.

3. Adjusting connections

Select Star automatically attempts to detect connection types for your Metabase connections. However, if you are connecting to different instances or data sources, you may need to adjust these mappings manually.

1. Go to Settings

2. Click on Data

3. Click on your Metabase data source

4. Switch to the Connections tab

5. Make sure the checkbox for the connection is checked

6. Make sure the Select Star Datasource is correctly selected