This workflow template automates the acquisition and storage of Torq audit logs into Snowflake. Scheduled to run every 10 minutes, it ensures logs are consistently updated, leveraging a global variable for time tracking. The process involves obtaining logs for a specific time range, reforming the data set, and inserting the records into Snowflake, thereby maintaining an up-to-date log repository for auditing and analytics.
Use Cases
null
Workflow Breakdown
Set and update a Global Variable for the time checkpoint if one does not already exist
Pull all audit logs that exist for the given start/stop time
Adjust the dataset to be inserted in Snowflake
Push logs into Snowflake
Vendors
Utils, Snowflake, Torq
Workflow Output
Torq audit logs into Snowflake
Tips
Setup all of the Snowflake parameters and integration names in the first workflow variable step