Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

"JSON Splitter" snap truncate data!

Is there any limitation of data size that “JSON Splitter” snap can handle? I get a 36mb json as input and output less than 1mb. I noticed “JSON Splitter” simply truncates the data!!! Ideally it should not but it is happening!!! Anyone find such odd b...

Abhijit by New Contributor
  • 2496 Views
  • 4 replies
  • 0 kudos

$ 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 the sql. Can anyone suggest how to enclose $ in the sql