Query Local IBGE Parquet
ibge_microdata_query_parquetRun bounded SQL queries on IBGE microdata Parquet files to compute summaries and statistics without reparsing original TXT files.
Instructions
Run a bounded read-only DuckDB SELECT/WITH query over local Parquet files.
The provided files are exposed as a view named microdata. Use this after converting IBGE fixed-width microdata to Parquet when you need repeated summaries, grouped tabulations, or weighted statistics without reparsing the original TXT files.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only SELECT or WITH query against the microdata view. Semicolons and write keywords are rejected. | |
| maxRows | No | Maximum rows to return. Defaults to 1000 and is capped at 10000. | |
| parquetPaths | Yes | Local Parquet file paths to expose as a DuckDB view named microdata. |