Setting up a Snowflake Sandbox environment
Find scripts and snippets in the DaAnalytics-github, to setup and get started with Snowflake. This peace is inspired by the following blogpost by Venkatesh Sekar from Hashmapinc.
In this folder the following scripts:
- Setup the 2nd Account Admin User; AccountAdmin.sql
- Define Resource Monitors; ResourceMonitors.sql
- Creating Roles; Roles.sql
- Creating RolesHierarchy; RoleHierarchy.sql
- Creating Sandbox Users; Users.sql
- Granting Roles to Sandbox Users; GrantingRoles.sql
- Creating Warehouses; Warehouses.sql
- Creating Databases; Databases.sql
Next, follow Venkatesh Sekar’s tips and try the following:
- Using the sample data
- Creating tables
- Creating internal stages
- Loading data from stage
- Interacting with the data and getting to know Snowflake
Good luck setting up your own Snowflake Sandbox. If you run into any issues, please let me know. I will do my upmost to help you out.
Thanks for reading.
Cheers
Originally published at http://www.daanalytics.blog.
