Introduction
intermix.io can detect custom properties from supported apps.
It works by introspecting the SQL text for a query comment. The comment encodes metadata about the application which submitted this query. Intermix handles tags from popular dashboard tools, and has also published our own format.
The intermix.io platform automatically detects tagged queries. When we see a tagged query, any of the properties of that application are then accessible in Filters and Group-bys.
Supported Apps
DBT
Mode queries will be automatically detected without any required action on your part.
Supported properties:
| node_id |
| profile_name |
| target_name |
| version |
| format |
Apache Airflow
Airflow is supported via a custom plugin. See this article for documentation on getting started.
Supported properties:
| dag |
| task |
| user |
| classname |
| file |
| function |
| linenumber |
Looker
Looker queries will be automatically detected without any required action on your part.
Supported properties:
| user_id |
| history_id |
| instance_slug |
Looker PDT
Looker PDT queries will be automatically detected without any required action on your part.
Supported properties:
| model_name |
| pdt_name |
Mode Analytics
Mode queries will be automatically detected without any required action on your part.
Supported properties:
| user |
| url |
| scheduled |
Report, run, and query ID properties will also be parsed from the URL.
Periscope Data
Periscope queries will be automatically detected without any required action on your part.
Supported properties:
| user_email |
| chart_name |
| dashboard_id |
| query_source |
| user_cat_refresh |
| aggregation |
| priority |
| filter_values |
Chartio
Chartio queries will be automatically detected without any required action on your part.
Supported properties:
| user_email |
| chart_id |
| chart_title |
| dashboard_id |
| dashboard_slug |
| dataset_id |
| dataset_name |
| datasource_alias |
| datasource_id |
| is_manual |
| organization_id |
| pipeline_id |
| reason |
Etleap
Etleap queries will be automatically detected without any required action on your part.
Supported properties:
| object_uuid |
| object_name |
| object_type |
| object_createDate |
| object_owner |
| source_uuid |
| source_name |
| destination_uuid |
| destination_name |
| loadType |
| sourceHighWatermark |
| sourceHighWatermarkType |
