Firebolt has two ways to save query data to use and analyze outside of Firebolt.
- You can use the SQL workspace to export query results to your local hard drive as a
CSVfile. For more information, see Exporting query results to a local hard drive. This method is limited to 10,000 rows.
- Use the
COPY TO (Beta)statement to write the output of a
SELECTquery to an Amazon S3 location. This gives you more options than exporting from the SQL workspace offers. For more information, see COPY TO (Beta).