Beef Cnpj 2015 New

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

Dbt path: trase_production.main_brazil.beef_cnpj_2015_new

Explore on Metabase: Full table; summary statistics

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

Model file link: trase/data_pipeline/models/brazil/beef/auxiliary/cnpj/beef_cnpj_2015_new.py

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

Dbt test runs & lineage: Test results · Lineage

Full dbt_docs page: Open in dbt docs (includes lineage graph -at the bottom right-, tests, and downstream dependencies)

Tags: mock_model, auxiliary, beef, brazil, cnpj

beef_cnpj_2015_new

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"]})