Stored procedures in Snowflake
npack 22h 0 1
Snowflake is poetry. They handcrafted every tiny detail of how a modern datawarehouse should work. B
- Snowflake now handles 300 million queries per day from its customer base
npack 11d 0 0
Snowflake now has some 2,500 customers and is adding to the list at a rate of around 500 per quarter - Window functions - Rows between current row - Snowflake syntax
npack 14d 0 0
Window functions to perform OLAP operations: - Cast as Integer syntax in Snowflake
npack 14d 0 0
Use the cast function to convert a string to a Integer / Number format:SELECT - Extract command syntax in Snowflake
npack 14d 0 0
Extracts the specified date or time part from a date, time, or timestamp - Snowflake Streams and tasks
BI-Dev 16d 1 0
This is a relatively new feature but has anyone used it so far in a production environment? If so ho - DATEDIFF command syntax in Snowflake
npack 16d 0 0
Calculates the difference between two date, time, or timestamp expressionsselect - Snowflake Inner Join syntax
npack 17d 0 0
SELECT R.* FROM Roster RINNER JOIN PlayerStats PON R.LastName = P.LastName;Example-2:<pr - Merge command syntax in Snowflake
npack 17d 1 0
Inserts, updates, and deletes values in a table based on values in a second table - Update command syntax in Snowflake
npack 17d 0 0
Updates specified rows in the target table with new values. - Insert into table command syntax in Snowflake
npack 17d 0 0
Insert one or more rows into the table from another table - ORDER BY Syntax in Snowflake
npack 17d 0 0
Specifies an ordering of the rows of the result table from a SELECT list. - GROUP BY HAVING Syntax in Snowflake
npack 17d 0 0
Filters rows produced by GROUP BY that do not satisfy a predicate. - GROUP BY Syntax in Snowflake
npack 17d 0 0
Groups rows with the same group-by-item expressions and computes aggregate functions for the resulti - Time travel query syntax in Snowflake
npack 17d 1 0
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) - CTEs (Common Table Expressions) in Snowflake
npack 17d 0 0
A CTE (common table expression) is a named subquery defined in a WITH clause. You can think of the C - DROP TABLE syntax in Snowflake
npack 17d 0 0
Removes a table from the current/specified schema, but retains a version of the table so that it can - Copying Prod data into isolated Dev Environment along with all the objects in Snowflake
AzharuddinK 23d 7 1
I have a requirement where I need to copy the entire database from Production for a particular role - Cast as Date / PARSE_DATE syntax in Google Bigquery
npack 23d 0 0
Use the PARSE_DATE function to convert a sting to a date in Bigquery: - Delete command syntax in Google Bigquery
npack 24d 0 0
Use the DELETE statement when you want to delete rows from a table - MERGE command syntax in Google Bigquery
npack 24d 0 0
A MERGE statement is a DML statement that can combine INSERT, UPDATE, and DELETE operations into a s
Copied