Error connecting to Azure Blob using Shared Access signature


msg 105019, level 16, state 1, line 100  external table access failed due internal error: 'java exception raised on call hdfsbridge_connect. java exception message:  parameters provided connect azure storage account not valid.: error [parameters provided connect azure storage account not valid.] occurred while accessing external file.'    create database scoped credential azurestoragecredential        identity = 'shared access signature',      secret = 'abcdexxxxxxxxxxxxxxxxxxxxxxxxx';      create external data source myazurestorage1 (          type = hadoop,           location = 'wasb://container@mydwblob.blob.core.windows.net/',          credential = azurestoragecredential        );      create external table dbo.myexternaltable(         vendorid varchar(50) null,    )    (            location='/2016/', data_source = myazurestorage1,           file_format = myfileformat,reject_type = value,reject_value = 1000          myfileformat,reject_type = value,reject_value = 1000      ) ; 



Microsoft Azure  >  Azure SQL Data Warehouse



Comments

Popular posts from this blog

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

Azure DocumentDB Owner resource does not exist

SQL Server 2008 - High Memory Usage