Synapse

Connecting PACE to Azure Synapse Analytics

The configuration in PACE for Azure Synapse is very similar to the configuration for PostgreSQL. The connection with Synapse is established via a SQLServer JDBC connection. The config for looks as follows:

app:
  processing-platforms:
    synapse:
      - id: "pace-synapse"
        host-name: 
        user-name: 
        password: 
        database: 
        port: 

PACE makes use of database roles as in Synapse. All used Principals in the policy should be available as database roles in the Synapse database. Available roles on the platform can be found by running the sql query:

select * from sys.database_principals where type_desc = 'DATABASE_ROLE';