Query SQL in Workbench

Use Workbench notebooks for governed SQL exploration when your organization has configured notebook SQL access. Depending on configuration, you can use SQL cells or SQL in Python through Spark. Exact catalog names, schema names, table names, and data reference steps can vary.

To query data in Workbench:

1. Sign in to Workbench and then select the correct Life Sciences AI Data Platform (LSAIDP) workspace in the left navigation panel.
2. Select Master Catalog in the workspace, then locate the authorized Real-World Data (RWD) asset and review the metadata.
3. Select Create, then select Notebook to create a notebook in the workspace, or select the notebook you want to open the notebook.
4. Select or attach an approved compute cluster if required by selecting Actions, then Attach an existing cluster. For more information about clusters, see AIDP Workbench Notebooks.
5. You can reference the cataloged RWD asset from the notebook using the options provided by Workbench.
6. Create a SQL cell, or a Python cell that runs SQL through Spark, by selecting the type from the drop-down menu in your notebook cell.
7. Start with a query that selects only the required columns and limits returned rows.
8. Save your work in the workspace and create reusable outputs. Reusable outputs can be saved in the following formats:
   • Approved managed tables
   • External tables
   • Managed volumes
   • Autonomous Data Warehouse (ADW) tables
   • Object Storage files
   • Other configured destinations