Skip to main content

File output connector

The file output connector writes a file local to the machine that runs the pipeline. The file output connector is unlikely to be useful in a Kubernetes-based cloud deployment, where the pipeline runs in an isolated container, but it can sometimes be valuable outside of these environments.

File output connector configuration​

The file connector has the following configuration parameters:

  • path: The file to write, specified as an absolute filename. Required.

Example​

The following writes a file named /tmp/output.txt:

CREATE TABLE stocks (
    symbol VARCHAR NOT NULL,
    price DECIMAL(38, 2) NOT NULL
);
CREATE VIEW copy WITH (
  'connectors' = '[{
    "transport": {
      "name": "file_output",
      "config": {
        "path": "/tmp/output.txt"
      }
    },
    "format": { "name": "csv" }
  }]'
)
AS SELECT * FROM stocks;