DBT Source: Sicasq 2026
File location: s3://trase-storage/brazil/logistics/sicasq/out/SICASQ_2026.csv
DBT source: trase-storage-raw.sicasq_2026
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
No description
Details
| Column | Type | Description |
|---|---|---|
company |
VARCHAR |
|
cnpj |
VARCHAR |
|
product |
VARCHAR |
|
status |
VARCHAR |
|
level |
VARCHAR |
|
cnae |
VARCHAR |
|
municipality_name |
VARCHAR |
|
trase_id |
VARCHAR |
Trase ID of the municipality the registered establishment is in. The Brazil soy model reads every input against the 2023 municipal map whatever the year (see MUNICIPALITIES_ON_THE_2024_MAP in trase/models/brazil/soy_2023_2024_v27/constants.py), so it is checked against the 2023 edition of IBGE's Divisão Territorial Brasileira. |
uf |
VARCHAR |
|
destination |
VARCHAR |
|
economic_bloc |
VARCHAR |
|
latitude |
VARCHAR |
|
longitude |
VARCHAR |
No data tests defined 🧐
-
Dbt source path:
memory.trase-storage-raw.sicasq_2026 -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml
-
Tags:
brazil_soy_2022_2025_update