DBT: Beef Cnpj 2019

File location: s3://trase-storage/brazil/beef/auxiliary/cnpj/BEEF_CNPJ_2019.csv

DBT model name: beef_cnpj_2019

Explore on Metabase: Full table; summary statistics

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main_brazil.beef_cnpj_2019

• Containing yaml link: trase/data_pipeline/models/brazil/beef/auxiliary/cnpj/_schema.yml

• Model file: trase/data_pipeline/models/brazil/beef/auxiliary/cnpj/beef_cnpj_2019.py

• Calls script: trase\tools\aws\metadata.py

• Original dbt_docs

• Tags: mock_model, auxiliary, beef, brazil, cnpj

---

Description

This model was auto-generated based off .yml 'lineage' files in S3. The DBT model just raises an error; the actual script that created the data lives elsewhere. The script is located at trase/tools/aws/metadata.py [permalink]. It was last run by Nanxu Su.

---

Details

ColumnsDepends OnModel code

Column	Type	Description

Models / Seeds

• source.trase_duckdb.trase-storage-raw.auxiliary_cnpj_original_cnpj_2019
• source.trase_duckdb.trase-storage-raw.commodity_dict
• source.trase_duckdb.trase-storage-raw.cnpj_2019_cnae_secondary
• source.trase_duckdb.trase-storage-raw.lc_originals_brazil_bol_2019

Sources

• ['trase-storage-raw', 'auxiliary_cnpj_original_cnpj_2019']
• ['trase-storage-raw', 'commodity_dict']
• ['trase-storage-raw', 'cnpj_2019_cnae_secondary']
• ['trase-storage-raw', 'lc_originals_brazil_bol_2019']

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "auxiliary_cnpj_original_cnpj_2019")
    dbt.source("trase-storage-raw", "commodity_dict")
    dbt.source("trase-storage-raw", "cnpj_2019_cnae_secondary")
    dbt.source("trase-storage-raw", "lc_originals_brazil_bol_2019")

    raise NotImplementedError()
    return pd.DataFrame({"hello": ["world"]})