For sql_database project, when connecting to blob throwing error

[ravikumarmcnxsi]

Hi,

I have been tasked to implement the Direct Data API for Conexus Data Warehouse customers. We have downloaded the project and modified the configurations from the folder: accelerators\sql_database\resources to provide Veeva Vault CRM, target Azure SQL Database, and Blob storage details.

We ultimately going to use Azure Data Factory Custom Activity to run the module. For testing purpose when we ran from local environment, it's not working. When we consulted our IT, they are suggesting that, our blob containers should be connected using the credentials. But, in the configuration files, we didn't see any parameters to provide authentication credentials like AccessKey and endpoints.

• Please help us in resolving the encountered error when running from local environment.
• Please guide us step by step process to set up using Azure Data Factory Custom Activity.

Post updating the configuration file details within accelerators\sql_database\accelerator.py and tried to run the module as below:

Vault-Direct-Data-API-Accelerators-main> python -m accelerators.sql_database.accelerator

We are facing below error for accessing the Blob container:

[Info] 2025-09-08 13:23:47 - ---Executing direct_data_to_object_storage.py--- [Debug] 2025-09-08 13:23:47 - Listing Direct Data files with start time: 2000-01-01T00:00Z and stop time: 2025-09-07T00:00Z [Info] 2025-09-08 13:23:47 - Direct Data files listed successfully [Debug] 2025-09-08 13:23:47 - Downloading Direct Data file: 217424-20250907-0000-F.001 [Info] 2025-09-08 13:23:48 - Direct Data file: 217424-20250907-0000-F.001 downloaded successfully [Debug] 2025-09-08 13:23:48 - Uploading to vaultcrmcontainer/ctsanu/217424-20250907-0000-F.tar.gz [Debug] 2025-09-08 13:23:48 - Retrieving Blob Client for vaultcrmcontainer/ctsanu/217424-20250907-0000-F.tar.gz [Info] 2025-09-08 13:23:48 - Retrieved Blob Client for vaultcrmcontainer/ctsanu/217424-20250907-0000-F.tar.gz Traceback (most recent call last): File "<>\Vault-Direct-Data-API-Accelerators-main\common\services\azure_blob_service.py", line 88, in upload_object response: dict = blob_client.upload_blob(data=data, overwrite=True) File "<>\AppData\Roaming\Python\Python310\site-packages\azure\core\tracing\decorator.py", line 119, in wrapper_use_tracer return func(*args, **kwargs) File "<>\AppData\Roaming\Python\Python310\site-packages\azure\storage\blob\_blob_client.py", line 615, in upload_blob return upload_block_blob(**options) File "<>\AppData\Roaming\Python\Python310\site-packages\azure\storage\blob\_upload_helpers.py", line 197, in upload_block_blob process_storage_error(error) File "<>\AppData\Roaming\Python\Python310\site-packages\azure\storage\blob\_shared\response_handlers.py", line 190, in process_storage_error exec("raise error from None") # pylint: disable=exec-used # nosec File "<string>", line 1, in <module> azure.core.exceptions.HttpResponseError: This request is not authorized to perform this operation using this permission. RequestId:c0020107-801e-0103-3595-20630a000000 Time:2025-09-08T07:53:48.3014217Z ErrorCode:AuthorizationPermissionMismatch Content: <?xml version="1.0" encoding="utf-8"?><Error><Code>AuthorizationPermissionMismatch</Code><Message>This request is not authorized to perform this operation using this permission. RequestId:c0020107-801e-0103-3595-20630a000000 Time:2025-09-08T07:53:48.3014217Z</Message></Error> [Error] 2025-09-08 13:23:48 - Error uploading blob to vaultcrmcontainer/ctsanu/217424-20250907-0000-F.tar.gz Exception: This request is not authorized to perform this operation using this permission. RequestId:c0020107-801e-0103-3595-20630a000000 Time:2025-09-08T07:53:48.3014217Z ErrorCode:AuthorizationPermissionMismatch Content: <?xml version="1.0" encoding="utf-8"?><Error><Code>AuthorizationPermissionMismatch</Code><Message>This request is not authorized to perform this operation using this permission.

It would be great help, if you please let us know if any further details required.
Note: In the error lines, we just modified the folder locations with <> due to security reasons.

Thanks,
Ravikumar