Snowflake export and import limits
Export a Snowflake result to CSV or JSON without running the query again. Tablyne has no import into Snowflake.
Tablyne exports results from Snowflake. It does not import into it.
Exporting a result
Use the export action on a console result. The export opens the same dialog as the other engines and writes the result Tablyne already stored on disk. It does not run the query again, so it does not use the warehouse a second time.
The formats offered for Snowflake results are CSV and JSON. The app refuses SQL export for Snowflake with the message “SQL export is not supported for Snowflake. Use CSV or JSON.” The reason is that Tablyne has no writer for Snowflake’s INSERT dialect, and it would rather refuse than produce a statement that is almost right.
Values keep their exact form. NUMBER(38) values stay as text, so no digits are lost. VARIANT, OBJECT and ARRAY values keep their raw JSON.
CSV exports neutralize text that a spreadsheet would run as a formula. This is on by default and you can turn it off per export in the dialog.
What is in the export
The export holds what the console kept. If the console cut the result at its row limit, the export is cut at the same place, and the console showed you where.
Import and copy
Snowflake has no import in Tablyne, because the connection is read-only. Importing is not part of the Snowflake workflow.