GBQ issues
Wanted to do suppression of time in case of changing from/to daylight saving time.I know for teradata there is...
Databases
Find and share best practices about all things databases, including products like Cloud Spanner, Bigtable, Firestore, and more.
Forum Posts
Reducing disk size of the Cloud managed SQL PG instance
Hi there. We need to reduce our SQL instance disk size. There is no way to do it via console. According to our...
GBQ equivalent function
I came across timezone_hour and interval hour functions in teradata.However not able to find the equivalent fu...
SQL Server Error Code 18456 on Cloud SQL when creating Linked Servers
Hello Everyone,Kindly asking for solution on my Cloud SQL using SQL Server environment. Currently I have two e...
Firestore Backup Stuck in Creating State
I created a firestore backup job following this guide. I have been waiting for about 5 hours and every time I ...
Dialogflow and Google Drive
We are looking to create a dialogflow agent internally for our organization that my employees can chat and ask...
MySQL Replication Failed From GCP to AWS Aurora
Hi Team,I have GCP MySQL server and i was migrate GCP to AWS Aurora Database and replication was enabled by bo...
can't edit and delete sql instance after deleting dms job
I got stuck to delete the sql instance and even can't edit the instance . I create dms job before and my job g...
Java code to fetch data from bigtable giving error creating bean with name datasourcescriptdatabase
Hi @,We are working on a java spring boot rest api to fetch data from bigtable. We followed below linkhttps://...
Cloud SQL SQL Server Clone Failure (FCB::Open Failed: Could not open file)
When trying to clone an instance of Sql Server which contains 3 databases, an error reporting the.mdf and .ldf...
You've reached your limit of 200 composite indexes in Firestore.
You've reached your limit of 200 composite indexes. To create new composite indexes, you'll need to delete som...
insert data on mysql with terraform
Hello I have a terraform script that creates a mysql instance correctly. I canot find a way to execute a sql f...
AttributeError: 'Engine' object has no attribute 'character_set_name'
I am running a python app on GCP app engine which connects to cloud SQL database (mySQL). But there is an erro...
on-prem oracle to postgreSQL (cloud SQL) Sync
Hi, curious if there's a method or recommended practices to be able to replicate or sync an on-prem oracle to ...
"unable to connect to source database server" in database migration job over VPN
Hi. My database migration project is to import from an AWS RDS Postgresql cluster to AlloyDB. I've connected t...
Datastore composite index not being recognized despite removing and recreating
So I'm using Datastore as my DB with the NodeJS client and I'm making an aggregate query. I have an index.yaml...
Datastore database not showing in dashboard
Hi everyone, I encountered a problem while using Google Datastore. I created a Datastore database with id, def...
Private Tables
Hello everyone,I am trying to make an app that will be published in different app stores.In this app, I am try...
AlloyDB encryption
Hey folks,I'm on the hunt for some solid advice on AlloyDB encryption. I stumbled upon this upcoming webinar b...
Is it possible to sync MySQL to PosgreSQL
hello guys, I am using the GG Adscript to get some GGAds data and then insert it into my PostgreSQL database. ...
Monitoring CloudSQL's Point in Time Recovery Storage Usage?
Hello,I read in this answer that the Cloud Storage bucket used to store WAL archives to support the "Point in ...
alloydb omni 15.2.2 agent error messages regarding failed to install some extensions
Hi I am seeing a lot of errors on a reboot of my alloydbtest serverIt seems to be trying to reinstall the agen...
Is it possible to make sharded table in BigQuery with Partitioning?
Hello!I have a case when I need to store huge amount of data and I need to partition it by minutes. But BQ sup...
RDS Postgres to Cloud SQL Migration issue
I'm trying to migrate our Postgres database from RDS to Cloud SQL using the migration tool, and I'm getting an...
Custom Spanner Multi-Region Configuration
Hi, I'm curious if the GCP team will work with customers who are interested in creating multi-region configura...
Issue setting up the Stream Firestore to BigQuery extension
We're running into a small issue with Firebase that I was hoping the community might be able to help us with. ...
Fetching data back from datastore (The query is giving me error, what is something that I need todo)
def fetch_pizza_shop_name(custom_client, custom_session_id):pizza_shop_data_client = custom_client()pizza_shop...
Datastore pricing
Hello everyone! My number of cloud firestore readops has increased sharply. I have enabled the Firestore/Datas...
Backup of google cloud sql instances database without it being blocked from usage until export
I wanted to create the on demand automated system of the google cloud sql instances database but if i use expo...
Connecting SQL database to Airflow in Google Cloud Composer
Hope all are well. I have a DAG running in the Google Cloud Composer. But, I am having an issue connecting SQL...
Articles from Product Experts and Googlers
Media CDN flexible origin shielding: Reducing origin load, latency, and improving viewer experience
Discover how Media CDN's new flexible origin shielding enhances content delivery! Learn how to reduce origin load, optimize latency, and improve viewer experience by precisely controlling your shield locations.
Agents are not tools
There is a common refrain from many that “why can’t agents just be tools?”. This blog provides a point of view about why tools and agents should be treated differently, and why there needs to be a different way to interact with them.
Optimizing LLMs serving with the new NVIDIA TensorRT-LLM container on Vertex AI
Learn how about NVIDIA's open-sourced library for optimizing LLM inference directly into Vertex AI Prediction, enabling you to serve open models with 1-click deployment and getting significantly improved performance and cost-efficiency.
