SAP Knowledge Base Article - Preview

3028919 - Template Table DDL for Snowflake fails - SAP Data services 4.x

Symptom

  • When attempting to create a Snowflake template table, the following error will occur when it is saved.
    • Error "Syntax error at line <78>: <GUID::'' LOAD TABLE <datastore>..<database>.Test INPUT ( Query ) SET (>: near <.> found <'.'> expecting <INPUT>."
  • An attempt to run the Job will fail with the error message:
    • Database '<OWNER_NAME>' does not exist or not authorized.>. The SQL submitted is <CREATE TABLE "<OWNER_NAME>"."<SCHEMA_NAME>"."<TEMPLATE TABLE_NAME>" 


Read more...

Environment

SAP Data Services 4.2 SP14

Product

SAP Data Services 4.2

Keywords

SAP Data Services, Snowflake, Table Owner,SAP BODS , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , Problem

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.