Solved

Are materialized views supported on the cloud native platform?

  • 1 February 2023
  • 4 replies
  • 54 views

I added some materialized views to my postgres database, but they are not available to my cloud native LDM. Are they supported?

icon

Best answer by jacek 7 February 2023, 17:33

View original

4 replies

Userlevel 2

Today I merged the corresponding merge request.

It should be released into GD.cloud very soon, most likely in 2023-02-23 or in 2023-03-09 at latest.

Userlevel 3

Hi Scott. The best course of action would be to scan the PostgreSQL data source containing materialized views.
If they do not appear in the left panel in LDM Modeler, it means that we do not support scanning them yet. 

Do you have an eta on support? It has been in the platform for 6 months. It is also mentioned in the cloud documentation. https://www.gooddata.com/developers/cloud-native/doc/cloud/connect-data/performance/

 

My solution was to create a view that is just `select * from materialized_view`, and that normal view is visible.

Reply