hi,
i am trying to execute the below query and i getting error as HRESULT = '0x80070005'.:
I have given "Storage Blob Data Contributor" access to synapse analytics resource. can anyone help me?.
CREATE EXTERNAL TABLE [dbo].[PopulationCETAS] WITH (
LOCATION = 'populationParquet/',
DATA_SOURCE = [MyDataSource23],
FILE_FORMAT = [ParquetFF23]
) AS
SELECT
*
FROM
OPENROWSET(
BULK 'csv/population-unix/population.csv',
DATA_SOURCE = 'sqlondemanddemo',
FORMAT = 'CSV', PARSER_VERSION = '2.0'
) WITH (
CountryCode varchar(4) COLLATE Latin1_General_100_CI_AS_SC_UTF8 ,
CountryName varchar(64) COLLATE Latin1_General_100_CI_AS_SC_UTF8 ,
Year int,
PopulationCount int
) AS r;
Started executing query at Line 1
Access check for 'CREATE/WRITE' operation against 'https://sangilistorage.dfs.core.windows.net/csv/populationParquet/' failed with HRESULT = '0x80070005'.
Total execution time: 00:00:01.488

