File Writer

In this article

Overview

You can use this Snap to read a binary data stream from the input view and write it to a specified file destination. Possible file destinations include: SLDB, HTTP, S3, FTP, SFTP, FTPS, or HDFS. If File permissions for the file are provided, the Snap set those permissions to the file. This is a Write Snap type.

This Snap has the ability to use an MD5 checksum that automatically checks for data integrity and corruption while uploading the file.  

Prerequisites

IAM Roles for Amazon EC2

The 'IAM_CREDENTIAL_FOR_S3' feature is used to access S3 files from EC2 Groundplex, without Access-key ID and Secret key in the AWS S3 account in the Snap. The IAM credential stored in the EC2 metadata is used to gain access rights to the S3 buckets. To enable this feature, the following line should be added to global.properties and the jcc (node) restarted:
jcc.jvm_options = -DIAM_CREDENTIAL_FOR_S3=TRUE

Please note this feature is supported in the EC2-type Groundplex only.

For more information on IAM Roles, see http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/iam-roles-for-amazon-ec2.html

Support for Ultra Pipelines

Works in Ultra Pipelines.

Limitations

Files uploaded to SLFS have a 100-MB per file limit. This limit does not apply when writing to external storage. 

Known Issues

  • This Snap does not create an output file when using the input from SAS Generator Snap configured with only the DELETE SAS permission. This is not the case when the target file exists.
  • This Snap does not fail and turns green after execution despite providing an expired SAS URI. As a workaround, select Validate after write to fail the Snap in case of invalid credentials.

Snap Input and Output

Input/OutputType of viewNumber of viewsExamples of Upstream/Downstream SnapsDescription
InputBinary
Min: 1
Max: 1

Any Snap with a binary output view can be connected upstream, such as CSV Formatter, JSON Formatter, XML Formatter, or File Reader.

Any binary data stream.
OutputDocument
Min: 0
Max: 1
Downstream Snap is optional. Any Snap with a document input view can be connected downstream.

The output view for this Snap is optional. If an output view is open and the file write action is successful, the output view provides a document with information on the filename, result, and original data. An example is:

{
        "filename": "ftp://ftp.Snaplogic.com/home/qatest/user_manual.pdf",
        "result": "overwritten",
        "original": {
            "content-type" : "application/json"
        }
    }

The value of the "result" field can be "overwritten", "created", "ignored", or "appended". The value "ignored" indicates that the Snap did not overwrite the existing file because the value of the File action property is "IGNORE".

Do not use the 423patches7923 build for the File Writer Snap, because it causes connectivity issues with the Snaplex nodes.

Snap Settings

FieldField TypeDescription

Label*


String

Specify a name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Default Value: File Writer
Example: File Writer

File name*

String

Specify the URI of the destination file to which the the data (binary input from the upstream input view) is written. It may start with one of the following protocols:

  • http:
  • https:
  • s3:
  • sftp:
  • ftp:
  • ftps:
  • hdfs:
  • sldb:
  • smb:
  • file: (only for use with a Groundplex)

  • wasb:

  • wasbs:

  • gs:

  • adl: 

Writing Files in SLDB

For SLDB files, if you enter:

  • a file name, such as file.csv, then it writes the file to: /<org>/projects/<pipeline project>/file1.csv (where <org> is your organization name and <pipeline project> is the project where the Pipeline is stored), if the Pipeline is in a project other than the shared project.

  • shared/file1.csv, then it writes the file to: /<org>/shared/file1.csv.

The Snap can write a file to its own project directory or the shared project, and cannot write it to another project directory.


Writing Files in S3

To write files in S3, your account must have full access. 

You can also access the fields in a binary header when specifying a file name. For example, if you have a File Reader Snap upstream of a File Writer Snap, you can access the "content-location" header field to get the original path of the file. You can then use a new file name based on the old one, for instance, to make a backup file:
$['content-location'].match('/([^/]+)$')[1] + '.backup'

For http: and https: protocols, the Snap uses http PUT method only. This property should have the following syntax:

[protocol]://[host][:port]/[path]

  • "://" is a separator between the file protocol and the rest of the URL and the host name and the port number should be between "://" and "/". If the port number is left empty, a default port number for the protocol is used. The hostname and port number are left empty in the sldb and S3 protocols. The value in this field should be an absolute path for all protocols except SLDB.
  • The file:/// protocol is supported only for Groundplex. In Cloudplex configurations, use SLDB or other file protocols. When using the file:/// protocol, the file is accessed based on the permissions of the user associated with the Snaplex is running (Default: Snapuser). 

  • For HDFS, if you want to be able to suggest information, use the HDFS Writer Snap. 

Use the file system access with caution, and ensure to clean up the file system after use.


  • When using expressions to build a file name, ensure that the resulting filename does not contain characters that are not supported by the target platform. 
    • The following characters are illegal in a share name: \ / [ ] : &#124; < > + = ; , * ? "

    • The following characters are not allowed in SMB share name: " \ / : | < > * ?

For more information about referencing SMB file names, see Microsoft's documentation

Default Value[None]

Examples

