This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Be sure to review our Idea Submission Guidelines for more information!
Need ability to call Stored Procedures in Snowflake Database.
Access to execute Snowflake stored procedures opens the door to Alteryx participating in Snowpark workflows. This would be a big win for us to bring these two technologies together.
I think you can do via Run CMD Tool.
Use the "Run Command" tool in Alteryx to execute the stored procedure in Snowflake. The Run Command tool allows you to run a SQL command on the connected database, which in this case is Snowflake.
This is doable through python however how would this work in terms of Creds and security. If you want to have this deployed on server what would be the suggested method to connect to snowflake?
Try using pre and Post SQL Statement in input Data tool
No it will not work in snowflake at all. So the only way is to open up the python tool and do the following
the only database platforms that are supported are SQL SERVER and Oracle
What I need is a way to store the creds.
from snowflake.sqlalchemy import URL
from sqlalchemy import create_engine
from sqlalchemy.orm import Session
username = 'LOGIN'
password = 'PASSWORD'
account = 'XXXXXX'
region = 'xxxxxx'
warehouse = 'meowmeow'
database = 'kittykat'
Create an engine
engine = create_engine(URL(
account = account
, user = username
, password = password
, region = region
, warehouse = warehouse
, database = database
, schema = schema
with engine.connect() as connection:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.