I get an error when I want to insert a record into a table using a pre-hook macro.
(‘42000’, “[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near ‘<’. (102) (SQLExecDirectW)”)
dbt with Fabric
The pre_hook macro.
{%- macro custom_pre_hook_fabric() -%}
INSERT INTO [VGC].[BRONZE].[m_model_exec]
(
m_model_exec_id,
m_model_name,
m_invocation_id,
m_job_exec_id,
m_model_start_end,
m_row_count
)
VALUES (‘debug’,‘debug’,‘debug’,‘debug’,CURRENT_TIMESTAMP,0);
{%- endmacro -%}
The dbt model works fine without the pre_hook macro. When I and the pre_hook in the config it fails?