Connector with Snowflake

Yes, this can also be done with Automations!

You could use a scheduled event and trigger the automation with it. Then run the connector function from the automation and use the output to create a record in another action. This will require looping ion the Automation as well, to create a different record each time, based on the length of the array.

Note: Depending on the amount of records and data to be created, you may hit the 60 seconds limit timeout. So you should be proactive in the amount of records created. An option is to split them in 100 records at a time (or even less, depending on how much data you are passing in the connector, which here looks like a decent amount).

You can also see a creative solution to this timeout in this post from @steve.midcalf Using Looping in Automations to move 450 records from Staging Table to Production Table