LogoLogo
About UsCustomersResourcesGet Started for Free
About UsCustomersResourcesGet Started for Free
  • What is Select Star?
  • 🏁Getting Started
    • 1. Data Source Setup
    • 2. Mark Service Accounts
    • 3. Hide Unwanted Datasets
    • 4. Invite Owners
    • 5. Add Documentation
    • Next Steps
  • 🔄Integrations
    • Snowflake
      • Using Key Pair Authentication
      • Using Password Authentication
      • Snowflake Tag Sync
      • Snowflake Key Pair Rotation
    • Databricks
      • Databricks on AWS
      • Databricks on Azure
    • BigQuery
    • AWS Redshift
      • Manual setup
    • Microsoft SQL Server / MS SQL (beta)
      • Query Logs
    • MySQL (beta)
      • Query Logs
    • Oracle (beta)
      • Query Logs
    • Salesforce (beta)
    • DB2 (beta)
    • PostgreSQL
      • AWS Aurora PostgreSQL
      • AWS RDS PostgreSQL
      • PostgreSQL on-prem
    • AWS Glue (beta)
    • dbt
      • dbt Cloud
      • dbt Core (open source)
      • dbt Tags
      • dbt Tests
      • dbt docs Sync
        • Github dbt docs Sync
        • Bitbucket dbt docs Sync
      • dbt Impact Report
      • dbt Project Dependencies
    • Apache Airflow (beta)
    • Tableau
      • Tableau Cloud
      • Tableau Server
    • PowerBI
    • Looker
    • Metabase
    • Fivetran (beta)
    • Mode
    • Sigma Computing
    • Sisense / Periscope (beta)
    • Looker Studio (beta)
    • ThoughtSpot
    • QuickSight (beta)
      • Event Logs
    • Hex (beta)
    • Slack
    • Monte Carlo
    • Private Network
    • Request an Integration
  • ✨Features
    • Search
    • Table Page
    • Database Page
    • Dashboard Page
    • Data Lineage
    • Entity Relationship Diagram (ERD)
    • Queries & Joins
    • Tags
    • Teams
    • Discussion
    • Downstream Notifications
    • Documentation
      • Pages
      • Metrics
        • Metrics Generation
      • Glossary
    • Automated Documentation
    • User Analytics
    • Chrome Extension
    • Source Tables
    • Cost Analysis
    • Schema Change Detection
    • AI Features & Settings
      • Ask AI Chatbot
    • Request a Feature
  • 🧭Data Discovery
    • Where's my data?
    • Where's my dashboard?
    • How can I get the full context of this data?
    • My dashboard looks off
    • Change management
    • I'm new to the team
    • I have a data question
  • 🗃️Data Management
    • Add Documentation
      • CSV Metadata Upload
    • Collections
    • Tags
    • Data Ownership
    • Sensitive / PII Data
    • Automated PII Detection
  • 📚Learning Data
    • Getting Started: Looker
    • Getting Started: Mode
    • Getting Started: Tableau
    • Getting Started: Snowflake
    • Getting Started: Databricks
    • Getting Started: Data Warehouse
    • Getting Started: BigQuery
      • Nested Fields
    • Getting Started: Sigma
    • Getting Started: ThoughtSpot
  • 🛠️Data Source Management
    • Manage Data Sources
    • Connect Data Source Users to Select Star
    • Custom Attributes
    • Recent Queries
  • 👥User Management
    • Invite Users
    • Roles & Permissions
    • SAML SSO
    • Importing Roles and Teams (Okta)
    • Policy Based Access Control
    • Account and User Settings
  • 💻Select Star API
    • Overview
    • API Token
    • Getting Started
    • Rich Text Descriptions via API
    • Troubleshooting
    • API Examples
    • API Reference
  • 🔓Security & Compliance
  • ❓FAQ
    • Icon Map
  • 📰Changelog
    • April 16, 2025 - Semantic Models, AI Metrics, and More!
    • March 12, 2025 - Fivetran Integration, Tableau Updates and More!
    • February 6, 2025 - Collections, Slack App Published, Salesforce Formula Lineage and more!
    • December 10, 2024 - Hex Integration, Impact Score & Snowflake Key Pair Authentication!
    • November 13, 2024 - New Navigation, Airflow and More!
    • September 30, 2024 - Upstream Data Quality Issue Tracking & 5 New Integrations!
    • August 30, 2024 - Monte Carlo, dbt Cross-Project Lineage
    • July 31, 2024 - Glossary Import, Lineage Updates & more!
    • July 9, 2024 - Lineage Explorer 2.0, Slack AI and Notifications
    • February 29, 2024 - AI Chat, Schema Change Notifications
    • February 23, 2024 - Manual Lineage Creation
    • November 23, 2023 - Bulk AI Documentation
    • October 19, 2023 - Downstream Notifications
    • October 16, 2023 - New Homepage
    • October 13, 2023 - dbt Impact Report
    • Historical Changelogs
  • Security & Compliance
  • System Status
Powered by GitBook
On this page
  • Before you start
  • 1. Create Service Account
  • 2. Creating database user for SelectStar. Only for on-prem integration.
  • 3. Create a new data source
  • 4. Choose cloud vs on-prem
  • 5. Adjusting connections

Was this helpful?

  1. Integrations

Metabase

Follow these steps to connect your Metabase to Select Star.

PreviousLookerNextFivetran (beta)

Last updated 3 months ago

Was this helpful?

Before you start

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. Create Service Account

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.

2. Creating database user for SelectStar. Only for on-prem integration.

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.

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

3. Create a new data source

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.

4. Choose cloud vs on-prem

Please choose type of your Metabase instance.

4.1 Cloud

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.

4.2 On-prem

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.

3.23.108.85
3.20.56.105

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.

5. Adjusting connections

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:

  1. Go to Settings

  2. Click on Data

  3. Click on your Metabase data source

  1. Switch to the Connections tab

  2. Make sure the checkbox for the connection is checked

  3. 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.

🔄
Create Service Account in Metabase
Create database user for on-premise solution
Create a new data source in SelectStar
Choose cloud vs on-prem
Screenshot add user with group form in Metabase.
Screenshot setting group permissions..
Screenshot saving database permissions.
Screenshot of "Metabase analytics" collection
Screenshot of setting audit log permissions.
Animations shows where to click to create a new data source.
Screenshot shows a new data source form.
Screenshot shows choice of cloud vs on-prem
Screenshot shows on-prem database credentials