Cookbook Recipes (Snippets)
- Bulk Excel Loader
- Using TEXTTABLE to Implement SPLIT / SPLIT_PART
- Avoiding SQL Injection attacks using procedures
- Snowflake: working with multiple warehouses
- UPDATE statement with two tables
- CSV Export with Filter
- Email Notification with Editable FROM Address
- CSV Export with FTP Upload
- Pass Key Value Pairs to a Procedure Using Multi-Dimensional Arrays
- Create Unix Timestamps
- Check if a String Can Be Cast to a Number Using isNumeric
- Show Running Queries on Redshift via Native Interface
- SQL Snippet to Create Views with LEFT( "foo"."bar", 4000) AS "Name" for Long Strings e.g. Salesforce
- Use Values Larger Than 2147483647 with FROM_UNIXTIME
- Filtering for Dates that Belong to the Current Week with SQL
- Get Usage of Views (for Cleanup and Other Purposes)
- Duplicate Removal with ROW_NUMBER() and PARTITION
- MSSQL ENDOFMONTH Replacement
- Check for (!)= '' and (NOT) NULL at the Same Time
- Get the Recent N Stages of Mat Tables and Create a Procedure to Drop Old Ones
- Add a Column to a View that uses Batch Job or Slowly Changing Dimensions (advanced version)
- Add a Column to a View That Uses Batch Job or Slowly Changing Dimensions (Simple Version)
- Backup the Data Warehouse by Copying It to a Parallel Instance