Skip to content

DBT: Traders

File location: s3://trase-storage/ecuador/logistics/ruc/out/traders.csv

DBT model name: traders

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
FileName VARCHAR
NUMERO_RUC VARCHAR
trader_label VARCHAR
NOMBRE_COMERCIAL VARCHAR
ESTADO_CONTRIBUYENTE VARCHAR
CLASE_CONTRIBUYENTE VARCHAR
FECHA_INICIO_ACTIVIDADES VARCHAR
FECHA_ACTUALIZACION VARCHAR
FECHA_SUSPENSION_DEFINITIVA VARCHAR
FECHA_REINICIO_ACTIVIDADES VARCHAR
OBLIGADO VARCHAR
TIPO_CONTRIBUYENTE VARCHAR
NUMERO_ESTABLECIMIENTO VARCHAR
NOMBRE_FANTASIA_COMERCIAL VARCHAR
CALLE VARCHAR
NUMERO VARCHAR
INTERSECCION VARCHAR
ESTADO_ESTABLECIMIENTO VARCHAR
province_name VARCHAR
canton_of_headquarters VARCHAR
parish_name VARCHAR
ACTIVIDAD_ECONOMICA VARCHAR
geocode VARCHAR
name VARCHAR
DPA_VALOR VARCHAR
DPA_ANIO VARCHAR
canton_geocode VARCHAR
canton_name VARCHAR
DPA_PROVIN VARCHAR
DPA_DESPRO VARCHAR
parish_trase_id VARCHAR
canton VARCHAR
parish_of_headquarters VARCHAR
trader VARCHAR

No data tests defined 🧐

Models

Models

Sources

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.ref("shrimp_ciiu")
    dbt.ref("parish")
    dbt.source("trase-storage-raw", "out")

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