Azure Synapse Analytics

/* --- 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;