File action*


Dropdown list

Specify the action to perform if the file already exists. The available options are:

  • Overwrite - If Overwrite is selected, the Snap attempts to write the file without checking for the file's existence for a better performance, and the "fileAction" field will be "overwritten" in the output view data.
  • Append - Append is supported for file, FTP, FTPS and SFTP protocols only.
  • Ignore - If Ignore, it will not overwrite the file and will do nothing but write the status and file name to its output view.
  • Error -  If Error is selected, the error displays in the Pipeline Run Log. If an error view is defined, the error will be written there as well.
  • In case you are selecting Append as File action, then ensure that the ‘Number of retries’ is 0 or not greater than 0.
  • For wasb:// and wasbs:// file protocols, only the Overwrite file action is supported.

Default ValueOverwrite

Write empty fileCheckbox

Select this checkbox to write an empty file when the incoming binary document has empty data. If there is no incoming document at the input view of the Snap, no file is written regardless of the value of the property.

Default Value: Not selected.

Write header file


String

The binary data stream in the input view may contain header information about the binary data in the form of a document with key-value-pair map data.
Select this checkbox to enable the Snap to write a header file whose name is generated by appending ".header" to the value of the File name property. The same header information is also included in the output view data, as shown in the "Expected output" section above, under the key "original". Note that if the header has no keys other than Content-Type or Content-Encoding, the .header file will not be written

Default Value: Not selected 

Validate after write


Checkbox

Select this checkbox to enable the Snap to check if the file exists after the completion of the file write. This may delay a few more seconds for the validation.

Default Value: Not selected 

Number of retriesInteger

Specify the maximum number of retry attempts when the Snap fails to write. If the value is larger than 0, the Snap first stores the input data in a temporary local file before writing to the target file.

  • Ensure that the local drive has sufficient free disk space as large as the expected target file size.
  • Owing to the nature of retry mechanism, the Snap does not support the Append operation if the Number of retries is set to more than zero.

Minimum value: 0

Default Value: 0
Example: 3

Retry interval (seconds)Integer

Specify the minimum number of seconds for which the Snap must wait before attempting recovery from a network failure.

Minimum value: 1

Default Value: 1
Example: 3

File permissions for various users

Use this field set to provide any combination of permissions to the available users. 

  • Supported for sftp, ftp, ftps, file, and hdfs protocols only.
  • FTP/FTPS servers on Windows machines may not be supported.
User typeString/Expression

Choose one of the three standard user types. The available options are:

  • owner
  • group
  • others

Each row can have only one user type and each user type should appear only once. Select one from the suggested list. Specify at most one row per user type.

Default Value: N/A
Example: owner

File permissionsString/Expression/Suggestion

Specify the privilege to provide to the user on the file. The available permissions are:

  • read
  • write
  • execute
  • read+write
  • read+execute
  • write+execute
  • read+write+execute

Default Value: N/A
Example
: read+write+execute

Create directory if not present  


Checkbox

Select this checkbox to enable the Snap to create a new directory if the specified directory path does not exist. This field is not supported for HTTP, HTTPS, SLDB and SMB file protocols.

Default Value: Not selected

Flush interval (kB)Integer

Flush interval in kilobytes during the file upload. The Snap can flush a given size of data output stream written to the target file server. If the value is zero, the Snap flushes in maximum frequency after each byte block is written. Larger the value is, the less frequent flushes the Snap performs. Leave the property at default -1 for no flush during the upload. This property may help if the file upload experiences an intermittent failure. However, more frequent flushes will result in a slower file upload.

Default Value: -1
Example: 100

Advanced propertiesUse this field set to add advanced properties, such as SAS URI.
PropertiesString

The URI of the Shared Access Storage (SAS) to be accessed. Supported SAS types are:

  • Service SAS on container
  • Service SAS on blob
  • Account SAS

ValuesString/Expression

Specify the value for the SAS URI.

If the SAS URI value is provided in the Snap settings, then the settings provided in the account (if any account is attached) are ignored.

Snap Execution


Dropdown list

Select one of the three modes in which the Snap executes. Available options are:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.
  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Examples

  • For SFTP files, if you attempt to write a file into a directory where you do not have a write access right, the write operation will fail with "access denied" error. When you get an SFTP account credential, it is also important to know where your home directory is, for example, sftp://ftp.snaplogic.com/home/mrtest for username "mrtest"
  • HDFS Example

For HDFS file access, please use a SnapLogic on-premises Groundplex and make sure that its instance is within the Hadoop cluster and SSH authentication has already been established. You can access HDFS files in the same way as other file protocols in File Reader and File Writer Snaps. There is no need to use any account in the Snap.

HDFS 2.4.0 is supported for the hdfs protocol.


An example for HDFS is: 

hdfs://<hostname>:<port number>/<path to folder>/<filename>

If Cloudera Hadoop Name node is installed in AWS EC2 and its hostname is "ec2-54-198-212-134.compute-1.amazonaws.com" and its port number is 8020, then you would enter:
hdfs://ec2-54-198-212-134.compute-1.amazonaws.com:8020/user/john/input/sample.csv
 Example pipeline file for an sldb file write

