How to view the logs?
I loaded a CSV file into MySQL table:load data local infile 'xxx.csv'into table xxxfields terminated by '|'lin...
Databases
Find and share best practices about all things databases, including products like Cloud Spanner, Bigtable, Firestore, and more.
Forum Posts
What data structure does Firestore use for its indexes?
is it b-tree? LSM tree? something else?
Multiple Tenancy with 1 Auth Gateway
Hey everyone, I have a question regarding authentication on multiple projects.Currently we have setup project ...
SET GLOBAL sql_mode ='STRICT_ALL_TABLES'
I am logged in as root on MySQL and cannot set the global sql_mode. I would like to include the mode " STRICT_...
Big Query: Partitioning public data set (chicago taxi trips) returns only data for one month
I have already posted the same question on stack overflow: stack overflow question CREATE OR REPLACE TABLE PAR...
About Google Cloud SQL Instance "Import" functionality
Hello Google, I am a new user and would like to know what are some properties of using the "Import" function f...
Cloud sql proxy occasionally fails with connections timedout
Hi there!We have been investigating a problem for days now and haven't found the cause or a workaround.On our ...
GCP Automatic Backup
In Cloud SQL GCP automatic backup means, Does its take a snapshot of the instance or really takes a backup of ...
Cannot drop views from Cloud (my) SQL, even as root
Hello everyone. When i try to drop a view on a cloud SQL database, i receive the error:1227 - Access denied; y...
Column should be hidden but working
After entering the formula in the column, I want the column to remain hidden but that column is being entered ...
Query to Retrieve all region Datasets
Hello Everyone,the below query gives us the details of the datasets present in our DBSELECT *FROM INFORMATION_...
Data Studio - GSheets vs SqlServer as "DB"
Hello all!Right now, I'm using Google Sheets as datasource for my reports.. But some of them are quite slow (t...
nfc scan
hi i am new to this, could u guys explain how to get the value of nfc that already scanned? i just have two ta...
SQL Server: Increase the Concurrent Connections
We have a client which require to migrate from SQL Server v2016 in On Premises to a services managed as Cloud ...
Communicating iot device with google cloud firebase using ssl
I have 2G GSM Module SIM808 which supports HTTPS using SSL but doesn't support TLS. I am trying to connect to ...
Viewing individual database metrics
The product is cloudsql mysql with individual databases running on the cluster. How do we view load from each ...
Ga4 to Big query not populating data
Hi, i´m currently migrating the data from ga4 to GCP (in the future to azure DWH) and i want to start analyzin...
Oracle to PostgreSQL migration support
Hi All.On the next link https://cloud.google.com/blog/products/databases/migrate-oracle-to-postgresql was anno...
Execute psql.exe from external tool
Hi allWith my team needs to migrate from SQL Server v2016 On Premises to PostgreSQL in Cloud SQL. The migratio...
Importing BAK Files - Unknown Error
Is it possibly to get more extended logging information on importing BAK files to a Cloud SQL Server instance?...
Replicate AWS Database With Private IP
We have a database on AWS we would like to replicate on Google SQL. We have a migration running, however it do...
Aborted connection occur in Cloud SQL
Hello All,In Cloud SQL , we are getting below log in GCP. Root user connection is aborted.[Note] [MY-010914] [...
Cloud SQL (PostgreSQL) access from Cloud Run service
Hi Everyone,I am trying to access the Cloud SQL PostgreSQL instance from Cloud Run service (Spring boot applic...
DeWitt Clause
Are Cloud Spanner or AlloyDB subject to a DeWitt Clause or are users free to publish benchmark results? I am n...
Document creates failing with Status(StatusCode="Aborted", Detail="Too much contention on these docu
So over time, we have been getting this below error but as of a couple of days ago, it has really ramped up. I...
GCP Postgres14 --with-lz4
Will Google build it's GCP cloudSQL instances with LZ4 so smart people could use SET default_toast_compression...
Firestore changes in logs explorer?
I am trying to search Logs Explorer for a specific change to a Firestore database entry. Likely would have bee...
Cannot connect Cloud Run application to Cloud SQL Postgres database with private IP
I'm experimenting with Cloud SQL for the first time. I'm trying to connect an application running in Cloud Run...
Latency to Reach Postgres from GKE/VM
I am currently investigating latency issue being faced while communicating to Postgres via GKE/VM.Both Postgre...
AlloyDB connecting from external network
Hi everyone, I took the AlloyDB preview for a spin, and now want to connect to it from or something similar fr...
Articles from Product Experts and Googlers
A developer's guide for building with Anthropic’s Claude 4 models on Vertex AI
We recently announced the general availability of two new models from the latest generation of Anthropic’s Claude model family on Vertex AI: Claude Opus 4 and Claude Sonnet 4. In this blog, we’ll guide you through building with the new Claude 4 models on Vertex AI.
Introducing DeepSeek R1 Model-as-a-service on Vertex AI Model Garden
Deploying Deepseek-R1-0528, a 671B parameters model, typically necessitates at least 8x H200 GPUs for a single API request. Such extensive resources are not accessible to everyone.To make Deepseek R1 more accessible to developers, we're excited to announce that DeepSeek R1 is now available as a fully managed API on Vertex AI in Preview.
Untangle the API maze with Apigee API Hub
Mirror mirror on the wall, What do I do with my API sprawl, Where can I see them all, How to make sure they listen to my call, And to ensure their compliance doesn’t fall. API Hub is the one to rule them all!
