• Beta
Query Search
  • 18 Jan 2021
  • 1 Minute To Read
  • Contributors
  • Print
  • Share
  • Dark
    Light

Query Search

  • Print
  • Share
  • Dark
    Light

Browsing to Query History

In the Toolbar, simply select SQL Lab and, in the drop-down menu, select Saved Queries.

2021-01-18_08-52-02.png


Interface

2021-01-18_08-21-47.png


Filtering Options

The Query Search provides a number of different filtering options. Simply complete filters, as needed, and then select SEARCH to view results.

Filtering options include:

Filter by User

Select a username from the drop-down list to show queries created by a specific user.

2021-01-18_08-48-03.png

Filter by Database

Select a database from the drop-down list to show queries that access a specific database.
2021-01-18_08-48-33.png

Query Search String

Enter any keyword to search all queries (e.g., table, column, etc.).

2021-01-18_08-49-00.png

Date Range Filters

Specify a date range of when the query ran — the first drio-down is the starting date and the second drop-down is the ending date.

2021-01-18_08-49-45.png

Status Filter

Select a current query status from the drop-down list.

2021-01-18_08-50-16.png

Column Headers

The query search table includes the following column headers:

  • State: Current status of the query (e.g., running, success, failed, etc.).
  • Time: The date & time stamp of when the query was run.
  • Tab Name: Tab in SQL that the query was Run
  • DB: The database associated with the query.
  • Schema: The schema that tables are located
  • Tables: Tables that the query retrieve data
  • User: The user who created the query.
  • Rows: The number of rows retrieved when the query was run.
  • SQL: The SQL code associated with the query.
  • Actions: Select the icon link to produce a copy of the query in the SQL Editor.
Was This Article Helpful?