All Collections
Database Objects
File formats (Snowflake)
File formats (Snowflake)

How to create and use Snowflake file formats

SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

A file format specifies the properties of the data when loading to or from a table. Once defined, a format can be used to load or unload data from any table in the database.

Create a file format using Database Explorer:

in Database Explorer, click on the "File Formats" menu and select "+ Create new"

Create a file format using table properties

Click on any table in a diagram to bring up its properties in the right menu.

In the "Options" tab, click on the "File Format" item to open a dropdown menu.

Select from available file formats or click "+ Add New"

File Format Properties

Format properties will vary based on format type. The common properties include:

路 Name

路 Generate File Format (enable or disable DDL in Forward Engineer)

路 Format Type (CSV, XML, PARQUET etc.,)

路 Description

Did this answer your question?