Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
conn = snowflake.connector.connect(
role = '***',
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.
Operating system used: Windows
You have various options if you want to interact with Snowflake from your Python code:
1. Rely on Snowpark Python, see our reference documentation.
2. Rely on Dataiku's SQLExecutor2 which is also compatible with Snowflake connections.
In both cases Dataiku takes care of the authentication under the hood so that you don't have to pass credential in plain text in your code.
Hope this helps.