eclipse-models/macros/create_sps.sql
desmond-hui b0b9bfb514
Initial setup 1 (#2)
* add gitignore

* replace xyz with eclipse

---------

Co-authored-by: desmond-hui <desmond@flipsidecryto.com>
2024-08-28 07:31:44 -07:00

12 lines
442 B
SQL

{% macro create_sps() %}
{% if target.database == 'ECLIPSE' %}
CREATE SCHEMA IF NOT EXISTS _internal;
{{ sp_create_prod_clone('_internal') }};
{% endif %}
{% endmacro %}
{% macro enable_search_optimization(schema_name, table_name, condition = '') %}
{% if target.database == 'ECLIPSE' %}
ALTER TABLE {{ schema_name }}.{{ table_name }} ADD SEARCH OPTIMIZATION {{ condition }}
{% endif %}
{% endmacro %}