• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. User Guide
  4. FAQs
  5. General FAQs
  6. What Are the Differences Between Data Formats Supported by an OBS Foreign Table?

What Are the Differences Between Data Formats Supported by an OBS Foreign Table?

An OBS foreign table supports CSV and TEXT. The two formats differ from each other in the following aspects:

  • CSV
    • Consists of records, which are separated as fields by separators. Each piece of record has the same field sequence.
    • Efficiently manages the linefeed in fields, but performs moderately in processing special characters.
  • TEXT

    Efficiently manages special characters, but performs moderately in processing the linefeed in fields.