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.