Snowflake AI & App Platform FAQs

Question 1

How does billing work for Cortex AI functions?

Accepted Answer

Billing is based on token consumption (roughly 4 characters per token) for both input and output, with rates varying depending on the specific model's complexity.

Question 2

What is the difference between an account locator and an organization-account?

Accepted Answer

An organization-account (orgname-accountname) is used for connection URLs and config, while the Account Locator (e.g., NZ90655) is specifically required for JWT claims like 'iss' and 'sub'.

Question 3

How do I optimize AI_FILTER performance in Snowflake?

Accepted Answer

Best practice is to combine AI_FILTER with traditional SQL predicates (like date ranges) to reduce the dataset before the AI processes the remaining records, which can lead to 2-10x speedups.

Question 4

Does this skill support Snowpark Container Services?

Accepted Answer

Yes, it includes guidance for SPCS container authentication, including the automatic detection of service identifier tokens in newer connector versions.

Question 5

Which AI models are available via Snowflake Cortex?

Accepted Answer

You can access premium models like Claude 3.5 Sonnet, Llama 3.1, Mistral Large 2, and Snowflake Arctic directly through SQL functions.

Snowflake AI & App Platform

Key Features

Use Cases

Snowflake AI & App Platform

Key Features

Use Cases