Example pipeline file for an sldb file write as shown below: 

Troubleshooting


ErrorReasonResolution

Could not evaluate expression: filepath

Mismatched input ':' expecting {<EOF>, '||', '&&', '^', '==', '!=', '>', '<', '>=', '<=', '+', '-', '*', '/', '%', '?', '[', PropertyRef}.


The expression toggle (=) is selected on the File name field, so it is trying to evaluate the filepath as an expression.


Check the expression syntax.

Click on the toggle to take the field out of expression mode.

Failure:
filename is undefined
filename was not found in the containing object.

The expression toggle (=) is selected on the File name field, so it is trying to evaluate the filename as an expression.


Check expression syntax and data types.

Click on the toggle to take the field out of expression mode.

Downloads

  File Modified

File file_writer.slp

Mar 15, 2017 by Diane Miller


See Also

Snap Pack History

 Click to view/expand


Release Snap Pack VersionDateTypeUpdates
4.27main12833Latest
  • Enhanced the File Operation Snap with a new field Azcopy absolute path that enables the Snap to make a single API call to move an entire directory. This field supports directory and wildcard characters for Azure blob storage for all three operations: Copy, Move and Rename.
  • Enhanced the Azure Storage Account with a new option called SAS URI in the Auth Type dropdown. This enables you to select either Access Key or the SAS URI while configuring the account settings.
4.26426patches12288Latest

Fixed a memory leak issue when using HDFS protocol in Binary Snaps.

4.26426patches11922LatestFixed an issue with the File Writer Snap, where the Snap failed to open a channel while accessing through a SFTP protocol.
4.26426patches11529Latest
  • Fixed an issue with the Decompress Snap, where the Snap prematurely uncompressed multi-stream BZIP2 files.
  • Enhanced the PGP Encrypt Snap with improved memory usage and also fixed an issue with this Snap, where the Snap failed to encrypt large size files due to the lack of memory.
4.26 main11181
StableUpgraded with the latest SnapLogic Platform release.
4.25 Patch

425patches10994

 
Latest
  • Removed duplicate strings in the request’s User Agent header sent by  S3 File Writer and S3 File Reader Snaps to display the string without any duplicates.
  • Enhanced the Directory Browser Snap to process the files with the owner field for the SFTP protocol. Upon validation, the output of the Snap fetches the owner’s name, which was previously displayed as unknown.
  • Fixed an issue with the File Writer Snap where the Snap fails to connect to the SFTP endpoint using the AWS Transfer Family.
  • Fixed an issue where integration Pipelines fail to connect the SFTP Server with the Binary Snap Pack when upgraded to the SnapLogic 4.25 release version (main9554).
4.25 Patch425patches10217
 
Latest
  • Fixed the following issues in the PGP Decrypt Snap caused due to the Snap patch 425patches9581:
    • The Snap writes an empty document to the output view when there is an error in the Snap. It will now decrypt the document and write it to the output view only if it succeeds.
    • The Snap fails to decrypt any non-signed encrypted file more than 500 bytes. It will now decrypt both non-signed and signed encrypted files. 
    • Removed the Project ID field from the Google Service Account, since the JSON Key already contains information about the Project ID. 
4.25 Patch425patches9581
 
Latest

Fixed an issue with the PGP Decrypt Snap where the Snap writes an empty document to the output view when there is an error in the Snap. It will now decrypt the document and write it to the output view only if it succeeds.

As of  we have discovered an issue with this Binary patch affecting the PGP Decrypt Snap. In case your Pipelines use the PGP Decrypt Snap, we recommend you to NOT use this patch. Else, your Pipelines will likely fail. We're working on a fix and will be deploying a Snap patch soon.

4.25 Patch425patches9564
 
Latest

Enhanced the SFTP session in Binary Snaps to support the SFTP servers which close SFTP sessions slowly.

4.25main9554
 
Stable

Enhanced the S3 File Writer Snap with an ability to write S3objects with Access Control List (ACL) details in a single API call.

In the 4.23 release, the S3 File Writer Snap used to write an S3 file and then set ACL if the ACL property was not empty. If the file write was successful and the ACL setting failed, both the output document in the output view and the error document in the error view was displayed. This issue has been resolved in the 4.24 release by enabling the Snap to configure ACL while writing the file. Therefore, the Snap produces an error document in the error view if the ACL configuration fails, irrespective of whether the file write action passes or fails.

4.24 Patch424patches9044-Latest

Enhanced the File Writer and S3 File Writer to use an MD5 checksum that automatically checks for data integrity and corruption while uploading the file.  

4.24 Patch424patches9020 
 
Latest

Fixed the file operation error of copying large S3 files in the File Operation Snap by supporting the transfer of zero-byte S3 files while uploading a file.

4.24 Patch424patches8876
 
Latest
  • Fixed the missing library error in Binary Snap Pack when running Hadoop Pipelines in JDK11 runtime.
  • Enhanced the Binary Snap Pack by adding a new account Two-Factor Auth Account that supports two layers of authentication for Secure File Transfer Protocol (SFTP). The two secure layers of verification to grant access include the Basic Auth (username/password) and the SSH Key (username/private key) methods.


