Search index: Google Spanner Search

Google Spanner Search is the built-in integration providing full-text search for Google Spanner.

It leverages the full-text search capabilities provided by Google Spanner.

Usage

Search is only supported on nodes, and on properties that correspond to a STRING column.

In Google Spanner, for each SQL table that corresponds to a searchable node label:

• Create a TOKENLIST column for each searchable column, using the TOKENIZE_FULLTEXT function. Here is an example of how to create a tokenized property:

  CREATE TABLE Album (
  id STRING(MAX) NOT NULL,
  title STRING(MAX),
  title_tokens TOKENLIST AS (TOKENIZE_FULLTEXT(title)) HIDDEN
  ) PRIMARY KEY(id);
  

• Create a single SEARCH INDEX for the table, containing all the TOKENLIST columns. Here is an example of how to create a search index:

  CREATE SEARCH INDEX AlbumIndex
  ON Album(title_tokens);
  

• And this it it. Linkurious Enterprise will automatically find the created search indexes, there is no need for additional configuration.