snowflake
Installation
SKILL.md
Purpose
This skill allows the AI to leverage Snowflake for cloud-based data warehousing, enabling efficient SQL queries and analytics on large-scale datasets for data engineering tasks.
When to Use
Use this skill for scenarios involving big data analytics, ETL pipelines, scalable SQL operations, or integrating with cloud storage. Apply it when datasets exceed on-premise capabilities, such as processing terabytes of data in real-time analytics or data warehousing for BI tools.
Key Capabilities
- Execute scalable SQL queries using Snowflake's virtual warehouses, e.g., via the SnowSQL CLI or Python connector.
- Load/unload data from cloud storage like S3 using COPY INTO commands, supporting formats like CSV, JSON, or Parquet.
- Manage resources programmatically, such as creating databases with SQL:
CREATE DATABASE my_db;or scaling warehouses via API calls to/api/v2/warehouses. - Support for secure data sharing and zero-copy cloning, enabling quick data replication without duplication.
- Integrate with external tools via JDBC/ODBC drivers or the Snowflake REST API for authentication and query execution.