Teradata Execute example

This example demonstrates how to execute various commands using the Teradata Execute Snap. This pipeline creates a table, inserts the data into the table, and reads the data using the respective execute commands (CREATE, INSERT, and SELECT).



  1. Create a table, Snaplogic.character_datatype under the schema name Snaplogic. The table has 4 columns: INTEGER, CHAR, VARCHAR and CLOB .
  2. Insert the required data into the table Snaplogic.character_datatype using the Teradata Execute Snap.


  3. We use the Teradata Execute Snap again and select the data from the table Snaplogic.character_datatype1 using the SELECT command.


  4. Successful execution of the Pipeline displays the following preview:


To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.