'insert csv file into snowflake as variant not working

I am trying to copy csv data into snowflake table with only one column(variant). When I run copy into statement, my variant column is only displaying data from first column. I'm not sure what the problem is. Please help.

Create or replace table name( RAW variant )

COPY INTO db_name.table_name FROM (SELECT s.$1::VARIANT FROM @stage_name.csv s);



Sources

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

Source: Stack Overflow

Solution Source