Make file queryable
fastero_create_file_connectionMake an uploaded CSV or Excel file queryable with SQL: a connection over the file, holding it as one table. Answers with connectionId and tableName. fastero_run_sql then runs SQL on it in DuckDB's dialect (SELECT * FROM "" LIMIT 10), fastero_list_connection_schemas lists its columns, and fastero_create_query or fastero_save_chart keeps a query on it for charts and dashboards. An Excel file gives one sheet: sheetName, else the first, and the answer names it. A file that already has a connection answers with that one (created: false), unless sheetName asks for a sheet it does not hold. The connection reads the latest upload of the file: after a file of the same name is uploaded again, its next query reads the new one. Any other file type is refused; a database is connected with fastero_create_connection instead. Owners, admins and editors of the project can make one.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | The connection’s name. Defaults to "<file name> (file connection)". | |
| fileId | Yes | An uploaded file’s id, from fastero_list_files. | |
| projectId | Yes | The project’s id, from fastero_list_projects. | |
| sheetName | No | For an Excel file: the sheet to load. The first sheet when left out. |