How-to | Configure the global default file format#

In the Engines & connections panel, you can configure a default file format by adding a comma-separated list under Preferred storage formats.

Enter the list in order from most preferred format to least preferred.

Default file format options:

  • CSV_ESCAPING_NOGZIP_FORHIVE

  • CSV_UNIX_GZIP

  • CSV_EXCEL_GZIP

  • CSV_EXCEL_GZIP_BIGQUERY

  • CSV_NOQUOTING_NOGZIP_FORPIG

  • PARQUET_HIVE

  • AVRO

  • ORC

  • JSON

  • STRING

The global engines and connections panel.