01-19-2023 03:22 AM
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
Solved! Go to Solution.
01-19-2023 08:50 AM
@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:
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)
01-19-2023 08:58 PM
@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 !