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
CDA VARCHAR
TYPE VARCHAR
CAPACITY VARCHAR
COMPANY VARCHAR
UF VARCHAR
MUNICIPALITY VARCHAR
ADDRESS VARCHAR
LAT VARCHAR
LONG VARCHAR
GEOCODE VARCHAR

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