Oracle ADW creating a ML user

Oracle Autonomous Data Warehouse has a number of features that make it a collaborative environment. No more silo’s or hiding your code in a cupboard, only to be lost or disregarded because it has too much dust on it!

One of those features is the ML Notebook. In this blog post we’ll show you how to create a ML user and perform some basic commands, in later blogs we’ll show you how to create machine learning models within the notebooks. 

Creating the User

Log into Oracle cloud environment

 Under the administration dashboard, select "Administration"

Left click on "Manage Oracle ML User"

In the following screen create a users name and email address to be used by the associated ML user. There is an option to create a password for the user, or have the system email the user and they can create their own password.

Once the user has received the email and logged in they will be presented with the ML home screen. Here the user can create new notebooks, schedule SQL queries or try some of the examples.

Left clicking on the "Notebook" enables the user to explore notebooks they have already created as well as creating new notebooks.

When you select new notebook, give the notebook a name and any comments about the notebook. 

You'll then be in the notebook. The Zeppelin notebook enables you to run SQL queries as well as document notes alongside the SQL. The notes are captured using the Markdown language.