Metabase
Follow these steps to connect your Metabase to Select Star.
Last updated
Follow these steps to connect your Metabase to Select Star.
Last updated
To connect Metabase to Select Star, you will need...
Admin account in your Metabase instance.
You can connect cloud and on-prem Metabase to SelectStar.
1. Go to your Metabase instance and in Admin Settings and go to Groups to Admin and select Create a group
2. Now go to People and invite a new user. Email address can be of any domain.
3. Click Create and save the password and email, they will be needed later.
4. Group Permissions - Database permissions.
In the top navigation tab select Permissions and then choose your group. For this group please set the permissions for Data Access to unrestricted.
This step is required to be able to display your data lineage.
Then click save.
5. Group Permissions - Collections permissions.
Next, still in Permissions tab, select Collections and choose Our Analytics collection.
Next click save changes.
6. [Pro & Enterprise Plans] "Metabase analytics" Collection Permission
For users on Pro and Enterprise plans of Metabase Cloud, enable at least "View" permissions for the "Metabase analytics" collection. This collection includes view-only questions, dashboards, and models that allows us compute popularity scores for Metabase objects in your instance.
7. Remember to click Save to confirm the changes.
Creating user for SelectStar in your database.
We will need a database user, which we can use to connect to your PostgreSQL database, where Metabase stores its information.
<password> here is only a placeholder, please replace this value with a strong password.
1. Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.
2. Fill form in the required information:
Source Type: Select "Metabase"
Display Name: This value is Metabase by default, but you can override it if desired.
Url: Url for cloud or on-prem Metabase instance.
Username: Email that was created in step 1 in your Metabase instance.
Password: Password that was generated in step 1 in your Metabase instance.
3. Click Connect.
Please choose type of your Metabase instance.
When cloud was selected please click Next. Your metadata should start loading automatically. Please allow 24-48 hours to completely index all metadata and generate popularity and lineage. When the sync is complete, you'll be able to explore Metabase in Select Star.
That option can be used also for self-hosted Metabase Pro and Enterprise plans.
When choosing on-prem Metabase integration, please fill out the details of your PostgreSQL database for us to use it.
IP Whitelisting
For any instance protected by a firewall, you must whitelist the following two IP addresses to connect Select Star.
Once you have filled the credentials please click Connect. Your metadata should start loading automatically. Please allow 24-48 hours to completely index all metadata and generate popularity and lineage. When the sync is complete, you'll be able to explore Metabase in Select Star.
If you are interested in using a different database please contact our sales team.
Select Star will automatically map detect the connection type for each of your connections in Metabase, however, if you are connecting to different instances or datasources, you might need to adjust this:
Go to Settings
Click on Data
Click on your Metabase data source
Switch to the Connections tab
Make sure the checkbox for the connection is checked
Make sure the Select Star Datasource is correctly selected
Choose for our group that we have created permission View and also enable Also change sub-collections switch.
