copy_to_sql and to_sql Functions Limitations

Teradata® Python Package User Guide

brand
Teradata Vantage
prodname
Teradata Python Package
vrm_release
16.20
category
User Guide
featnum
B700-4006-098K

UTF-8 and Unicode support

UTF-8 and Unicode characters are not supported by the copy_to_sql function.

To work around this limitation, convert UTF-8 and Unicode characters to ASCII and then push the data into the teradataml DataFrame.

Using schema_name parameter to save to non-default databases

The copy_to_sql and to_sql functions support saving teradataml or pandas DataFrames to either the default database of the user or valid databases that are directly created by the current user (the creation activity also grants the user write permissions).

Using the schema_name parameter to save to a databases that is not created by the user who has been granted write permissions, or to a non-default-database is not supported.