EXPORT SNOWFLAKE TABLE DATA TO CSV BY ADDING DOUBLE QUOTES

One has to use "FIELD_OPTIONALLY_ENCLOSED_BY" parameter while exporting the Snowflake table data to CSV by adding double quotes.

$ snowsql -a <Snowflake_Account_Name> -u <username>

Password: 

Ø $snowsql > use <Database_name>;

           +----------------------------------+                                            

            | status                           |

            |----------------------------------|

            | Statement executed successfully. |

            +----------------------------------+

Ø $snowsql > use WAREHOUSE <Warehousename>;

            +----------------------------------+                                            

            | status                           |

            |----------------------------------|

            | Statement executed successfully. |

            +----------------------------------+

Ø $snowsql > use schema <schema_name>;

          +----------------------------------+                                            

          | status                           |

        |----------------------------------|

        | Statement executed successfully. |

         +----------------------------------+

Ø $snowsql > create or replace table test (C1 VARCHAR(20), C2 VARCHAR(20),C3 VARCHAR(20), C4 CHAR(1), C5 INTEGER, C6 NUMBER ,TS TIMESTAMP_LTZ);

           +----------------------------------+                                            

           | status                           |

           |----------------------------------|

           | Table TEST successfully created. |

           +----------------------------------+

Ø insert into test values ('A','B,C,D','E','F',1,2, current_timestamp);

           +-------------------------+                                                     

            | number of rows inserted |

            |-------------------------|

            |                       1 |

            +-------------------------+

Ø select * from test;

          +----+-------+----+----+----+----+-------------------------------+              

          | C1 | C2    | C3 | C4 | C5 | C6 | TS                            |

          |----+-------+----+----+----+----+-------------------------------|

         | A  | B,C,D | E  | F  |  1 |  2 | 2020-10-22 04:22:11.843 +0000 |

         +----+-------+----+----+----+----+-------------------------------+

Use below Syntax to Unload the data from Snowflake to Internal Stage. 

Ø copy into @my_stage/test.csv from TEST FILE_FORMAT = (TYPE = CSV FIELD_OPTIONALLY_ENCLOSED_BY = '"' ESCAPE_UNENCLOSED_FIELD = NONE );

             +---------------+-------------+--------------+                                  

             | rows_unloaded | input_bytes | output_bytes |

             |---------------+-------------+--------------|

             |             1 |          52 |           71 |

             +---------------+-------------+--------------+

Ø get @my_stage/test.csv file:///Users//Desktop/Snowflake/SourceDataFile/;

          +-----------------------+------+------------+---------+

          | file                   | size | status     | message |

          |-----------------------+------+------------+---------|

          | test.csv_0_0_0.csv.gz |   71 | DOWNLOADED |         |

          +-----------------------+------+------------+---------+

Output in the test.csv file:

"A","B,C,D","E","F",1,2,"2020-10-22 04:22:11.843 Z"