connect_source
Register a CSV, Postgres, or REST API data source for SQL queries via DuckDB. Provide credentials via environment variables or a YAML config file.
Instructions
Register a data source (CSV file, Postgres database, or REST API). Credentials must be in environment variables or a YAML config file — never pass connection strings directly.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | Base URL for REST API sources | |
| name | Yes | Unique name for this data source | |
| path | No | File path for CSV/JSON sources | |
| type | Yes | Type of the data source | |
| source_config_path | No | Path to a YAML config file. If provided, all sources in the file are registered. |