cancel
Showing results for 
Search instead for 
Did you mean: 

Materialized View using a table from a Dashboard

keenan
Ranger

Hi all, is it possible to create a materialized view from an existing table in a dashboard, I want to do this because I want to create some statistics with python using the layout and data that is present in the dashboard. The table I want to use is a listing table, as I figured that an aggregate table would be more complex 

2 REPLIES 2

JoeM
Community Manager
Community Manager

@keenan  - All referencable columns from a materialized view can be found here.

With dashboard tables not referencable, you could leverage any of the objects as outlined in the above article.

Another option is to extract the SQL logic generated by the table insight, then drop that SQL into my MV to read in data via SQL statement. 
Retrieve the SQL from the insight table here:

JoeM_0-1674146878679.png

Read it into the MV using the incorta_sql() function:

df = incorta_sql("SELECT * FROM DS_Orders.Order_Source_Analyzer_Monthly WHERE (DS_Orders.Order_Source_Analyzer_Monthly.ORGANIZATION_CODE = 'M2' AND DS_Orders.Order_Source_Analyzer_Monthly.INVENTORY_ITEM_ID = 11923) AND DS_Orders.Order_Source_Analyzer_Monthly.MONTH>'2008-01-01' SORT BY DS_Orders.Order_Source_Analyzer_Monthly.MONTH ASC ")

incorta.show(df)

 

keenan
Ranger

@JoeM , thank you for your reply, however i believe the incorta_sql module/library is currently available only for cloud implementation of Incorta and not for on-premise. Is there any work around to this for on-prem installation ?

Thank you !