Control Diagram

The Architecture: Core Components

Query vault table
Controller procedures
Trigger point (can be an external or internal trigger)

Details of Core Components

1. Query Vault Table

This table serves as the heart of this strategy. We can securely store all the queries that load data into the cloud data warehouse in this Vault table. This table contains the following fields: