shield_lock
金大哥
← 返回 Skill 列表
extension
分类: 数据与分析无需 API Key

Snowflake 查询优化器代理

使用 ACCOUNT_USAGE 中的 QUERY_HISTORY 和 ACCESS_HISTORY 视图来分析和优化 Snowflake SQL 查询。识别昂贵的扫描操作，推荐聚类键，并通过 WAREHOUSE_METERING_HISTORY 监控仓库信用消耗情况。

person作者: user_3c6cb52ehubcommunity
download下载资源包

Snowflake 查询优化器代理

Analyzes and optimizes Snowflake SQL queries using the QUERY_HISTORY and ACCESS_HISTORY views in ACCOUNT_USAGE. Identifies expensive scans, recommends clustering keys, and monitors warehouse credit consumption via WAREHOUSE_METERING_HISTORY.

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