Connecting to Snowflake via python script in Dataiku

Options
Usersyed
Usersyed Partner, Registered Posts: 29 Partner

Hi all,

Need help on how to connect to Snowflake via a python script in Dataiku.
I have Snowflake connector already setup but that allows us to get data /tables into the flow.

What I want is to connect to Snowflake via a python script using the snowflake connector.
Tried this

conn = snowflake.connector.connect(
user='*****',
password='*****',
authenticator="externalbrowser",
account='*****',
role = '***',
warehouse='***',
database='**',
schema='***'
)

I end up getting a URL which I am supposed to copy and paste and then only I will be able to access it.
Is there a better way to do it because in production , nobody would be able to copy paste this redirect URL.

Thanks!


Operating system used: Windows

Tagged:

Answers

Setup Info
    Tags
      Help me…