Prepare the Azure Synapse Instance

Before configuring the destination, prepare your Azure Synapse instance.

1. If necessary, create a database in Azure Synapse.
2. If necessary, create a schema within the database.

   You can use the default schema named dbo or any other user-defined schema.

3. If necessary, create tables within the schema.

   If the tables defined in the destination do not exist, the destination can create new tables in the schema. You can configure the destination to load data into existing tables only, as described in Specifying Tables.

4. Set up a user that can connect to Azure Synapse using SQL Login or Azure Active Directory password authentication.

   For more information about these authentication methods, see the Azure documentation.

5. Grant the user the following permissions that are required to use the COPY command to load data into Azure Synapse:
   • INSERT
   • ADMINISTER DATABASE BULK OPERATIONS
   If you want the destination to handle data drift automatically, grant the user the additional permission:

   • ALTER TABLE
   If you want the destination to create tables automatically while handling data drift, grant the user the additional permission:

   • CREATE TABLE