Uploading Data Files using Teradata Studio - 17.00 - Uploading Data Files using Teradata Studio - Teradata Package for Python - Teradata Vantage

Getting Started Guide for Data Scientists Using Python with Vantage

Product
Teradata Package for Python
Teradata Vantage
Release Number
17.00
Release Date
December 2020
Content Type
Programming Reference
Publication ID
B700-4040-120K
Language
English (United States)

The data files used in this example are three CSV files included in the attached zip file DataScience-Python_Datafiles.zip.

Follow the steps below to upload the files to Vantage using Teradata Studio.

See Teradata Studio™ User Guide, B035-2041 for details on how to use Teradata Studio.

Repeat these steps for all the three data files in the attachment:

  1. Launch the software and establish a connection to the target Vantage system.
  2. Navigate to the database where you want to create the three tables that are used to store the CSV data.
  3. Click the database name to expand the list of objects in it.
  4. Right click Tables in the desired target database and select Teradata > Data Transfer.
  5. In the Data Transfer Wizard window,
    • a. Use the "External File" source option that uses the Smart Load utility;

      b. Click the "Launch" button.

  6. In the Import Data window:
    • Ensure the "Column Labels in First Row" button is checked.
    • Specify "Comma" under File Options > Column Delimiter.
    • Specify "None" under File Options > Character String Delimite.
    • Specify "Windows OS" under File Options > Line Separator. Or choose the operating system you have.
    • Click "Finish" button at the bottom.
  7. The Table Column Data Types window displays a sample of the data and their interpreted types in the manner Teradata Studio plans to import them into the database. Use the information in the attached "Table DDL details for the data" file to make any changes as needed in this window.
  8. The SQL Preview window displays a preview of the table DDL based on your preceding input. Ensure this preview matches the specifications provided in the attached "Table DDL details for the data" file.
  9. Click "Finish".
  10. The data upload begins automatically. Wait until the upload is complete.
  11. After the upload, verify in Teradata Studio that the tables are present in the desired destination locations.