Azure Storage Container

Sprinkle requires a Cloud Storage Container to store intermediate data and report caches.

Note

If the warehouse is Azure Synapse, the Date Lake Storage which is configured for Synapse Analytics(during creation) should be used here.

Follow the below steps to create and configure a storage container:

STEP-1: Create a Storage Account

1. Log in to the Azure Portal and select All Services.
2. Select Storage Account and choose Add.
3. Select the subscription in which you want to create the account.
4. Select the desired resource group or create a new resource group. You can refer to the Azure Documentation of resource management.
5. Provide the storage name, this name should be unique across all the Azure storages. The name also must be between 3 and 24 characters in length and may include only numbers and lowercase letters.
6. Select a location for your storage account, or use the default location.
7. Select a performance tier, recommended is Standard.
8. Set the Account kind field to Storage V2 (general-purpose v2).
9. Specify other settings if anything is required
10. Select Review + Create to review your storage account settings and create the account.
11. Click on Create, it will create the account

STEP-2: Create Storage Container

1. Log in and go to the new storage account in the Azure portal.
2. In the left menu for the storage account, select Containers from the Blob service section.
3. Click on the + Container button.
4. Provide a name for your new container. The container name must be lowercase, must start with a letter or number, and can include only letters, numbers, and the dash (-) character. Refer to the Azure Documentation for more information.
5. Set the level of public access to the container or you can whitelist the Sprinkle IP shown in Driver Setup.
6. Select OK to create the container.

You can refer to the Azure quick start guide for Storage containers.

STEP-3: Get Access Key

1. Navigate to your storage account in the Azure portal.
2. Under Settings, select Access keys. Your account access keys appear, as well as the complete connection string for each key.
3. Locate the Key value under key1, and click the Copy button to copy the account key.

STEP-4: Configure Azure Storage connection in Sprinkle

• In the Add Storage Form
• Provide all the mandatory details
  • Distinct Name: Name to identify this connection
  • Storage Account Name: Created in STEP-1
  • Container Name: Created in STEP-2
  • Access Key: Copied in STEP-3
• Test Connection
• Create

Get JDBC URL

On the Azure portal go to synapse workspace, then on the left side under the Analytics pools tab select sql-pools.

Select the sql-pool for which you want to integrate to sprinkle.

On the left side under the Settings tab select connection strings. Select JDBC, here copy JDBC URL(remove username and password from JDBC URL).