Overview of Action Builder SQL Mirror
The Action Builder SQL Mirror is a read-only, continuously updated Postgres database hosted on Amazon AWS. It provides a full copy of an organization's data, typically with a latency of no more than 1 minute. It is designed for data dumps into data warehouses and ad-hoc querying. Because it is read-only, users cannot write data or create indexes/views directly on the mirror; for such needs, data should be dumped into a separate database. To push data into Action Builder, the API must be used instead.