Use Case:link
You use basic SQL transformations and want to trigger stored procedures from your Fivetran dashboard.
Fivetran Recommendation:link
You can trigger stored procedures in your Fivetran dashboard because we execute transformation scripts directly on the destination.
To trigger a stored procedure, create a new transformation in your Fivetran dashboard. Enter a SQL script that executes your stored procedure. Choose a schedule type, then save your transformation.
If you aren’t sure that Fivetran supports your stored procedure, execute the SQL script from the SQL editor in your destination. If the execution is successful, the script is valid and should work with Fivetran basic SQL transformations.