Query Tables for Fusion Data Intelligence from Autonomous Data Warehouse as OAX_USER

Verify proper configuration of your Autonomous Data Warehouse connection by running a sample query.

  1. Sign in to Database Actions as OAX_USER.
  2. On the Development tab, click the SQL label to open SQL Developer Web. Select All Objects in the Objects dropdown.
    You should see all objects for OAX USER in the Navigator.
  3. Run this query to verify proper configuration:
    select * from DW_CUSTOMER_LOCATION_D