dbt
The dbt types you can search for, with an example of each
Read from target/manifest.json of a dbt context source. Write dbt types with the dbt. prefix.
See Search for the query syntax. Properties listed as Exact match the whole value only.
dbt.model
A dbt model.
anfra search 'type:dbt.model schema:marts materialized:incremental'Finds the incremental models in the marts schema.
Properties: unique_id, name, package_name, materialized, database, schema, alias, relation_name, description, path, owner, owner_email, group, meta, data_source_name, primary_key. Exact: access
dbt.source
A source table.
anfra search 'type:dbt.source source_name:stripe'Finds the tables of the stripe source.
Properties: unique_id, name, package_name, materialized, database, schema, alias, relation_name, description, path, owner, owner_email, group, meta, source_name, source_description. Exact: loaded_at_field
dbt.column
A column of a model or source.
anfra search 'type:dbt.column is_primary_key:true'Finds the primary key columns.
Properties: node_unique_id, name, description, data_type, meta, accepted_values. Exact: granularity, is_primary_key, is_unique, is_not_null
dbt.metric
A MetricFlow metric.
anfra search 'type:dbt.metric metric_type:ratio'Finds the ratio metrics.
Properties: unique_id, name, package_name, label, description, expression, numerator, denominator, input_metrics, input_measures, filter, path, owner, owner_email, group, meta. Exact: metric_type, agg, window, grain_to_date, time_granularity
dbt.semantic_model
A MetricFlow semantic model.
anfra search 'type:dbt.semantic_model primary_entity:order'Finds the semantic models whose primary entity matches "order".
Properties: unique_id, name, package_name, label, description, primary_entity, group, path. Exact: agg_time_dimension
dbt.semantic_entity
A join key of a semantic model.
anfra search 'type:dbt.semantic_entity entity_type:foreign'Finds the foreign keys that join one semantic model to another.
Properties: semantic_model_unique_id, name, label, description, expr. Exact: entity_type, role
dbt.dimension
A dimension of a semantic model.
anfra search 'type:dbt.dimension dimension_type:time time_granularity:day'Finds the time dimensions at day granularity.
Properties: semantic_model_unique_id, name, label, description, expr. Exact: dimension_type, time_granularity, is_partition
dbt.measure
A measure of a semantic model.
anfra search 'type:dbt.measure agg:count_distinct'Finds the measures that count distinct values.
Properties: semantic_model_unique_id, name, label, description, expr. Exact: agg, agg_time_dimension, non_additive_dimension
dbt.exposure
A downstream use of dbt nodes, such as a dashboard or application.
anfra search 'type:dbt.exposure depends_on:(type:dbt.source name:orders)'Finds the exposures built on the orders source table, directly or through models.
Properties: unique_id, name, package_name, label, description, path, owner, owner_email, group, meta. Exact: exposure_type, url, maturity
dbt.tag
A tag.
anfra search 'type:dbt.model depends_on[depth=1]:(type:dbt.tag name:finance)'Finds the models tagged finance, on the model itself or on one of its columns.
Properties: name
dbt.project
The dbt project that built the manifest.
anfra search 'type:dbt.project'Shows the ingested dbt project, with the dbt version and adapter that built its manifest.
Properties: name. Exact: project_id, dbt_version, adapter_type, generated_at