I have an elasticube with data tables pushed from 30 odd MS SQL databases. Then I have a custom table which has a UNION ALL query created for all 30 tables pushed. This Custom Table is used to query the dashboards for insights. All the MS SQL tables and Custom Tables are configured with 'Changes Only' build behavior.
I am building the elasticube with 'Changes Only' mode, but still, the build time is increasing every time the new table is added to the Cube. I observed, that on every build run, the query of custom table is evaluated and eventually all the MS SQL tables are verified.
Is there a way to skip all the 30 MS SQL DB tables in the query and just evaluate the 31st one which is newly added?
Please sign in to leave a comment.