Skip to content

Seipcs Brazil Beef 2020

s3://trase-storage/brazil/beef/sei_pcs/v2.2.0/SEIPCS_BRAZIL_BEEF_2020.csv

Dbt path: trase_production.main_brazil.seipcs_brazil_beef_2020

Explore on Metabase: Full table; summary statistics

Containing yaml file link: trase/data_pipeline/models/brazil/beef/sei_pcs/v2_2_0/_schema.yml

Model file link: trase/data_pipeline/models/brazil/beef/sei_pcs/v2_2_0/seipcs_brazil_beef_2020.py

Calls script: trase/models/brazil/beef

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, beef, brazil, sei_pcs, v2.2.0

seipcs_brazil_beef_2020

Description

No description

Details

Column Type Description

Models / Seeds

  • source.trase_duckdb.trase-storage-raw.id_mun_master_a_new
  • source.trase_duckdb.trase-storage-raw.brazil_beef_carcass_weight_equivalence_factors
  • source.trase_duckdb.trase-storage-raw.br_cost_matrix_osrm_2019
  • model.trase_duckdb.uf_new
  • model.trase_duckdb.cd_disaggregated_beef_2020_new
  • model.trase_duckdb.zdc_data_collection_2020_br_beef
  • model.trase_duckdb.brazil_sif_inspected_beef_establishments_2020
  • model.trase_duckdb.br_bovine_slaughter_2015_2022_new
  • model.trase_duckdb.cnpj8_supply_sheds_2020

Sources

  • ['trase-storage-raw', 'id_mun_master_a_new']
  • ['trase-storage-raw', 'brazil_beef_carcass_weight_equivalence_factors']
  • ['trase-storage-raw', 'br_cost_matrix_osrm_2019']

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    # static data (doesn't update every year)
    dbt.source("trase-storage-raw", "id_mun_master_a_new")
    dbt.ref("uf_new")
    dbt.source("trase-storage-raw", "brazil_beef_carcass_weight_equivalence_factors")
    dbt.source("trase-storage-raw", "br_cost_matrix_osrm_2019")

    # trade data
    dbt.ref("cd_disaggregated_beef_2020_new")
    dbt.ref("zdc_data_collection_2020_br_beef")

    # SIF and SIGSIF data
    dbt.ref("brazil_sif_inspected_beef_establishments_2020")
    dbt.ref("br_bovine_slaughter_2015_2022_new")

    # RFB CNPJ data
    # TODO: use new data
    # dbt.ref("beef_cnpj_2015_new")

    # GTAs
    dbt.ref("cnpj8_supply_sheds_2020")

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