Snowflake schemachange: Automate Database Deployments
Automate database deployments in Snowflake using schemachange, a CI/CD tool for managing schema migrations and version control.
Snowflake
AI_PARSE_DOCUMENT: Read Documents using SQL in Snowflake
Snowflake’s AI_PARSE_DOCUMENT function makes it possible to read and extract text from PDFs, Word files, and other unstructured documents using just SQL.
Slowly Changing Dimensions (SCD) Implementation in Snowflake
Learn how to implement SCD Type 1, 2, and 3 in Snowflake with practical SQL examples for handling dimension changes.
Snowflake INFER_SCHEMA: Create Tables Using Schema Detection
Identifying table structures from raw files and create tables dynamically using INFER_SCHEMA function in Snowflake.
Snowflake Cortex AISQL Functions
Explore how Snowflake Cortex AISQL functions bring the power of generative AI directly into SQL with real-time scenarios.
Event Tables in Snowflake
Event Tables in Snowflake collect telemetry data (logs, traces, events) from components like stored procedures, UDFs.
Data Unloading using COPY INTO Command in Snowflake
The COPY INTO command in Snowflake enables unloading data from tables into internal or external stage locations in formats like CSV, JSON, or Parquet.
Snowflake Directory Tables: Query and Manage Staged Files
Directory Tables in Snowflake provide a structured way to access file metadata in both internal and external stages.
Snowflake File URLs: Securely Access and Share Staged Files
Snowflake File URLs provides controlled and secure data access to the staged files without exposing the entire stage.
Data Load using COPY INTO Command in Snowflake
The COPY INTO command in Snowflake is a powerful tool for efficiently loading data from staged files into tables.