Week 32 - Security & Governance

This week we're looking into some new security features that Snowflake has recently released

As you might know, the default idle time for Snowflake sessions is 4 hours BUT that was recently adjusted; you can now change this value on certain levels.

Because we can finetune these numbers, Management has asked us to enforce it for some of our new colleagues :

The challenge for this week :
- Create 2 users
- User 1 should have a max idle time of 8 minutes in the old Snowflake UI
- User 2 should have a max idle time of 10 minutes in SnowSQL and in their communication with Snowflake from tools like Tableau

One of the things we'd be looking for looks like this :

Remember, if you want to participate:

  1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER
  2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
  3. Post the URL in the comments of the challenge
Previous
Previous

Week 33 - Administration

Next
Next

Week 31 - SQL & Query Techniques