gdartigueeis's avatar
gdartigueeis
Cloud Apps
11-13-2023
Status:
New Idea

Recompiling views

There are cases where the Sisense queries have to read from views.

Would you consider allowing to issue queries like “ALTER database.materializedView REBUILD”  instead of only allowing select commands, in this case this would allow to refresh data that would be selected by the jdbc connector.

Dashboards & Analytics
Data Connectors

1 Comment

  • dougnewton's avatar
    dougnewton
    ETL
    12-22-2023

    Or a variation of this -- put your materialized-view recompilation statement in a stored procedure.

    Then allow Sisense to call stored procedure(s), for any of the connections defined in the cube, at the beginning of the build.