Compose a DB Query

You can query an existing data store using the query composer on Workbench. If you don’t have an existing data store, you can create one from the Explore page.

You can run these commands without bringing up a cluster. See Mapping of Cluster and Command Types for more information.

Perform the following steps to query an existing data store:

  1. Navigate to Workbench and click + New Collection.

  2. Select DB Query from the command type drop-down list.

  3. From the Select a Data Store drop-down list, select the data store to which the query is to be applied.

  4. Query Statement is selected by default from the drop-down list (upper-right corner of the screen). Enter your DB query in the text field.

    or

    To run a stored query, select Query Path, then specify the cloud storage path that contains the DB query file.

  5. Add macro details (as needed).

  6. Click Run to execute the query.

Monitor the progress of your job using the Status and Logs panes. You can toggle between the two using a switch. The Status tab also displays useful debugging information if the query does not succeed. For more information on how to download command results and logs, see Get Results.