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
When the designer of your table unwittingly decides to use spaces in the names of columns and tables, you lose the option to SELECT * and must explicitly call out column names as pointed out by JackLacava and others.
OTOH, it’s generally not good design to SELECT * in code that parses data from a/ table/s. Column names should always be used, and often renamed with AS for greater code clarity.