Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • Enable Raw Data Querying

  • From Kyvos 2024.11 onwards, you can process a flexible use the semantic model allows the summary function of a dimension or measure to be modified at any time during SQL queries.
    To do this,

    Set the value of the kyvos.process.compute.typeproperty must be Kyvos Compute.

    in a tabular way.

  • When you process a semantic model with no Spark, cuboids are stored at persistent storage. However, a copy of these cuboids is kept at the local storage (local disk).

...

  1. Modify the values of the following properties in the advance properties of semantic model job:

    • kyvos.process.compute.type=KYVOS_COMPUTEKyvos compute
      This property is required only if the Default Compute Cluster Type is External at the application levelkyvos.build.aggregate.type=TABULAR
      This property is not required if the semantic model is configured for Kyvos compute-based processingto enable Kyvos compute based processing for the semantic model.

Post deployment steps on Azure
Anchor
postdeployment-Azure
postdeployment-Azure

...

  • To execute the sanity suite for no-spark and Kubernetes (K8S) supported deployments, refer to the Prerequisites for no-spark deployments section.

  • Modify the value of the following semantic model advanced properties on Kyvos Web Portal:

    • kyvos.sqlwarehouse.catalog = ‘Your catalog name’ 

    • kyvos.sqlwarehouse.tempdb = ‘Your Database name’ 

    • kyvos.process.compute.type=KYVOS_COMPUTEKyvos compute
      This property is required only if the Default Compute Cluster Type is External at the application levelkyvos.build.aggregate.type=TABULAR
      This property is not required if the semantic model is configured for Kyvos compute-based processingto enable Kyvos compute based processing for the semantic model.

  • You can also set subtype to select no-Spark model processing for semantic model via property.
    To do this, navigate to the Kyvos Properties page and update the KYVOS_PROCESS_COMPUTE_SUBTYPE property and restart Kyvos services.

  • For Kyvos Compute (no-Spark) deployments with enhanced security, when creating a Kyvos warehouse connection of a Databricks managed workspace, ensure that the firewall settings on the storage account are disabled.