DBT Source: Piers 2015

File location: s3://trase-storage/brazil/trade/bol/2015/originals/PIERS_2015.xlsx

DBT source: trase-storage-raw.piers_2015

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

---

Description

No description

---

Details

ColumnsData TestsReferenced ByDBT details

Column	Type	Description
Carrir_Agent	VARCHAR
Carrir_Group_SCAC	VARCHAR
Carrier_Name	VARCHAR
HS4_Code	VARCHAR
HS8_Code	VARCHAR
HS8_English	VARCHAR
BL_Description	VARCHAR
POR_Country	VARCHAR
POR_Name	VARCHAR
POR_Tradelane	VARCHAR
POL_Country	VARCHAR
POL_Name	VARCHAR
POL_Terminal	VARCHAR
POL_Tradelane	VARCHAR
POD_Country	VARCHAR
POD_Name	VARCHAR
POD_Terminal	VARCHAR
POD_Tradelane	VARCHAR
DEST_Country	VARCHAR
DEST_Name	VARCHAR
DEST_Tradelane	VARCHAR
POMO_Country	VARCHAR
POMO_Name	VARCHAR
POMO_Tradelane	VARCHAR
POMD_Country	VARCHAR
POMD_Name	VARCHAR
POMD_Tradelane	VARCHAR
YYYY	VARCHAR
YYYYMM	VARCHAR
YYYYMMDD	VARCHAR
Shipper	VARCHAR
Shipper_Type	VARCHAR
Shipper_Street	VARCHAR
Shipper_Neighborhood	VARCHAR
Shipper_City	VARCHAR
Shipper_State_Name	VARCHAR
Shipper_State	VARCHAR
Shipper_Zip	VARCHAR
Shipper_Country_Name	VARCHAR
Shipper_Registration_Number	VARCHAR
Consignee	VARCHAR
Consignee_Type	VARCHAR
Consignee_Street	VARCHAR
Consignee_Neighborhood	VARCHAR
Consignee_City	VARCHAR
Consignee_State_Name	VARCHAR
Consignee_State	VARCHAR
Consignee_Zip	VARCHAR
Consignee_Country_Name	VARCHAR
Consignee_Registration_Number	VARCHAR
Forwarder	VARCHAR
Forwarder_Type	VARCHAR
Forwarder_Street	VARCHAR
Forwarder_Neighborhood	VARCHAR
Forwarder_City	VARCHAR
Forwarder_State_Name	VARCHAR
Forwarder_State	VARCHAR
Forwarder_Zip	VARCHAR
Forwarder_Country_Name	VARCHAR
Forwarder_Registration_Number	VARCHAR
Notify	VARCHAR
Notify_Type	VARCHAR
Notify_Street	VARCHAR
Notify_Neighborhood	VARCHAR
Notify_City	VARCHAR
Notify_State_Name	VARCHAR
Notify_State	VARCHAR
Notify_Zip	VARCHAR
Notify_Country_Name	VARCHAR
Notify_Registration_Number	VARCHAR
Operator_Agent	VARCHAR
Operator_Name	VARCHAR
Port_Rotation	VARCHAR
Service_Name	VARCHAR
Transit_Time	VARCHAR
Cargo_Type	VARCHAR
Container_Type	VARCHAR
Mode	VARCHAR
Package_Type	VARCHAR
WTMT	VARCHAR
C20	VARCHAR
C40	VARCHAR
TEU	VARCHAR
Id_Datamar	VARCHAR

No data tests defined 🧐

Models

• brazil_bol_2015

• Dbt source path: memory.trase-storage-raw.piers_2015

• Source yml: trase/data_pipeline/models/_sources_trase_storage.yml

• Original dbt_docs