Files
dbt-f2dq/macros/meta/save_monitored.sql
M7XBeastandCursor ff096b51b5 Initial publish of dbt_f2dq (f2dq) package v0.12.1.
Clean package repo for Gitea installs via packages.yml git URL.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-10-11 17:37:40 +03:00

17 lines
775 B
SQL

{% macro save_monitored(monitored_path) %}
{% set monitored_query %}
select
{{ full_table_name('name', 'schema', 'database') }} as {{ f2dq.quote_column('model') }},
time_filter as {{ f2dq.quote_column('time_filter') }},
metrics as {{ f2dq.quote_column('metrics') }},
columns as {{ f2dq.quote_column('columns') }},
anomaly_detector as {{ f2dq.quote_column('anomaly_detector') }},
owners as {{ f2dq.quote_column('owners') }}
from {{ ref('f2dq_selected') }}
{% endset %}
{% set query_result = run_query(monitored_query) %}
{% set monitored_file_path = monitored_path or 'target/f2dq/monitored.json' %}
{% do query_result.to_json(monitored_file_path) %}
{% endmacro %}