Google launched Search Indexes

You can now create a Search Index on Columns containing INT64 or TIMESTAMP

Photo by Alexandre TOPOLEWSKI on Unsplash

Google just announced the general availability of search indexes on columns containing INT64 or TIMESTAMP data and BigQuery which can optimize predicates that use those columns[1].

With this new functionality you can save time and money when querying data. A BigQuery search index is a data structure designed to enable very efficient search with the SEARCH function. A search index can also optimize some queries that use supported functions and operators[2].

Google launches Data Preparation powered by Gemini for BigQuery

With the following SQL statement blue print you can create such a search index:

CREATE TABLE my_dataset.my_table(a STRING, b INT64);

CREATE SEARCH INDEX my_index
ON my_dataset.my_table(ALL COLUMNS);

Search indexes are fully managed by BigQuery and automatically refreshed when the table changes. The following schema changes to the table can trigger a full refresh:

• A new indexable column is added to a table with a search index on…