DBT Macro: Detach Postgres

DBT macro name: trase_duckdb.detach_postgres

DBT details

• Macro file: trase/data_pipeline/macros/detach_postgres.sql

• Original dbt_docs

---

Description

No description

---

Details

Referenced ByDepends OnMacro code

Models

• postgres_economic_blocs
• postgres_ports
• postgres_regions_without_geometry
• postgres_traders
• postgres_logistics
• postgres_countries
• postgres_commodity_equivalence_factors
• postgres_commodities
• postgres_eu_economic_blocs

Macros

• run_query

{% macro detach_postgres() %}

-- Only do the following if within a dbt run (not whenever compiling)
{% if execute %}
  {% set dynamic_db_name = this.identifier ~ '_postgres_db' %}
  {% set detach_query = "DETACH " ~ dynamic_db_name ~ ";" %}

  {% do run_query(detach_query) %}
  {{ log("Dettached from " ~ dynamic_db_name, info=True) }}

{% endif %}

{% endmacro %}