4.24main8556
 
StableUpgraded with the latest SnapLogic Platform release.
4.23 Patch423patches8453
 
Latest

Fixed an issue in the File Writer Snap with the ADL protocol, to perform the correct action when OVERWRITE is selected from the File Action drop-down field.

4.23 Patch423patches8368-Latest

Fixed an encryption issue with the File Operation Snap by implementing both SSE-KMS and SSE-S3 supports to the Snap.

4.23 Patch423patches8368-Latest

Fixed an issue in the Snap Pack by removing the plaintext credentials in file URL from JCC log messages.

4.23 Patch423patches8099-Latest

Enhanced the Snap Pack by upgrading SMB client library.

4.23 Patch423patches7958-Latest

Fixed an issue with the File Writer Snap by avoiding overwriting of documents when using appending the data to a CSV file in SFTP.

4.23 Patch423patches7958-Latest

Rolled back the recent patch to Binary Snap Pack (File Writer Snap - 423patches7923) that might have induced SSL handshake failures/terminations in existing Pipelines. 

4.23 Patch423patches7923
Latest
  • Fixed the SFTP connection failure issue in File Writer Snap by
    • Ensuring that the BouncyCastleProvider is the first in the list of providers in the Security object.
    • Upgrading the BouncyCastle version to 1.67.

Do not use the 423patches7923 build for the File Writer Snap, because it causes connectivity issues with the Snaplex nodes.

4.23 Patch423patches7795-Latest

Fixed an issue with File Writer Snap by skipping the validation of the SAS URI having write permission, if the SAS URI uses an access policy.

4.23 Patch423patches7660-Latest

Enhanced the File Poller Snap by adding a field, Exit on first matches, which when set to true stops the Snap from executing after the first file paths matching the filter are written to the output view. If the field is not configured or is set to false (default value), then the Snap continues to poll the directory until the Polling timeout is reached.

4.23main7430-Stable

Enhanced the ZipFile Write Snap to provide the ability to change the default content-type (application/octet-stream) for any file that is stored into the Azure Blob Storage (WASB: or WASBS: file protocol). Hence, the files that the ZipFile Write Snap writes into the Blob Storage can be saved with content-type asapplication/zipor any other type instead of application/octet-streamalways.

You can now prevent the Snap from writing files always to Azure Blob Storage (WASB: or WASBS: file protocol) with the application/octet-stream content-type. To do so, configure a binary header property in an upstream Snap, such as JSON Formatter or Mapper, to match the file's content – application/zipapplication/java-archive and so on; and pass it as the $content-type (case-sensitive) for the file.

Binary header property in upstream Snap

4.22 Patch422patches6947-Latest

Fixed the issue of the hanging thread in the SMB accounts.

4.22 Patch422patches6950-Latest

Enhanced the S3 Dynamic Account by allowing to use the Security token field in Directory Browser, File Operation, File Poller, Multi File Reader, and File Delete Snaps. 

4.22 Patch422patches6629-Latest

Fixed the ZipFile Write Snap error by allowing the number of retries to be set greater than 0.

4.22 Patch422patches6542-Latest

Fixed SMB hanging threads by upgrading SMB client library.

4.22main6403-Latest
  • Added the Cross Account IAM Role feature to the existing accounts, AWS S3 Account and S3 Dynamic Account, to enable the AWS account user to access the resources of another AWS account for a specified time without sharing the login credentials.
  • Enhanced the File Operation Snap by adding a new property Simple file operation that allows moving or copying a file, through FTP protocol, irrespective of the account's access permissions on source and target directories.
4.21 Patch421patches6136-Latest

Fixed the issue with Multi File Reader Snap that continues to look for a directory even when FileSystem information is unavailable.

4.21 Patch421patches6090-Latest

Fixed the 'Connection pool shut down' error in S3 File Writer Snap by keeping the AmazonS3Client class object open until all the documents are processed.

4.21 Patch 421patches6077-Latest

Fixed the UnknownHostException error in Binary Snaps due to intermittent failures in FileSystemProvider registration, by replacing ServiceLoader with direct instantiations of FileSystemProvider class objects.

4.21 Patch421patches5994-Latest

Fixed an error in Multi File Reader and File Delete Snaps during Pipeline execution where the Snaps fail to retrieve the temporary files from the given S3 location.

4.21 Patch 421patches5963-Latest

Enhanced the Directory Browser Snap by making the File filter field optional.

4.21 Patch421patches5975-Latest

Fixed the Directory Browser Snap that fails with an Unable to create filesystem object for smb:// error, by rolling back the SMB client library to the prior working version as in snapsmrc542.

4.21 Patch421patches5871-Latest

When configuring the SSH Auth account type, SSH passphrase is now optional, whereas it was a required field earlier. 

4.21 Patchbinary8849-Latest

Enhanced the Directory Browser Snap by adding a new advanced property Use fast file-type check for wasb/wasbs protocols for quick Snap execution. 

