Datastream for Bigquery
I am reaching out for help with two issues we are facing with replicating a source postgresql schema to google...
Databases
Find and share best practices about all things databases, including products like Cloud Spanner, Bigtable, Firestore, and more.
Forum Posts
Cloud SQL Export taking too long
Cloud SQL export operation for postgres instance has been running for 20+ hours and is still in progress. No o...
How to transfer a datastore kind to a new namespace and kindname
This is the way I follow to transfer data from one namespace to another in a new kind1) export namespace n1 an...
Always on cluster in GCP having 2 listener ip for 2 different sql instance on 2 node cluster. Why bo
Always on cluster in GCP having 2 listener ip for 2 different sql instance on 2 node cluster. Why both sql ins...
gcp myql autoincrement on table skipping numbers
i find one issue of GCP mysql database, one table primary id with auto increment, but now it happens skipping ...
Cloud SQL Proxy Issues in Cloud Build yaml
Hi everyone,I have a Postgres Cloud SQL instance, and I'm trying to run some basic migrations on it. I'm tryin...
Citus Extension in Cloud SQL Postgres
Hi,We are looking for a solution to evolve our DB to support sharding and horizontal scaling. We currently use...
How to check Firestore Read by collection
Hi,We are looking into our reads, and We are unable to figure out which collection is getting read more. How c...
duplicates
dataset is called zip_to_zip_moving, i have four tables there, one is called zillow_corrected,realtor_correcte...
AlloyDB ORM Support
Hi, I am trying to use AlloyDB for my application and analytical solution. My application is based on java, Sp...
MSSQL Create Replica fail with unknow problem
Hi,I was trying to create a replica for my database ( Enterprise 2019 ). The master database has deletion prot...
Cloud Spanner minimun nodes
Hi allWe have a prospect lead with an e-commerce solution with shopping and deliveries items functionality fro...
Postgres instance failed over randomly?
We just experienced what appears to be a random failover of a Postgres CloudSQL instance. In looking at the lo...
Database Migration Job - Source DB server having multiple DB out of which only 1 is to be migrated
In the Migration Job, at the step defining source, I have given the server details where multiple DBs are host...
How to create case-insensitive unique constraint in Google Spanner using GoogleSql?
I want to create case-insensitive unique constraint for a column. But I am not able to figure out exact syntax...
How does my springboot app connect to the AlloyDB for postgreSQL.
How to configure the dependency and application.properties for my spring-boot application to connect to the Al...
Cloud SQL for PostgreSQL billing calculation- Clarification
Dear Experts,we have created Cloud SQL for PostgreSQL 14 database in GCPStorage used showing as 120 MB of 500G...
Multiple appends to same record overwrite even when using transaction
Hi all,1I am running Firestore in Datastore mode and have a structure in one of my tables where I use an array...
Cannot export with gcloud cli or console
I'm unable to export my databases using gcloud or the console since few days without any other issue. The erro...
Data movment cost from google drive to google cloud bucket
I have around 40T data on google drive, and I want to transfer them to google cloud bucket. I knew there is no...
Issue with write rule on firestore
I am facing a set data rule issue... It was working then stopped working nothing changes in the rules... I hav...
How to connect cloud spanner via jdbc driver in pyspark
Hi all, I am trying to connect my spanner, it's done but when I reading/writing to table then getting error li...
Why enable-database-replication needs a restart?
The doc says:--[no-]enable-database-replication: Enable database replication. Applicable only for read replica...
Migrate local datastore.db data created by python 2.7 dev_appserver.py to Datastore emulator
Hello, we have an old set of data locally created for our tests on dev_appserver.py python 2.7 application.We ...
Connecting to SQL Server in VM Instance using SSMS
Hello Everyone,I have a VM instance running Ubuntu 20.04 in Compute engine. My ultimate goal is to host a .Net...
User rights management for Cloud SQL - SQL Server
Hello,I am fairly new to GCP and their implementation of SQL PaaS, am familiar with other cloud vendors offeri...
google Cloud Data structure Deletion
Hello- My developer is un Ukraine so I didn't feel the need to update my credit card for our google console da...
CloudSQL between VPCs
Hello,I have some CloudSQL instances that use public IP's and I'm replacing them with new instances with only ...
Big Query External Query to SQL Cloud
Hello I have gone throw the following tutorials:https://cloud.google.com/bigquery/docs/cloud-sql-federated-qu...
Rest API
Good afternoonSorry if this is an obvious question. I have a REST API from eposnow which is what my stores use...
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.
