topic Re: Databricks to snowflake data load in Data Engineering

Databricks to snowflake data load

SuMiT1 — Tue, 28 Oct 2025 11:19:46 GMT

Hi Team,

I’m trying to load data from Databricks into Snowflake using the Snowflake Spark connector. I’m using a generic username and password, but I’m unable to log in using these credentials directly. In the Snowflake UI, I can only log in through “Sign in with Azure AD.”

Below is the code snippet I’m using:

sfOptions = {

"sfURL": "XD1.privatelink.snowflakecomputing.com",

"sfDatabase": "Z_AICS",

"sfSchema": "ASK_SMG",

"sfWarehouse": "WAGT_ETL",

"sfUser": "sys_aski@xyz.com",

"sfPassword": "Qtr3tdint$",

"sfRole": "AZURE_DATA_PLATFORMS"

}

selected_df.write \

.format("snowflake") \

.options(**sfOptions) \

.option("dbtable", "DIM_TOPIC") \

.mode("overwrite") \

.save()

However, I’m getting the following error:

> Incorrect username or password was specified.

Could anyone please suggest how to authenticate and connect Snowflake from Databricks when Azure AD SSO is required for login?

Re: Databricks to snowflake data load

nayan_wylde — Tue, 28 Oct 2025 12:56:30 GMT

@SuMiT1 The recommended method to connect to snowflake from databricks is OAuth with Client Credentials Flow.

This method uses a registered Azure AD application to obtain an OAuth token without user interaction.

Steps:

Register an app in Azure AD and configure it for Snowflake OAuth integration.
Create a security integration in Snowflake using the client credentials.
Use the token in your Spark job.

Here is the full guide.

https://community.snowflake.com/s/article/How-To-Connect-To-Snowflake-From-Azure-Databricks-Using-OAuth-Client-Credentials

Other option is OAuth with User Credentials Flow (Interactive Login)

This method uses a user's Azure AD credentials to obtain a token. It's less ideal for automation but works for interactive sessions.

https://snowforce.my.site.com/s/article/How-To-Connect-To-Snowflake-From-Azure-Databricks-Using-OAuth-User-Credentials