This article provides a Streamlit in Snowflake application with a very simple user interface for generating public / private keys and setting the public keys for users to use key pair authentication instead of passwords

Snowflake Community is a platform for users of the Snowflake cloud data platform to share knowledge, ask questions, and collaborate. Readers can learn about cloud data warehousing, data analytics, and data engineering best practices. With forums, user groups, and community events, Snowflake Community provides resources for Snowflake users to connect and learn from each other.

Snowflake Community

This post details a Streamlit application to generate public and private keys for Snowflake key-pair authentication. The user-friendly interface requires a passphrase and username, providing downloadable keys and SQL statements for key management. The application emphasizes enhanced security and simpler key rotation.

Generating Private and Public Keys using Streamlit in Snowflake

Using Key Pair Authentication with different clients