ISB-CGC BigQuery Table Search Release Notes

To learn about this discovery tool created by the ISB-CGC, please visit ISB-CGC BigQuery Table Search.

For more detailed information about the data stored in ISB-CGC BigQuery tables please visit ISB-CGC BigQuery Tables.

June 13, 2024 v2.0

  • The ISB BigQuery Table Search now has a separate URL (https://bq-search.isb-cgc.org/) from the ISB-CGC webpage (https://isb-cgc.org/)

  • Each search filter and its selected value is saved as a parameter in the ISB BigQuery Table Search URL. This URL can be saved and then used again.

  • The previous link to the ISB BigQuery Table Search is being redirected to the new URL.

  • Search results are available through API calls.

  • The Access filter has been removed.

September 8, 2021 v1.05

New Features

On the Search results, added an “Example Joins” column. This column specifies the number of example join queries, for the table on that row, which are provided by the BigQuery Table Search.

Functionality includes:

  • Click the number in the “Example Joins” column to see a list of examples.

  • From there, click on View Details for a particular example to see the SQL Query and a longer description.

  • On the View Details screen, click on COPY to copy the query to your clipboard.

December 8, 2020 v1.04

New Features

  • On the Filter panel, under Show More Filters, a filter BQ Project has been added. It has also been added to the Column selection dropdown list.

Bug Fixes

  • On multi-select filters (Program, Source, Data Type, Experimental Strategy), the X button to delete the selected value did not completely display. It has been fixed so that the entire X button displays.

July 23, 2020 v1.03

New Features

  • The Access filter has been added, which has options of All, Open Access and Controlled Access. Controlled Access data cannot be previewed, but can be opened in the Google BigQuery Console, if the user has the required permissions.

March 11, 2020 v1.02

New Features

  • Users now have the ability to access, query and inspect in detail BigQuery tables in Google Cloud Platform’s BigQuery console directly from the Table Search UI. Every table has a “Open” option which when clicked will send the user to the table in the BigQuery console on the Google Cloud.

  • An Open button, with the same functionality as described above, has been added to the Schema Description section.

  • Program and Experimental Strategy filters were added.

  • Values for the Data Type and Source filters have been modified in order to align more closely with GDC naming conventions.

January 30,2020 v1.01

New Features

  • A “Name” column consisting of user-friendly descriptive names for the BigQuery tables has been introduced.

  • The Name filter, a free-form text search field is now available allowing users to search for all or a portion of the user-friendly descriptive names.

  • Columns can be now added or removed from the display by using the Columns selector option.

  • By default, Dataset ID and Table ID are no longer initially displayed in the full column view, but can be added to the display using the columns selector.

  • The Full ID, which is denoted [projectID.datasetID.TableID] (concatenation of the project ID, dataset ID and the Table ID, each separated by a period symbol) is listed under the detailed table information section found after clicking on the blue plus sign.

  • A Copy button, found adjacent to the Full ID has been added. The Full ID adheres to BigQuery Standard SQL format and contains the necessary grave accents (`) required for executing SQL queries in BigQuery. When copied to the clipboard, the Full ID can be directly used to run queries in BigQuery Query Editor without any further manual modifications.

Enhancements

  • Individual table schemas captured by the “Fields” column in the CSV download now contain field information in comma-separated format.

November 26, 2019 v1.0

Initial Release

The ISB-CGC BigQuery Table Search UI is a discovery tool that allows users to explore and search for ISB-CGC hosted BigQuery tables. It can be accessed directly from the ISB-CGC homepage.

Major features in the initial release include:

  • The ability to search for BigQuery tables by multiple filters:

  • Status

  • Categories

  • Reference Genome Build

  • Source

  • Data Type

  • Dataset ID

  • Table ID

  • Table Description

  • Labels

  • Field Name

  • Display of search results in a tabular format, with the following information about BigQuery tables:

  • Dataset ID

  • Table ID

  • Status

  • Source

  • Data Type

  • Num Rows

  • Created Date

  • Detailed schema information for each table, including full table ID, table description, and field descriptions.

  • The ability to preview the first eight rows in the BigQuery table of choice.

  • The ability to download a CSV format file of search results.


Have feedback or corrections? Please email us at feedback@isb-cgc.org. Follow us on BlueSky and X!