mirror of
https://github.com/FlipsideCrypto/fsc-utils.git
synced 2026-02-06 10:56:49 +00:00
20 lines
382 B
SQL
20 lines
382 B
SQL
{{
|
|
config(
|
|
materialized = 'incremental',
|
|
incremental_strategy = 'merge',
|
|
unique_key = 'ddl_hash',
|
|
merge_update_columns = [],
|
|
)
|
|
}}
|
|
{% if execute %}
|
|
SELECT
|
|
$${{- fsc_utils.generate_datashare_ddl() -}}$$ AS ddl,
|
|
md5(ddl) AS ddl_hash,
|
|
sysdate() as ddl_created_at
|
|
{% else %}
|
|
SELECT
|
|
null as ddl,
|
|
null as ddl_hash,
|
|
null as ddl_created_at
|
|
from dual limit 0
|
|
{% endif %} |