How does billing work for Cortex AI functions?

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.

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

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'.

How do I optimize AI_FILTER performance in Snowflake?

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.

Does this skill support Snowpark Container Services?

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

Which AI models are available via Snowflake Cortex?

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

Name: Snowflake AI & App Platform
Author: brendadeeznuts1111

bybrendadeeznuts1111

数据库管理

Builds and deploys applications on Snowflake's AI Data Cloud using snow CLI, Cortex AI functions, and Native App patterns.

关于

This skill empowers developers to build, deploy, and manage sophisticated applications within the Snowflake AI Data Cloud ecosystem. It provides expert guidance on utilizing the Snowflake CLI (snow) for project management, implementing Cortex AI functions directly in SQL for LLM capabilities, and navigating the complexities of Native App development and Marketplace publishing. By covering essential patterns like JWT key-pair authentication, Snowpark integration, and Snowpark Container Services (SPCS) authentication, it helps prevent common configuration errors and optimizes cost management for AI-driven data applications.

主要功能

JWT key-pair authentication setup and account identifier troubleshooting
0 GitHub stars
Snowflake CLI (snow) configuration and command management
Native App project structuring and Marketplace publishing workflows
Cortex AI function implementation (Complete, Summarize, Translate, AI_FILTER)
Snowpark Python and SPCS container authentication patterns

使用场景

Developing and publishing Snowflake Native Apps to the Data Marketplace
Integrating LLM capabilities directly into SQL queries using Snowflake Cortex
Automating secure authentication for CI/CD pipelines using JWT and snow CLI

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brendadeeznuts1111/tier-1380-omega snowflake-platform

For use in Claude.ai and ChatGPT

Download Skill

GitHub

关于