738 questions
Best practices
0
votes
4
replies
51
views
Dynamic field search in Spanner DB
We're building a SaaS platform for which we need to design a data model which could accompany domain specific data. We don't know the structure of domain specific data. So these are the evaluated ...
- 323
-3
votes
1
answer
65
views
Why are there no records read from spanner change stream?
I'm trying to write a Python GCP dataflow that processes records from a Spanner change stream and prints them out. I am running it locally and it appears to work but prints no records when I update a ...
- 525
1
vote
1
answer
65
views
Cloud Spanner doesn't enforce referential integrity between parent and child, What does this mean?
INTERLEAVE IN child tables share the same physical row interleaving characteristics, but Spanner doesn't enforce referential integrity between parent and child.
What is meant by this? Because I'm ...
- 13
0
votes
2
answers
78
views
Cloud build error in liquibase step to enable spanner API
I have setup a GCP project for build activities that support multiple GCP projects deployments, this way I have one place to manage the CI/CD and in this project no other resources APIs like spanner ...
- 85
0
votes
1
answer
81
views
GCP Spanner Insert error- Row [4503837324345344] in Table was already inserted in this transaction
I am trying to insert data into a spanner table using its python client library. The table's DDL is
CREATE TABLE MyTable (
Id INT64,
name STRING(MAX),
curr_timestamp TIMESTAMP NOT NULL OPTIONS (...
- 831
0
votes
1
answer
63
views
Arrow Flight SQL with Google Spanner
I found out there is a possibility to connect Arrow Flight SQL connector to Postgres database, and I know there is a possibility to configure Spanner database to act like a Postgres one, so is it ...
0
votes
0
answers
209
views
Spanner error while updating data into a JSON column
I am working with the GCP Spanner database using the sqlalchemy ORM. This is the table schema where I am trying to insert/update (based on a check) data into a JSON column:
from sqlalchemy import ...
0
votes
0
answers
43
views
MyBatis With Cloud Spanner -- Is Selecting A Collection of Inner POJOs w/Single Parent Key From Single Table Possible?
Looking at the MyBatis docs for building entities which themselves contain lists of other entities, the following SHOULD work unless I'm misunderstanding (completely possible), but it results in ...
0
votes
2
answers
171
views
Google Cloud Spanner Graph Joins
I have 2 tables (InterestCategory and Interest) and a graph (TestGraph) in my Google Cloud Spanner database
CREATE TABLE InterestCategory
(
interest_category_id STRING(36) NOT NULL,
...
- 1,780
0
votes
0
answers
62
views
Convert OffsetDateTime to com.google.cloud.Timestamp for GCP Spanner TIMESTAMP
I am using Java 21 Spring Boot 3.4.2 and SpannerTemplate. I need to convert a field OffsetDateTime to the com.google.cloud.Timestamp for the TIMESTAMP column in the database.
I tried implementing ...
- 448
0
votes
1
answer
147
views
Should we retry a query if spanner returns ResourceExhausted error?
Recently I have seen the following error in my logs using the method ReadWriteTransaction from the spanner library:
*status.Error: rpc error: code = ResourceExhausted desc = Failing fast as CPU ...
- 329
0
votes
0
answers
71
views
Can I do Entity Resolution at scale with Google Spanner using Multiple Embeddings and Vector Indexes to Merge Company Data from Multiple Providers?
I'm working on merging company data from 3 or more different providers. I'm exploring an entity resolution approach using separate embeddings for name, location, and domain, stored in vector indexes. ...
0
votes
1
answer
279
views
How to create temporary tables in Spanner
Is there any way to create a temporary table in Google Cloud Spanner through:
SELECT * INTO <temp table> FROM <table name>
where I can then use the temp table with multiple other queries ...
- 1,780
0
votes
1
answer
88
views
Persisting Data in spanner with JPA and Hibernate 6
I am working on integrating spanner with our existing application. I'm facing an error when trying to save/persist data into DemoClass entity in spanner using JPA and hibernate 6. The error I'm facing ...
- 1
1
vote
0
answers
55
views
Best POM for Google Spanner and Dataflow
I've been getting bizarre ClassNotFound errors in this io.grpc library, strange timeout errors, etc. Plus I saw on an old document there's a need to enforce the minimum version. I've tried building a ...
- 1,199