Basic Understanding at
https://blogs.oracle.com/datamining/introducing-oracle-machine-learning-sql-notebooks-for-the-oracle-autonomous-data-warehouse-cloud
Details: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/part-using.html#GUID-F9B1D121-5D89-40B4-90C6-8E8E233C2B3F
Troubleshooting:
How to login to a given Schema in notebook
Schema/User need to be given following GRANTS/ROLES to be able to access notebook.
GRANT DWROLE to;
GRANT OML_DEVELOPER to;
These Roles can be given by ADMIN user. ADMIN user should connect using SQL Developer or from other client source. (ADMIN user cant run SQL from notebook)
I use a compute machine in the same OCI compartment, then create a connection to ADW.
https://blogs.oracle.com/datamining/introducing-oracle-machine-learning-sql-notebooks-for-the-oracle-autonomous-data-warehouse-cloud
Details: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/part-using.html#GUID-F9B1D121-5D89-40B4-90C6-8E8E233C2B3F
Troubleshooting:
How to login to a given Schema in notebook
Schema/User need to be given following GRANTS/ROLES to be able to access notebook.
GRANT DWROLE to
GRANT OML_DEVELOPER to
These Roles can be given by ADMIN user. ADMIN user should connect using SQL Developer or from other client source. (ADMIN user cant run SQL from notebook)
I use a compute machine in the same OCI compartment, then create a connection to ADW.
No comments:
Post a Comment