Materialized Views in Postgres

Alex Karr shared this problem 1 year ago
Resolved

Hello,

I am using Yellowfin 7.1 to connect to a Postgres database server, using a Generic JDBC data source and the org.postgresql.Driver.


Yellowfin (in either the datasource test or a view) cannot see any of the materialized views I created on the schema I am connected to. Even though I can select from the views using the same user Yellowfin is connecting with, via a SQL editor tool.


I did find this thread when doing some digging:


https://www.yellowfinbi.com/resources/forum/YFForum-Using-DB2-materialized-query-tables-thread-127676


Does the table discovery not support materialized views?

Comments (4)

photo
1

Hi Alex,


Unfortunately it is not possible to create a view based off of a view defined at the database level. However you can achieve the same results by either creating a virtual table using your view's SQL statement, or by creating a Freehand SQL view directly. The former will allow you to use the results like a normal table within a larger view, while the latter will create your entire view from the SQL statement.


If neither of these meet your needs, I would be interested in knowing why so that I can offer more pointed suggestions!


Regards,

Nathan

photo
1

Hi Alex,


Have you had any luck in resolving this?


Regards,

Nathan

photo
1

Nathan,


I was able to work around this. Thank you for following up!

Cheers,

Alex

photo
1

Hi Alex,Glad to hear it. I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!


Regards,

Nathan