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
Tom -
1. If the connections are working fine Then I would suggest using the like operator vs equal to see if there are any rows returning.
2. Try the query like this instead of *, there could be some columns causing issue while calling in BR. The below is for SQL. If it is Oracle then you have to use ""
"SELECT [Column Name] FROM [Table Name] WHERE [Column Name] = Value"