Week 24 - Streamlit & Apps

To celebrate the release of Snowpark for Python into GA and the release of the Streamlit integration into private preview, we're going to do a doubled up Snowpark and Streamlit challenge!

Your challenge is to create an app that looks like the one below:

Requirements:

• You must allow the user to select between the following objects:
  • 'None'
  • 'Shares'
  • 'Roles'
  • 'Grants'
  • 'Users'
  • 'Warehouses'
  • 'Databases'
  • 'Schemas'
  • 'Tables'
  • 'Views'
• The app should display the FF logo
• It should display the version of Snowpark you are using
• It should display the results of show statements as a dataframe
• Schemas, tables, views and grants should be on the account level (i.e. not per database etc...)

Here's the .png file for the logo, right click to download:

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