Data source guides

Supported platforms

Each guide covers creating a read-only user or service account with the minimum permissions Unity Layer needs. Run the commands in your database console, then enter the credentials in Connect database.

• MySQL Create a read-only user and grant SELECT permissions on your database.
• PostgreSQL Set up a read-only PostgreSQL user with schema and table access.
• Amazon Redshift Configure a read-only Redshift user for schema and table access.
• Snowflake Create a role, grant warehouse and database access, then assign a user.
• Azure SQL Configure firewall rules and a read-only user for Azure SQL Database.
• BigQuery Create a service account with IAM roles and upload the JSON key.
• MariaDB Same pattern as MySQL — dedicated user with SELECT grants.
• Databricks Enable Unity Catalog, create a token, and grant catalog permissions.
• SQL Server Create an ingestion user with VIEW DEFINITION and SELECT on schemas.
• ClickHouse Create a user with SHOW DATABASES and SELECT grants.
• CockroachDB PostgreSQL-compatible user setup for your CockroachDB cluster.
• PrestoDB Configure authentication and catalog-level SELECT grants.
• Trino Configure authentication and grants across Trino catalogs.

On-demand integrations

These platforms are available on request. Contact your administrator or support to enable them for your workspace.

• Oracle — Available on request — contact support to enable.
• IBM DB2 — Available on request — contact support to enable.
• Amazon Aurora — Connect via the MySQL or PostgreSQL guide depending on your engine.
• Synapse Analytics — Use the SQL Server guide — Synapse uses T-SQL authentication.