topic Problem with OPENROWSET BULK token in SQL database

Problem with OPENROWSET BULK token

fabric_user — Tue, 19 Nov 2024 17:13:41 GMT

I'm following this training module:

https://learn.microsoft.com/en-us/training/modules/get-started-sql-database-microsoft-fabric/5-simplify-data-management

When I'm trying to run this code, I'm getting an error:

SELECT TOP 100 * FROM OPENROWSET (BULK 'abs://citydatacontainer@azureopendatastorage.blob.core.windows.net/Safety/Release/city=Seattle/*.parquet' , FORMAT = 'PARQUET') AS [Seattle_Dataset]

I copy pasted the code directly from the tutorial:

Am I doing something wrong?

I'm quite new to SQL databases

Thanks!

Re: Problem with OPENROWSET BULK token

fabric_user — Tue, 19 Nov 2024 17:16:21 GMT

Also the same error when trying to run this code:

https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/20-work-with-database.html?azure-portal=true

Re: Problem with OPENROWSET BULK token

JulianePadrao — Tue, 19 Nov 2024 20:02:31 GMT

We apologize for the inconvenience you experienced. The exercise has now been updated.

mslearn-fabric

Re: Problem with OPENROWSET BULK token

mohitkumawat — Wed, 20 Nov 2024 11:05:03 GMT

Hi fabric_user ,

as I checked in the Microsoft Doc right now "OPENROWSET" Features is not supported in SQL Fabric Database.

https://learn.microsoft.com/en-us/fabric/database/sql/feature-comparison-sql-database-fabric

Re: Problem with OPENROWSET BULK token

JulianePadrao — Wed, 20 Nov 2024 15:33:06 GMT

Thank you for your feedback. It appears that this feature has been moved to the future roadmap. We appreciate you bringing this to our attention. The material has been updated accordingly and should be live soon.

Re: Problem with OPENROWSET BULK token

Anonymous — Tue, 26 Nov 2024 06:47:33 GMT

Hi fabric_user

Thanks for the solution JulianePadrao and mohitkumawat offered, the bulk can be used in Azure SQL instead of SQL Server.

You can refer to the following link about it.

Use BULK INSERT or OPENROWSET(BULK...) to import data to SQL Server - SQL Server | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.