DBT: Beef Cnpj 2015 New

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

DBT model name: beef_cnpj_2015_new

Explore on Metabase: Full table; summary statistics

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main_brazil.beef_cnpj_2015_new

• 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_2015_new.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
company_name	VARCHAR
cnpj	VARCHAR
cnpj8	VARCHAR
tax_municipality	VARCHAR
zdc	VARCHAR
original_tax_municipality	VARCHAR

Models / Seeds

• source.trase_duckdb.trase-storage-raw.beef_cnpj_2015
• model.trase_duckdb.cd_combined_beef_2015_new
• model.trase_duckdb.brazil_sif_inspected_beef_establishments_2018
• model.trase_duckdb.zdc_data_collection_2015_br_beef

Sources

• ['trase-storage-raw', 'beef_cnpj_2015']

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.ref("cd_combined_beef_2015_new")
    dbt.ref("brazil_sif_inspected_beef_establishments_2018")
    dbt.ref("zdc_data_collection_2015_br_beef")
    dbt.source("trase-storage-raw", "beef_cnpj_2015")

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