Select an interpreter

Oracle Healthcare Translational Research-Notebook provides you with the option to choose between various interpreters that process data and generate output.

For more information, see:

• Available interpreters
  

Available interpreters

The various interpreters supported in this release are described in the following sections:

• fcc-jdbc
  
• fcc-pyspark
  
• fcc-spark-sql
  
• PGX
  
• PGQL
  
• greenmarl
  
• fcc-ORE
  
• fcc-spark-scala
  
• Markdown
  
• fcc-python
  

fcc-jdbc

Click this icon to create a paragraph with ofsaa jdbc.

The ofsaa-jdbc Interpreter provides the following functions:

• #help - list available custom functions of the interpreter.
• loadGraph (code,graphtag [--optional,date]) - load a graph for a particular date in yyyy-mm-dd format.

  The return type is void and should not be assigned to any variable.

  For example: loadGraph("code","graphtag","date");

• listGraphs() - list all of the available graphs in a tabular form.

  Cannot be used in conjunction with any other code.

  For example: listGraphs()

• getGraphDetails(code) - get graph details in a tabular form.

  Cannot be used in conjunction with any other code.

  For example: getGraphDetails("code")

• listDatasets() - list all available datasets in a tabular form.

  Cannot be used in conjunction with any other code.For example: listDatasets()

fcc-pyspark

Click this icon to create a paragraph with the fcc-pyspark interpreter.

fcc-spark-sql

Click this icon to create a paragraph with the OFSAA SQL interpreter.

PGX

Click this icon to create a paragraph with the PGX interpreter.

PGQL

Click this icon to create a paragraph with the PGQL interpreter.

greenmarl

Click this icon to create a paragraph with the greenmarl interpreter.

fcc-ORE

Click this icon to create a paragraph with the fcc-ORE interpreter.

fcc-spark-scala

Click this icon to create a paragraph with the OFSAA interpreter.

This interpreter provides the following functions:

• loadGraph(code,graphtag [--optional,date]) - load the graph for a particular date in yyyy-mm-dd format.

  Return type is void and should not be assigned to any variable.For example: loadGraph("code","graphtag","date");

• saveGraphAs(graphtag, usertag) - create a snapshot of a graph against a new tab.

  The return type is void and should not be assigned to any variable.For example: saveGraphAs("graphtag","usertag");

• listGraphs() - list all available graphs in a tabular form.

  Cannot be used in conjunction with any other code.For example: listGraphs()

• getGraphDetails(code) - get the graph details in a tabular form.

  Cannot be used in conjunction with any other code.For example: getGraphDetails("code")

• loadDataset(code) - load a particular dataset.

  Returns a DataFrame.For example: var ds = loadDataset("code"))

• loadDataset(code,date) - load dataset for a particular date in yyyy-mm-dd format.

  Returns a DataFrame.For example: var ds = loadDataset("code","startDate","endDate"))

• listDatasets() - list all available datasets in a tabular form.

  Cannot be used in conjunction with any other code.For example: listDatasets()

Markdown

Click this icon to create a paragraph with the Markdown interpreter.

fcc-python

Click this icon to create a paragraph with the fcc-python interpreter.