Target file

After transformation, the Target File function lets you save your final data into a file, like Excel (.xlsx), CSV, or JSON. You can choose where to save this file, such as:

• Your local system
• An SFTP server (a secure remote location)
• A cloud storage service like AWS S3 or Google Cloud

This step usually occurs at the end of a data pipeline, when you’re ready to download the results or send the file to another person or system.

It’s useful when you want to share reports, backup data, or provide final outputs to other teams or tools.

Steps to use Target File:

Step 1: From the drop-down menu under “Select file type,” choose the format to download the file. Options may include CSV, JSON, XLSX, and Parquet.

Step 2: From “Select type,” choose the download location:

• Local download (download to your computer)
• SFTP (upload to a secure server)
• Cloud (save to cloud storage like AWS S3, GCS, etc.)

Step 3: Specify the file name you want to assign to the exported file.

Step 4: Save the configuration and run the graph. The file will be downloaded automatically.

For example:

• We select “xlsx” as the file type from the drop-down menu.
• As we wanted to download the file on the local system, we chose “Local download.”
• Providing the file name “Retail file.”
• Run the graph. The file will be downloaded automatically, and its name will be displayed in the preview section.

Note:

• Target files will only download files up to 10 MB; the rest of the data will be truncated from the file.
• If the user prefers SFTP, select the option and enter the required details to establish the connection.
• If choosing the Cloud option, select it and pick the desired connection from the list.