Macro error

[fithisux]

Hi, I try to port the demo to work with my TPC-H from a local duckdb installation (I do not have a snowflake account and I am not interested).

I have setup duckdb (like in my other dbt project).

But I get

No macro named 'get_escape_characters' found within namespace: 'automate_dv'

Can you help me?

[fithisux]

On a second note I see that duckdb does not have code generation. But I try to add this. And even though I have some additions for the macros

e.g.

{%- macro duckdb__cast_date(column_str, as_string=false, alias=none) -%}

    {%- if as_string -%}
    '{{ column_str }}'::date
    {%- else -%}
    cast({{ column_str }} as string)::date
    {%- endif -%}

    {%- if alias %} AS {{ alias }} {%- endif %}

{%- endmacro -%}

it still "prefers" the snowflake version.

How can I change this?

[fithisux]

Datavault-UK/automate-dv#171