Discover Data and Run a Query Workflow (Preview)

Use this workflow to identify the appropriate data source, explore its available tables, and execute a bounded Logical SQL query.

1. Find likely data sources.

   {
     "jsonrpc": "2.0",
     "id": 200,
     "method": "tools/call",
     "params": {
       "name": "oracle_analytics-find_matching_datasources",
       "arguments": {
         "nl_question": "Show revenue by sales channel"
       }
     }
   }

2. Describe the chosen subject area tables.

   {
     "jsonrpc": "2.0",
     "id": 201,
     "method": "tools/call",
     "params": {
       "name": "oracle_analytics-describe_data",
       "arguments": {
         "datamodelName": "Sales History Subject Area",
         "tableNames": ["SALES", "CHANNELS"]
       }
     }
   }

3. Execute a bounded Logical SQL query. (Note that the Logical SQL could be generated by AI.)

   {
     "jsonrpc": "2.0",
     "id": 202,
     "method": "tools/call",
     "params": {
       "name": "oracle_analytics-execute_logical_sql",
       "arguments": {
         "query": "SELECT \"Sales History Subject Area\".\"CHANNELS\".\"CHANNEL_DESC\" AS llm_0, \"Sales History Subject Area\".\"SALES\".\"AMOUNT_SOLD\" AS llm_1 FROM \"Sales History Subject Area\" ORDER BY llm_1 DESC FETCH FIRST 100 ROWS ONLY",
         "maxRows": 100
       }
     }
   }