Query Tables for NetSuite Analytics Warehouse 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_NS_ACCOUNT_D