shield_lock
JinDaGe
← Back to skills
extension
Category: Data & AnalyticsNo API key required

Snowflake 查询分析器

使用 Snowflake 信息模式和查询历史视图来分析和优化 Snowflake SQL 查询。识别仓库尺寸问题、扫描低效问题，并推荐聚类键。

personAuthor: user_3c6cb52ehubcommunity
downloadDownload package

Snowflake 查询分析器

Profiles and optimizes Snowflake SQL queries using the Snowflake Information Schema and Query History views. Identifies warehouse sizing issues, scanning inefficiencies, and recommends clustering keys.

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

  • Build and Test
  • codecov

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