Google Cloud Platform

Hello folks, we are making a company internal google chatbot system hosted on Google Cloud Platform. The backend is being written in ExpressJS + TypeScript, we are planning to use Cloud SQL to store basic entities like Users, Spaces, Connections(use-case specific).

The question I have is which tool is recommended for this basic use case where we want to query some data and perform CRUD operations. Also, how we should be handling the DB version control & migrations?

I am new to the cloud platforms. I am trying to figure out which Google Cloud product would be the best fit for my needs. Here are the requirements I am trying to meet:

1. Store data in @{Google Cloud Platform}|tool:4240|.
2. Support potentially thousands of concurrent users running analytical queries.
3. The data volumes would be moderate (as far as Google is concerned) - we are talking 10's of GB up to potentially 100s of GB.
4. The data needs to be updated once a day (but ideally a few times a day).
5. Perhaps my biggest goal is the following: I am trying to avoid having to build a traditional data warehouse with star-schema and ETL process. I have experience with these projects, and they end up being very costly, error-prone, hard to troubleshoot, and rigid (hard to deploy changes). Instead, I am hoping to just copy my OLTP tables to GCP and query them from there, relying on GCP horsepower. I appreciate any feedback.

I am currently working on a long term mobile app project. Current stack: Frontend: Dart/Flutter Backend: Golang, AWS Resources (AWS Lambda, Amazon DynamoDB, etc.) Since there are only two developers and we have limited time and resources, we are looking for a BAAS like Firebase or AWS Amplify to handle auth and push notifications for now. We are prioritizing developing speed so we can iterate quickly. The only problem is that AWS amplify support for flutter is in developer preview and has limited capabilities (We have tested it out in our app). Firebase is the more mature option. It has great support for flutter and has more than we need for auth, notifications, etc. My question is that, if we choose firebase, we would be stuck with using two different cloud providers. Is this bad, or is this even a problem? I am willing to change anything on the backend architecture wise, so any suggestions would be greatly appreciated as I am somewhat unfamiliar with Google Cloud Platform. Thank you.

We decided to go with the Google Cloud Platform due to its intuitive management dashboard, simple and cheap pricing and high reputation. CloudFlare keeps traffic costs under control and allows us to be more flexible with security inside the clusters.

We use Google Cloud Platform, Microsoft Azure and Amazon S3 (amongst others) because our platform needs to be cloud-independent to give customers the freedom they need and deserve. But being in the healthcare enterprise space, we believe Azure is the top choice... today (it tends to change often).