Skip to content

DBT: Cd Disaggregated Beef 2019

File location: s3://trase-storage/brazil/beef/trade/cd/disaggregated/CD_DISAGGREGATED_BEEF_2019.csv

DBT model name: cd_disaggregated_beef_2019

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Relies on script: trase\tools\aws\metadata.py

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

Column Type Description
index_mdic VARCHAR
index_bol VARCHAR
vol VARCHAR
vol_mdic VARCHAR
matching_stage VARCHAR
state.trase_id VARCHAR
message VARCHAR
via VARCHAR
hs4 VARCHAR
hs5 VARCHAR
hs6 VARCHAR
hs8 VARCHAR
exporter.cnpj VARCHAR
exporter.label VARCHAR
port_of_export.name VARCHAR
port_of_export.group VARCHAR
exporter.type VARCHAR
exporter.municipality.trase_id VARCHAR
importer.label VARCHAR
country_of_destination.name VARCHAR
country_of_destination.trase_id VARCHAR
country_of_destination.group VARCHAR
matched VARCHAR
fob VARCHAR
year VARCHAR
exporter_geocode VARCHAR
state_of_production VARCHAR

No data tests defined 🧐

Models

Models

Sources

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.ref("brazil_bol_2019")
    dbt.source("trase-storage-raw", "brazil_mdic_disaggregated_2019_beef")
    dbt.ref("brazil_mdic_port_2019")
    dbt.ref("empresas_cadastro_2019")

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