Architecture

The Coalesce platform has the following components:

1. Metadata Repository
   Coalesce stores the metadata format for each of your data warehouse environments in a highly scalable NoSQL database (Firebase). This metadata never stores Snowflake data or passwords, it is solely used for storing the metadata configuration of your data warehouse and storing deployment success and failure.
2. Developer's GUI (Frontend)
   The Coalesce frontend communicates on behalf of users when they are logged in via app.coalescesoftware.io. It communicates to the metadata repository and submits commands to Snowflake on your behalf.

3. CLI tool (coa)
   For automation purposes, the coa CLI Tool is used for automating all transformations, enabling all data transformations to run on-premise.