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