Snowflake 查询历史提取器
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.
Installation
Use the upstream install or setup path that matches your environment:
- git clone git@github.com:snowflakedb/snowflake-connector-python.git
- python -m pip install -U pip setuptools wheel build
Requirements and caveats from upstream:
- # Snowflake Connector for Python
-
-
Basic usage or getting-started notes:
- to create a wheel package using PEP-517 build:
- shell
- Find the snowflake_connector_python*.whl package in the ./dist directory.
- Source: https://github.com/1991513ccie-png/skills
- Extracted from upstream docs: https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/HEAD/README.md
