CODEWITHSUNDEEP
azure-blob-storageazure-synapsedbeaver
jona
jona

Reputation: 35

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

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.

enter image description here

But on DBeaver, the same query won't work

enter image description here

¿Does anyone know why this happen?

Best regards

Upvotes: 0

Views: 137

Answers (1)

Chen Hirsh
Chen Hirsh

Reputation: 1390

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.

Upvotes: 0

Related Questions