What does the COPY INTO [STAGE] FROM [TABLE]; SQL command do in Snowflake?
COPY INTO [STAGE] FROM [TABLE];
COPY INTO <location> FROM <table> unloads table data into one or more files at the destination location, including a Snowflake stage. The inverse form, COPY INTO <table> FROM <stage>, loads staged files into a table.
COPY INTO <location> FROM <table>
COPY INTO <table> FROM <stage>
Community Discussion