Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How to execute a MS-SQL stored procedure in Dataiku
Added on April 11, 2025 10:12AM
Likes: 0
Replies: 0
Turribeach
Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,410 Neuron
Not a question but an answer as I couln't find any relevant posts. I solved this problem using a SQLExecutor2 in a Python recipe:
from dataiku import SQLExecutor2
executor = SQLExecutor2(connection="connection name")
sql_str = """Execute sp_name 'param1','param2', 'param3'"""
output_df = executor.query_to_df(sql_str, post_queries=['COMMIT'])