How to export insert statements in Snowflake UI

Question

How do I get an export of insert statements in the Snowflake UI, like what I can get in SQL Developer. There is an option to get data in .csv and .tsv format, but not as insert statements.

Answer 1

The easiest way is to use external tool that supports export to SQL

Example: DBeaver - Data transfer

• Table/View in object explorer: RC -> Export Data -> SQL

• Results: RC -> Export Results -> SQL