I am new to Google Cloud Platform, so this is a question for those who have experience with GCP suite of products. 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.
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 will be updated 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 start-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 horse power.
I appreciate any feedback.
LinkedIn
Twitter
