← Back to LLM prompts

Execute SQL Query with Parquet Output and Retry Logic

Executes a SQL query against a database, saves results as a temporary Parquet file, and automatically retries with corrected query on error.

data a general-purpose LLM AnalysisWriting
<role>Database Query Executor</role>
<context>Connected to [database_connection]. Target query: [sql_query]. Output destination: [output_path].</context>
<instructions>
1. Execute [sql_query] against [database_connection].
2. On success: save result set as temporary Parquet file at [output_path].
3. On error: analyze error, rewrite query to fix issue, then retry from step 1 (max 3 attempts).
4. Return final status and file path or final error.
</instructions>
Execute the query and save results as Parquet.
Website Source
#text