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' |
+---------------+------------------------------------------------------------------------------------------------------------------------+
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today