The Autonomous REST Composer includes a SQL Editor that allows you to view your model and test it by executing SQL queries.

After you have configured one or more endpoints, you can take the following steps to view your schema and execute queries against it.

  1. From the Autonomous REST Composer, open the SQL Editor by using one of the following methods:
    • Select the SQL Editor tab from the side menu.
    • Click Test Connect on any of the tabs.

    SQL Editor window for the Autonomous REST Composer

  2. To view tables and objects in your schemas, expand the schema you want to view from the Schema Tree pane.
  3. To view the details of a table or object, select the table or object from the Schema Tree. Details such as column names and data types appear in the Table Details pane.
  4. To query your Model, enter a SQL query in the Editor pane and then click EXECUTE to run the query.
    Note: You can double-click on table names to quickly add a basic SELECT statement to the Editor pane.
    The results of the query are displayed in the Results section along with the status of the query execution. The maximum number of rows displayed per query is 200.
  5. Optionally, you can review the status of your endpoints by querying the INFORMATION_SCHEMA.SYSTEM_SAMPLING_STATUS system table. For example: 
    SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SAMPLING_STATUS

    This will allow you to verify that your endpoints have been successfully sampled by the driver and diagnose any issues, should they occur.