Mode
Important Capabilities
Capability | Status | Notes |
---|---|---|
Platform Instance | ✅ | Enabled by default |
This plugin extracts Charts, Reports, and associated metadata from a given Mode workspace. This plugin is in beta and has only been tested on PostgreSQL database.
Report
/api/{account}/reports/{report} endpoint is used to retrieve the following report information.
- Title and description
- Last edited by
- Owner
- Link to the Report in Mode for exploration
- Associated charts within the report
Chart
/api/{workspace}/reports/{report}/queries/{query}/charts' endpoint is used to retrieve the following information.
- Title and description
- Last edited by
- Owner
- Link to the chart in Metabase
- Datasource and lineage information from Report queries.
The following properties for a chart are ingested in DataHub.
Chart Information
Name | Description |
---|---|
Filters | Filters applied to the chart |
Metrics | Fields or columns used for aggregation |
X | Fields used in X-axis |
X2 | Fields used in second X-axis |
Y | Fields used in Y-axis |
Y2 | Fields used in second Y-axis |
Table Information
Name | Description |
---|---|
Columns | Column names in a table |
Filters | Filters applied to the table |
Pivot Table Information
Name | Description |
---|---|
Columns | Column names in a table |
Filters | Filters applied to the table |
Metrics | Fields or columns used for aggregation |
Rows | Row names in a table |
CLI based Ingestion
Install the Plugin
pip install 'acryl-datahub[mode]'
Starter Recipe
Check out the following recipe to get started with ingestion! See below for full configuration options.
For general pointers on writing and running a recipe, see our main recipe guide.
source:
type: mode
config:
# Coordinates
connect_uri: http://app.mode.com
# Credentials
token: token
password: pass
# Options
workspace: "datahub"
default_schema: "public"
owner_username_instead_of_email: False
api_options:
retry_backoff_multiplier: 2
max_retry_interval: 10
max_attempts: 5
sink:
# sink configs
Config Details
- Options
- Schema
Note that a .
is used to denote nested fields in the YAML recipe.
Field | Description |
---|---|
password ✅ string(password) | Mode password for authentication. |
token ✅ string | Mode user token. |
connect_uri string | Mode host URL. Default: https://app.mode.com |
default_schema string | Default schema to use when schema is not provided in an SQL query Default: public |
owner_username_instead_of_email boolean | Use username for owner URN instead of Email Default: True |
platform_instance_map map(str,string) | |
workspace string | |
env string | The environment that all assets produced by this connector belong to Default: PROD |
api_options ModeAPIConfig | Retry/Wait settings for Mode API to avoid "Too many Requests" error. See Mode API Options below Default: {'retry_backoff_multiplier': 2, 'max_retry_interva... |
api_options.max_attempts integer | Maximum number of attempts to retry before failing Default: 5 |
api_options.max_retry_interval One of integer, number | Maximum interval to wait when retrying Default: 10 |
api_options.retry_backoff_multiplier One of integer, number | Multiplier for exponential backoff when waiting to retry Default: 2 |
The JSONSchema for this configuration is inlined below.
{
"title": "ModeConfig",
"description": "Any non-Dataset source that produces lineage to Datasets should inherit this class.\ne.g. Orchestrators, Pipelines, BI Tools etc.",
"type": "object",
"properties": {
"env": {
"title": "Env",
"description": "The environment that all assets produced by this connector belong to",
"default": "PROD",
"type": "string"
},
"platform_instance_map": {
"title": "Platform Instance Map",
"description": "A holder for platform -> platform_instance mappings to generate correct dataset urns",
"type": "object",
"additionalProperties": {
"type": "string"
}
},
"connect_uri": {
"title": "Connect Uri",
"description": "Mode host URL.",
"default": "https://app.mode.com",
"type": "string"
},
"token": {
"title": "Token",
"description": "Mode user token.",
"type": "string"
},
"password": {
"title": "Password",
"description": "Mode password for authentication.",
"type": "string",
"writeOnly": true,
"format": "password"
},
"workspace": {
"title": "Workspace",
"type": "string"
},
"default_schema": {
"title": "Default Schema",
"description": "Default schema to use when schema is not provided in an SQL query",
"default": "public",
"type": "string"
},
"owner_username_instead_of_email": {
"title": "Owner Username Instead Of Email",
"description": "Use username for owner URN instead of Email",
"default": true,
"type": "boolean"
},
"api_options": {
"title": "Api Options",
"description": "Retry/Wait settings for Mode API to avoid \"Too many Requests\" error. See Mode API Options below",
"default": {
"retry_backoff_multiplier": 2,
"max_retry_interval": 10,
"max_attempts": 5
},
"allOf": [
{
"$ref": "#/definitions/ModeAPIConfig"
}
]
}
},
"required": [
"token",
"password"
],
"additionalProperties": false,
"definitions": {
"ModeAPIConfig": {
"title": "ModeAPIConfig",
"type": "object",
"properties": {
"retry_backoff_multiplier": {
"title": "Retry Backoff Multiplier",
"description": "Multiplier for exponential backoff when waiting to retry",
"default": 2,
"anyOf": [
{
"type": "integer"
},
{
"type": "number"
}
]
},
"max_retry_interval": {
"title": "Max Retry Interval",
"description": "Maximum interval to wait when retrying",
"default": 10,
"anyOf": [
{
"type": "integer"
},
{
"type": "number"
}
]
},
"max_attempts": {
"title": "Max Attempts",
"description": "Maximum number of attempts to retry before failing",
"default": 5,
"type": "integer"
}
},
"additionalProperties": false
}
}
}
See Mode's Authentication documentation on how to generate token
and password
.
Code Coordinates
- Class Name:
datahub.ingestion.source.mode.ModeSource
- Browse on GitHub
Questions
If you've got any questions on configuring ingestion for Mode, feel free to ping us on our Slack.