Modify this code as needed with your Teradata host name, user name and specify an advanced login mechanism if any (eg. LDAP, Kerberos...) with the logmech parameter if you need to. All the connection parameters are documented on the teradatasql PyPi page there: https://pypi.org/project/teradatasql/
The code below simply creates a Teradata connection, and opens a cursor creating a table and loading it with our file.
import teradatasql
import getpass
tdhost='<Your-Teradata-System-HostName-Here>'
tdUser='<Your-Teradata-User-Name-Here>'
# Create a connection to Teradata
con = teradatasql.connect(None, host=tdhost, user=tdUser, password=getpass.getpass())
# Create a table named geojson_src and load the JSON map into it as a single CLOB
with con.cursor () as cur:
cur.execute ("create table geojson_src (geojson_nm VARCHAR(32), geojson_clob CLOB CHARACTER SET UNICODE);")
r=cur.execute ("insert into geojson_src (?, ?)", ['cities',jmap])