Connectors

/

Metabase

Data replication

Sync Metabase data anywhere.

Metabase is accessible to all. Metabase is a self-service business intelligence software and it is a BI tool with a friendly UX and integrated tooling to let your company explore data on its own. Metabase is the easy, open-source way for everyone in your company to ask questions and learn from data. Metabase is an open-source business intelligence tool that lets you create charts and dashboards using data from a variety of databases and data sources. It generally assists users to create charts and dashboards from their databases.

  • Standard
  • Beta
  • 6 streams
Sync Metabase dataRead the docs
Metabase

One connector

Everything Metabase can do in Airbyte

  • Sync to your warehouse

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

  • One authorization

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

  • Cloud or self-hosted

    Run the Metabase connector on Cloud, Self-Managed Enterprise.

Specifications

What to know before you sync Metabase

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version2.1.57
  • Release stageBeta

Sync capabilities

  • Full Refresh SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 6 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.

6 streams

Every table you can sync from Metabase

  • Card

  • Collections

  • Dashboard

  • User

  • Databases

  • Native Query Snippet

Authentication

Authenticate Metabase once

  • Password

Explore

Related connectors

MixpanelProduct AnalyticsStandard Sources cloudself-managed-enterprise
MuxProduct AnalyticsStandard Sources cloudself-managed-enterprise
PendoProduct AnalyticsStandard Sources cloudself-managed-enterprise
PlausibleProduct AnalyticsStandard Sources cloudself-managed-enterprise
PostHogProduct AnalyticsStandard Sources cloudself-managed-enterprise
ProductboardProduct AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Metabase's API provides access to a wide range of data types, including:

1. Metrics: These are numerical values that can be used to measure performance or track progress over time. Examples include revenue, website traffic, and customer satisfaction scores.
2. Dimensions: These are attributes that can be used to group or filter data. Examples include date, location, and product category.
3. Filters: These are criteria that can be used to limit the data returned by a query. Examples include date ranges, customer segments, and product types.
4. Joins: These are used to combine data from multiple tables or sources. Examples include joining customer data with sales data to analyze customer behavior.
5. Aggregations: These are used to summarize data by grouping it into categories and calculating metrics for each category. Examples include calculating average revenue per customer or total sales by product category.
6. Custom SQL: This allows users to write their own SQL queries to access and manipulate data in any way they choose.

Overall, Metabase's API provides a powerful tool for accessing and analyzing data from a wide range of sources, making it an ideal choice for businesses and organizations of all sizes.

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 8000) - Database: The name of the database you want to connect to - Username: Your Airbyte username - Password: Your Airbyte password
4. Click on "Save" to save your connection details.
5. 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.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Metabase data today

Free for 14 days on Airbyte Cloud. Set up the Metabase connector once and let Airbyte keep it in sync.

Try it freeTalk to sales