- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2025 02:05 AM
hi @bferrell
Hi! If I’m understanding this correctly, the issue seems to be that the Service Principal launching the query from the dashboard (specifically app-39l35m...) is not authorized to execute the query.
However, from the screenshot you shared, it’s clear that the connection itself is being established successfully, which suggests that your configuration is correct. So I’d say the problem is most likely that this Service Principal doesn’t have sufficient permissions to read from the table(s), and that’s why the query returns nothing.
On the other hand, your personal user account does have access, either directly or through a group, which is why it works for you locally. You should go to the Catalog / Schema / Table in the Data > Catalog section, and check the Permissions tab. Use the filter at the top-right to search for the Service Principal (app-39l35...) and verify if it has the necessary permissions.
If it turns out that permissions aren’t the issue, could you share the exact error message the query is returning?
Hope this helps! 🙂
Isi