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

Help Center
1

Tip

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.

Examples

Say you have data in a csv like this: 

foo,"['fizz','buzz']",barfoo,"['fizz','buzz']",barfoo,"['fizz','buzz']",barfoo,"['fizz','buzz']",barfoo,"['fizz','buzz']",bar

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:

image.png

Notes

  • 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