DBT Source: Cd Ecuador 2017
File location: s3://trase-storage/ecuador/trade/cd/export/2017/CD_ECUADOR_2017.csv
DBT source: trase-storage-raw.cd_ecuador_2017
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
No description
Details
| Column | Type | Description |
|---|---|---|
Year |
VARCHAR |
|
Import.Declaration.Number |
VARCHAR |
|
Date.yyyy.mm |
VARCHAR |
|
Date.yyyy.mm.dd |
VARCHAR |
|
Company.ID.Number |
VARCHAR |
|
Exporter |
VARCHAR |
|
Address |
VARCHAR |
|
Importer |
VARCHAR |
|
Country.of.Origin |
VARCHAR |
|
Country.of.Destiny |
VARCHAR |
|
Product.Schedule.B.Code |
VARCHAR |
|
Product.Description.by.Schedule.B.Code |
VARCHAR |
|
Product.Description |
VARCHAR |
|
Harmonized.Code.Product.Spanish |
VARCHAR |
|
Harmonized.Code.Description.English |
VARCHAR |
|
TOTAL.Quantity.1 |
VARCHAR |
|
Measure.Unit.1..Quantity.1. |
VARCHAR |
|
TOTAL.FOB.Value..US.. |
VARCHAR |
|
FOB.per.Unit..Quantity1. |
VARCHAR |
|
TOTAL.CIF.Value..US.. |
VARCHAR |
|
TOTAL.Net.Weight..Kg. |
VARCHAR |
|
TOTAL.Gross.Weight..Kg. |
VARCHAR |
|
Type.of.Transport |
VARCHAR |
|
Custom |
VARCHAR |
|
Date.Loading |
VARCHAR |
|
Bill.of.Lading |
VARCHAR |
|
Transport.Company |
VARCHAR |
|
Manifest |
VARCHAR |
|
Regime |
VARCHAR |
|
Port.of.Loading |
VARCHAR |
|
Countersign |
VARCHAR |
No data tests defined 🧐
Models
-
Dbt source path:
memory.trase-storage-raw.cd_ecuador_2017 -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml