I have a few stored procedures written in Snowflake and wanted to check if I can leverage the InformaticaCloud -Snowflake connectivity to orchestrate these stored procedures.
Note: I don't have the mapping of these jobs on the IICS side. Source tables, target tables, and stored procedures are in Snowflake. Only the orchestration and monitoring part needs to be done from IICS. Is it feasible to do that?
Can IICS use as a Standalone scheduler?
It is possible but the monitoring is lacking and you only have 2 options, either using a command task in a taskflow or API call in a mapping. The SQL Transformation does not support Snowflake.