table_materialization.sql.jinja2

{%- materialization view, default -%}

  -- `BEGIN` happens here:
  {{ run_hooks(pre_hooks, inside_transaction=True) }}

  {% call statement('main') -%}
    {{ create_view_as(intermediate_relation, sql) }}
  {%- endcall %}

  {{ adapter.rename_relation(intermediate_relation, target_relation) }}
  {{ run_hooks(post_hooks, inside_transaction=True) }}
  
  -- `COMMIT` the transaction
  {{ adapter.commit() }}
  
  {{ drop_relation_if_exists(backup_relation) }}

{%- endmaterialization -%}