Does Firebolt allow array columns for data loading using csv files?


Firebolt supports loading array columns for using csvs using the format of double quotes on the outside and single quotes on the inside, examples below.


Say you have data in a csv like this:


You can create your external table with a query like:

CREATE EXTERNAL TABLE IF NOT EXISTS ex_array_test  (    foo string,   fizzbuzz array(TEXT),   bar string  )   URL =....

This would look like:



  • Numbers in the array are also supported - ex.

CREATE EXTERNAL TABLE IF NOT EXISTS ex_array_number_dbl  (    foo string,   fizzbuzz array(DOUBLE),   bar string  ) ....

array(INT) also works if the numbers are integers

  • The sorting order in the file is respected