$ in sql statement
I have a sql statement in snowflake execute snap.
“copy into table table_name from
(select t.$1,
t.$2,
t.$3
from file x(file_format=>'csv_format)t)”
I keep getting errors because of $ in ...
Forum Discussion
Sangeetha:
I agree with @bojanvelevski - please show the actual error you’re getting.
Also, most of us here are not familiar with snowflake, so it would also help to understand your intent. I can see 4 possibilities (at least):
- Are “$1”, “$2”, and “$3” the actual literal column names in your DB (the dollar signs actually appear as part of the names)?
- Or are these intended as “bound parameters”? (TTBOMK, SnapLogic doesn’t handle bound parameters in any flavor of SQL snaps.)
- Or are they properties in a document in the incoming document stream?
- Or, are they pipeline arguments? (In which case you need the leading underbar not the dollars sign.)
