dbt macro to create table from dbt model

create_table_macro.sql

{% macro create_table(table_name) %}

{% set sql %}
    BEGIN;
    DROP TABLE IF EXISTS {{ table_name[:-4] }};
    CREATE TABLE {{ table_name[:-4] }} AS SELECT * FROM {{ table_name }}; 
    GRANT SELECT ON {{ table_name[:-4] }} TO webview;
    COMMIT;
{% endset %}

{% do run_query(sql) %}
{% do log(table_name+" table created", info=True) %}
{% endmacro %}