optimism-models/macros/create_sps.sql
drethereum 86699e12f7
AN-2390/update-vars-udf-sp-opt (#46)
* added project level variable and associated IF statements to on-run-start macros to default UDF/SP updates to False

* readjusted spacing in macros
2022-11-11 11:10:02 -07:00

9 lines
259 B
SQL

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