DBT Source: 02023000-201501-201812imp Ccd
File location: s3://trase-storage/china/trade/originals/02023000-201501-201812imp CCD.xlsx
DBT source: trase-storage-raw.02023000-201501-201812imp ccd
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
No description
Details
| Column | Type | Description |
|---|---|---|
ImpExp |
VARCHAR |
|
HSCode |
VARCHAR |
|
ProductName |
VARCHAR |
|
Month |
VARCHAR |
|
TraderCode |
VARCHAR |
|
ChineseTraderNameCN |
VARCHAR |
|
ChineseTraderName |
VARCHAR |
|
PlantLocation |
VARCHAR |
|
Quantity |
VARCHAR |
|
ValueUSD |
VARCHAR |
|
PriceUSD |
VARCHAR |
|
PriceUnitUSD |
VARCHAR |
|
OriginOrDestinationCountry |
VARCHAR |
|
Customs |
VARCHAR |
|
TradeMethod |
VARCHAR |
|
Shipment |
VARCHAR |
|
RoutingCountry |
VARCHAR |
|
PreferentialGeneralTarrifRate |
VARCHAR |
|
PreferentialGeneralShippingTonnageDuty |
VARCHAR |
|
OriginOrDestinationEconomicRegion |
VARCHAR |
|
OriginOrDestinationContinent |
VARCHAR |
|
OriginOrDestinationRegion |
VARCHAR |
|
QuantityUnit |
VARCHAR |
|
Quantity_1 |
VARCHAR |
|
ValueCNY |
VARCHAR |
|
PriceCNY |
VARCHAR |
|
PriceUnitCNY |
VARCHAR |
|
Tel |
VARCHAR |
|
Fax |
VARCHAR |
|
Zip |
VARCHAR |
|
Email |
VARCHAR |
|
Linkman |
VARCHAR |
|
CompanyType |
VARCHAR |
|
Address |
VARCHAR |
|
CompanyLocation |
VARCHAR |
|
EconomicZone |
VARCHAR |
|
Province |
VARCHAR |
|
Region |
VARCHAR |
|
PaymentTerms |
VARCHAR |
|
PaymentTermsNote |
VARCHAR |
|
Industry |
VARCHAR |
|
SubIndustry |
VARCHAR |
|
Year |
VARCHAR |
No data tests defined 🧐
-
Dbt source path:
memory.trase-storage-raw.02023000-201501-201812imp ccd -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml