• Source
  • Product Analytics
  • Beta

Move Metabase data anywhere it matters.

Stream Metabase card, collections and dashboard to any warehouse or AI app.

Source

Metabase

  • Snowflake
  • BigQuery
  • Postgres
  • Databricks
  • Claude
Streams
6
Destinations
50+
Standard support
2.1.63

Overview

What is the Airbyte Metabase connector?

The Airbyte Metabase connector extracts data from Metabase and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh. It publishes 6 streams you can select per connection.

  • 01

    Sync to your warehouse

    Land 6 Metabase tables in 50+ destinations on a schedule you control.

  • 02

    One authorization

    Authenticate Metabase once and Airbyte keeps every scheduled sync running on it.

  • 03

    Cloud or self-hosted

    Run the Metabase connector on Cloud, OSS, Hybrid.

6 streams

Every table you can sync from Metabase

  • Card
    Sync modesFullIncr.
  • Collections
    Sync modesFullIncr.
  • Dashboard
    Sync modesFullIncr.
  • User
    Sync modesFullIncr.
  • Databases
    Sync modesFullIncr.
  • Native Query Snippet
    Sync modesFullIncr.

Setup

Live in six steps

  1. Open Metabase and navigate to the "Databases" tab.

  2. Click on "Add Database" and select "Generic SQL" as the type.

  3. In the "Connection Details" section, enter the following information: - Name: A name for your database connection - Host: The hostname or IP address of your Airbyte instance - Port: The port number used by your Airbyte instance (default is

  4. Database: The name of the database you want to connect to - Username: Your Airbyte username - Password: Your Airbyte password

  5. Click on "Save" to save your connection details.

  6. Once your connection is saved, you can use it to create queries and visualizations in Metabase. Simply select your Airbyte connection from the list of available databases when creating a new query or visualization.

Configuration fields

Metabase configuration fields
FieldTypeDescription
instance_api_url*stringURL to your metabase instance API
username*stringNot documented.
passwordstringNot documented.
session_tokenstringTo generate your session token, you need to run the following command: curl -X POST \ -H "Content-Type: application/json" \ -d '{"username": "person@metabase.com", "password": "fakepassword"}' \ http://localhost:3000/api/session Then copy the value of the id field returned by a successful call to that API. Note that by default, sessions are good for 14 days and needs to be regenerated.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

  • Cloud
  • OSS
  • Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Metabase connector questions

What data can I sync from Metabase with Airbyte?

6 streams: Card, Collections, Dashboard, User, Databases, Native Query Snippet.

Does the Metabase connector support incremental sync?

The Metabase connector supports full refresh sync. Check the stream list on this page for incremental support per table.

Where can I run the Metabase connector?

Run the Metabase connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales

Start syncing Metabase in minutes.

Free 14-day trial. No credit card needed.