We can use Teradata SQL Assistant to load data from file into table in Teradata. Create pandas data frame. Import data into Teradata SQL Assistant. First, create a table in your database to which you want to import the data. Remove the header rows from the Excel file and Save the file as comma delimited file from Excel (CSV File). We can import a CSV file into the Teradata SQL Assistant with the help of the import function. Then, I turn on IMPORT DATA and run the INSERT INTO cdwhist process. Another approach is to use sqlalchemy connection and then use pandas.DataFrame.to_sql function to save the result. My task is run in three operations. The Volatile tables in Teradata are created by the user and used only the duration they are logged into and dropped automatically by Teradata Manager once the user disconnects from the session. IMPORT via TERADATA SQL Assistant is not preferable if data is too huge in terms of records counts or row length. It is the second step that’s failing. Make sure you have the columns in Excel in the same order as the table you created. Turn off the Import Data mode and resume querying. Importing Excel Data into Teradata Table 1. It allows you to very quickly create a table from the values in another table without having to bother using a CREATE TABLE statement or specifying the data types of the fields. 2. From Teradata SQL Assistant, click ‘File’, then ‘Import Data’. Go to tools option and change the data format to "yyyy-mm-dd" format. no of columns on the table should be equal to ?now press f5, it will ask for the source, jus browse and select the source and you can load the data in to the table using SQL assistant. You will find delimiter in menu tools options import/export. Click on File and Select Import Data,Now writeinsert into table.namevalues(?, ?, ?, ?) In SQL Assistant set the Delimiter as ","(comma) . Posted in Import/Export Teradata | No Comments » Top 10 Most Powerful Functions for PROC SQL … First, the table definition is created using CREATE MULTISET VOLATILE TABLE cdwhist. The example below would create a new table called active_employees based on entries in the employee table that have the active_flg set to 'Y'. 11. Sample data. The result can be queried directly using Teradata SQL Assistant: Approach 2 - sqlalchemy. Importing Data from FLAT FILE to TABLE using TERADATA SQL ASSISTANT is very simple.It is very easy to import data from any flat file to table in TERADATA using TERADATA SQL Assistant. Now in SQL set the delimiter as comma ",". Finally, the last step utilizes the cdwhist volatile table and joins it with a table on the database. With this approach, we don't need to create the table in advance. Next, make sure you have the columns in Excel in the same order as the table you created. Write the below SQL statement in the query window and execute it. The columns in Excel should be in same order as that in Teradata table. Remove the header rows from the Excel file and save as a Text (Tab Delimited) file. I have the following sample table (DPT) and am trying to insert the values into the created volatile table except for "Budget_Last_Yr" column using Teradata SQL Assistance. The query syntax should be based on the data of your file. Dropping here means, dropping both the definition and data inserted into the volatile table. You then need to remove the header row from the table as save the file as comma delimited file in excel.