Database users

DX supports direct SQL access to your data lake, enabling direct read and write operations to be performed outside of the DX interface.

Read access allows you to query DX-managed and custom tables—ideal for building custom applications, integrating with platforms like Snowflake, or Connecting to DX from BI tools.

Write access lets you load custom data into DX. To maintain separation from DX-managed tables, custom tables must reside in the “custom” namespace and follow the naming custom.tablename. Foreign key constraints that reference DX-managed tables is not supported.

Setup instructions

Step 1 – Create a database user

1. Log in to DX as an admin user.
2. Navigate to the DB Users admin screen.
3. Add a new user with either the read or read_write scope.
4. Copy your database credentials.

Step 2 – Connect to your database

Use a Postgres-compatible database client and connect to the database with the credentials you generated in Step 1. For desktop clients, we recommend Postico and pgAdmin. If your database user was granted the read_write scope, you can create tables in the custom. namespace and write to them.