Skip to main content
INFOColumn-level Lineage is not currently supported for Azure Synapse.
Steps to complete:
  1. Run SQL script and create schema for Datafold
  2. Configure your data connection in Datafold

​
Run SQL script and create schema for Datafold

To connect to Azure Synapse, create a user with read-only access to all tables you wish to diff, plus read and write access to a Datafold-specific temp schema. On a dedicated SQL pool, the login is created in the master database, while the user and grants are created in your pool’s database: 
/* --- Run on the master database of your Synapse SQL pool --- */
CREATE LOGIN DatafoldUser WITH PASSWORD = 'SOMESECUREPASSWORD';

/* --- Run on your dedicated SQL pool (the database you want to connect) --- */
CREATE USER DatafoldUser FOR LOGIN DatafoldUser;

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

/* Allow the user to create views */
GRANT CREATE VIEW TO DatafoldUser;

/* Grant read access to the schemas you want to diff */
GRANT SELECT ON SCHEMA::YourSchema TO DatafoldUser;

/* Grant read + write access to the datafold_tmp schema */
GRANT CONTROL ON SCHEMA::datafold_tmp TO DatafoldUser;

​
Configure in Datafold

Field NameDescription
Connection nameA name given to the data connection within Datafold
HostThe hostname for your Synapse SQL endpoint (e.g. your-workspace.sql.azuresynapse.net)
PortSynapse connection port; default value is 1433
UsernameThe user created in our SQL script, named DatafoldUser
PasswordThe password created in our SQL script
DatabaseThe name of the dedicated SQL pool (database) you want to connect to
Dataset for temporary tablesThe schema created in our SQL script, in database.schema format: DatabaseName.datafold_tmp in our script above.
Click Create. Your data connection is ready!