Save Python data-frame as Table in Teradata
One option is to use fastterdata
, specifically the load_table
function:
load_table(abs_path, df, table_name, env, db, connector = "teradata", clear_table=True)Loads a pandas dataframe from memory into teradata via the optimized fastload functionality.
Note that you need to install requirements listed here.
although I never performed it by my self, but in theory each of following looks promising:
- SQL Alchemy for Teradata (https://downloads.teradata.com/tools/articles/teradata-sqlalchemy-introduction)
- pandas.to_sql (http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_sql.html#pandas.DataFrame.to_sql)
- above fasterdata (please note that fast load don't exist for MacOS)
- write to csv and Teradata Parallel Transporter the easy way with tdload