Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

xupzhou
‎02-17-2026 09:00 AM

Snowflake Key-Pair Authentication (Generally Available)

Coauthor: Abhishek Narain

Ensuring secure connectivity to your data sources is critical for modern data estates. We have released the Key-Pair authentication for Snowflake connections Preview in October and are happy to announce it is now Generally Available (GA).

This release offers an enhanced security alternative to basic authentication methods, such as username and password, allowing you to align with industry best practices for identity management.

Why Key-Pair authentication matters

Reliable and secure authentication is the foundation of any production workload. Snowflake supports Key-Pair authentication to provide a more robust security mechanism than traditional credentials.

Using Key-Pair authentication helps you:

  • Stronger, password‑less security using RSA/ECDSA cryptographic keys, eliminating password‑based risks and supporting encrypted private keys for added protection.
  • Enterprise‑grade compliance, ideal for service accounts and automated workloads because Snowflake will deprecate single‑factor passwords.

Snowflake Key-Pair authentication is fully supported across various items and experiences, including Power BI Semantic models, Dataflow Gen2, Data pipelines, Copy jobs, Mirroring.

How to use Snowflake Key-Pair authentication

You can configure Key-Pair authentication through the Fabric user interface or programmatically via the REST API.

Configure via the Microsoft Fabric portal

To use this feature in the portal:

  1. Navigate to the Get Data wizard or the Manage connections and gateways settings.
  2. Create a new connection or edit an existing Snowflake connection.
  3. In the authentication settings, select Key-Pair as the Authentication kind.
  4. Enter your Username, Private key. Passphrase will only be required when the private key file is encrypted.

Snowflake_KeyPair_Authentication_with_encrypted_private_keySnowflake_KeyPair_Authentication_with_encrypted_private_key

Configure via the REST API

For users who automate connection management, you can now create Snowflake connections with Key-Pair credentials using the Fabric Connections REST API.

To learn more about automating this configuration, refer to the Connections - Create Connection documentation.

Learn more about Snowflake Key Pair Authentication

How to setup Snowflake Key Pair authentication in Microsoft Fabric

0