1. Using Oracle Machine Learning on Autonomous Database
  2. Get Started with Notebooks for Data Analysis and Data Visualization
  3. About Interpreter Bindings and Notebooks
  4. Verify Interpreter Bindings

Verify Interpreter Bindings

After setting and changing the order of interpreter bindings, you can verify the interpreter bindings whether you are using SQL or Python interpreter or both in a given notebook. You use a SQL statement to view and verify the interpreter binding information about your notebook.

For Python notebooks, the interpreter binding is used for all python paragraphs.

Note:

For Python notebooks, do not override the interpreter binding at the paragraph level.
To verify the interpreter binding of notebooks:
  1. Open the notebook for which you want to check the interpreter binding.
  2. Run the following SQL statement:
    %sql
SELECT SYS_CONTEXT ('USERENV', 'SERVICE_NAME') FROM DUAL;

    The SQL statement provides the name of the service to which a given session is connected.

  3. Click Run.
    The SQL statement returns the information about the interpreter, the order of the binding, and the service name. The result is displayed in the following format tenantname__databasename_ servicename.domain. Here:
    • HDY7RUSKGDMPHN2 is the tenant name
    • PDB1 is the database name
    • low is the interpreter binding order
    • adwc.oraclecloud.com is the domain name
    Interpreter binding validation

Parent topic: About Interpreter Bindings and Notebooks