Skip to content

DBT: Certification Data Cleaned

File location: s3://trase-storage/ecuador/logistics/certification/out/certification_data_cleaned.csv

DBT model name: certification_data_cleaned

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Description

This model was auto-generated based off .yml 'lineage' files in S3. The DBT model just raises an error; the actual script that created the data lives elsewhere. It was last run by Harry Biddle.

Details

Column Type Description
certification VARCHAR
CERT_NUM VARCHAR
trader_label 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
pond VARCHAR
POND_ID_MATCHING_NOTES VARCHAR
trader VARCHAR

No data tests defined 🧐

Models

Sources

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "certification_data_clean_semicolon")

    raise NotImplementedError()
    return pd.DataFrame({"hello": ["world"]})