Connect to Vantage using Python
Overview
This how-to demonstrates how to connect to Vantage using teradatasql Python database driver for Teradata Vantage.
Prerequisites
-
64-bit Python 3.4 or later.
-
teradatasqldriver installed in your system:
teradatasql package runs on Windows, macOS (10.14 Mojave or later) and Linux. For Linux, currently only Linux x86-64 architecture is supported.
- Access to a Teradata Vantage instance. Currently driver is supported for use with Teradata Database 16.10 and later releases.
If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com
Code to send a query
This is a simple Python code to connect to Teradata Vantage using teradatasql. All that is left, is to pass connection and authentication parameters and run a query:
Summary
This how-to demonstrated how to connect to Teradata Vantage using teradatasql Python database driver. It described a sample Python code to send SQL queries to Teradata Vantage using teradatasql.
Further reading
If you have any questions or need further assistance, please visit our community forum where you can get support and interact with other community members.