See how to create a set of parent-child tables using the interleave keyword in SQL DDL code.
- [Instructor] So now we're going to go back…and work with interleave tables.…So we're going to go into our test instance,…and we have our example db,…it has one junk table.…And what we want to do is go to the level…of the database,…and we want to create a table.…So now let's call this more junk,…not great names,…and notice we have this interleave,…speeds up queries that require data,…so that's interleave it.…And junk has been defined as a parent,…so this is our parent.…
And then we can say,…delete parent child rows together.…Okay and then click continue.…Notice we get the parent id,…it's inherited.…And now we're going to call this more junk id,…and say done.…And then we'll just have some name or some other…attribute on here,…that we want.…And we'll say done.…And we'll say continue.…And then notice the primary key set automatically…to a composite,…because this is required for interleaving.…
So again it's very similar to primary key foreign key,…from more standard relational database implementations,…just kind of different words.…
- What is Cloud Spanner?
- Creating an instance and database using the console
- Making hot schema updates
- Cloud Spanner queries
- Loading data into Cloud Spanner
- Understanding transactions
- Cloud Spanner DevOps tools
- Auditing logs with Stackdriver
- Cost optimization
Skill Level Intermediate
Google Cloud Storage and Data Essential Trainingwith Joseph Lowery2h 54m Intermediate
Google Cloud Platform Essential Trainingwith Lynn Langit3h 56m Intermediate
1. Why Cloud Spanner?
2. Cloud Spanner Basics
3. Cloud Spanner Queries
4. Cloud Spanner DevOps
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.