Forum Discussion

stustustustu's avatar
stustustustu
Copper Contributor
Aug 28, 2023

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=...
Naufal20's avatar
Naufal20
Copper Contributor
Jan 28, 2024
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?
  • Naufal20's avatar
    Naufal20
    Copper Contributor
    Jan 30, 2024
    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);