Multiple database connections

A Supersimple account can now read from more than one database. Point each data model at the connection it should query with the connection field.

models:
  account:
    name: Account
    table: myschema.account
    # Name of the connection, exactly as it appears in Supersimple settings
    connection: Production Postgres Replica
    primary_key:
      - account_id

Relations (joins) only work between models on the same connection, and queries that try to combine connections are rejected with an explanation of why. To add another connection to your account, please contact support or your account manager.

Read more in the docs.