Teradata FastExport
On this Page
Snap type: | Read | |||||||
---|---|---|---|---|---|---|---|---|
Description: | This Snap allows you to export data from a Teradata database by providing a table name and configuring the connection. The Snap writes the exported data to the specified file and provides the console output and status code on the output view for any downstream Snap checking for successful execution. SELECT TOP [limit] * FROM [table] WHERE [where clause] ORDER BY [ordering] You will need the Teradata Tools & Utilities (TTU) to have access to the Teradata FastExport component.
| |||||||
Prerequisites: | None | |||||||
Support and limitations: | Works in Ultra Tasks. | |||||||
Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring Teradata Database Accounts for information on setting up this type of account. | |||||||
Views: |
| |||||||
Settings | ||||||||
Label | Required. The 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. | |||||||
Schema name | The database schema name. In case it is not defined, then the suggestion for the table name will retrieve all tables names of all schemas. The property is suggest-able and will retrieve available database schemas during suggest values. Example: SYS Default value: [None] | |||||||
Table name | Required. Name of table to execute a select query on. Example: people Default value: [None] | |||||||
Where clause | Where clause of select statement. This supports document value substitution (such as $person.firstname will be substituted with the value found in the incoming document at the path). However, you may not use a value substitution after "IS" or "is" word. Please see the examples below. Examples:
Caution Using expressions that join strings together to create SQL queries or conditions has a potential SQL injection risk and is hence unsafe. Ensure that you understand all implications and risks involved before using concatenation of strings with '=' Expression enabled. Default value: [None] | |||||||
Order by | Enter in the columns in the order in which you want to order by. The default database sort order will be used. Example: Default value: [None] | |||||||
Limit rows | The number of rows the query should return. Default value: [None] | |||||||
Output fields | Enter or select output field names for SQL SELECT statement. Fields available include:
To select all fields, leave it at default. Example: email, address, first, last, etc. Default value: [None] | |||||||
Fetch Output Fields In Schema | Select this check box to include only the selected fields or columns in the Output Schema (second output view). If you do not provide any Output fields, all the columns are visible in the output. Default value: Not selected | |||||||
Match data types | Conditional. This property applies only when the Output fields property is provided with any field value(s). If this property is selected, the Snap tries to match the output data types same as when the Output fields property is empty (SELECT * FROM ...). The output preview would be in the same format as the one when SELECT * FROM is implied and all the contents of the table are displayed. Default value: Not selected | |||||||
Number of retries | Specify the maximum number of reconnection attempts that the Snap must perform, in case of connection failure or timeout. Default Value: 0 | |||||||
Retry interval (seconds) | Enter in seconds the duration for which the Snap must wait between two reconnection attempts, until the number of retries is reached. Default Value: 1 | |||||||
Staging mode | Required when the value in the Number of retries field is greater than 0. Specify the location to store input documents between retries, from the following options:
To disable staging, enter 0 in the Number of retries field. Default value: In memory | |||||||
Fast Export | ||||||||
File Action | Required. Select an action to take when the specified file already exists in the directory. Options available include: Overwrite, Ignore, Error. Default value: Error | |||||||
FEXP Location | The location of the Teradata FastExport component. Default value: /usr/bin/fexp | |||||||
Character Set | Select the character set in which data should be encoded when you export data from the Teradata Database. Teradata Database allows a character set to be established when invoking the FastExport. The available options are:
In general, the command language and the job output should be the same as the client character set used by the job. However, the UTF-8 character set also supports the network-attached platforms that use UTF-16 character set. Default value: Default | |||||||
Output File | Location of exported data file. If there is a white space, then the path should be in quotes as per the Teradata documentation. Default value: [None] | |||||||
Data Format | Export file format. Possible values are:
See the Format Syntax Element for the EXPORT command in the Teradata FastExport Reference for detailed information. Default value: FASTLOAD. | |||||||
Date format | Required. Date format used in the output file in text mode. Options available include Integer and Text. Default value: Integer | |||||||
Snap Execution | Select one of the following three modes in which the Snap executes:
Default Value: Execute only |
For the Suggest in the Order by columns and the Output fields properties, the value of the Table name property should be an actual table name instead of an expression. If it is an expression, it will display an error message "Could not evaluate accessor: ..." when the Suggest button is pressed. This is because, at the time the Suggest button is pressed, the input document is not available for the Snap to evaluate the expression in the Table name property. The input document is available to the Snap only during the preview or execution time.
See Also
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.