Will prefixing a random String (like a UUID4) cause hotspotting as the Primary Key?
If I used a randomly generated String which contained a prefix as the only Primary Key, would this cause hotsp...
Databases
Find and share best practices about all things databases, including products like Cloud Spanner, Bigtable, Firestore, and more.
Forum Posts
Which GCP Database Is Best for a Scalable Solo Developer Project?
Hey GCP community! I'm a solo developer working on a dynamic web app and exploring which Google Cloud databa...
Cloud Run can't connect to MySQL after Google Cloud SQL Maintenance
We are seeing a super weird issue regarding MySQL server connectivity from Cloud Run.Our setup is two separate...
Regarding preparing the training Dataset for the Text2SQL
Am building the ChatBot for our Crop Databases. Where we would like to have, users interact with the Databases...
Feature Request: Support for Approximate Quantile Extensions (DataSketches KLL, t-digest) in Cloud S
Hi Google Cloud SQL Team & Community,We are using Cloud SQL for PostgreSQL and rely heavily on its capabilitie...
CloudSQL for MySQL - privilge issue when importing
Hi there!When I am trying to import a .sql file which is stored in GCS , I am getting attached message from co...
Regarding Cross Region Data Transfer in Bigquery
I have migrated data from Firestore to BigQuery, and it's now streaming in real-time into a table named table1...
Error log flooded with "Unable to normalize query"
Hi. My cloud MySQL instance is flooded with identical messages like the one below:2024-03-04T10:18:23.973486Z ...
Migrate from aws opensearch to GCP alternative
Hi Everyone,we are planning to migrate from aws opensearch to gcp alternative , we can't see direct document o...
Firestore '404 Database (default) not found' from GKE Autopilot Despite Correct Config/Permissions/W
Hello Community,I'm encountering a persistent and baffling error trying to access Firestore from a Python Flas...
`google_vacuum_mgmt` Extension Blocking PostgreSQL Migration to Azure
Hi team,We’re attempting to migrate our Cloud SQL for PostgreSQL database to Azure using Azure Database Migrat...
Recurring Spikes in Cloud SQL (MySQL) Usage - Occurring 4-5 Times Daily, Around :28-:30 Past Hour
Hi,I'm experiencing a peculiar pattern of recurring spikes in my Cloud SQL for MySQL Enterprise instance (runn...
Is there a tool that automatically recommends indexes to speed up PostgreSQL?
I know there are custom extensions out there that offer this, like hypopg, but Cloud SQL for Postgres doesn't ...
Objectify - Datastore key retrieval error com.googlecode.objectify.Result.now()" null
Recently we have migrated from JDO to Objectify for accessing datastore as a part of App Engine Gen 2 Migratio...
Fine-grained IAM condition for connecting BigQuery agent SA to CloudSQL
Hi,I'm trying to connect BQ to a specific CloudSQL instance.It works when adding the "roles/cloudsql.client" r...
Problem in Creating Spanner Graph other than Default Schema
Hi All, I am trying to create a graph on tables that is not in default schema. But I am not able to do so. Is ...
BigQuery transfers from Postgres db with hyphen in db name
I am trying to transfer data from an on premises postgres db into big query via a data transfer. This works gr...
Accidently deleted my VM
Accidently deleted my VMI have not taken backups or snapshots.Is there any way to get the mysql data and php f...
Cloud SQL Proxy Dial Error
Hi all,I've been connected to a Cloud SQL Postgres DB with `cloud-sql-proxy` and earlier this week it was work...
Recovering Cloud SQL Database Deleted 9 Days Ago with 7-Day Backup Retention
Hello Google Cloud Community,I accidentally deleted a Cloud SQL database instance 9 days ago, and I had the au...
Move approx 100 million records from BigQuery to Cloud SQL
Hello Team,I have a Apache Beam dataflow implemented to transfer approximately 100 million records from Q to C...
Error while trying reprogram scheduled maintenance
Hey folks, I’m stuck trying to reschedule a maintenance window for my Cloud SQL instance [INSTANCE_NAME] in pr...
Firestore API Returns NOT_FOUND (gRPC Error 5) for Document Visible in Console
Hi everyone,I'm facing a puzzling issue with Firestore. My Node.js backend application consistently receives a...
How to fix data base
To fix a database, you'll first need to identify the issue, back up your data, and then apply the appropriate ...
cloud sql psc problem
hello We have a problem with a cloud sql instance with psc as connection mode. It is impossible to edit this i...
How to extract data for bigqueries
HiI'm using BigQuery to automatically import data from an GWS. The external system doesn't allow me to configu...
Cloud SQL CPU Utilization < 25% but underprovisioned?
Greetings,We have a database instance deployed for some time on GCP with very light workload and is using Post...
Migrating to CloudSql: permission issues
Hello all,We are slowly moving from MariaDB to Cloudsql, but are main problem remains....permissions/priviledg...
Can't start, delete CloudSQL with VPC
Hello,I'm tried to set up CloudSQL PostgreSQL with a VPC, and now I want to delete it. However this instance h...
Cloud SQL materialized views not visible in UI
Hi, I have a Cloud SQL database running on PostgreSQL 17. I'm testing out some features, and one of these is m...
Articles from Product Experts and Googlers
BigQuery Data Preparation with AI Agents: Smarter, faster, and code-free
Ready to unlock the secrets hidden in your product data? This tutorial demonstrates how BigQuery Data Preparation can clean and transform your raw data into actionable business intelligence, using a realistic example from the Fashion and Beauty industry.
Launched: ABAP SDK v1.10 unleashing powerful AI/ML, eventing, and storage capabilities
Supercharge your SAP systems! ABAP SDK v1.10 unlocks BigQuery AI/ML, simplified event-driven integration, Cloud Storage content repositories & access to 290+ Google Cloud APIs. See what's new.
From idea to viral video: the GenAI workflow you need
What if you could create professional-quality videos with just a fraction of the effort? This blog introduces a radical new GenAI workflow on Vertex AI, using models like Gemini, Imagen3, MusicLM and Veo2 etc to make video creation accessible to everyone.
