randypitcherii
/ snowflakeDataForBreakfastWorkshop.sql
Last active
May 30, 2022 06:27
This SQL file contains the SQL necessary for the March 2019 Hashmap+Snowflake Data for Breakfast workshop demonstrations.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // =========================================================================== | |
| // Welcome! | |
| // | |
| // Log in to your Snowflake instance, create a new worksheet, then | |
| // copy and paste the contents of this file into your worksheet. | |
| // =========================================================================== | |
| // =========================================================================== |
randypitcherii
/ snowflakeStitchBlog.sql
Last active
March 26, 2019 21:44
Full guided SQL for the Talend Stitch + Snowflake blog post
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // =========================================================================== | |
| // Welcome! | |
| // | |
| // Log in to your Snowflake instance, create a new worksheet, then | |
| // copy and paste the contents of this file into your worksheet. | |
| // | |
| // Make sure you're using the ACCOUNTADMIN role before we get started | |
| // (see the context in the upper right corner of your worksheet) | |
| // | |
| // Next, head over to the Partner Connect page (link in the top right of the snowflake toolbar). |
randypitcherii
/ ShareableSnowflakeMonitoring.twbx
Last active
April 29, 2019 19:08
Tableau workbook for snowflake cost monitoring
randypitcherii
/ hashmap_zero_to_snowflake.sql
Last active
November 16, 2022 11:31
SQL commands for Hashmap's slightly-modified Zero to Snowflake demonstrations. Find the original, official SQL from Snowflake at https://bit.ly/2JJZl3J
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // This SQL file is for the Hands On Lab Guide for the 30-day free Snowflake trial account | |
| // The numbers below correspond to the sections of the Lab Guide in which SQL is to be run in a Snowflake worksheet | |
| // Modules 1 and 2 of the Lab Guide have no SQL to be run | |
| // See the lab guide here - https://s3.amazonaws.com/snowflake-workshop-lab/InpersonZTS_LabGuide.pdf | |
| //===================================== | |
| // MODULE 1 | |
| // Steps to Prepare Your Lab Environment |
randypitcherii
/ 2020-06-21 -- Structure.rest Snowflake Setup.sql
Created
June 21, 2020 18:05
Snowflake SQL for creating an isolated Structure.rest environment
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //============================================================================= | |
| // create top level objects | |
| //============================================================================= | |
| USE ROLE SYSADMIN; | |
| // Database | |
| CREATE DATABASE STRUCTURE_WORKSPACE; | |
| // Warehouse | |
| CREATE WAREHOUSE STRUCTURE_WORKSPACE_WH |
randypitcherii
/ netflix_streams_and_tasks.sql
Created
July 7, 2020 18:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //============================================================================= | |
| // Set context | |
| //============================================================================= | |
| USE ROLE <YOUR_ROLE>; | |
| USE WAREHOUSE <YOUR_WAREHOUSE>; | |
| USE DATABASE <YOUR_DATABASE>; | |
| CREATE SCHEMA NETFLIX_STREAMS_AND_TASKS; | |
| //============================================================================= |
OlderNewer