We wanted to share a python tool we've developed recently which provides a cli to teradata bteq and other utilities to allow:
* easy execution of scripts/SQL queries from the command line
* download to csv (and binary) format without third-party conversion tools
* upload from csv (and binary) format without third-party conversion tools
The full package and more details are available at the following site https://github.com/xlfe/dwhwrapper
Requires: python 2.6, Teradata linux_cliv2, Teradata BTEQ
Optional: Teradata fastexp, fastld and mload
Tested using Teradata utilities version 13
I'll love to take a look. I'm doing some things at the moment with Teradata and Python, but using pyodbc to connect.
Any plans for a windows version ? I've started to modify the code but I stopped at the type_mappings ; not my area of expertise I'm afraid. I'll have another go at it later.