szymon_dybczak
Esteemed Contributor III

Hi @palearnings ,

To query a table in Unity Catalog you need at minimum following privileges:

- USE CATALOG - on the parent catalog of the table

- USE SCHEMA - on the parent schema of the table

- SELECT on the table itself

Did you set all of those privileges on your ADF service principal?

If you did that then refer to following yt video. It shows how to setup adf dataset to point to specific UC table:

https://youtu.be/saVZdf6cQig?t=187