Skip to main content

SHOW FILE FORMATS

Returns a list of created file formats.

Syntax

SHOW FILE FORMATS;

Examples

SHOW FILE FORMATS;

+---------------+------------------------------------------------------------------------------------------------------------------------+
| name | format_options |
+---------------+------------------------------------------------------------------------------------------------------------------------+
| my_custom_csv | TYPE = CSV FIELD_DELIMITER = '\t' RECORD_DELIMITER = '\n' QUOTE = '\"' ESCAPE = '' SKIP_HEADER = 0 NAN_DISPLAY = 'NaN' |
+---------------+------------------------------------------------------------------------------------------------------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today