To File
📄️ To File - An Overview
The To File process in SYNTASA is used to export data from the SYNTASA environment into external file formats, such as CSV or plain text, and store it in connected cloud storage solutions like Amazon S3. This is particularly useful when you want to make the processed data available outside SYNTASA for reporting, data sharing, or downstream consumption.
📄️ Understanding Parameters for Generating Standard Output File
he To File process in Syntasa allows you to export processed data from the platform into external file formats like CSV or text files. When choosing the Standard output format, the system creates a comma-separated (CSV-style) file that is easy to share, analyze, or integrate with external tools. This article will guide you step-by-step through the configuration options for generating a Standard output file, including an explanation of each setting visible in the Parameters section of the TO FILE process.
📄️ Understanding Parameters for Generating Key-Value Output File
The Key-Value output format in the TO FILE process allows you to export your structured data into a flat text format where each row contains key-value pairs. Syntasa’s TO FILE process gives users complete control over how output data is formatted by allowing custom delimiter values in Key-Value output files. Rather than being restricted to specific characters, users can define their own ID Delimiter, Key-Value Pair Delimiter, Key-Value Delimiter, and Array Delimiter based on the needs of their downstream systems. For example, you may choose a comma, pipe (|), colon (:), tab (\t), or any other character. This flexibility allows you to generate output files in formats compatible with legacy systems, APIs, flat-file ingestions, or any third-party tools expecting a specific structure.
📄️ Parameters in To File Process
In Syntasa’s TO FILE process (also previously known as the Publish process), users can customize output file names using dynamic parameters. These parameters are replaced at runtime with actual values from the dataset or execution context, allowing for meaningful and unique file names. This capability is particularly useful when organizing outputs by row count, date range, data volume, or partition. Each parameter is written using curly braces and an at-symbol, such as {@rows} or {@date}.
📄️ Mapping Columns in 'To File' Process
The Mapping screen in the TO FILE process allows users to control which columns are included in the output file and how they appear. This screen is essential for customizing the structure and order of your exported data. By selecting only the relevant columns, renaming them, and setting their order, users can format output files to match specific business or integration requirements.
📄️ Step by Step Guide to Create File via 'To File' Process
In this article, we’ll walk through a complete step-by-step guide to configure and execute the TO FILE process in Syntasa, which allows you to export data from the Syntasa environment into external cloud storage in the form of CSV or text files.