Create csv file format snowflake2/9/2023 ![]() When I finally select all the data from the table, it ends up splitting into 7 columns with: Here is the table create statement: create or replace temp table mycsvtable as select t.$1 ColumnA, t.$2 ColumnB, t.$3 ColumnC from (file_format => mycsvformat) t Here is a sample of data: "ColumnA","ColumnB","ColumnC","ColumnD","ColumnE","ColumnF" Here is my file format definition: create or replace file format mycsvformat ![]() It seems like the field_optionally_enclosed_by arg should be handling this, but it is not. ![]() But the fields are still being split again if the contents itself contains a ','. I've created a file format with the type of CSV and with settings that I believe should be splitting on ',' and using '"' as a possible string field wrapping. I am trying to load a CSV file from a stage, into a table that I am creating from the file contents.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |