Skip to content

Special Cases

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

Dbt path: trase_production.main_brazil.special_cases

Explore on Metabase: Full table; summary statistics

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

Model file link: 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

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, brazil, dictionaries

special_cases

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

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