SAP Knowledge Base Article - Public

3699367 - Bad performance with Snowflake live connection

Symptom

  • Bad performance with Snowflake live connection

Environment

  • SAP Analytics Cloud Enterprise

Reproducing the Issue

  1. Create a Snowflake live connection.
  2. Create a model with around 70 dimensions/measures against the Snowflake live connection.
  3. Create a simple story with only one measure. 
  4. It need very long time to load the story while the SQL is executed only a few seconds in Snowflake

Cause

  • The issue is currently investigated by Development team

Resolution

  • The issue is currently investigated by Development team

Keywords

SAC, SQL live conection,snowflake live , KBA , LOD-ANA-LDC-SQL , SAC Live Data Connection SQL , Problem

Product

SAP Analytics Cloud all versions