Process Tabular with Inserts/Updates/Deletes at Source

• imani_technology

  SSCrazy Eights

  Points: 8200

  More actions

  May 26, 2017 at 10:40 am

  #149488

  We have an SSAS Tabular model.  The source is Spark.  We have code that performs special inserts and deletes of our Spark/Hive data source.  We want those inserts and deletes to be reflected in SSAS Tabular.  I know we can do a Process Full on the Tabular model.  However, this process much run every 15 minutes and we cannot get a single Process Full to finish in time for the next one to start, mainly due to the large source data set.

  What are our options?  We are using SSAS Tabular 2016.

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  May 26, 2017 at 8:11 pm

  #1944402

  I've not personally done much with tabular (just multidimensional), but it sounds like you're going to need to investigate partitions.

  https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/partitions-ssas-tabular

  I hope this helps,
  Rob