Python Forum
write csv data into teradata table
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
write csv data into teradata table
#1
Hi All,
I am writing csv data into Teradata table:
Using below code .. and getting error..

import csv
with open(r"C:\Users\sandy\Desktop\venmo_output1.CSV",'r')as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        #print(row['TRAN_STMT_DESC'],row['Sum(tran_amt)'], row['Sum(tran_cnt)'])
        curs.execute(""""INSERT INTO PYTHON_LKP(TRAN_STMT_DESC,tran_amt, tran_cnt )VALUES(?,?,?)""",row)
here goes my error:
Error:
ProgrammingError: ('42000', '[42000] [Teradata][ODBC Teradata Driver][Teradata Database] String not terminated before end of text. (-3760) (SQLPrepare)')
My csv file generated from python using to_csv function.
data is like this in csv file :
Output:
TRAN_STMT_DESC tran_amt tran_cnt VENMO 100 1 VENMO 30 1 VENMO 8 1
please can any one help me on this

thanks
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Using pyodbc&pandas to load a Table data to df tester_V 3 748 Sep-09-2023, 08:55 PM
Last Post: tester_V
  write json into a table herobpv 4 1,424 Jan-22-2023, 04:36 AM
Last Post: herobpv
  Write sql data or CSV Data into parquet file mg24 2 2,356 Sep-26-2022, 08:21 AM
Last Post: ibreeden
  Is this possible to write a script for checking data from website? WanW 2 1,081 Jun-02-2022, 02:31 AM
Last Post: Larz60+
  Write and read back data Aggie64 6 1,812 Apr-18-2022, 03:23 PM
Last Post: bowlofred
  panda table data kucingkembar 0 1,074 Mar-01-2022, 10:38 PM
Last Post: kucingkembar
  Sorting table data Blacktime2 1 1,292 Feb-26-2022, 07:05 PM
Last Post: ibreeden
  Strategy on updating edits back to data table and object variables hammer 0 1,164 Dec-11-2021, 02:58 PM
Last Post: hammer
  SQLALCHEMY - Not selecting data from table jamesaarr 4 2,178 Nov-02-2021, 03:02 PM
Last Post: Larz60+
  SaltStack: MySQL returner save less data into Database table columns xtc14 2 2,115 Jul-02-2021, 02:19 PM
Last Post: xtc14

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020