Destination Adapter: File Export

Description

The File Export destination adapter allows you to export data from DataBridge Data Frames to various file formats. It supports CSV, JSON and JSONL formats. Generated files are delivered to the Results Folder

This adapter is useful for debugging issues, particularly transformation-related issues.

Configuration

Required Parameters

data_source (string)

Name of the Data Frame to export.

destination_file_name (string)

Name of the output file (must include correct extension).

format (string)

Export format: "csv", "json", or "jsonl"

Configuration Examples

CSV Export

{
  "version": 1,
  "destination_adapters": [
    {
      "adapter": "file_export",
      "configuration": {
        "data_source": "employees",
        "destination_file_name": "employees_export.csv",
        "format": "csv"
      }
    }
  ]
}

JSON Export

{
  "version": 1,
  "destination_adapters": [
    {
      "adapter": "file_export",
      "configuration": {
        "data_source": "employees",
        "destination_file_name": "employees_export.json",
        "format": "json"
      }
    }
  ]
}

JSONL Export

{
  "version": 1,
  "destination_adapters": [
    {
      "adapter": "file_export",
      "configuration": {
        "data_source": "employees",
        "destination_file_name": "employees_export.jsonl",
        "format": "jsonl"
      }
    }
  ]
}

Output File Structure

CSV Format

empid,gender,jobrole,salary
1,male,engineering,1234
2,female,legal,12350

JSON Format

[
  {"empid": 1, "gender": "male", "jobrole": "engineering", "salary": 1234},
  {"empid": 2, "gender": "female", "jobrole": "legal", "salary": 12350}
]

JSONL Format

{"empid": 1, "gender": "male", "jobrole": "engineering", "salary": 1234}
{"empid": 2, "gender": "female", "jobrole": "legal", "salary": 12350}