--- title: "Advanced Search" slug: "advanced-search" updated: 2026-08-10T14:52:25Z published: 2026-08-10T14:52:25Z canonical: "docs.databee.buzz/advanced-search" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.databee.buzz/llms.txt > Use this file to discover all available pages before exploring further. # Advanced Search The **Advanced Search** feature allows you to write and run SQL queries to explore data efficiently. It is designed for read-only data analysis, with tools that help you build, manage, and reuse queries while understanding the underlying database structure. Navigate to the **Search** page and select **Advanced Search**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/advanced_search(1).png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) On the “Advanced Search” page, you can create worksheets, explore databases, write SQL queries, run them, and download the results. Queries must be written in your data lake’s SQL dialect to execute properly. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/advanced_search_page.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) ## Database Explorer The **Database Explorer** helps you understand the data structure in your data lake before writing queries. Navigate through Schemas, Tables, and Columns. For each column, you can view the Data type (for example, `number`, `text`, `array`, `variant`)and whether the column is a primary key. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/database_explorer(1).png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) The Database Explorer loads in two stages. Schemas and their table and view names appear first, then the column details for each schema load in the background. > [!NOTE] > **Note:** > > While the columns are still loading, the resync icon at the top of the Database Explorer shows a spinner and its tooltip reads “Loading columns…”. During that time, column search and column auto-complete in the SQL editor are unavailable. Both become available as soon as the background load finishes — you do not need to reload the page. From the **three‑dot (⋮) menu** next to a table, you can: ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/3dot_menu.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) - **View Definition**: Click the View Definition option to view the SQL definition of the selected view. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/view_definition_1.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) If the view is built from other views, you can click the **blue underlined view names** in the `FROM` and `JOIN` clauses to navigate to their definitions. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/view_definition_2.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) Use the **Back** and **Forward arrows** at the top of the dialog to move through your navigation history. You can also click the **Copy** icon to copy the displayed SQL definition to your clipboard. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/view_definition_3.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) > [!NOTE] > **Note:** > > Only view names that are available in the Database Explorer (that is, views you have permission to access) are displayed as clickable links. - **View Sample Data**: Displays a sample of records from the selected table to help you understand the data. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/view_sample_data.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) - **Copy Table Name**: Copies the fully qualified table name to your clipboard for use in SQL queries. - **Generate SELECT Statement**: Automatically generate a basic `SELECT` query for the table. ## Worksheets Worksheets help you organize and manage multiple queries within Advanced Search. ### Create and Manage Worksheets - **Add a new worksheet**: Select **+** to create a new worksheet. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/add_new_worksheet.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) - **Rename or delete a worksheet**: ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/edit_delete_worksheets.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) Closing a worksheet only removes it from the current view and tabs. The worksheet still exists and can be re‑opened at any time from the sidebar. - From the **worksheet tab**, select the **three‑dot (⋮) menu**, then choose **Rename** or **Delete Worksheet**. - From within an open worksheet, select the **three‑dot (⋮) menu** to rename or delete it. > [!WARNING] > **Warning:** > > SQL Query Limitations: Only read-only SQL operations are supported. Data modification operations such as INSERT, UPDATE, DELETE, or DROP are not allowed. ## Type‑Ahead Assistance As you type a query, Advanced Search provides **real‑time suggestions**, including SQL functions, table names, column names, and keywords. This helps reduce errors and speeds up query creation. ## Running Queries and Viewing Results Choose a schema from the **Schema** drop-down to select the database schema you want to query. Enter your SQL query in the editor, then click **Run** to execute it. Queries use the worksheet’s selected schema unless you qualify the table in the query, for example `ocsf.device`. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/query_run(1).png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) Scroll down to view the results displayed in a tabular format. If the result set is large, use the pagination controls to navigate through multiple pages. You can **Download** the query results in **CSV** or **JSON** format. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/query_result.png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) ## Code Versions (Query History) The **Code Versions** feature lets you reuse previous queries. - **Copy to Clipboard**: Copy the loaded query directly to the clipboard for reuse or modification. - **Load Query**: Load a previously executed query from history. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/code_versions(1).png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D) This is useful for auditing past queries or building new ones based on earlier work. ## More Actions Use **More Actions** to quickly work with your SQL queries: - **Format Query**: Automatically formats SQL for better readability. - **Copy Query**: Copies the current query to the clipboard. - **Load from File**: Upload a saved SQL file into the editor. - **Save to File**: Download the current query as a file. - **SQL Syntax Reference**: Opens the SQL syntax reference for guidance on supported syntax and functions for your configured data lake. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/more_actions(1).png?sv=2026-02-06&spr=https&st=2026-11-04T10%3A34%3A15Z&se=2026-11-04T11%3A34%3A15Z&sr=c&sp=r&sig=GHHpn352V3oYFdR5pG9hxlL%2BexCenyrBlT07UItQUkQ%3D)