Forum Discussion
Problem with OPENROWSET BULK token
I'm following this training module:
When I'm trying to run this code, I'm getting an error:
SELECT TOP 100 *
FROM OPENROWSET
(BULK 'abs://[email protected]/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!
5 Replies
We apologize for the inconvenience you experienced. The exercise has now been updated.
Also the same error when trying to run this code:
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
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.
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.
