SELECT INTO Statements
You can use the SELECT INTO statement to export formatted data to a file.
Data Export with an SQL Query
The following query exports data into a file formatted in comma-separated values (CSV):
SELECT Clicks, Device INTO "csv://CampaignPerformance.txt" FROM "CampaignPerformance" WHERE Device = 'Mobile devices with full browsers'
You can specify other formats in the file URI. The possible delimiters are tab, semicolon, and comma with the default being comma. The following example exports tab-separated values:
SELECT Clicks, Device INTO "csv://CampaignPerformance.txt;delimiter=tab" FROM "CampaignPerformance" WHERE Device = 'Mobile devices with full browsers'