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