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.

  • teradatasql driver installed in your system:

    pip install teradatasql

    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.
Did this page help?