Configure Storage Account in Azure Portal for Azure Synapse SQL Account

A Storage Account is a resource in Azure that contains all your Azure Storage data objects, such as blobs, file shares, queues, tables, and disks. This storage account provides a unique namespace for your Azure Storage data that you can access over HTTP or HTTPS.

  1. Create your Storage Account
    1. Log into the Microsoft Azure Portal.
    2. Hover over Storage accounts and click + Create.
      This page contains the Basics, Advanced, Networking, Data protection, Encryption, Tags, and Review tabs.
    3. In the Basics tab, specify the Project and Instance details.
    4. Configure the settings required for your storage account under the respective tab.
      Learn more about the settings in each tab from the Creating a Storage Account in Azure page.
    5. Review the details of your storage account and click Create.
      The page displays the status of the deployment of your storage account.
    6. After the deployment is complete, click Go to resource to view the details of your storage account.

      Azure Storage Account details

  2. Locate Information Required to Configure Your Snap Account
    1. Open the storage account that you have created in the Azure portal.
    2. Navigate to Security + networking > Access keys.
    3. Make note of the Key and Connection string.

      Azure Storage Access Keys

    4. To generate a Shared access signature (SAS), click Shared access signature.
    5. On the Signing key list, select the key for which you want to generate the SAS.
    6. Click Generate SAS and connection string.

      Generate Shared Access Signature

  3. Configure Azure Synapse SQL Account
    1. Navigate to the Snap of your choice and set up the Azure Synapse SQL Account with the following details noted in the previous steps:
      • Storage Account
      • Azure Container
      • Azure Folder
      • Azure Auth Type
      • Storage Key (if Azure Auth Type is Managed Identity)
      • Azure Identity

      Azure Synapse SQL Blob Configuration Settings

    2. Click Validate.
      The account is validated and you will be redirected to the log-in page of Microsoft Azure Portal and back to the Account configuration dialog. The Azure Secret will be autogenerated.
    3. Click Apply and save the account.