DBT Source: Certification Data Clean Semicolon
File location: s3://trase-storage/ecuador/logistics/certification/out/certification_data_clean_semicolon.csv
DBT source: trase-storage-raw.certification_data_clean_semicolon
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
No description
Details
| Column | Type | Description |
|---|---|---|
CERTIFICATION_DATASET |
VARCHAR |
|
CERT_NUM |
VARCHAR |
|
TRASE_NAME |
VARCHAR |
|
COMPANY |
VARCHAR |
|
ASSOCIATED_NAMES |
VARCHAR |
|
TYPE |
VARCHAR |
|
CERT_EXPIRY |
VARCHAR |
|
CERT_EXPIRY_YR |
VARCHAR |
|
CERT_START |
VARCHAR |
|
CERT_START_YR |
VARCHAR |
|
SPECIES |
VARCHAR |
|
LAT |
VARCHAR |
|
LONG |
VARCHAR |
|
COORD_NOTES |
VARCHAR |
|
CERT_BAP |
VARCHAR |
|
BAP_STAR_DESIGNATION |
VARCHAR |
|
CERT_BAP_NOTES |
VARCHAR |
|
CERT_ASC_NOTES |
VARCHAR |
|
CERT_ASC_TYPE |
VARCHAR |
|
TRASE_POND_ID |
VARCHAR |
|
POND_ID_MATCHING_NOTES |
VARCHAR |
No data tests defined 🧐
Models
-
Dbt source path:
memory.trase-storage-raw.certification_data_clean_semicolon -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml