Error: dbt incremental model on BQ Partitioned table using string field

[madm4niac]

I raised another issue for the Prehook - macro one. Adding it just for your reference and help.

Pre hook - Macro - Delete statement

The problem I’m having The pre_hook fires the macro but the macro isn’t deleting the records from the pub_table The context of why I’m trying to do this For every Airflow DAG run, I would like to replace the records in the pub_table with the records from the int_table if there is a match with the field _meta_source_file. For example, If the pub_table has 100 records and int_table has 120 records for _meta_source_file = “abc”, then during the DAG run, the pub_table 100 records should be replac…