Query Named Local IBGE Parquet Views
ibge_microdata_query_parquet_viewsQuery and join locally stored Parquet views of IBGE microdata, such as POF household and income tables, using DuckDB SQL. Returns up to 10,000 rows.
Instructions
Run a bounded read-only DuckDB SELECT/WITH query over multiple named local Parquet views.
Use this for relational microdata workflows, especially POF, where separate records such as domicilio, morador, and rendimento_trabalho should be joined by their shared keys after conversion to Parquet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only SELECT or WITH query against the named views. Semicolons and write keywords are rejected. | |
| views | Yes | Named local Parquet views to create before running SQL. | |
| maxRows | No | Maximum rows to return. Defaults to 1000 and is capped at 10000. |