DBT Source: Seipcs Brazil Soy 2015
File location: s3://trase-storage/brazil/soy/sei_pcs/post-processed/SEIPCS_BRAZIL_SOY_2015.csv
DBT source: trase-storage-raw.seipcs_brazil_soy_2015
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
No description
Details
| Column | Type | Description |
|---|---|---|
COUNTRY_OF_ORIGIN |
VARCHAR |
|
BIOME_TRASE_ID |
VARCHAR |
|
COMODITY |
VARCHAR |
|
YEAR |
VARCHAR |
|
EXPORTER |
VARCHAR |
|
EXPORTER_TAX_ID |
VARCHAR |
|
PORT_OF_EXPORT |
VARCHAR |
|
COUNTRY_OF_DESTINATION |
VARCHAR |
|
COUNTRY_OF_DESTINATION_TRASE_ID |
VARCHAR |
|
IMPORTER |
VARCHAR |
|
VOLUME_RAW |
VARCHAR |
|
VOLUME_NORM |
VARCHAR |
|
FOB |
VARCHAR |
|
BRANCH |
VARCHAR |
|
PRODUCT |
VARCHAR |
|
STATUS |
VARCHAR |
|
LVL3_NAME_PROD |
VARCHAR |
|
LVL3_TRASE_ID_PROD |
VARCHAR |
|
LVL6_GEOCODE_PROD |
VARCHAR |
|
LVL6_NAME_PROD |
VARCHAR |
|
LVL6_TRASE_ID_PROD |
VARCHAR |
|
LVL6_GEOCODE_LH |
VARCHAR |
|
LVL6_NAME_LH |
VARCHAR |
|
LVL6_TRASE_ID_LH |
VARCHAR |
|
QA_EXPORT_MUN |
VARCHAR |
|
EXPORTER_TRASE_ID |
VARCHAR |
No data tests defined 🧐
Models
soy_stickiness_2017_port_cnpj8soy_stickiness_2017_port_cnpj8_lhsoy_stickiness_2017_port_exporter_tax_idsoy_stickiness_2017_port_exporter_tax_id_lhsoy_stickiness_2019_port_cnpj8soy_stickiness_2019_port_cnpj8_lhsoy_stickiness_2019_port_exportersoy_stickiness_2019_port_exporter_tax_idsoy_stickiness_2019_port_exporter_tax_id_lh
-
Dbt source path:
memory.trase-storage-raw.seipcs_brazil_soy_2015 -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml