Why am I unable to access these partitioned parquet files in Dbeaver, while it works well on Synapse?

huangapple go评论48阅读模式
英文:

Why am I unable to access these partitioned parquet files in Dbeaver, while it works well on Synapse?

问题

我尝试通过DBeaver访问我的SQL Serverless中的一些视图。

我在Azure ADLS上有几个分区的parquet文件,并且有一个Synapse Workspace,我在其中使用SQL Serverless来访问这些数据。

在Synapse上一切都正常工作。

但是在DBeaver上,相同的查询不起作用。

是否有人知道为什么会发生这种情况?

最好的问候。

英文:

I try to access some views in my SQL Serverless via Dbeaver.

I have several partitioned parquet files on Azure ADLS, and a Synapse Workspace where I use SQL Serverless to access these data.

Everything work well on Synapse.

Why am I unable to access these partitioned parquet files in Dbeaver, while it works well on Synapse?

But on DBeaver, the same query won't work

Why am I unable to access these partitioned parquet files in Dbeaver, while it works well on Synapse?

¿Does anyone know why this happen?

Best regards

答案1

得分: 0

当您使用Synapse Studio时,您使用的是Azure AD用户,具有对底层存储的访问权限。当您使用dbeaver连接时,您可能会使用SQL用户,并且需要授予它对存储文件的访问权限。

请查看此链接以获取详细的步骤,以启用SQL用户的访问权限:link

英文:

When you are using Synapse studio, you are using an Azure AD user, with access to the underline storage. When you are connecting with dbeaver, you probably use an SQL user, and you need to grant it access to the storage files.

Please see this link for detailed steps to enable access for SQL users.

huangapple
  • 本文由 发表于 2023年5月29日 11:19:00
  • 转载请务必保留本文链接:https://go.coder-hub.com/76354491.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定