Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.
How it works
Ask it something hard.
📎 ai-skill-for-snowflake.txtLOADED ✓
Our nightly ETL takes 2 hours on a Large warehouse and costs too much. What should I check in Snowflake first?
CLAUDE · WITH THIS SKILLYou get: the order to investigate (Query Profile, then warehouse, then SQL) -> the Snowsight path to Query History and what to read in the profile (bytes spilled, partitions scanned) -> what spilling versus poor pruning means and the fix for each -> an ACCOUNT_USAGE query on WAREHOUSE_METERING_HISTORY to prove credits before and after -> auto-suspend and a resource monitor with the Admin click path -> a one-line reason to profile first -> the single next action.
Questions before you buy? A person answers, usually the same day: hello@kissmyskills.com
// the file itself
Read it before you buy it.
The first lines of the file your AI will read, exactly as delivered. Nothing rewritten for the page.
Use the name Once the file is loaded, talk to it by name: “Serge, check this page.” That is what the name is for. It also keeps several skills apart in one chat.
// the skill your AI runs on
You are a senior Snowflake data engineer and administrator embedded in the user's daily work, across virtual warehouses, Snowpipe, Streams and Tasks, Time Travel and the Query Profile. You have been activated to get correct results first and credits second.
KissMySkills.com | Install: paste this whole file into Claude Projects (Project instructions), a custom GPT (Instructions), a Gemini Gem, or your AI's system prompt. Then just ask questions the way you normally would. You are a senior Snowflake data engineer and administrator embedded in the user's daily work: you write the SQL, design warehouses and roles, build pipelines and read query profiles. You optimise for correct results, then credits, then simplicity. Tone: direct, practical, step-by-step when steps are needed, with runnable SQL. · Architecture: separated storage and compute. Virtual warehouses (XS to 6XL, auto-suspend, auto-resume, multi-cluster) are billed per second with a 60-second minimum per resume. · Objects: Account > Databases > Schemas > Tables, Views, Stages, File Formats, Streams, Tasks, Pipes, Procedures. Permanent, transient and temporary tables differ in Time Travel and Fail-safe. · Time Travel (AT / BEFORE with TIMESTAMP, OFFSET or STATEMENT), UNDROP, Fail-safe, Zero-Copy Cloning. · Loading: internal and external stages (S3, Azure Blob, GCS), COPY INTO with file formats (CSV, JSON, Parquet), Snowpipe with auto-ingest, PUT from SnowSQL. · Semi-structured data: VARIANT, colon path notation, LATERAL FLATTEN, PARSE_JSON, INFER_SCHEMA. · Pipelines: Streams (standard, append-only), Tasks on a schedule or after a predecessor, task graphs, SYSTEM$STREAM_HAS_DATA, Dynamic Tables with a target lag. · SQL specifics: QUALIFY, RESULT_SCAN, MERGE, clustering keys, search optimization, query tags, TRY_CAST, ARRAY_AGG, window functions. · Performance: Query Profile in Snowsight, micro-partition pruning, spilling to remote storage as a sign to size up, result cache. · Security: RBAC with ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, USERADMIN and custom roles, future grants, network policies, key-pair auth, masking and row access policies, Secure Data Sharing. · Cost control: resource monitors, ACCOUNT_USAGE views (WAREHOUSE_METERING_HISTORY, QUERY_HISTORY), auto-suspend, STATEMENT_TIMEOUT_IN_SECONDS. · Programmability: Snowpark for Python, Java and Scala, UDFs, stored procedures, Streamlit in Snowflake, Cortex functions (only those you are sure exist). · Editions: Standard, Enterprise, Business Critical. Multi-cluster warehouses, 90 days Time Travel and masking policies need Enterprise or above.
74 lines · .txt · instant download
// what's inside
What's inside this skill
Runnable Snowflake SQL with QUALIFY, window functions, FLATTEN and MERGE
COPY INTO, stage, file format and Snowpipe setups with validation options
Streams, Tasks and Dynamic Tables designed as incremental pipelines
Warehouse sizing, resource monitors and ACCOUNT_USAGE cost queries
Data engineers, analytics engineers and Snowflake admins who write SQL and run pipelines on Snowflake daily.
// two ways to get it
Use it inside your AI, or download it once.
Library plan
This skill and 2,500+ others, inside your chat
$9/mocancel anytime, or $59 a year
All 2,500+ skills, prompt packs and agents, loaded the moment you ask
Nothing to download or paste: connect once in Claude, ChatGPT, Claude Code or Cursor
New skills every week and 10 catalog files a month to download
Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.
// ask your assistant
Or let your AI set up this skill for you.
Go to kissmyskills.com/pages/connector and set up the "AI Skill for Snowflake" skill (handle: ai-skill-for-snowflake) for me
Paste it into Claude, ChatGPT, Claude Code, Cursor or Codex. Your AI walks you through connecting KissMySkills (about 3 minutes, 7-day free trial) and loads the skill. What your AI will read →
What you're actually buying
This Claude/ChatGPT skill works as a Snowflake AI assistant inside your daily data work: it writes runnable Snowflake SQL with QUALIFY, FLATTEN and MERGE, the CREATE STAGE, FILE FORMAT and COPY INTO statements for loads, Snowpipe definitions, Streams and Tasks or Dynamic Tables for incremental pipelines, role hierarchies with GRANT statements, and masking and row access policies.
It knows warehouses and credit billing, micro-partition pruning and the Query Profile, Time Travel, UNDROP and Zero-Copy Cloning, ACCOUNT_USAGE views for cost, Snowpark and stored procedures, plus the traps like Tasks that never run because nobody resumed them. It does not operate Snowflake directly; it prepares the SQL, Snowsight click paths and checks so you run them yourself.
Works the same way in Claude, ChatGPT and Gemini. One purchase, download the file, install in under 2 minutes, then ask the way you would ask a senior data engineer next to you. Pairs with Oleg, Database Engineer, the persona skill; this one is the helper inside Snowflake.
// how to install
Under 2 minutes
Four steps. Any AI chat.
01
Download the file
After checkout, the download link lands in your inbox. Save the .txt file anywhere on your device.
02
Open your AI chat
Any AI chat you already use: Claude, ChatGPT, Gemini, Grok, Copilot or another.
03
Paste the prompt
Open the .txt file, copy the prompt section and paste it into Claude or ChatGPT - or add it to a Project so it is always there.
04
Start working
Your AI is now configured as a specialist. Ask it anything inside its domain.
No technical knowledge required.
With Library there is nothing to download. Connect your AI once, then ask for any skill by name.
It turns Claude, ChatGPT or Gemini into a Snowflake AI assistant that writes and fixes SQL, builds loads with COPY INTO and Snowpipe, designs Streams, Tasks and Dynamic Tables, writes role grants and masking policies, reads Query Profiles and tunes warehouse sizes and credits.
Does it operate Snowflake for me?+
No. It never runs queries, creates objects or changes warehouses in your Snowflake account. It prepares runnable SQL, Snowpark code and Snowsight click paths, and warns you before DROP, TRUNCATE, production ALTERs or anything that burns credits at scale, suggesting a CLONE or Time Travel check first.
Can it help lower my Snowflake credit spend?+
Yes. It reads your Snowflake Query Profile description for spilling and poor pruning, recommends warehouse size and auto-suspend changes, writes the ACCOUNT_USAGE queries that show credits per warehouse and per query, and sets up resource monitors with quotas and triggers.
Which AI tools does this skill work with?+
Works with Claude (recommended), Claude Code, ChatGPT, Gemini and Copilot, and any AI chat that accepts system prompts. Claude Projects gives the best results because it remembers your Snowflake databases, schemas, roles and warehouse layout between chats.
Ready to give your AI a specialist?
This one and 2,500+ others, inside Claude, ChatGPT, Claude Code, Codex or Cursor. Cancel anytime.