Can not read data from materialized view In Postgres

1

Hello. I have problem with postgres materialized view in dremio
I saw the question about similar problem (
Can't see PostgreSQL materialized views)

but when I tried to make settings according to the Dremio manual I do not see the “Grant External Query access” options on advanced options page.

Version of my instance of dremio is Build
16.0.0-202105120132280783-b6a3f06a

Community Edition
Thanks in advance!

2

@dkc What is the error? Please share query profile if possible

3

I have not error yet) , i can not to do settings ( Grant External Query access .) to query materialized view

image
image909×741 35 KB

4

@dkc That checkbox is to enable the Dremio feature called External queries where you can send queries to RDBMS sources like Postgres without Dremio need to parse the SQL, so if there are any native PG functions, you can use them, here is the documentation on how to use the feature

https://docs.dremio.com/data-sources/external-queries.html

5

but I do not see this checkbox on the form (i put the screen above).This is my problem.
Thanks in advance

6

@dkc Sorry missed that, let me check and get back to you

7

Hello! Are there some news about this question? This function will be avaliable ?
Thanks in advance!

8

@dkc Starting from Dremio 16.0, external query is a RBAC privilege

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

Currently, this is an Enterprise Edition feature