Skill UI

Comprehensive Snowflake development assistant covering SQL best practices, dynamic tables, streams, tasks, Snowpipe, Cortex AI functions/agents, Snowpark Python, dbt integration, performance tuning, and security hardening for production data platforms.

A comprehensive guide to advanced development practices on the Snowflake platform. Covers best practices for SQL (MERGE, semi-structured data, colon prefix rule), modern data pipeline construction (Dynamic Tables, Streams/Tasks, Snowpipe), and deep integration with Cortex AI functions and Snowpark Python. Essential knowledge for data engineers building robust, scalable, and intelligent data applications.

A comprehensive guide for executing core Snowflake data loading workflows. This covers setting up stages (S3, GCS, Azure), defining file formats (CSV, JSON, Parquet), and using COPY INTO for bulk loading. It also details advanced continuous ingestion using Snowpipe, enabling real-time data synchronization from cloud storage into Snowflake tables.