DBT: Special Cases

File location: s3://trase-storage/brazil/dictionaries/special_cases.csv

DBT model name: special_cases

Explore on Metabase: Full table; summary statistics

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main_brazil.special_cases

• Containing yaml link: trase/data_pipeline/models/brazil/dictionaries/_schema.yml

• Model file: trase/data_pipeline/models/brazil/dictionaries/special_cases.py

• Calls script: trase\data\brazil\logistics\sicasq\in\sicasq_not_in_soy_cnpj_special_cases.py

• Original dbt_docs

• Tags: mock_model, brazil, dictionaries

---

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/data/brazil/logistics/sicasq/in/sicasq_not_in_soy_cnpj_special_cases.py [permalink]. It was last run by Tomas Carvalho.

---

Details

ColumnsDepends OnModel code

Column	Type	Description

Models / Seeds

• source.trase_duckdb.trase-storage-raw.soy_cnpj_2016
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2008
• source.trase_duckdb.trase-storage-raw.cd_combined_soy_2016
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2015
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2006
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2005
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2014
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2010
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2017
• source.trase_duckdb.trase-storage-raw.auxiliary_cnpj_original_cnpj_2019
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2004
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2013
• source.trase_duckdb.trase-storage-raw.sicasq_2017
• source.trase_duckdb.trase-storage-raw.cd_combined_soy_2015
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2012
• source.trase_duckdb.trase-storage-raw.cd_combined_soy_2017
• source.trase_duckdb.trase-storage-raw.cnpj_2019_cnae_secondary_final
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2009
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2007
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2011
• source.trase_duckdb.trase-storage-raw.soy_cnpj_2018

Sources

• ['trase-storage-raw', 'soy_cnpj_2016']
• ['trase-storage-raw', 'soy_cnpj_2008']
• ['trase-storage-raw', 'cd_combined_soy_2016']
• ['trase-storage-raw', 'soy_cnpj_2015']
• ['trase-storage-raw', 'soy_cnpj_2006']
• ['trase-storage-raw', 'soy_cnpj_2005']
• ['trase-storage-raw', 'soy_cnpj_2014']
• ['trase-storage-raw', 'soy_cnpj_2010']
• ['trase-storage-raw', 'soy_cnpj_2017']
• ['trase-storage-raw', 'auxiliary_cnpj_original_cnpj_2019']
• ['trase-storage-raw', 'soy_cnpj_2004']
• ['trase-storage-raw', 'soy_cnpj_2013']
• ['trase-storage-raw', 'sicasq_2017']
• ['trase-storage-raw', 'cd_combined_soy_2015']
• ['trase-storage-raw', 'soy_cnpj_2012']
• ['trase-storage-raw', 'cd_combined_soy_2017']
• ['trase-storage-raw', 'cnpj_2019_cnae_secondary_final']
• ['trase-storage-raw', 'soy_cnpj_2009']
• ['trase-storage-raw', 'soy_cnpj_2007']
• ['trase-storage-raw', 'soy_cnpj_2011']
• ['trase-storage-raw', 'soy_cnpj_2018']

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "soy_cnpj_2016")
    dbt.source("trase-storage-raw", "soy_cnpj_2008")
    dbt.source("trase-storage-raw", "cd_combined_soy_2016")
    dbt.source("trase-storage-raw", "soy_cnpj_2015")
    dbt.source("trase-storage-raw", "soy_cnpj_2006")
    dbt.source("trase-storage-raw", "soy_cnpj_2005")
    dbt.source("trase-storage-raw", "soy_cnpj_2014")
    dbt.source("trase-storage-raw", "soy_cnpj_2010")
    dbt.source("trase-storage-raw", "soy_cnpj_2017")
    dbt.source("trase-storage-raw", "auxiliary_cnpj_original_cnpj_2019")
    dbt.source("trase-storage-raw", "soy_cnpj_2004")
    dbt.source("trase-storage-raw", "soy_cnpj_2013")
    dbt.source("trase-storage-raw", "sicasq_2017")
    dbt.source("trase-storage-raw", "cd_combined_soy_2015")
    dbt.source("trase-storage-raw", "soy_cnpj_2012")
    dbt.source("trase-storage-raw", "cd_combined_soy_2017")
    dbt.source("trase-storage-raw", "cnpj_2019_cnae_secondary_final")
    dbt.source("trase-storage-raw", "soy_cnpj_2009")
    dbt.source("trase-storage-raw", "soy_cnpj_2007")
    dbt.source("trase-storage-raw", "soy_cnpj_2011")
    dbt.source("trase-storage-raw", "soy_cnpj_2018")

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