Snowflake Identity: Create a unique identifier for a row within a table, with identity or autoincrement.
Snowflake Sequence: Create a sequence object to generate a series of unique numbers.
Snowflake Equal_Null: Snowflake's comparison operator that treats NULL as equal to NULL.
Snowflake Drop View: Remove a view from the database schema.
Snowflake Alter Session: Change the current session settings for a specific user or task.
Snowflake Count: Aggregate function to count the number of rows that match a condition.
Snowflake Default Value: Set a default value for a column when no value is specified.
Alter Table Cluster By Snowflake: Re-cluster a table based on specified column(s) for optimization.
Snowflake Drop Table: Remove an entire table and all of its data from the database.
Snowflake Group By Date: Aggregate data by date or time intervals using GROUP BY clause.
Snowflake Indexes: Snowflake uses micro-partitions for clustering data, not traditional indexes.
Snowflake Not Null: Constraint to ensure that a column cannot contain NULL values.
Upload CSV to Snowflake: Import data from a CSV file into a Snowflake table.
Snowflake Drop Column: Remove a column from a table without deleting data in other columns.
Snowflake Percentile: Calculate the nth percentile of a sorted set of values.
Snowflake Truncate Table: Quickly delete all rows from a table, but not the table itself.
Snowflake Row Number: Assign a unique sequential integer to rows within a result set.
Snowflake Cumulative Sum: Calculate a running total of a numeric column in a result set.
Snowflake Date Trunc: Function to truncate a date or timestamp to the specified part.
Snowflake Convert Timezone: Adjust a timestamp from one timezone to another.
Snowflake Delete: Remove rows from a table that match a specified condition.
Snowflake Parse JSON: Extract and use information from JSON formatted data.
Snowflake CTE: Use Common Table Expressions to create temporary result sets.
Snowflake Cast: Convert one data type into another within a SQL statement.
Snowflake Create Table: Command to define a new table structure for storing data.
Snowflake Clone Table: Create an exact copy of a table, including its data and structure.
Snowflake Update: Modify existing rows in a table with new values based on a condition.
Snowflake Create View: Define a virtual table based on the result-set of an SQL statement.
Snowflake Case When: Conditional expression to perform different actions based on conditions.
Snowflake Rename Table: Instruction to change the name of an existing table.
Snowflake Rename Column: Alter an existing table to change the name of one of its columns.
Snowflake Coalesce: Function that returns the first non-null value in a list of arguments.
Snowflake DateAdd: Function to add a specified time interval to a date or timestamp.
Snowflake Insert Into: Add new rows of data to a specified table in the database.
Snowflake Alter Table Add Column: Command to add a new column to an existing table.
Get the newsletter for the latest updates, events, and best practices from modern data teams.