How to configure Azure Storage Account for use with Custom Application Connector

• How to configure Azure Storage Account for use with Custom Application Connector
  • Preface
  • Prepare the Storage Account
    • Configure a Queue in that storage account to be notified when new Blobs are added to its blob store
    • Create Minimal-Permissions SAS Tokens
    • Obtain other Storage Account properties
  • Use the obtained credentials to onboard a Custom Application Connector

Preface

Since version 2.4.165, the Custom Application Connector can consume data stored in Azure Storge Accounts. This opens the door to retreiving many Azure data sources that were not previously available.

With this addition, any Azure data source that can put its data into an

• Azure Storage Account's Blob store
  • Its "Kind" must be StorageV2, so it can have the feature to alert its queue on new blobs
• In a 1-event-per-line files
  • either clear text, gzipped, zipped, or parquet (compressed or not)

can be consumed.

Prepare the Storage Account

Go to the the storage account where that data that you want to consume is at -
Navigate to https://portal.azure.com
Navigate to Storage Accounts -> your storage account. Verify it's kind is "StorageV2" in the storage accounts table, or in the Overview -> Account Kind

Configure a Queue in that storage account to be notified when new Blobs are added to its blob store

1. Create a queue dedicated for the connector

   1. Navigate to Queues
   2. Click "+ Queue", name it something unique, e.g. "sk4queue", and OK
   3. Keep that queue name aside

2. Navigate to "Events"

3. Click "+ Event Subscription"

4. Enter useful name like "notify-sk4queue-on-new-blobs"

5. Events Schema should be the default "Event Grid Schema"

6. Under Event Types -> "Filter to Event Types", make sure only the "Blob Created" is selected.

7. Under Endpoint Details

   1. In "Endpoint Type" select "Storage Queues"
   2. In "Endpoint" click "Select an endpoint"
   3. In the panel that opened, select the subscription where the current Storage Account is at
   4. Select the storage account
   5. Select the queue created in the first step, e.g. "sk4queue"
   6. Click "Confirm Selection"

8. Click "Create"

It can technically be configured such that the queue and the blob will be in differrent storage accounts. for the sake of simplicity they're configured in the same storage account

Create Minimal-Permissions SAS Tokens

1. Navigate to "Shared access signature", under "Settings"
2. Create a SAS for the queue
   1. Select only the "Queue" from the "Allowed services" section
   2. Select only the "Object" from the "Allowed resource types"
   3. Select only the "Process" from the "Allowed permissions"
   4. Set the End time to a time far in the future, e.g. 10 years in the future, so the connector doesn't stop working because of SAS Token invalidation
   5. Click "Generate SAS and connection string"
   6. Copy the value from the "SAS Token" field
      • Example value is: "?sv=2018-03-28&ss=q&srt=o&sp=p&se=2019-09-23T17:52:57Z&st=2019-09-23T09:52:57Z&spr=https&sig=aASkYB8%2BGf21fMXl3Bnf0Mod7n81Dq8E%2FeggjEQr%2BD8%3D"
3. Create a SAS for the blob storage
   1. Select only the "Blob" from the "Allowed services" section
   2. Select only the "Object" from the "Allowed resource types"
   3. Select only the "Read" from the "Allowed permissions"
   4. Set the End time to a time far in the future, e.g. 10 years in the future, so the connector doesn't stop working because of SAS Token invalidation
   5. Click "Generate SAS and connection string"
   6. Copy the value from the "SAS Token" field
      • Example value is: "?sv=2018-03-28&ss=b&srt=o&sp=r&se=2029-09-23T17:52:57Z&st=2019-09-23T09:52:57Z&spr=https&sig=2NfpJEsdxkLCfMHBXm9Z7RvojSfLKWiHuMi6vY%2FSDQ4%3D"

Obtain other Storage Account properties

1. Navigate to "Properties"
2. Copy the value from the "Primary Blob Service Endpoint" field, under the "Blob service" section
3. Copy the value from the "Primary Queue Service Endpoint" field, under the "Queue service" section

Use the obtained credentials to onboard a Custom Application Connector

1. In the Cloud Connectors UI, navigate to Settings -> Accounts
2. Click "+ Add Account" and select "Custom Application" from the services list
3. Select "Azure Storage - SAS Tokens" in "Authentication Method"
4. Fill in the other obtained credentials and properties
5. Click "Test Connection" to test the configuration is successful
6. Click "Done" to finish the account creation and "Start" to start its sync. operation

Done!