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.
Production Infrastructure OverviewProduction Infrastructure Overview

Production Infrastructure Overview

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

CLI Infrastructure Overview


Did this page help you?