Enhancing security with key-pair authentication for Snowflake
Introduction
If you’re a Snowflake customer, you probably heard about the recent announcement moving towards mandatory multi-factor authentication. This is a big step in data security, reflecting a broader industry trend towards more robust protection measures. At Keebo, we’re not just keeping pace; we’re leading the charge. That’s why we’re thrilled to roll out our latest feature: Key-Pair Authentication for our Warehouse Optimization tool. This update isn’t just about enhancing security—it’s about making your data management effortlessly secure.
Implementing Keebo’s Key-Pair Authentication
Setting up key-pair authentication in your Keebo environment is simple. Here’s how you can enhance your security:
• Generate Your Keys: Start by creating a public and a private key and assign the public key to a Snowflake user. Keep your private key secure—it’s your digital fingerprint. For more details on how to do this, read the Snowflake user guide.
• Setup on Keebo: Add your private key to your Keebo setup during initial configuration. It’s a one-off setup that secures your long-term operations. You can do this by the following:
Click into your Warehouse Optimization ‘Settings’
Go to the ‘Advanced settings’
Select Key Pair Authentication in the bubble selection and enter the following fields:
- Keebo role name
- Private Key password (optional)
- Keebo user name
- Private Key
Lastly, execute the SQL statements that are presented at the bottom of the page in the Snowflake console.
Lastly, validate the secure connection to Snowflake by clicking on ‘Next’. If at anytime your connection settings with key-pair authentication need to be updated, repeat the same aforementioned steps until they are completed.
In short, Keebo is keeping up with the latest security updates Snowflake dishes out to ensure you aren’t left in the dust. This commitment to security isn’t just about compliance—it’s about giving you peace of mind and the tools you need to secure your data environment effectively and efficiently. Schedule your risk-free trial with Keebo today and start seeing Snowflake cost savings within 24hrs.
