Setting up a Snowflake Sandbox environment

Daan Bakboord

Jan 8, 2020·1 min read

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.