This workflow template facilitates the seamless transfer of Torq audit and activity logs into Snowflake, enabling businesses to efficiently store and analyze their operational data. By automating the extraction, transformation, and loading of logs, organizations can maintain a comprehensive and up-to-date record of their activities, enhancing data-driven decision-making and compliance efforts. The integration with Snowflake ensures scalable and secure data management.
Use Cases
Example , Function
Workflow Breakdown
Set and update a Global Variable for the time checkpoint if one does not already exist
Pull all audit and activity 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.