Python and Snowflake how can add Azure AD username and password to snowflake connection to be able to access the account and run ETL scripts?

Question

I am trying to login to Snowflake through our Azure AD integration button.

My connection script was using the credentials of a trial account where there is only the username and password on snowflake:

conn = snowCtx.connect(
    user=user,
    password=password,
    account=account,
    database=database,
    schema=schema,
    warehouse=warehouse,
    role='SYSADMIN',
    autocommit=False,
)

Now I need to add and integrate the Azure AD username and password with the connection on order to access my prod account and start my ETL process.

I checked the following:

import azure.functions as func

but before that I installed the azure library using:

pip install azure

But there is no module functions within azure library.

How can I add the Azure AD authentication to snowflake cursor?

For your question about But there is no module functions within azure library, azure.functions is a module which already installed when you created the python function in VS code. So do not need to care about it. — Hury Shen
If your question is resolved, please accept the answer so it gets marked as answered. — Ilya Berdichevsky

Ilya Berdichevsky Ilya Berdichevsky · Accepted Answer · 2021-01-13T21:56:51

Use pip install azure-functions to install azure.functions.

Also see Quickstart: Create a Python function in Azure from the command line, Azure Functions Python developer guide and Improve throughput performance of Python apps in Azure Functions.

But there is no module functions within azure library.

From https://pypi.org/project/azure/:

Starting with v5.0.0, this package is deprecated. Please install the service specific packages prefixed by azure needed for your application.

Python and Snowflake how can add Azure AD username and password to snowflake connection to be able to access the account and run ETL scripts?

1 Answers