How it works

1. A schedule trigger checks Salesforce every hour for records of the chosen object that were created or updated. 2. A For Each loop goes through the records found. 3. For each record, a Snowflake step writes a row to the target table using the statement you set up.