Skip to main content

Vantage Modules for Jupyter

Details


Note: If you are using the source extensions (not prebuilt) you must upgrade to node 20

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

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

Note: The docker image is also available on Docker Hub  https://hub.docker.com/r/teradata/jupyterlab-extensions

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, Navigator and Connection Manager.

In addition, in the Docker image, we have bundled the Teradata driver for Python and teradataml library as well as the Teradata driver for R and tdplyr library. The teradataml and tdplyr libraries contain the analytic functions that interact with Vantage 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, Refresh, Sample Data, Profiling Information 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

 

 

Not available
OS version
03.04.02.00
Release version

Technical Details

  • Version
  • Released
  • TTU
  • OS
  • Teradata

Vantage Modules for Jupyter