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). (Virtualize a delta table with PolyBase - SQL Server | Microsoft Learn) All is working with sysadmin permissions and we can select and return data. However with a normal user access we are getting the following error when selecting from the tables, even with db_owner access.
Msg 2571, Level 14, State 3, Line 2
User 'public' does not have permission to run DBCC TRACEON.
Msg 16513, Level 16, State 0, Line 2
Error reading external metadata.
Running a profiler trace it looks like behind the scenes it runs a query with the
OPTION(QUERYTRACEON 12917) setting which looks to require sysadmin.
Any ideas?
Thanks
Stu
4 Replies
- 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);
stustustustu ohh man we have just run into the exact same thing! Polybase on sql 2022 w/ adls gen2. Executing queries can only work with sysadmin roles. Did you figure anything out? The suggested traceflag or pushdown options didn't seem to work for us.
- Check if trace flag 6408 is set, or if pushdown is enabled; none of them should be used for your scenario.
