Sep 25, 2025: AI_COUNT_TOKENS AISQL function (Preview)

The Snowflake AISQL AI_COUNT_TOKENS function helps you size your AI workloads by calculating the total number of input tokens processed by AISQL large language models and task-specific functions, so you can size queries appropriately before hitting model limits and accurately estimate costs based on input token usage.

Key features of AI_COUNT_TOKENS include:

  • Count tokens: Calculate the total number of input tokens for any AISQL function, including AI_COMPLETE, AI_EMBED, AI_CLASSIFY, and AI_SENTIMENT. AI_COUNT_TOKENS also takes the specific model into account for functions that can use different models.

  • Get cost optimization insights: Get precise input token counts before running operations, helping you optimize prompts and right-size AI spending across your organization.

  • Support complex configurations: Analyze the impact of advanced features like classification with custom labels, descriptions, task definitions, and examples to understand the full token impact of your AI workflows.

For more information, see AI_COUNT_TOKENS.

Language: English