datavault-uk / automate-dv-demo Goto Github PK

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?

Hello folks,

First of all, thank you for your work. I use dbt_vault and the regularly published examples on projects and you can't imagine how it simplifies my daily work :)

This morning, I wanted to transcribe the metadata into an Excel file in order to centralize and regenerate the models. I noticed a little oversight or maybe it's wanted!

In the LNK_INVENTORY_ALLOCATION Link.

The primary key of the link is 'INVENTORY_ALLOCATION_PK' and the foreign keys are "PART_PK", "SUPPLIER_PK", "LINEITEM_PK"

In the "v_stg_orders" staging view, you have defined the key with three source columns :

INVENTORY_ALLOCATION_PK:
  - 'LINENUMBER'
  - 'PARTKEY'
  - 'SUPPLIERKEY'

While,

PART_PK: 'PARTKEY'
SUPPLIER_PK: 'SUPPLIERKEY'
LINEITEM_PK:
  -  'ORDERKEY'
  -  'LINENUMBER'

I think ORDERKEY is missing in the hash calculation of the primary key of the link

I thank you a lot.