Vantage Modules for Jupyter v2.01
About this download

Visit the landing page for more information including sample notebooks, video clips and more ... https://teradata.github.io/jupyterextensions

Join the community discussion at community.teradata.com - Ecosystem Management Forum, topic: Jupyter

Vantage Modules for Jupyter

Vantage Modules for Jupyter provide extensions to the JupyterLab platform to enhance the user experience connecting and executing SQL statements on Teradata Vantage. These extensions include the Teradata SQL Kernel and Navigator.

In addition, in the Docker image, we have bundled the Teradata Python driver and teradataml library as well as the Teradata R driver a tdplyr library. The teradataml and tdplyr libraries contain the analytic functions that interact with the Vantage Machine Learning Engine (MLE) in the Python and R languages respectively.

The SQL Kernel Provides:

  • 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 easy to read, scrollable grid
  • Execution history that stores execution metadata to recall SQL commands at a later time
  • Visualization using Vega library to display charts, graphs, plots, etc.
  • Support for basic data load from a file
  • Preference settings allow users to modify logging options for the SQL kernel
  • Magic commands that provide additional custom kernel options to enhance Teradata user experience

The Navigator Provides:

  • The ability to explore the Advanced SQL Engine catalog, regardless of the language you are using in your notebook (SQL, Python, R).
  • Hierarchical display of SQL object relational model
  • Column metadata showing data type and indexes
  • Row Count, Show DDL and Column Distribution menu options

The Connection Manager Provides:

  • Connection management to add, remove, edit, copy, list, and test connections
  • User interface that is independent of the SQL notebook
  • Connections that are shared with the Navigator and SQL notebooks