4.21 Patchbinary8843-Latest

Fixed the issue in PGP Encrypt Snap where decrypting its output file using a third-party PGP software adds a random suffix and TMP extension in the file name. This issue occurs only when using the PGP Encrypt Snap in a Windows-based Groundplex.

4.21snapsmrc542-StableUpgraded with the latest SnapLogic Platform release.
4.20 Patchbinary8801-Latest
  • Fixed the Decompress Snap wherein the Snap stops decompressing at 64MB without displaying any error, when decompressing using the GZIP scheme.
  • Fixed an issue in the PGP Encrypt Snap so that third-party decryption tools do not receive a .tmp file from the Snap.   
4.20 Patchbinary8791-Latest

Fixed the ZipFile Write Snap wherein the Snap fails to execute if it finds different zip file paths when processing multiple input binary data.

4.20 Patchbinary8785-Latest
  • Added the User-defined object metadata and Object tags properties in the S3 File Writer Snap and the Get Object Tags property in the S3 File Reader Snaps to allow the inclusion of user-defined metadata and object tags.
  • Fixed a regression caused by Patch binary8775 wherein the File Reader and S3 File Reader Snaps fail to read S3 files with an account that does not include GetObjectTagging permission.
4.20 Patchbinary8775-Latest

Fixed the File Writer Snap to allow the deletion of temporary Google Storage files from the /tmp directory of the Groundplex if Pipeline execution stops before completion. 

4.20 Patchbinary8741-Latest
  • Fixed the ZipFile Write Snap wherein the Snap gives a Null Pointer Exception error if no input data is received by it during execution. 
  • Fixed the Email Sender & Reader Snaps where the Snaps fail to execute due to resource exhaustion on the Snaplex.
4.20 Patchbinary8710-Latest
  • Fixed the ZipFile Write Snap where the Snap generates files with incorrect names when the Use input view label checkbox is selected.
  • Fixed the File Writer Snap where the Snap fails intermittently when there is a network disruption.
  • Fixed the File Reader Snap where the Snap generates an output view, along with the error view, if there is an error when using the Google Service account.
4.20snapsmrc535-StableUpgraded with the latest SnapLogic Platform release.
4.19 Patchbinary8369-Latest

Fixed the following issues associated with the SMB account wherein:

  • Pipelines with multiple concurrent SMB connections hang intermittently.
  • Directories are not deleted completely.
4.19snaprsmrc528-Latest
  • The Key Passphrase field is now a mandatory field for the SSH Auth account. Ensure that you provide a passphrase when adding/editing accounts. Else, you will likely lose all updates related to the account and Pipeline.
  • Raises the minimum buffer size in the S3 File Writer Snap to 6 MB.
4.18 Patchbinary8768-Latest
  • Fixed the File Reader, File Writer, and Directory Browser Snaps to resolve 0x103 (STATUS_PENDING) and 0xc000022d (STATUS_RETRY) errors for SMB file operations.
4.18 Patchbinary8046-Latest

Enhanced the Snap Pack to support AWS SDK 1.11.634 to fix the NullPointerException issue in the AWS SDK. This issue occurred in AWS-related Snaps that had HTTP or HTTPS proxy configured without a username and/or password. 

4.18 Patch MULTIPLE7884-Latest

Fixed an issue with the PostgreSQL grammar to better handle the single quote characters.

4.18 Patchbinary7860-Latest

Fixed an issue with the File Writer Snap wherein the Snap is intermittently unable to set correct permissions.

4.18 Patch

binary7851

-Latest
  • Added new field, Advanced properties, in the File Reader, File Writer, File Delete, ZipFile Read, ZipFile Write, Directory Browser, Multi File Reader, File Poller, and File Operation Snaps. Use this field to configure the SAS URI to access Azure Storage. Supported SAS types are Service SAS on container, Service SAS on blob, and Account SAS.
  • Added new Snap, SAS Generator. This Snap enables you to generate Shared Access Storage (SAS) URIs for accessing Azure Storage containers and blobs.
4.18 Patchbinary7746-Latest

Fixed an issue with the SMB file protocol wherein Binary Snaps are unable to create a native thread using an SMB file path.

4.18 PatchMULTIPLE7778-Latest

Updated the AWS SDK library version to default to the Signature Version 4 Signing process for API requests across all regions.

4.18 Patchbinary7720-Latest

Fixed an issue with the ZipFile Read Snap wherein the Snap fails to extract files from a zip file heavier than 100MB when the number of retries is greater than zero.

4.18snapsmrc523-Latest

Added a new account type, Google Service Account, which enables you to isolate workflows from individual users.

4.18snapsmrc523-Latest

Added a new account type, Google Service Account, which enables you to isolate workflows from individual users.

4.17 Patch binary7589-Latest

Fixed an issue with the File Reader Snap wherein SMB fails to provide multiple Snaps with concurrent access.

4.17 Patch binary7487-Latest

Fixed an issue with the File Writer Snap wherein the Overwrite File action for SMB files fails on subsequent executions.

