Skip to content

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

Explore dependencies/lineage: link

Relies on script: trase\data\brazil\logistics\sicasq\in\sicasq_not_in_soy_cnpj_special_cases.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/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

No data tests defined 🧐

Models

Sources

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