See the types of transactions available for use with Spanner queries. Look at the API to understand how to use these transactions type in your client API SQL queries.
- [Narrator] I'll take a minute to just call out…transactional control in Spanner.…Transactions can be read-write or read-only.…As developers, you can define the scope of a transaction…in your code, kind of like an explicit transaction.…There is a read-only API.…It's kind of like a NOLOCK for read in SQL server…or SQL kind of databases,…and I'm gonna take you over…and show you the code examples, as well.…So on our same Getting Started Python code sample…that we were working with earlier…to insert data and to do queries with an index hint.…
There's a really great section for transactions…that encourage you to work through using the patterns…that we started with.…So we've got some samples for read-only transactions,…and you can see, the key line of code here is…results equals snapshot.execute.sql.…So that's gonna give you snapshotting capability.…Transactions in Spanner, like with any RDBMS,…are an advanced topic.…So, again, I recommend that you consult the documentation,…and also because this is a beta product,…
- 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.