gnosis-models/macros/create_sps.sql
drethereum c265dcf7b1
AN-2422/update-udf-sp-gno (#15)
added project level variable and associated IF statements to on-run-start macros to default UDF/SP updates to False
2022-11-14 14:27:56 -05:00

9 lines
257 B
SQL

{% macro create_sps() %}
{% if var("UPDATE_UDFS_AND_SPS") %}
{% if target.database == 'GNOSIS' %}
CREATE schema IF NOT EXISTS _internal;
{{ sp_create_prod_clone('_internal') }};
{% endif %}
{% endif %}
{% endmacro %}