Getting started

Deploy with docker

1. Pull docker image

   docker pull selectzero/selectzero:2025.2.8

2. Run container

   docker run -d -v {local_path}/logs:/usr/app/logs -v {local_path}/database:/usr/app/database -v {local_path}/drivers:/usr/app/drivers -v {local_path}/reports:/usr/app/reports -v {local_path}/keys:/usr/app/keys -p 8090:8090 -e JAVA_OPTIONS='-Xmx4g' selectzero/selectzero:2025.2.8

   -v {local_path}/logs:/usr/app/logs

   Logs storage

   -v {local_path}/database:/usr/app/database

   DQM local database

   -v {local_path}/drivers:/usr/app/drivers

   JAR connectors storage

   -v {local_path}/reports:/usr/app/reports

   Reports and results

   -v {local_path}/keys:/usr/app/keys

   Key files storage such as BigQuery JSON keys and application certificate keystore

   -p 8090:8090

   Port mapping for exposing DQM application at port 8090

   selectzero/selectzero:2025.2.8

   Image from dockerhub, latest tag is also available

3. Validate that DQM container is running

   docker ps

By default, DQM will run on port 8090: http://localhost:8090

• You can find the initial password for the admin user from application logs (only in application console logs, this won't be persisted on file level):

  Username: admin Password: [generated password can be found in logs]

For more information, see configuration page.

Add a New Database Connection

1. On Connections page, click "New connection" button.

2. Insert database connection information:

   

   • Driver/Connector – database JDBC driver (see Connector settings to add new drivers)

   • Connection name – custom name for the connection

   • Server – database server address

   • Port – database port

   • Database name – database name in server

   • User – database user (we recommend using a user with read-only rights) For more granular database user management, see Adding additional database users

   • Password – password for the user

3. Click "Add connection" button.

4. New connection will appear on the list, and the connection status will show if the connection was successful.

Objects page provides an overview of all database objects, allowing users to create a data catalog to manage data assets efficiently.

The Objects view can be accessed on the Catalog page under the Objects tab.

Each catalog object consists of:

• Data quality metric - Calculated based on test cases and profilings

• Name - Object name in the database

• Attributes - Number of columns for the object

• Row count - Latest known row count from profiling

For more information, see Catalog page.

• Click "New test case" button

• Fill test case info:

  

  • Description - Test case short description, which will be visible from list view. Additional longer description can be added with button

  • Expected - Test case expected results, which can be either numerical or string value. Expected result can also be combination of expected results:

    

  • Target - Target connection to execute the test against

  • Query window - Test case SQL Query window

• Click "Save" button

Profile Database Objects

Follow these steps to profile database objects.

1. Press "Add objects" button on the sidebar.

2. Filter out objects you wish to profile.

   

3. Choose an object to profile by checking the checkboxes and clicking "Insert selected" button.

4. New profiling object will now be shown on the page.