Issue with non-Eng character like 'â' changed to '/342' (migrated data from SQL Server to Postgres)
We have recently migrated data from an MS SQL server to PostgreSQL GCP. One of the tables has compressed data....
Databases
Find and share best practices about all things databases, including products like Cloud Spanner, Bigtable, Firestore, and more.
Forum Posts
Datastream - Error configuring data flow exclusion elements
Hi team, we are running a transmission to move data from mysql to BQ. In order to transfer only the tables and...
Logging of SQL Commands in Logs Explorer from Cloud SQL Service
Hello Community,I would like to know if SQL commands, such as SELECT * FROM..., executed on a Cloud SQL instan...
Cloud SQL instance still suspended after resolving billing issues
Ran out of credits provided by a code which caused my CloudSQL instance to become suspended so I started the f...
how cache works on BigQuery and SSRS integration
Hi Team,If any one has used SSRS with integration with BigQuery. I want to understand how cache works when we ...
Migration of data from BigQuery to CloudSQL Postgres
We have a need to do a bulk load from BigQuery tables to a CloudSQL Postgres instance. In order to do this, th...
Datastream to Cloud SQL private IP not working over private connectivity.
I'm having issues understanding what is blocking here.I have configured Cloud SQL instance in us-east1 with ne...
Redis Memstore Cluster IAM Credentails
Hi,We have redis memstore cluster and in producion we would like to have IAM credentials enabled.i followed ht...
Unable to use embedding function with google_ml_integration extension
UPDATE table set embedding = embedding('textembedding-gecko@003',content);HINT: No function matches the given ...
Filestream (SQL Server)
Hello,Filestream is not supported on the Cloud SQL (SQL Server).Is there any workaround to overcome this issue...
Extension not editable
Is it just me or are the firebase extensions currently not working properly? If I edit it via the cloud consol...
Unable to call procedure after restoring sql dump on new db
I have exported the sql dump file from my existing cloud sql db to a bucket then I have created a new db and r...
Cloud sql bill shot up
My Cloud SQL bill suddenly increased. The application/ db is being tested by couple of us. It is not in produc...
Migrate Postgres on a VM to CloudSQL
Hi,I am trying to migrate my Postgres data on vm to cloud sql. I follwed all the steps that were shown in Qwik...
429: Too many request on cluster where open connections are just 40 and max can go 1000
My alloy db instance shows number of connections 40 and i now at peak i can reach 1000. But for some reason fr...
AlloyDB Role/User Permission
Hi Experts,I would like to know about assigning roles to other users in AlloyDB, please share your input.I hav...
Does Google SQL allow us to downgrade from Enterprise to Standard
Currently, I am using the standard version and want to upgrade the Enterpirse side for a while and can downgra...
Data Stream incompatible with Postgres 16
I've been using DataStream for almost 1 year now without a problem.I have a CloudSQL instance running a postgr...
Datastream - Estimating costs after POC success
Hello,I have a few Cloud SQL (Postgres) production instances and would like to implement Datastream streams to...
Firestore
hi,How to access other project's firestore database (read/write) from another project. Both the projects are d...
Help with Calculated Field in GCP Query
Hello everyone, I hope I'm posting in the right section. I'm new to the world of GCP, and I'm working with a S...
Label on CloudSQL backup
Is there a possibility to add a label to the cloudsql backup? from gcloud, api or from the standard web interf...
Cannot update PostGIS to 3.4.0
Following the official CloudSQL documentation: https://cloud.google.com/sql/docs/postgres/extensions#postgis ,...
[About Cloud MySQL] Flag Modified Not Work without Restart
As title said, our maintainer set a no-need-restart flag, sql_mode, on instance modification page, but not wor...
Postgres database updating using hardlink
I want to upgrade my cloudsql postgres instances from 14 to 15, but the regular method takes around 15 minutes...
An error occurred when upgrading postgreSQL 9.6 to 14 in place
hiI upgraded my database using console mode and received an error message."db=cloudsqladmin,user=cloudsqladmin...
Is there a Free Tier for Cloud SQL?
I found this article where a staff from Google replied saying that there is: Solved: Is Cloud SQL for MySQL fr...
Does MAUI ios/Android need access Webapi or connect to Firestore?
Hi,I'm thinking a question that ios/Android client need connect to webapi? or just connect to Firestore using ...
Error : reserved_ip_range issue in google_redis_instance resources
I'm trying to create a Memorystore Redis instance using google_redis_instance . I’m getting the error message ...
Dataflow Job Fails with Cannot create PoolableConnectionFactory and PERMISSION_DENIED Errors
I'm working on a data migration personal project where I need to transfer multiple tables from Microsoft SQL S...
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.
