CSV Files
The Greppilot CSV integration allows you to upload comma-separated value files and query their contents using SQL. This turns your local CSV data into a queryable data source within the Greppilot dashboard.
Setup
Unlike other integrations, the CSV integration does not require any external authentication or configuration fields. To integrate a CSV file:
- Navigate to the Integrations section in Greppilot.
- Select CSV Files and click Connect.
- You will be prompted to upload a CSV file. Once uploaded, the file becomes immediately available for querying.
Only one CSV file can be active per CSV integration instance. Uploading a new file will replace the previously uploaded file associated with that integration.
Querying CSV Data
Once a CSV file is uploaded, you can query it using natural language or SQL. The agent can execute SELECT queries directly against your uploaded data.
The uploaded CSV data is exposed as a virtual table named data. Column names and types are inferred automatically during the upload process.
| Parameter | Type | Description |
|---|---|---|
sql | string | The SQL SELECT query to execute against the CSV data. The table name for your CSV data is data. |
Example Queries
Chat:
"Can you show me the total sales from the 'data' table?"
"What are the top 5 products by revenue?"
"Plot sales over time from the 'data' table."
Greppilot automatically coerces numeric string values (e.g., from COUNT(*) or SUM()) returned by SQL queries back into numbers. This ensures values render correctly in charts and other visualizations.
Technical Details
Once a CSV file is uploaded, its contents are available as a queryable SQL table named data. Column names and types are inferred automatically, and the data can be queried with standard SELECT statements just like any other connected database.