Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi Dataiku Team,
Is there any way that i can use a Secret/Key in a SQL Script Recipe without having to hardcode it in the code ?
I believe the User -secrets only works in Python/R.
What i am trying to do is pass an s3-Key and Secret to an SQL script recipe running on a snowflake connection.
Any suggestions are welcome. 🙂
Are you hoping to do this without using Python?
I don't know of way to do this other than to use a Python recipe. Maybe others will have better ideas.
If you were to use Python, you could probably use the partial recipe functionality described here to execute the SQL once you had added the user secrets. Or for more flexibility, you might use query_to_df with side effects (see above link for more info) to execute the query.
Hi @Marlan Thank you for the suggestion.
The challenge i had was that the secrets or keys i was passing were ending up in the Log.
as the sql query passed to snowflake was getting printed to the log .
Anyway i found a snowflake document which helped to create variables.
This has helped me for now.