Forum Discussion
SQL Server 2022 Polybase on Delta File Format
We are testing Polybase with external tables on Delta format in ADLS Gen 2 on SQL Server 2022(16.0.4055.4). (https://learn.microsoft.com/en-us/sql/relational-databases/polybase/virtualize-delta?view=...
I'm having same issue too from Polybase 2022 to S3 object storage. Require sysadmin role even for SELECT queries. You already had any workaround on this issue?
My issued has been resolved by enable trace flag 14073. Without Sysadmin role be able to queries.
This solution provided by Microsoft Polybase support team.
DBCC TRACEON (14073, -1);
DBCC TRACESTATUS (14073, -1);
This solution provided by Microsoft Polybase support team.
DBCC TRACEON (14073, -1);
DBCC TRACESTATUS (14073, -1);