No option to enable external queries in ui or api

1

I’ve just upgraded from Dremio 13.0 to 17.0.0 and my api calls are failing as they expect the MSSQL source type to have “enableExternalQuery” in the config but this is now missing. Looking at the UI there is also now no option to enable this.
Has something changed and the docs need updating?

Thanks for your help

dremioapi
dremioapi516×501 22.7 KB

dremioui
dremioui741×792 38.4 KB

2

from 17 enableExternalQuery for mssql is true

3

@rongfengliang Thanks, that would explain why it is missing! I couldn’t find anything about this in the release notes - is this the intended behavior going forwards? Do you know the rationale behind this?

4

yes. not in release notes. I found it from jdbc plugin

image
image3070×1126 397 KB

1 Like
5

@rongfengliang @Saltxwater External query is now a RBAC privilege which is an Enterprise edition feature

https://docs.dremio.com/security/rbac/privileges/