4.17 PatchALL7402-Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17 Patch binary7381-Latest

Fixed an issue with SMB accounts wherein login to the server fails if password contains a plus (+) sign.

4.17 Patchbinary7366-Latest

Added support for multiple slashes as a prefix for SMB file URLs.

4.17 Patchbinary7280-Latest

Added a new field, File Delete Action, to the File Delete Snap that handles missing target files.

4.17 Patchsnapsmrc515-Latest
4.16 Patchbinary7049-Latest

Fixed an issue with the File Writer Snap wherein the Snap writes FTPS files partially. Two new global properties, ftpsDelayBeforeClosing and ftpDelayBeforeClosing, enable you to add delays to the FTP file protocol to handle the partial write. 

4.16 Patchbinary7049-Latest

Fixed an issue with the File Writer Snap wherein the Snap writes FTPS files partially. Two new global properties, ftpsDelayBeforeClosing and ftpDelayBeforeClosing, enable you to add delays to the FTP file protocol to handle the partial write. 

4.16 Patchbinary6975-Latest

Added a new property, Blob endpoint, for Binary Accounts, which enables you to specify the Azure Blob Storage endpoint that you want to use with an Azure Storage account. 

4.16snapsmrc508-Latest

Added a new property Only Output on Change in the File Poller Snap. This property helps avoid redundancy by not displaying the same matching file in every polling result unless the file is changed.

4.15 Patchbinary6744-Latest

Fixed a timeout error while writing to S3 in the S3 File Writer Snap.

4.15 Patchbinary6414-Latest

Fixed an issue wherein the hostname specified in the Directory Browser path failed to appear as a path in the output document.

4.15 Patchbinary6414-Latest

Fixed an issue wherein the hostname specified in the Directory Browser path failed to appear as a path in the output document.

4.15snapsmrc500-Latest

Added a new property, Binary Header Properties, to the CSV Formatter Snap. This property can be configured with the binary headers and their values in the incoming document.  

4.14 PatchMULTIPLE5732-Latest

Fixed an issue with S3 file reads getting aborted intermittently because of incomplete consumption of input stream.

4.14snapsmrc490-Latest

Enhanced the Basic Auth and Symmetric Crypto accounts to support pipeline parameters. Using pipeline parameters, Basic Auth now supports passing username and password, and Symmetric Crypto now supports passing secret key dynamically.

4.13 Patch

binary5372

-Latest

Updated the File Operation Snap for S3 to support files larger than 5GB by using an API for multipart upload copy.

4.13 Patch binary5315-Latest

Added a new property "Enable staging" to enable the File Reader and S3 File Reader Snaps to perform as expected even in a slow network connection to AWS S3.

4.13snapsmrc486-Latest

Added AWS Key Management Service (KMS) encryption support to AWS S3 and S3 Dynamic accounts in the Binary Snap Pack.

4.12binary5044-Latest

Fixed an issue with the S3 File Writer Snap, which corrupts while writing files if retry value is set to 1.

4.12 Patchbinary4882-Latest

Fixed issue caused in the File Operation Snap due to the rollback after the 4.12 release that impacted the S3 and FTP protocols. 

4.12 Patchbinary4840-Latest

Fixed an issue in the File Delete Snap, wherein if no account is given for the SFTP protocol, then the error did not display.

4.12 Patchbinary4797-Latest

Added a new property 'Number of retries' in the File Writer Snap to fix interoperability issues with a server software.

4.12 Patchbinary4736-Latest

Fixed the issue where File Writer Snap does not write files to Windows Serv-U FTP server, while not displaying any error message.

4.12snapsmrc480-Latest
  • Added new Snaps - File Operation Snap and S3 File Reader Snap.
  • Updated S3 File Writer Snap to provide suggestions for S3 buckets and file names (versioning support).
4.11 Patchbinary4424-Latest

Resolved an Issue with SFTP server where the pipeline stopped responding while writing to the Tumbleweed server (SFTP server). Fixed the code in a way that the SFTP server now flushes out data after each write.

4.11 Patchbinary4328-Latest

Fixed an issue with the File Delete Snap that was unable to delete the file with a size greater than 1MB.

4.11 Patchsnapsmrc465-Latest
  • Added the new Snaps, Multipart Reader and Multipart Writer.
  • Updated the S3 File Writer Snap with Maximum upload threads property to support the performance.
  • The File Reader and the ZipFile Reader Snaps now show the progress message during the pipeline runtime.
4.11binary4019-Stable

Resolved an issue with the File Writer Snap writing to an FTP Server that may prematurely close the connection; this patch ensures the write has fully completed before disconnecting.

4.10 Patchbinary3930-Latest

Directory Browser - When "Ignore empty result" is not selected, the "original" passthrough document is now returned even when the S3 directory is empty.

4.10 Patchbinary3840-Latest

S3OutputStream handles failures.

4.10snapsmrc414-Stable

No updates made. Automatic rebuild with a platform release.

4.9 Patchbinary3331-Latest

Directory Browser Snap - fixed NPE issue, "File filter" property, and "Display update time and owner for S3 subdirectories" property.

