copy_to API When Loading Data into PTI Table | Teradata Python Package - copy_to API When Loading Data into PTI Table - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Publication Date
February 2025
Publication ID
B700-4600-004K
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
ft:sourceId
dita
dita:id
tcl1683670667798
When the copy_to API fails with the Database error message “4358 Time Series: TD_TIMECODE| TD_SEQNO out of range for table”, you must check the permitted TD_TIMECODE and TD_SEQNO range using the following:
con = get_connection().connection
cur = con.cursor()
td_cur = cur.execute(“exec DBC.TD_TIMESERIES_RANGE('MyDB.table_name')”)
td_cur.fetchall()
Where:
  • MyDB is the schema name
  • table_name is the name of the table to be created
And correct the data or the arguments like "seq.max" to suit the data.
When the data insertion fails, the table is already created.

If a table is to be created with the same table name after the error is handled, the existing table must be dropped using the argument "if_exists = replace".