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