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
email
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