PERMISSION ERROR: Not authorized to use external query.

April 17, 2025 16:57
Updated

Summary/Reported Issue

Getting error when attempting to run an external query

Error seen is:

PERMISSION ERROR: Not authorized to use external query.SQL Query SELECT * FROM TABLE("blah"."external_query"('SELECT * FROM your.external.table1 WITH(NOLOCK) union SELECT * FROM your.external.table2 WITH(NOLOCK) union SELECT * FROM your.external.table3 WITH(NOLOCK)'))

Relevant Versions

Dremio 25.0.x

Troubleshooting Steps

Make sure the user has enough permissions to run external queries

Cause

Wrong RBAC roles assigned

Steps to Resolve

Granting the user EXTERNAL QUERY privileges corrected the problem