Export data into several output formats using snowsql

 Step: 1

Connect to database:

Step: 2

Connect to schema:

Step: 3

 Specifying file location using option ‘spool’:

Exporting db data into csv file:

 

Step: 4

At last the csv file has placed in specified location.

Exporting db data into text format:

Specifying file location using option ‘spool’:

At last the csv file has placed in specified location.