Location provided by DATA_SOURCE 'sales_data' cannot contain any wildcards.

Question

Getting this error while following instructions in https://microsoftlearning.github.io/dp-203-azure-data-engineer/Instructions/Labs/03-Transform-data-with-sql.html

while running following code:
USE Sales;

GO;

SELECT Item AS Product, SUM(Quantity) AS ItemsSold, ROUND(SUM(UnitPrice) - SUM(TaxAmount), 2) AS NetRevenue

FROM OPENROWSET( BULK 'sales/csv/*.csv',

DATA_SOURCE = 'sales_data', FORMAT = 'CSV', PARSER_VERSION = '2.0', HEADER_ROW = TRUE ) AS orders GROUP BY Item;

Usage of filepath function with DATA_SOURCE 'sales_data' might result in unexpected results if number of wildcards in data source LOCATION changes. Location provided by DATA_SOURCE 'sales_data' cannot contain any wildcards.

This question is related to the following Learning Module

Answer 1

Hi siddharth ranjan,

The error you are facing might be due to one of the following reasons:

1. The directory you're trying to create already exists.
2. There's a problem accessing the directory.
3. You don't have the necessary permissions for the directory.

Please don't hesitate to reach out to us if you have any other queries.

Thank you.