MySQL

1. Create a PostgreSQL Read-Only User

To connect to MySQL, create a user with read-only access to all tables you wish to compare. Include read and write access to a Datachecks-specific dataset:

/* Create the database if it doesn't exist */
CREATE DATABASE IF NOT EXISTS datachecks_tmp;

/* Create a Datachecks user */
CREATE USER 'datachecks_user'@'%' IDENTIFIED BY 'YOURSECUREPASSWORD';

/* Grant read access to compare tables in YourSchema */
GRANT SELECT ON `YourSchema`.* TO 'datachecks_user'@'%';

/* Grant access to all tables in the datachecks_tmp database */
GRANT ALL ON `datachecks_tmp`.* TO 'datachecks_user'@'%';

/* Apply the changes */
FLUSH PRIVILEGES;

Your read-only user now has the necessary permissions for Datachecks to securely connect to your MySQL database.

Datachecks uses the datachecks_tmp schema for temporary processing, ensuring that core data remains untouched during validation and monitoring tasks.

2. Add MySQL as a data source in Datachecks

Go to Settings > Datasources, click New Datasource, and select MySQL to configure the connection to your database.

Once selected, you’ll be directed to the configuration page. Enter the following details:

title: "PostgreSQL"description: "Connect your PostgreSQL data source to Datachecks."

1. Create a PostgreSQL Read-Only User

To connect to PostgreSQL, you need to create a user with read-only access to all tables in all schemas and write access to the datachecks-specific schema for temporary tables:

 /* Create a temporary schema for datachecks */
 CREATE SCHEMA datachecks_tmp;

 /* Create a datachecks user */
 CREATE ROLE datachecks WITH LOGIN ENCRYPTED PASSWORD 'SOMESECUREPASSWORD';

 /* Grant all privileges on the temporary schema to datachecks */
 GRANT ALL ON SCHEMA datachecks_tmp TO datachecks;

 /* Grant read-only access to all tables in the specified schema */
 GRANT USAGE ON SCHEMA <myschema> TO datachecks;
 GRANT SELECT ON ALL TABLES IN SCHEMA <myschema> TO datachecks;

Your new read-only user now has the necessary permissions for Datachecks to connect to your PostgreSQL database securely.

Datachecks uses the datachecks_tmp chema for temporary processing, ensuring that core data structures remain intact. This isolation prevents any impact on critical data during validation and monitoring tasks.

2. Add PostgreSQL as a data source in Datachecks

Go to Settings > Datasources, click New Datasource, and select Postgres to configure the connection to your database.

Once selected, you’ll be directed to the configuration page. Enter the following details:

Click Test & Save Datasource. Your data connection is ready!