Versions Compared

Key

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

...

Snowflake user with ACCOUNTADMIN role must be created.
The reason is that Storage Management in some cases provides table metrics and Snowflake requires an ACCOUNTADMIN role in order to access them. Please check TABLE_STORAGE_METRICS for more information.

...

Java connector is a critical middle-ware component. Please follow the steps in this guide (SM-2102) Java Connector Setup to set it up/upgrade to a new version before you continue. 

...

The final step in SAP & Snowflake connectivity is a the creation of two storages in transaction /DVD/SM_SETUP - Snowflake storage which represent represents the table level of Snowflake infrastructure and the flat Snowflake stage which handles temporary files.

...

It is binary storage pointing to the Internal Stage of the Snowflake user. For loading/unloading data uses extended functionality of Snowflake JDBC driver.

Storage ID - logical name of the storage connection
Storage type - SNOW_STAGE (Snowflake internal stage)
Full name of Snowflake account - <account name>.<region>.<platform> more information in Snowflake account name doc.
User - Snowflake user
Password - user password
Password for JDBC Connection is Hashed - indicator whether the password is hashed (you can create a hash of the password by using report /DVD/XOR_GEN)
Java connector RFC - TCP/IP RFC destination used for communication with Datavard Java connector
Driver path - Snowflake driver directory path

...

Storage ID - logical name of the storage connection
Storage type - SNOWFLAKE (Snowflake transparent storage)
Full name of Snowflake account - <account name>.<region>.<platform> more information in Snowflake account name doc.
Warehouse - name of an existing warehouse in Snowflake
Database - name of an existing database in Snowflake
Database schema - name of an existing database schema in Snowflake
User - Snowflake user
Password - user password
Password for JDBC Connection is Hashed - indicator whether the password is hashed (you can create a hash of the password by using report /DVD/XOR_GEN)
Referenced storage - Snowflake stage storage used for staging temporary files while reading from/writing to Snowflake
Driver path - Snowflake driver directory path
Java connector RFC - TCP/IP RFC destination used for communication with Datavard Java connector

...