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

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main_brazil.sicarm_2023

• Containing yaml link: trase/data_pipeline/models/brazil/logistics/sicarm/in/_schema.yml

• Model file: trase/data_pipeline/models/brazil/logistics/sicarm/in/sicarm_2023.py

• Calls script: trase\tools\aws\metadata.py

• Original dbt_docs

• Tags: mock_model, brazil, in, logistics, sicarm

---

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

ColumnsDepends OnModel code

Column	Type	Description

Models / Seeds

• source.trase_duckdb.trase-storage-raw.sicarm_ba_202302
• source.trase_duckdb.trase-storage-raw.sicarm_rn_202302
• source.trase_duckdb.trase-storage-raw.sicarm_ro_202302
• source.trase_duckdb.trase-storage-raw.sicarm_mt_202302
• source.trase_duckdb.trase-storage-raw.sicarm_rj_202302
• source.trase_duckdb.trase-storage-raw.sicarm_ap_202302
• source.trase_duckdb.trase-storage-raw.sicarm_pe_202302
• source.trase_duckdb.trase-storage-raw.sicarm_df_202302
• source.trase_duckdb.trase-storage-raw.sicarm_ce_202302
• source.trase_duckdb.trase-storage-raw.sicarm_sc_202302
• source.trase_duckdb.trase-storage-raw.sicarm_es_202302
• source.trase_duckdb.trase-storage-raw.sicarm_al_202302
• source.trase_duckdb.trase-storage-raw.sicarm_pr_202302
• source.trase_duckdb.trase-storage-raw.br_municipalities_2017
• source.trase_duckdb.trase-storage-raw.sicarm_ac_202302
• source.trase_duckdb.trase-storage-raw.sicarm_go_202302
• source.trase_duckdb.trase-storage-raw.sicarm_mg_202302
• source.trase_duckdb.trase-storage-raw.sicarm_pa_202302
• source.trase_duckdb.trase-storage-raw.sicarm_se_202302
• source.trase_duckdb.trase-storage-raw.sicarm_rs_202302
• source.trase_duckdb.trase-storage-raw.sicarm_pi_202302
• source.trase_duckdb.trase-storage-raw.sicarm_sp_202302
• source.trase_duckdb.trase-storage-raw.sicarm_ms_202302
• source.trase_duckdb.trase-storage-raw.sicarm_am_202302
• source.trase_duckdb.trase-storage-raw.sicarm_to_202302
• source.trase_duckdb.trase-storage-raw.sicarm_pb_202302
• source.trase_duckdb.trase-storage-raw.sicarm_ma_202302
• source.trase_duckdb.trase-storage-raw.sicarm_rr_202302

Sources

• ['trase-storage-raw', 'sicarm_ba_202302']
• ['trase-storage-raw', 'sicarm_rn_202302']
• ['trase-storage-raw', 'sicarm_ro_202302']
• ['trase-storage-raw', 'sicarm_mt_202302']
• ['trase-storage-raw', 'sicarm_rj_202302']
• ['trase-storage-raw', 'sicarm_ap_202302']
• ['trase-storage-raw', 'sicarm_pe_202302']
• ['trase-storage-raw', 'sicarm_df_202302']
• ['trase-storage-raw', 'sicarm_ce_202302']
• ['trase-storage-raw', 'sicarm_sc_202302']
• ['trase-storage-raw', 'sicarm_es_202302']
• ['trase-storage-raw', 'sicarm_al_202302']
• ['trase-storage-raw', 'sicarm_pr_202302']
• ['trase-storage-raw', 'br_municipalities_2017']
• ['trase-storage-raw', 'sicarm_ac_202302']
• ['trase-storage-raw', 'sicarm_go_202302']
• ['trase-storage-raw', 'sicarm_mg_202302']
• ['trase-storage-raw', 'sicarm_pa_202302']
• ['trase-storage-raw', 'sicarm_se_202302']
• ['trase-storage-raw', 'sicarm_rs_202302']
• ['trase-storage-raw', 'sicarm_pi_202302']
• ['trase-storage-raw', 'sicarm_sp_202302']
• ['trase-storage-raw', 'sicarm_ms_202302']
• ['trase-storage-raw', 'sicarm_am_202302']
• ['trase-storage-raw', 'sicarm_to_202302']
• ['trase-storage-raw', 'sicarm_pb_202302']
• ['trase-storage-raw', 'sicarm_ma_202302']
• ['trase-storage-raw', 'sicarm_rr_202302']

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