Forum Discussion
Solved
SQL Query to External Table
I tested the following SQL in a data adapter, accessing a external table
Select * FROM Table
WHERE "Cost Center" = 'CC_11111111'
;
Data returned here, data adapter worked fine.
I am ...
https://stackoverflow.com/questions/71553042/snowflake-how-to-filter-on-a-field-name-that-contains-spaces-it-works-fine-i
Fyi square brackets are used in SQL Servernfor this, and double quotes in Oracle (and many others). That doesn't answer your question but might cut down on testing things. What type of DB are you connecting to?
I think you should get more detail on the error in the Error Log on the System tab. Can you check there?
Snowflake DB.
Here is an error when enclosing in []
Error processing Data Management Step 'Load_FDH_Employee_GL_Actuals'. Unable to execute Business Rule 'FDH_To_OS_Refresh'. ERROR [42000] SQL compilation error:
syntax error line 1 at position 45 unexpected 'Center'.