Skip to content

DBT: Sicarm 2023

File location: s3://trase-storage/brazil/logistics/sicarm/in/SICARM_2023.csv

DBT model name: sicarm_2023

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 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", "sicarm_ba_202302")
    dbt.source("trase-storage-raw", "sicarm_rn_202302")
    dbt.source("trase-storage-raw", "sicarm_ro_202302")
    dbt.source("trase-storage-raw", "sicarm_mt_202302")
    dbt.source("trase-storage-raw", "sicarm_rj_202302")
    dbt.source("trase-storage-raw", "sicarm_ap_202302")
    dbt.source("trase-storage-raw", "sicarm_pe_202302")
    dbt.source("trase-storage-raw", "sicarm_df_202302")
    dbt.source("trase-storage-raw", "sicarm_ce_202302")
    dbt.source("trase-storage-raw", "sicarm_sc_202302")
    dbt.source("trase-storage-raw", "sicarm_es_202302")
    dbt.source("trase-storage-raw", "sicarm_al_202302")
    dbt.source("trase-storage-raw", "sicarm_pr_202302")
    dbt.source("trase-storage-raw", "br_municipalities_2017")
    dbt.source("trase-storage-raw", "sicarm_ac_202302")
    dbt.source("trase-storage-raw", "sicarm_go_202302")
    dbt.source("trase-storage-raw", "sicarm_mg_202302")
    dbt.source("trase-storage-raw", "sicarm_pa_202302")
    dbt.source("trase-storage-raw", "sicarm_se_202302")
    dbt.source("trase-storage-raw", "sicarm_rs_202302")
    dbt.source("trase-storage-raw", "sicarm_pi_202302")
    dbt.source("trase-storage-raw", "sicarm_sp_202302")
    dbt.source("trase-storage-raw", "sicarm_ms_202302")
    dbt.source("trase-storage-raw", "sicarm_am_202302")
    dbt.source("trase-storage-raw", "sicarm_to_202302")
    dbt.source("trase-storage-raw", "sicarm_pb_202302")
    dbt.source("trase-storage-raw", "sicarm_ma_202302")
    dbt.source("trase-storage-raw", "sicarm_rr_202302")

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