Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Requesting snowflake with python

Solved!
GP30
Level 1
Requesting snowflake with python
Hello, I am working on web app designer, I want to create a tile which lists the tables of my schemas of my snowflake db.
I have to do it in python but I don't know how to do it.
Since I am already connecting to snowflake from dataiku (I can add a dataset to the flow) I tell myself that in my script I no longer need to put the credentials to connect. 
Would you know how to connect to snowflake with python? (without putting id and password)
0 Kudos
1 Solution

OK have a look at the SQLExecutor2 method:

https://knowledge.dataiku.com/latest/code/python/tutorial-sql-in-python-recipe.html

This will allow you to execute SQL over your existing SQL connections, like Snowflake, and retrieve the contents as a data frame.

View solution in original post

0 Kudos
6 Replies
Turribeach

What type of Dataiku WebApp are you designing?

0 Kudos
GP30
Level 1
Author

it's Application Designer.

0 Kudos

OK so you are not designing a Dataiku WebApp you are designing Dataiku Application. I am not sure which on you really meant to do and the answer to your question will depend on what you are developing. Do you want a Dataiku WebApp or a Dataiku Application? These are completely different things and fill completely different purposes. 

0 Kudos
GP30
Level 1
Author

i'm designing an  Dataiku Application.

On one of my tiles (Edit Projet variables) i'm trying to create a python capable to list all tables whitch are in my snowflake db 

0 Kudos

OK have a look at the SQLExecutor2 method:

https://knowledge.dataiku.com/latest/code/python/tutorial-sql-in-python-recipe.html

This will allow you to execute SQL over your existing SQL connections, like Snowflake, and retrieve the contents as a data frame.

0 Kudos
GP30
Level 1
Author

thank you it works

0 Kudos