Skip to content

DBT: Jjhinrichsen 2023 Csv

File location: s3://trase-storage/brazil/logistics/jjhinrichsen/jjhinrichsen_2023.csv

DBT model name: jjhinrichsen_2023_csv

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Description

2023 crushing-capacity figures, manually extracted from the JJ Hinrichsen PDF (jjhinrichsen_2023_pdf) into a CSV; consumed by CRUSHING_FACILITIES_2003_2023.py. Superseded from 2024 onwards by the ABIOVE_CAPACITY_MAP Python literal (see the jj_hinrichsen_anuario doc).

Details

Column Type Description
Company VARCHAR
location VARCHAR
Department VARCHAR
Capacity VARCHAR
Process VARCHAR
Seed VARCHAR
Remarks 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", "jjhinrichsen_2023_pdf")

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