The modern web interface, Snowsight, is designed for ease of use and does not impose the 100MB file size limit found in the older "Classic" interface.
Downloading query results from can be done through several methods depending on the data volume and your preferred interface. While the Snowsight web UI is the most direct for small-to-medium datasets, command-line tools like SnowSQL and the Snowflake Connector for Python offer more robust options for large-scale exports and automation. Downloading via the Web Interface (Snowsight) snowflake download query result
: Supports direct download to CSV and TSV; some third-party integrations also allow export to Microsoft Excel . Exporting via Command Line (SnowSQL) The modern web interface, Snowsight, is designed for
: Run your query in a worksheet, then select Download results from the query details pane to save the data as a CSV or TSV file. Downloading via the Web Interface (Snowsight) : Supports