Uploading Data Files using Teradata Studio - 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
Published
December 2020
Language
English (United States)
Last Update
2023-06-28
dita:mapPath
rdw1604689631129.ditamap
dita:ditavalPath
hod1606861214058.ditaval
dita:id
B700-4040

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.