Google Cloud Platform for Architects

Interleaving tables in Cloud Spanner

Interleaving means creating a parent child relationship between two tables. This is done by sharing primary and/or secondary keys. The child table inherits parent's keys:

1. To do so, while creating another table, select the Interleave in another table option. This option will be available if you have created at least one table in the same database before. You also need to specify which table you want as the Parent table. Here, you can select to delete child rows with the same primary key as the parent's row. The table_2 is about whether all of the accounts have credit cards allotted to them or not, so the fields in the credit card column are Boolean.

2. Once you have created the table and added data in ...