LogoLogo
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 an API Access Token
  • Workspace API Tokens
  • Member API Tokens
  • Important Notes
  • 2. Connect Mode API to Select Star
  • 3. Connect Mode Discovery Database

Was this helpful?

  1. Integrations

Mode

PreviousFivetran (beta)NextSigma Computing

Last updated 23 days ago

Was this helpful?

Before you start

To connect Mode to Select Star, you will need...

  • Admin access to your Mode account.

  • A paid Mode plan (required for API token generation).

  • If you want to see Mode reports in personal spaces and calculate popularity based on the last 90 days of user activity, you will need credentials for your Mode Discovery Database. Learn more about getting access to Mode Discovery Database .

Complete all of the following steps to see Mode metadata, lineage, and popularity in Select Star.

1. Create an API Access Token

To enable integration with Mode, you can use either Workspace API tokens or Member API tokens. However, we strongly recommend using Workspace API tokens as they provide comprehensive access and help avoid permission issues when organizational structures change.

Workspace API Tokens

Workspace API tokens are designed for programmatic management of your Mode workspace. They mimic Admin access to the Workspace and are ideal for tasks such as archiving inactive reports or managing schedules. Only Admins can create and manage these tokens.

To generate a Workspace API token:

  1. Navigate to Workspace Settings > Features > API Keys > Workspace keys.

  2. Click "Create API Key" and provide a display name.

  3. Save "Key ID" and "Secret" values, as you will need them in .

Member API Tokens

Member API tokens are intended for individual use cases, such as updating specific reports or managing collections. These tokens mimic the individual user's access to resources in the Workspace.

To generate a Member API token:

  1. Admins must enable Member API tokens in Workspace Settings > Features > API Keys > Member keys.

  2. Users can then create their own tokens in Workspace Settings > Personal > My API Keys.

Important Notes

  • API tokens expire after 90 days by default. – Using a Member API token allows you to restrict access to specific collections within Select Star, but it introduces additional complexity to the permissions model.

  • Ensure you securely store both the Token (Key ID) and Secret when creating any API token.

2. Connect Mode API to Select Star

Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.

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

  • Display Name: This value is Mode by default, but you can override it if desired.

  • API access token: The Key ID value from the API token created in Mode.

  • Token secret: The Secret value from the API token created in Mode.

  • Organization: The name of your Mode organization. It'll be the part of the url after app.mode.com/home/

  • DB Connection: The database you are running Mode on top of, such as Snowflake or BigQuery.

  • DB Username: The name of the service account user that runs mode queries in your DB Connection. It is not a Select Star service account. This is used to identify which queries Mode runs so that Select Star can generate lineage between the database and Mode.

Click the Connect button.

3. Connect Mode Discovery Database

This step is optional, but highly recommended if you want to see Mode reports in personal spaces and to calculate popularity scores based on the last 90 days of user activity.

To skip this step, click the Next button.

You'll need the following information:

  • Account: Your Mode Discovery Database account name.

  • Username: Your Mode Discovery Database username.

  • Password: Your Mode Discovery Database password.

  • Role: By default, this value is PUBLIC.

  • Warehouse: The name of your Mode Discovery Database. By default, this value is WAREHOUSE_XS_MODE.

  • Database: By default, this value is MODE.

  • Schema: By default, this value is ORGANIZATION_USAGE.

When you have entered the information, click Next.

Your metadata should start loading automatically. Please allow 24-48 hours to completely generate popularity and lineage.

When the sync is complete, you'll be able to explore Mode in Select Star. See the link below for more information on Mode in Select Star.

Save "Key ID" and "Secret" values, as you will need them in .

For more details, refer to .

You must ensure DB Connection and DB Username are set so we can calculate column-level lineage from your DWH to Mode dashboards. You can also verify wether or not the connection has been set by going to > Mode > Connections.

To learn how to get the Snowflake credentials for Mode Discovery Database, see Mode's instructions .

🔄
Mode's API token documentation
Settings > Data
here
Getting Started: Mode
here
Create an API Access Token
Connect Mode API to Select Star
Connect Mode Discovery Database to Select Star
step 2
step 2