Question: Unable to pass Schema and table name as Parameters to Select Snaps
When passing the Schema name as parameter, I can see the value in preview but snap is complaining that it is null.
Forum Discussion
I assume you are using the JSON Formatter to write the file, yes? But how are you formatting it? And what application are you using to try to open the file?
By default, the JSON Formatter will use a very compressed format with no line breaks. Some editors don’t deal well with a file where all the data is on one very long line.
You could enable “Pretty Print” on the formatter, which produces a much more readable and verbose format like this:
But this format can also be a challenge for some JSON-capable applications since all of the data is inside a single JSON array.
You might want to consider the “JSON Lines” format, where each line is a compactly formatted JSON object representing one document:
This is often the best choice when dealing with a “log”. Each JSON line corresponds to a line of your CSV file. See https://jsonlines.org/
I enabled the json lines in JSON FORMATTER snap… after which my file could open up faster in notepad++.
Awesome! Worked for me!
Thank you!
Max - what you're asking for is a Cartesian Product between the first and second outputs - basically every record from one path combined with every record from the other. You can do this using a Join snap configured as follows:
Hope this helps!
