Forum Discussion
Solved
Avoiding including Snowflake credentials in Python script when python script uses Snowflake
Hi everyone, I've been testing runing some forecasting scripts in Power BI desktop where the python script imports the data used to generate the forecast from Snowflake. The Snowflake connection...
Hi. Power Bi has snowflake connector. You should use them to let powerbi keep the credentials encrypted and secured. Then you can run a python step at Query Editor (Transform Data) to keep going if you prefer transforming data that way.
I hope that helps,
Hi. Power Bi has snowflake connector. You should use them to let powerbi keep the credentials encrypted and secured. Then you can run a python step at Query Editor (Transform Data) to keep going if you prefer transforming data that way.
I hope that helps,
Cheers this seems the best short-term solution.
Now I just need to get the python script to work since for some reason set_index works fine in a regular python scripting tool but not in Snowflake or Power BI.