SAP Knowledge Base Article - Public

3738308 - Live data connection to Snowflake is missing in SAP Analytics Cloud (SAC)

Symptom

Snowflake is not in the data source list when create connection is SAC.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Go to Connections in SAC.
  2. Select Add connection.
  3. Search for "Snowflake" as a data source.
  4. Observe that Snowflake is not available.

Cause

To create live data connections to Snowflake, SAC must be running on HANA Cloud.

To check whether your tenant is running on SAP HANA Cloud, click About menu in SAC. The SAP HANA Cloud version will be displayed in the dialog if your tenant runs on SAP HANA Cloud. If you can't find any reference to an SAP HANA Cloud version in the dialog, your tenant is running on SAP HANA 2.0. 

Details can be found in the SAC help guide:  About Live Data Access | SAP Help Portal 

Resolution

How to verify if your SAC is running on HANA Cloud:

  1. Verify the tenant runtime:
  2. In the tenant, open About.
  3. If an SAP HANA Cloud version is shown, the tenant runs on HANA Cloud; if there is no reference to an SAP HANA Cloud version, the tenant is not on HANA Cloud.

The migration to HANA Cloud information can be found in the link SAP Analytics Cloud infrastructure is moving to SAP HANA Cloud.

As a temporary alternative, use an import data connection to Snowflake and load data on a schedule. Detailed steps can be seen in the link Connecting Analytics Cloud to Snowflake (Import mode).

See Also

Keywords

snowflake, connector missing, not available, live connection, sac connections, hana cloud, data federation, live data connection, connection setup, data source search, connector visibility, haas, sac, snowflake live, prerequisites , KBA , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud all versions