Category
Data Sources
Product Version
7.1
Materialized Views in Postgres
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:
Does the table discovery not support materialized views?
The same problem 
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
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
Hi Alex,
Have you had any luck in resolving this?
Regards,
Nathan
Hi Alex,
Have you had any luck in resolving this?
Regards,
Nathan
Nathan,
I was able to work around this. Thank you for following up!
Cheers,
Alex
Nathan,
I was able to work around this. Thank you for following up!
Cheers,
Alex
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
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
Replies have been locked on this page!