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
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 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.
HOW TO: Make External API calls from Snowflake?
Explore how Snowflake offers a secure and efficient way to make external API calls directly within its environment.
RESULT_SCAN in Snowflake
RESULT_SCAN in Snowflake retrieves the results of a previously executed query and presents them as a virtual table allowing to run subsequent queries
HOW TO: Delete Rows From a DataFrame in Snowflake Snowpark?
Discover how to delete rows from a DataFrame in Snowpark using Table.update() and Session.sql() methods.