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