dbt-sqlserver

dbt-sqlserver copied to clipboard

When attempting to add a SQL header, nothing is generated. (for reference: https://docs.getdbt.com/reference/resource-configs/sql_header )

{{ config(materialized='table') }}

{% call set_sql_header(config) %}
declare @temp float = 1.345;
{%- endcall %}

select * from MyTable where MyColumn = @temp

this also doesn't work:

{{ 
    config(
        materialized='table',
        sql_header="""
declare @temp float = 1.345;
""") 
}}

select * from MyTable where MyColumn = @temp

The compiled SQL looks like:

select * from MyTable where MyColumn = @temp