databend icon indicating copy to clipboard operation
databend copied to clipboard

help how to read a csv with variable number of columns

Open djouallah opened this issue 1 year ago • 2 comments

I am doing a benchmarks to test the ETL performance for multiple Python Engine, I could not figure out how to do the same with databend, any help will be appreciate it

https://github.com/djouallah/Light_ETL_Challenge

djouallah avatar Jun 22 '24 00:06 djouallah

copy into your_table_with_3_colums from (select $1, $2, $3 from @your_stage/path_to_csvs) file_format = (type=csv)

youngsofun avatar Jun 22 '24 01:06 youngsofun

csv has variable number of columns

djouallah avatar Jun 22 '24 01:06 djouallah