4.9 Patchbinary3183-Latest

Fixed SFTP connection leak when "Validate after write" is checked for File Write Snap.

4.9 Patchbinary3170-Latest

Addressed the following issue in Directory Browser: "Update time" being returned "unknown" for directories within S3 objects

4.9 Patchbinary3081-Latest

Added ability to sign PGP encrypted files.

4.9 Patchbinary3060-Latest

Addressed an issue in Directory Browser and fixed issue in writing the original document to output view when reading from S3.

4.9 Patchbinary3022-Latest

Addressed an issue regarding an array out of bounds exception when IAM Role is enabled.

4.9 Patchbinary3000-Latest
  • Restore the update date date-time format for using Directory Browser with S3. A new property Display update time and owner name for s3 subfolders was added that, when enabled, will calculate update times and owners on AWS S3 subfolders.
  • Added the IAM support to the AWS S3 account.
4.9Snapsmrc405-Stable

No updates made. Automatic rebuild with a platform release.

4.8 PatchSnapsmrc405-Latest

Addressed an issue with Directory Browser taking too lont to start listing files from S3 bucket and then failing with partial results due to CPU spikes.

4.8Snapsmrc398-Latest
  • Info tab added to accounts.

  • Streaming performance improvement while writing to an S3 bucket using S3 File Writer. Updated the S3 File Writer Snap with a Buffer size(MB) property.
  • The 'content-location' in the output header of Binary Snaps was updated to correctly reflect the location (for example, sldb:/// instead of sldb://). This may impact your Pipeline if you are using this information in the following Snaps: File Reader, AES Encrypt, AES Decrypt, BlowFish Encrypt, Blowfish Decrypt, Compress, Decompress, File Writer, Multi File Reader, PGP Encrypt, PGP Decrypt, TwoFish Encrypt, TwoFish Decrypt, or S3 File Writer.
4.7.0 Patchbinary2346-Latest

ZipFile Read Snap: Added support for reading 7z archive formats created using Windows machines.

4.7.0 Patchbinary2337-Latest

Added Encrypted filename property to PGP Encrypt Snap.

4.7Snapsmrc382-Latest
  • Updated the Snap Account settings with a new Account Type, Azure Data Lake.
  • Updated the Snaps- Directory Browser, File Writer, File Reader with the account Type, Azure Data Lake.
  • Updated the File Reader and ZipFile Read Snaps with the property, Prevent URL encoding.
  • Spark mode support added to S3 File Writer for AWS S3.
  • Spark mode support added to File Reader for AWS S3.
4.6.0 Patchbinary2110-Latest

File Writer: fixed an issue on Windows Snaplexes that prevented creating directories that are not present.

4.6.0 Patchbinary2009-Latest

File Writer: fixed an issue on Windows Snaplexes that prevented creating directories that are not present.

4.6.0 Patchbinary1898-Latest

File Reader and ZipFile Reader Snaps: Added a new "Prevent URL encoding" setting to allow users to disable automatic URL encoding of file paths. This allows pre-encoded URLs and file paths to be used as-is.

4.6.0 Patchbinary1851-Latest

Resolved an issue with Directory Browser Snap not freeing up connections in Windows Groundplex.

4.6.0Snapsmrc362
Stable
  • Binary Snaps that work with AWS S3 accounts can now configure their accounts with IAM Role.
  • Enhanced the File Writer Snap with an option to create a directory if the specified directory path does not exist, the newly added field, Create directory if not present.
  • Updated based on the currently supported account types.  The supported account types are: Basic Auth, AWS S3, S3 Dynamic, SSH Auth, SMB, Azure Storage, and Google Storage.
4.5.1 binary1563-Latest
  • File Reader, ZipFile Read, Multi File Reader Snaps are updated with the Execute during preview field to execute the Snap during the Save operation so that the output view can produce the preview data. For more information, see File Reader, ZipFile Read, & Multi File Reader.
  • File Delete & File Writer Snaps are updated with an option to validate file deletion & file writing after Snap execution. For more information, see File Delete & File Writer.
  • ZipFile Write Snap is updated with an option, Use input view label, to enable sequential file naming of files added to zip file. For more information, see ZipFile Write.
  • Fixed an error in File Reader Snap that exposed account credentials in an error message.
  • Fixed an error in File Writer & File Delete Snap to ensure consistent error handling for all the protocols.
4.5Snapsmrc344-Stable
  • File Reader, File Writer, S3 File Writer, ZipFile Read, Directory Browser, Multi File Reader, File Poller, File Delete, ZipFile Write, HDFS Reader and HDFS Writer updated to support IAM Roles for Amazon EC2.
  • Support for Google Storage added to File Reader, File Writer, Directory Browser, Multi File Reader, File Poller, File Delete, ZipFile Read, and ZipFile Write Snaps.
  • Resolved an issue in File Writer Snap that occurred when writing to an SFTP file with an SSH account.
  • Resolved an issue in Multi File Reader Snap that occurred when adding error views and performing binary data streaming.
  • Doc Enhancement: Example added to File Delete Snap.
4.4.1--Latest
  • A new Snap property Write empty file has been added to File Writer and S3 File Writer Snaps to allow for creation of zero byte files. 
  • Resolved an exception in File Writer when 'file name' has no value.  
  • ZipFile Read: "zip-filename" was added to the header of the output binary document.
4.--Stable
  • Resolved an issue with File Writer failing to timeout when attempting to connect to an SFTP location that was unreachable.
  • Resolved an issue with File Reader failing validation is FTP connection password had special characters.
  • Support for WASB and WASBS in Directory Browser, Multi File Reader, File Delete, File Poller, ZipFile Read, and ZipFile Write Snaps.
4.3.2--Latest
  • NEW! S3 File Writer
  • Implemented wasbs:// protocol support in Binary Snap Pack.

    In the SnapLogic 4.3.2 release, WASB (Windows Azure Storage Blob) or WASBS protocol (wasb:/// or wasbs:///) support has been added to the Binary Snaps.

    In the WASB and WASBS file URL, the top directory should be the name of the 'Azure Storage container'.

    The follow line should be added to global.properties file and the jcc restarted to have the Azure Storage support available:

    	jcc.jvm_options = -DDEFAULT_URL_PATTERN=.*.core.windows.net.*
  • Resolved an issue with Directory Browser Snap returning Invalid Path.
4.3.1---
  • Feature: Enhanced File Delete Snap to support S3 protocol.
  • Resolved an issue with smb pathname failing when directory name contained a space.
  • Resolved an issue with a pipeline  showing as successful when writing to a project to which it had no access.
  • Resolved an issue with Directory Browser not returning any data when target files were not present. The option, Ignore empty result, now allows you to determine whether or not to output an empty document of no data is passed through.
4.3.0---
  • File Reader and File Writer now support Azure Blob as a file protocol.
  • Support for specifying another Windows drive path added to Directory Browser, File Poller, Multi File Reader, File Reader, and File Writer.
  • File Delete no longer displays user credentials in error messages.
  • Resolved an issue with File Poller failing to properly determine directories versus files in an S3 path.

4.2.2

---
  • Resolved an issue with the ZipFile Read Snap failing to decompress a zip file.
  • Resolved an issue with MultiFile Reader not able to read UNC-syntax local files in Windows Groundplex.
  • Resolved an SFTP I/O error with File Read.
  • Resolved an issue in SFTP pooling when a large number of connections are opened for both pooling enabled and disabled.
  • Resolved an issue in File Poller where setting Polling timeout to a negative number below -1 caused the Snap to run forever.
  • Resolved an issue in AES Snap with 256 bit keys.
  • Resolved a file size issue in File Writer with the Dropbox FTP site.
4.2.1-
 
-
  • NEW! File Poller Snap. This Snap polls a directory looking for files matching the specified pattern.
  • PGP Decrypt now supports files that are encrypted and signed.
  • Resolved Directory Browser unable to support file protocol on Windows Groundplex
  • Resolved Multi File Reader File protocol is not working for Windows Groundplex
Summer 2015---
--
 
-
  • ZipFile Read Snap hangs when the File property is evaluated to a binary object too large to be a file URL
  • Directory Browser: Unexpected results when using SFTP protocol paths
  • SMB ClearText credentials visible for incorrect connection string
--
 
-
  • File writer Snap - Null pointer exception resolved - Better reporting on ftps errors
  • Directory Browser Snap listed wrong path for S3 sub-directories
--
 
-
  • Directory Browser: added pass-through capability
  • File Delete: resolved an error writing to network stream
  • File Writer: The output view field "fileAction" has changed to "result", web HDFS enhancements
--
 
-
  • Compress and Decompress: Resolved an issue with pipeline preview not limiting the amount of data available in preview.
  • File Writer: Improved error messages.

Multi File Reader: Resolved an issue were some files were read twice if Include subfolders was selected when using the S3 protocol.

--
-

Tooltip cleanup

--November 2014-

File Writer now lets you set file permissions.

--July/Summer 2014-

NEW! ZipFile Read and Write

--April 2014-

File Writer Snap updated to allow for appending, overwriting, ignoring or erroring out if the file already exists.

--March 2014-
  • NEW! Encrypt and Decrypt Snaps for AES
  • NEW! Encrypt and Decrypt Snaps for Blowfish
  • NEW! Encrypt and Decrypt Snaps for Twofish
  • NEW! Directory Browser
  • Execute during preview was added to the File Writer Snap.
--January 2014-

An output view was added to File Writer.

--December 2013-
  • NEW! File Delete Snap
  • NEW! PGP Decrypt and PGP Encrypt
--November 2013-
  • NEW! Compress and Decompress
  • Writer Snaps can now be enabled to write during preview.
  • Reader Snaps allow you to pass through data from the input view. The output of the reader will provide a new document element holding the original data from the input view (under original).
--July 2013-

There are now separate Snaps for reading a single file into SnapLogic and reading multiple files (File Reader and Multi File Reader).

--June 2013-

Initial release. Read/write support for popular data formats: Binary, CSV, HTML, JSON