Need advice for data structure and security rules
Hi,I am a newbie in cloud-firestrore and trying to find the optimal design for the following case.I have 5 ent...
Databases
Find and share best practices about all things databases, including products like Cloud Spanner, Bigtable, Firestore, and more.
Forum Posts
Need website Backup
Hi Team, Unfortunately, we missed our hosting renewal date. but when we connected WordPress, they said our web...
'h' format requires -32768 <= number <= 32767
I am trying to write a dataframe into postgreSQL database table. When i write it into heroku's postgres SQL da...
i have gcp and i have one project there, but i have build a different project in firebase app for db
so what every i am doing in the gcp giving it roles iam roles to configure the policies , i am not able to do ...
Freeze header row of table in BIGQuery
Hi everyone. Is it possible to freeze the header row of a table in BIGGQuery so that it can still be visible w...
How to represent international phone numbers in Cloud Spanner?
What would be the best way to represent international phone numbers in Google Cloud Spanner? I would like it t...
Unable to retrieve the redis instance ID using API
Hi All,We are monitoring the GCP environment using Elastic. To get the redis metrics, we are using the Elastic...
Firestore Dister Recovery Planning
Currently we don't take any backup for FireStore DataBase. Wanted to know best practice for that. Do we need t...
Google Cloud SQL (MySQL) Error
I have a MySQL 5.7 Google Cloud SQL server with a read replica and i it's been generating a lot of this warnin...
Unable to track down Datastore quota which is being exceeded
During increased traffic my API which runs on Cloud Run gives the error copied below. My best guess is that th...
Relation size Limit
What is the limit size of relation in GCP Postgresql. 30 TB- with indexes or not?
Which GCP database solution to use for my application?
Explanation of Problem: I have built an e-commerce inventory accounting application using Firestore as my data...
Ordering behavior of Firestore recursive queries in Python
Hello, I have a structure in Firestore that has one collection, and each document in the collection contains t...
Migration Postgres SQL Server from 9.6 to 12
Hi All,I am trying to migrate an existing Postgres 9.6 database hosted in GCE to 12 In order to do that I expo...
overprovisioned Cloud SQL instances
Hi Team, I am working on finding the over provisioned cloud SQL databases and provide the recommendations for ...
Firestore Read Write Limit
Currently Write limit per second for 10,000 or 10 MB found in FireBase Doc . We are using using firestore for ...
How do you drop all data in firebase
We have a lot of data we used to need for email campaigns that are no longer needed.How do you keep the schema...
How to increase upload size in google cloud deployed Moodle
Dear All,I created a VM Machine and installed Moodle App on it. Its working perfectly fine, however soon i not...
Google Cloud Platform: How can I see my Database tables on BigQuery?
Maybe this question is dumb but I'm new with this and I'm not really getting it.On Google Cloud Platform I hav...
Is it possible to reset, and recreate firestore?
I'm trying to migrate my firestore database to a new location, since google added a new Canadian region after ...
3 - schema architecture
In 3- schema architecture we have three levels1)view level 2)Logical view3)physical levelWhich means user can ...
Data engineer Documentation
Hiii all I prepare the data engineer certification please I need a good book that explains me in details to cl...
Pub/Sub data route to MySQL table
Hi,How can I insert Published JSON data (Pub/Sub) into MySQL table?
Issues with Firestore - Datastore/Native
I created the firestore database in datastore mode not knowing that this impacts the API. You learn by trying ...
How to connect to SQL instance from App Engine instance
Hi,We are having trouble to connect to a postgres database from a docker image on an instance within the App E...
"[table] re-created., notFound" Error bigquery
I'm working on fixing my project that runs inside of App Engine and uses Big Query for data storage, and every...
Multiple instance of Firestore in same project
Firebase Firestore doesn't support multiple instance in a single project. We need to create multiple instance ...
Migrating Firestore Data to Dev or Test Instance
Need recommendation to clone production Firestore DB to Dev/Test Instance.Currently we can export Data into st...
Setting up Google Ads Cloud transfer fails with "unexpected error"
Trying since weeks and informed Google Support many times (send feedback). No response receive, still not able...
Spanner DB Functions and Triggers
I am in the process of evaluating Cloud Spanner to determine if its the proper fit. We currently are running a...
Articles from Product Experts and Googlers
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!
Next-Gen Data Pipelines: Airflow 3 Arrives on Google Cloud Composer
We are thrilled to announce that Google is the first hyperscaler to provide selected customers with access to Apache Airflow 3 on our fully managed Cloud Composer 3 service. Discover how powerful new features like DAG Versioning, a modern React-based UI, and scheduler-managed backfills can help you innovate faster and more reliably.
