Datameer on MS Azure: Export to Snowflake

Goal

I would like to export data from Datameer deployed on Microsoft Azure to Snowflake.

Learn

Datameer exports data to Snowflake in two steps:

1. Datameer writes a Workbook's data into an Azure Blob Storage Container.
2. Snowflake connects to this container using the SAS Token and copies data to the target table.

To configure the export option, it is required to configure the following parameters in a Datameer Snowflake Connection settings.

• • Azure Blob Storage Account / Azure Blob Storage Container / Azure Blob Storage Account Credentials - these three are required to let Datameer write a Workbook's data into an Azure container.
  • Azure Blob Storage Account SAS - this token is for Snowflake to connect to the container and read the data.

The SAS token has the following format. This whole string should be added to the Azure Blob Storage Account SAS field at the Datameer Snowflake Connection.

?sv=YYY-MM-DD&ss=bfqt&srt=sco&sp=rwdlacupx&se=YYY-MM-DD'T'HH:MM:SSZ&st=YYY-MM-DD'T'HH:MM:SSZ&spr=https&sig=XXXXXXXXXXXXXXXXXXX

The token could be created at the Azure portal under Storage Accounts -> Azure Blob Storage Account set in the Snowflake Connection -> Settings -> Shared access signature.

Troubleshooting 

An ExportJob fails with 403 Error AuthenticationFailed. Ensure that the SAS token is valid.

Failure using stage area. Cause: [Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature. (Status Code: 403; Error Code: AuthenticationFailed)] when creating export table.

An ExportJob fails with 401 Error NoAuthenticationInformation. Ensure that the SAS token has been set at the Connection properties.

java.lang.RuntimeException: Failure using stage area. Cause: [Server failed to authenticate the request. Please refer to the information in the www-authenticate header. (Status Code: 401; Error Code: NoAuthenticationInformation)] when creating export table.

An ExportJob fails with 403 Error AuthorizationResourceTypeMismatch. Ensure that the SAS token has configuration has  Container set as the Allowed resource type.

java.lang.RuntimeException: Failure using stage area. Cause: [This request is not authorized to perform this operation using this resource type. (Status Code: 403; Error Code: AuthorizationResourceTypeMismatch)] when creating export table.