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
Snowflake DB, and here is the error I"m getting when running.
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'.
We are on version 6.8 and upgrading soon to 7.4