{"id":"07e0a0b3-3dc8-4c5b-8206-64266fab544d","shortId":"ceXpas","kind":"skill","title":"Snowflake Query History Extractor","tagline":"Extracts query history and performance metadata from Snowflake using the Snowflake Python Connector and INFORMATION_SCHEMA.QUERY_HISTORY view. Identifies expensive queries by credits consumed, data scanned, and spillage to remote storage. Exports results to a Pandas DataFrame for","description":"# Snowflake Query History Extractor\n\nExtracts query history and performance metadata from Snowflake using the Snowflake Python Connector and INFORMATION_SCHEMA.QUERY_HISTORY view. Identifies expensive queries by credits consumed, data scanned, and spillage to remote storage. Exports results to a Pandas DataFrame for downstream analysis or Slack reporting.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- git clone git@github.com:snowflakedb/snowflake-connector-python.git\n- python -m pip install -U pip setuptools wheel build\n\nRequirements and caveats from upstream:\n- # Snowflake Connector for Python\n- [![Build and Test](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)\n- [![codecov](https://codecov.io/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=MVKSNtnLr0)](https://codecov.io/gh/snowflakedb/snowflake-connector-python)\n\nBasic usage or getting-started notes:\n- to create a wheel package using PEP-517 build:\n- shell\n- Find the snowflake_connector_python*.whl package in the ./dist directory.\n\n- Source: https://github.com/snowflakedb/snowflake-connector-python\n- Extracted from upstream docs: https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/snowflake-query-history-extractor/)","tags":["snowflake","query","history","extractor","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-snowflake-query-history-extractor","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/snowflake-query-history-extractor","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,517 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:12:32.238Z","embedding":null,"createdAt":"2026-05-18T13:19:30.066Z","updatedAt":"2026-05-18T19:12:32.238Z","lastSeenAt":"2026-05-18T19:12:32.238Z","tsv":"'-517':146 '/dist':158 '/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=mvksntnlr0)](https://codecov.io/gh/snowflakedb/snowflake-connector-python)':131 '/skills/snowflake-query-history-extractor/)':177 '/snowflakedb/snowflake-connector-python':163 '/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)':127 '/snowflakedb/snowflake-connector-python/head/readme.md':170 'agent':172 'agentskillexchange.com':176 'agentskillexchange.com/skills/snowflake-query-history-extractor/)':175 'analysi':84 'basic':132 'build':112,122,147 'caveat':115 'clone':101 'codecov':128 'codecov.io':130 'codecov.io/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=mvksntnlr0)](https://codecov.io/gh/snowflakedb/snowflake-connector-python)':129 'connector':17,58,119,152 'consum':27,68 'creat':140 'credit':26,67 'data':28,69 'datafram':40,81 'directori':159 'doc':167 'downstream':83 'environ':99 'exchang':174 'expens':23,64 'export':35,76 'extract':5,46,164 'extractor':4,45 'find':149 'get':136 'getting-start':135 'git':100 'git@github.com':102 'github.com':126,162 'github.com/snowflakedb/snowflake-connector-python':161 'github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)':125 'histori':3,7,20,44,48,61 'identifi':22,63 'information_schema.query':19,60 'instal':88,92,107 'm':105 'match':97 'metadata':10,51 'note':138 'packag':143,155 'panda':39,80 'path':95 'pep':145 'perform':9,50 'pip':106,109 'python':16,57,104,121,153 'queri':2,6,24,43,47,65 'raw.githubusercontent.com':169 'raw.githubusercontent.com/snowflakedb/snowflake-connector-python/head/readme.md':168 'remot':33,74 'report':87 'requir':113 'result':36,77 'scan':29,70 'setup':94 'setuptool':110 'shell':148 'skill':173 'skill-snowflake-query-history-extractor' 'slack':86 'snowflak':1,12,15,42,53,56,118,151 'snowflakedb/snowflake-connector-python.git':103 'sourc':160,171 'source-agentskillexchange' 'spillag':31,72 'start':137 'storag':34,75 'test':124 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'u':108 'upstream':91,117,166 'usag':133 'use':13,54,89,144 'view':21,62 'wheel':111,142 'whl':154","prices":[{"id":"694bd499-0962-47df-a5a7-cf78a12a9e7d","listingId":"07e0a0b3-3dc8-4c5b-8206-64266fab544d","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:19:30.066Z"}],"sources":[{"listingId":"07e0a0b3-3dc8-4c5b-8206-64266fab544d","source":"github","sourceId":"agentskillexchange/skills/snowflake-query-history-extractor","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/snowflake-query-history-extractor","isPrimary":false,"firstSeenAt":"2026-05-18T13:19:30.066Z","lastSeenAt":"2026-05-18T19:12:32.238Z"}],"details":{"listingId":"07e0a0b3-3dc8-4c5b-8206-64266fab544d","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"snowflake-query-history-extractor","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"2a04ed703aa9f89b282afe3fc544a4908d80ab4a","skill_md_path":"skills/snowflake-query-history-extractor/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/snowflake-query-history-extractor"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Snowflake Query History Extractor","description":"Extracts query history and performance metadata from Snowflake using the Snowflake Python Connector and INFORMATION_SCHEMA.QUERY_HISTORY view. Identifies expensive queries by credits consumed, data scanned, and spillage to remote storage. Exports results to a Pandas DataFrame for downstream analysis or Slack reporting."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/snowflake-query-history-extractor"},"updatedAt":"2026-05-18T19:12:32.238Z"}}