cosmos-models/macros/create_sps.sql
Ryan-Loofy 4870678012
Create PROD Clone (#5)
* Create PROD Clone

* Add UPDATE_UDFS_AND_SPS Variable

* Remove on start

* Add start hooks
2022-11-30 12:13:33 -05:00

9 lines
253 B
SQL

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