-- Create a temporary stage CREATE TEMPORARY STAGE my_export_stage; -- Unload data into the stage COPY INTO @my_export_stage/large_data_ FROM (SELECT * FROM your_table_name) FILE_FORMAT = (TYPE = 'CSV' COMPRESSION = 'GZIP') SINGLE = FALSE -- Set to TRUE if you want one large file (up to 5GB) MAX_FILE_SIZE = 5368709120; -- Sets limit up to 5GB per file Use code with caution.
: Forces everything into one file, but limited to 5GB . Step B: Download to Your Computer (SnowSQL) how to download more than 100mb from snowflake
-- Run this in your terminal/command prompt GET @my_export_stage file:///C:/your/local/path/; Use code with caution. 3. Alternative: Python Connector -- Create a temporary stage CREATE TEMPORARY STAGE