Teradata Vantage Modules for Jupyter - Teradata Vantage Modules for Jupyter - 1.2

Teradata Vantage™ Modules for Jupyter Installation Guide

prodname
Teradata Vantage Modules for Jupyter
vrm_release
1.2
category
Installation
featnum
B700-4010-049K
Teradata Vantage™ Modules for Jupyter allows users to do the following:
  • Access Vantage in Python, R or SQL from JupyterLab notebooks
  • Explore objects in a Teradata Vantage catalog

The Docker image includes JupyterLab, Teradata Vantage Modules for Jupyter, and other components to run as a Docker container on a client machine. A manual installation allows you to install components on a client machine that already has JupyterLab.

What's Included? Docker Image Installation Manual Installation into JupyterLab
Navigator module
Teradata SQL kernel
Teradata Python Package  
Teradata R Package  
Sample Teradata SQL notebooks
Sample Teradata Python notebooks  
Sample Teradata R notebooks  
JupyterLab and other libraries helpful to data scientists  

Navigator Module

The Teradata SQL extension module includes a navigator module for viewing and browsing objects in Teradata Vantage, regardless of the language you are using in your notebook (Python, R, SQL).

The navigator provides the following:
  • Hierarchical display of database objects
  • Column metadata showing data type and indexes
  • Row Count and Column Distribution menu options

SQL Kernel

The Teradata SQL extension module includes a Teradata SQL kernel. This allows you to run SQL commands on Vantage from a JupyterLab notebook.

The SQL kernel provides the following:
  • Connection management to add, remove, connect, and list connections
  • Query engine that uses embedded Teradata SQL driver
  • SQL-aware notebook with SQL content assist and syntax checking
  • Result set renderer that displays result data in an easy-to-read, pageable grid
  • Execution history that stores execution metadata to recall SQL commands at a later time
  • Visualization using Vega library to display charts, graphs, plots, and more
  • Magic commands that provide additional custom kernel options to enhance your Teradata Vantage user experience
  • Support for basic data import from a .csv file of up to 100k rows

Python

With the Teradata Python Package you can execute Python statements on Vantage from a JupyterLab notebook. For information about using the Teradata Python Package, see the following documents:
  • Teradata Python Package User Guide
  • Teradata Python Package Function Reference
If performing a manual installation, use the procedures in Teradata Python Package User Guide, B700-4006.

R

With the Teradata R Package you can execute R statements on Vantage from a JupyterLab notebook. For information about using the Teradata R Package, see the following documents:
  • Teradata R Package User Guide
  • Teradata R Package Function Reference
If performing a manual installation, use the procedures in Teradata R Package User Guide, B700-4005.

Examples and Tutorials

Sample SQL, Python and R notebooks and additional information about using Teradata Vantage Modules for Jupyter can be found at: https://teradata.github.io/jupyterextensions/.