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 all versions

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.