'How do I load <file name>.csv.gz from snowflake stage into a snowflake table?

I have successfully loaded 1000 files into a Snowflake stage=MT_STAGE. Every file has exact same schema. Every file has exact same naming convention (filename).csv.gz Every file is about 50 megs (+/- a couple megs). Every file has between 115k-120k records. Every file has 184 columns. I have created a Snowflake table=MT_TABLE. I keep on getting errors trying to do a "COPY INTO" to move files from stage into a single table. I've tried countless variations of the command, with & without different options. I've spent 3 days reading documentation and trying to watch videos. I have failed. Can anyone help?

copy into MT_TABLE from @MT_STAGE;

Copy executed with 0 files processed

copy into MT_TABLE from @MT_STAGE (type=csv field_delimiter=”,” skip_header=1);

Syntax error: unexpected '('. (line 1)

copy into MT_TABLE from @MT_STAGE type=csv field_delimiter=”,” skip_header=1;

Syntax error: unexpected '”,'. (line 1)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source