Troubleshooting
AI function error or function not found
- Verify that the data warehouse AI functions are enabled (see Setup Guide for your warehouse)
- Check you have the required permissions (for example, Vertex AI User for BigQuery, CORTEX_USER for Snowflake)
- Ensure correct function syntax for your warehouse
High costs or slow queries
- Reduce polling frequency or data volume processed (use tumbling windows where possible)
- Use
WHERE
clauses to filter before applying AI functions - Consider sampling for very large datasets
Inconsistent LLM responses
- Make prompts more specific and directive
- Test prompts with various input examples
- Consider setting the LLM temperature to 0
Updated about 4 hours ago