DBT Macro: Metabase Question Url

DBT macro name: trase_duckdb.metabase_question_url

DBT details

• Macro file: trase/data_pipeline/macros/metabase_question_url.sql

• Original dbt_docs

---

Description

No description

---

Details

Referenced ByMacro code

Models

• s3_files_latest

{% macro metabase_question_url(query_expr, database_id=2) -%}
(
  'https://metabase.deforestationfree.com/question#' || to_base64(encode(
    CAST(
      json_object(
        'dataset_query', json_object(
          'database', {{ database_id }},
          'type', 'native',
          'native', json_object(
            'template-tags', json_object(),
            'query', {{ query_expr }}
          )
        ),
        'display', 'table',
        'parameters', json_array(),
        'visualization_settings', json_object(),
        'type', 'question'
      ) AS VARCHAR
    )
  ))
)
{%- endmacro %}