In this section, we provide guides and references to use the Metabase connector.
Supported Authentication Types:
- Basic Auth — Connect using a Metabase account email and password. The connector obtains a session token automatically.
- API Token — Connect using a Metabase API key. Recommended when basic authentication is disabled (e.g., SSO-enforced environments).
Configure and schedule Metabase metadata and profiler workflows from the OpenMetadata UI:
How to Run the Connector Externally
To run the Ingestion via the UI you’ll need to use the OpenMetadata Ingestion Container, which comes shipped with
custom Airflow plugins to handle the workflow deployment.
If, instead, you want to manage your workflows externally on your preferred orchestrator, you can check
the following docs to run the Ingestion Framework anywhere.
External Schedulers
Get more information about running the Ingestion Framework Externally
Requirements
The Metabase account or API key used to connect must have view access to all dashboards and charts you want to ingest.
To ingest owner information, the account must also have visibility of Metabase user profiles. This is available to admin accounts and accounts in groups with the appropriate permissions.
Note: Collate has been tested with Metabase versions 0.42.4 and 0.43.4.
Python Requirements
We have support for Python versions 3.9-3.11
To run the Metabase ingestion, you will need to install:
pip3 install "openmetadata-ingestion[metabase]"
All connectors are defined as JSON Schemas.
Here
you can find the structure to create a connection to Metabase.
In order to create and run a Metadata Ingestion workflow, we will follow
the steps to create a YAML configuration able to connect to the source,
process the Entities if needed, and reach the OpenMetadata server.
The workflow is modeled around the following
JSON Schema
1. Define the YAML Config
This is a sample config for Metabase:
2. Run with the CLI
First, we will need to save the YAML file. Afterward, and with all requirements installed, we can run:
metadata ingest -c <path-to-yaml>
Note that from connector to connector, this recipe will always be the same. By updating the YAML configuration,
you will be able to extract metadata from different sources.