Skip to content

DBT: Cd Dashboard Brazil 2018

File location: s3://trase-storage/brazil/trade/cd/dashboard/out/CD_DASHBOARD_BRAZIL_2018.csv

DBT model name: cd_dashboard_brazil_2018

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

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 Harry Biddle.

Details

Column Type Description
date VARCHAR
hs8 VARCHAR
hs_description VARCHAR
country_of_destination.label VARCHAR
fob VARCHAR
exporter.label VARCHAR
exporter.municipality.label VARCHAR
volume VARCHAR
exporter.cnpj VARCHAR
exporter.zip VARCHAR
via VARCHAR
via.name VARCHAR
year VARCHAR
month VARCHAR
hs6 VARCHAR
hs4 VARCHAR
exporter.cnpj.valid VARCHAR
port_of_export.name VARCHAR
state.name VARCHAR
state.trase_id VARCHAR
check VARCHAR
exporter.municipality.name VARCHAR
exporter.municipality.trase_id VARCHAR
exporter.municipality.state.trase_id VARCHAR
country_of_destination.name VARCHAR
country_of_destination.trase_id VARCHAR

No data tests defined 🧐

Models

Models

Sources

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.ref("hs2017")
    dbt.source("trase-storage-raw", "cd_brazil_2018")
    dbt.source("trase-storage-raw", "cd_brazil_2018_zipcodes_post_office")

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