Azure SQL

1. Create a Azure SQL Read-Only User

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

/* Select the database that will contain the temp schema */
USE DatabaseName;

/* Datafold utilizes a temporary dataset to materialize scratch work and keep data processing in your warehouse. */
CREATE SCHEMA datachecks_tmp;

/* Create the Datachecks user */
CREATE LOGIN DatachecksUser WITH PASSWORD = 'YOURSECUREPASSWORD';
CREATE USER DatachecksUser FOR LOGIN DatachecksUser;

/* Grant read access to compare tables */
GRANT SELECT ON SCHEMA::YourSchema TO DatachecksUser;

/* Grant read + write access to datachecks_tmp schema */
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA::datachecks_tmp TO DatachecksUser;

2. Add Azure SQL as a data source in Datachecks

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

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

Field Name	Description
Host	The name of the server that hosts your database.
Port	The default port is 1433. If your server uses a different port, specify that.
Username	The name of the dedicated user for Datachecks.
Password	The password of the Datachecks user.
Database	The name of the Azure SQL (schema) you want to connect to.
Schema	Specify the schema you want to access.
Connection Name	A name given to the data connection within Datachecks.
ODBC Driver	The driver required to establish a connection with Azure SQL (e.g., ODBC Driver 18 for SQL Server).

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