SAP Knowledge Base Article - Preview

3492823 - Schema alias not accounting for Snowflake table pattern of database.owner.table - SAP Data Services

Symptom

  • Snowflake tables require the pattern databasename.owner.table - alias available in Datastore does not account for this.
  • When editing a lookup function in a query transform, the table name pattern gets converted to datastore.owner.table - when it should be datastore.databasename.owner.table for Snowflake tables, causing issues.


Read more...

Environment

SAP Data Services

Product

SAP Data Services all versions

Keywords

alias name, snowflake database, snowflake, schema , KBA , EIM-DS-EXE , Job Execution , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.