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 list.
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=tdPassword)
# Create a table and load our country names, codes, and geometries.
with con.cursor () as cur:
cur.execute ("create table stg_countries_map (country_nm VARCHAR(32), ISO_A3_cd VARCHAR(32), boundaries_geo CLOB CHARACTER SET UNICODE);")
r=cur.execute ("insert into stg_countries_map (?, ?, ?)", [(f['properties']['ADMIN'], f['properties']['ISO_A3'], str(f['geometry'])) for f in countries_json['features']])