clone.sql

/*
  Run with: dbt run-operation clone_prod_to_target --args 'from: analytics.analytics'
*/

{% macro clone_prod_to_target(from) %}

    {% set sql -%}
        create schema if not exists {{ target.database }}.{{ target.schema }} clone {{ from }};
    {%- endset %}

    {% do run_query(sql) %}

{% endmacro %}