Skip to main content

a user-friendly and fast Teradata client for Python

Project description

PyPi License

https://raw.githubusercontent.com/capitalone/giraffez/master/docs/logo.png

Giraffez is a client library for Teradata, made to be fast and user-friendly. It shares many features with the official Teradata tools, but makes them available in an easy-to-use command-line interface and Python API.

Features

  • Export from Teradata to a flatfile or archival format, retaining data type information

  • Load into existing Teradata tables using the CLIv2 drivers

  • MultiLoad into existing Teradata tables using the Teradata PT Update (MLOAD)

  • Execute SQL statements using the Teradata CLIv2 library – performing ad hoc queries and commands

  • Interactive shell for executing Teradata queries – much like BTEQ, but with a friendly interface

  • Store your connection information and sets of credentials securely and use them automatically

  • Run job files in YAML format

  • Python API provides a convenient and efficient way to interface with Teradata

  • Archive Teradata tables to save space. These can easily be transformed to flatfiles or loaded back into Teradata

  • Secret Manage encrypted credentials securely using the giraffez secret and giraffez config commands

Quick Install

$ pip install giraffez

See the setup instructions for requirements and details on how to configure your environment.

Contributors

We welcome Your interest in Capital One’s Open Source Projects (the “Project”). Any Contributor to the Project must accept and sign an Agreement indicating agreement to the license terms below. Except for the license granted in this Agreement to Capital One and to recipients of software distributed by Capital One, You reserve all right, title, and interest in and to Your Contributions; this Agreement does not impact Your rights to use Your own Contributions for any other purpose

Sign the Agreement

Code of Conduct

This project adheres to the Open Code of Conduct By participating, you are expected to honor this code.


Teradata is a registered trademark of Teradata Corporation

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

giraffez-1.0.2.dev0.tar.gz (78.6 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page