Skip to content

Seipcs Bolivia Soy 2021

s3://trase-storage/bolivia/soy/sei_pcs/v1.0.0/SEIPCS_BOLIVIA_SOY_2021.csv

Dbt path: trase_production.main.seipcs_bolivia_soy_2021

Explore on Metabase: Full table; summary statistics

Containing yaml file link: trase/data_pipeline/models/bolivia/soy/sei_pcs/v1_0_0/_schema.yml

Model file link: trase/data_pipeline/models/bolivia/soy/sei_pcs/v1_0_0/seipcs_bolivia_soy_2021.py

Calls script: trase/models/bolivia/soy

Dbt test runs & lineage: Test results ยท Lineage

Full dbt_docs page: Open in dbt docs (includes lineage graph -at the bottom right-, tests, and downstream dependencies)

Tags: mock_model, bolivia, sei_pcs, soy, v1.0.0

seipcs_bolivia_soy_2021

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. The script is located at trase/models/bolivia/soy [permalink]. It was last run by Harry Biddle.

Details

Column Type Description

Models / Seeds

  • source.trase_duckdb.trase-storage-raw.bo_municipalities_level4
  • source.trase_duckdb.trase-storage-raw.bol_soy_prod_5_ha_estimates
  • source.trase_duckdb.trase-storage-raw.bo_distance_matrix_silos_ports
  • source.trase_duckdb.trase-storage-raw.bo_distance_matrix_mun_processing
  • source.trase_duckdb.trase-storage-raw.bolivia_assets
  • source.trase_duckdb.trase-storage-raw.people_per_municipality_2018_2022
  • source.trase_duckdb.trase-storage-raw.bo_distance_matrix_silos_processors
  • source.trase_duckdb.trase-storage-raw.additional_flows
  • source.trase_duckdb.trase-storage-raw.bo_distance_matrix_processing_port
  • source.trase_duckdb.trase-storage-raw.bo_distance_matrix_mun_silos
  • model.trase_duckdb.bolivia_soy_export_2018
  • model.trase_duckdb.bolivia_soy_export_2019
  • model.trase_duckdb.bolivia_soy_export_2020
  • model.trase_duckdb.bolivia_soy_export_2021

Sources

  • ['trase-storage-raw', 'bo_municipalities_level4']
  • ['trase-storage-raw', 'bol_soy_prod_5_ha_estimates']
  • ['trase-storage-raw', 'bo_distance_matrix_silos_ports']
  • ['trase-storage-raw', 'bo_distance_matrix_mun_processing']
  • ['trase-storage-raw', 'bolivia_assets']
  • ['trase-storage-raw', 'people_per_municipality_2018_2022']
  • ['trase-storage-raw', 'bo_distance_matrix_silos_processors']
  • ['trase-storage-raw', 'additional_flows']
  • ['trase-storage-raw', 'bo_distance_matrix_processing_port']
  • ['trase-storage-raw', 'bo_distance_matrix_mun_silos']

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "bo_municipalities_level4")
    dbt.source("trase-storage-raw", "bol_soy_prod_5_ha_estimates")
    dbt.source("trase-storage-raw", "bo_distance_matrix_silos_ports")
    dbt.source("trase-storage-raw", "bo_distance_matrix_mun_processing")
    dbt.ref("bolivia_soy_export_2018")
    dbt.ref("bolivia_soy_export_2019")
    dbt.ref("bolivia_soy_export_2020")
    dbt.ref("bolivia_soy_export_2021")
    dbt.source("trase-storage-raw", "bolivia_assets")
    dbt.source("trase-storage-raw", "people_per_municipality_2018_2022")
    dbt.source("trase-storage-raw", "bo_distance_matrix_silos_processors")
    dbt.source("trase-storage-raw", "additional_flows")
    dbt.source("trase-storage-raw", "bo_distance_matrix_processing_port")
    dbt.source("trase-storage-raw", "bo_distance_matrix_mun_silos")

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