OpenMetadata
Search…
Metabase
This guide will help install Metabase connector and run manually
Prerequisites
OpenMetadata is built using Java, DropWizard, Jetty, and MySQL.
  1. 1.
    Python 3.7 or above

Install from PyPI

Install Using PyPI
1
pip install 'openmetadata-ingestion[metabase]'
Copied!

Run Manually

1
metadata ingest -c ./examples/workflows/metabase.json
Copied!

Configuration

metabase.json
1
{
2
"source": {
3
"type": "metabase",
4
"config": {
5
"username": "username",
6
"password": "password",
7
"host_port": "host:port",
8
"service_name": "local_metabase",
9
"database_service_name": "Optional - Create Lineage by adding relevant Database Service Name"
10
}
11
}
12
...
Copied!
  1. 1.
    username - pass the Metabase Client ID.
  2. 2.
    password - the password for the Metabase Client Secret.
  3. 3.
    host_port - Hostname and Port number where the service is being initialized.
  4. 4.
    service_name - Service Name for this Metabase cluster. If you added the Metabase cluster through OpenMetadata UI, make sure the service name matches the same.
  5. 5.
    filter_pattern - It contains includes, excludes options to choose which pattern of datasets you want to ingest into OpenMetadata.

Publish to OpenMetadata

Below is the configuration to publish Metabase data into the OpenMetadata service.
Add metadata-rest sink along with metadata-server config
Metabase.json
1
{
2
"source": {
3
"type": "metabase",
4
"config": {
5
"username": "username",
6
"password": "password",
7
"host_port": "host:port",
8
"service_name": "local_metabase",
9
"database_service_name": "Optional - Create Lineage by adding relevant Database Service Name"
10
}
11
},
12
"sink": {
13
"type": "metadata-rest",
14
"config": {}
15
},
16
"metadata_server": {
17
"type": "metadata-server",
18
"config": {
19
"api_endpoint": "http://localhost:8585/api",
20
"auth_provider_type": "no-auth"
21
}
22
}
23
}
Copied!
Last modified 23h ago