Copy Tables to Data Labs | Teradata Studio/Studio Express - Copying Tables to Data Labs - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Copy a Vantage table to a data lab by dragging the source table from the Data Source Explorer and dropping it into the Data Lab View. The Data Lab Copy Wizard guides you through the steps of performing a table copy.
The Copy Wizard is not provided in Teradata Studio Express.
  1. In the Data Source Explorer, navigate to the table object you want to copy.
  2. Drag the table object to the Data Lab View and drop it on the parent data lab group.
  3. In Copy Table, verify the Source and Destination information is correct.
  4. If the table does not exist in the data lab group, select from these options:
    Option Description
    Copy Data Copies the source table data to the data lab table. To create a new table that is empty, de-select this option. If the target table exists, select to append or replace the data in the Data Lab.
    Lock Table Locks the table during the copy operation. Locking tables can cause performance to be slow.
  5. If the table already exists in the data lab group, select from these options:
    Option Description
    Lock Table Locks the table during the copy operation.
    Append to Existing Data Appends the source table data to the end of the data in the destination table.
    Replace Existing Data Replaces all existing data in the data lab table with the source table data.
  6. Click Next.
  7. In Filter Table, specify which table columns to copy and then select a filter type and data value to filter the data in the column.
    This filter creates the SELECT statement for the COPY operation.
  8. Click Next.
  9. In SQL Preview Filter Table, review the generated SQL for the COPY operation.
  10. Click Finish.
  11. Monitor the progress of the COPY operation in the Transfer Progress View.