If you use basic SQL transformations, find out how you can trigger stored procedures from your Fivetran dashboard.
You can trigger stored procedures in your Fivetran dashboard because we execute transformation scripts directly on the destination.
To trigger a stored procedure, follow the steps below:
- Create a new transformation in your Fivetran dashboard.
- Enter a SQL script that executes your stored procedure.
- Choose a schedule type.
- 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 execution is successful, the script is valid and will work with Fivetran's basic SQL transformations.