Data Management and Utilities

Snowflake provides GET_DDL Function using which DDL of database objects like tables, views, procedures etc., can be extracted.

Learn different ways to remove duplicate records from a Snowflake table using SWAP WITH and INSERT OVERWRITE commands.

Snowflake Resource Monitors assist in cost management and prevent unforeseen credit usage caused by operating warehouses.

The INFORMATION_SCHEMA is a read-only schema available automatically under each database. It stores metadata of all the objects built under the database.

A Virtual warehouse is a cluster of compute resources which provides required resources such as CPU, memory, and temporary storage in Snowflake.

A Snowflake Task allows scheduled execution of SQL statements including calling a stored procedure or Procedural logic using Snowflake Scripting.

A Stream is a Snowflake object that provides change data capture (CDC) capabilities to track the changes in a table.

Snowflake’s Zero Copy Cloning feature is a quick and easy way to create copies of database objects without incurring any additional costs.

Snowflake Time Travel enables accessing historical data that has been changed or deleted at any point within a defined period.