drop-seed-tables

{% macro drop_seed_table(dbname, tablename) %}

{% set sql -%}
    use database "{{ dbname.upper() }}";
    use schema "EDW_TRANSIENT";
    drop table if exists "{{ tablename.upper() }}";
{%- endset %}

{{ dbt_utils.log_info("drop seed operation on " ~ tablename ~ " in progress.") }}
{% do run_query(sql) %}
{{ dbt_utils.log_info("drop seed database operation on " ~ tablename ~ " is completed.") }}

{% endmacro %}