Google Cloud BigQuery allows me to explore and analyze large-sized structured data files with millions of rows. The service is fast and has seamless data import capabilities, especially with Google Cloud Storage.
Cons: Resource limits. Because of how Google Cloud BigQuery uses nodes, typical SQL processes involving window functions can fail. We've regularly hit resources exceeded limits on data sets of a few million records, which seems absurd these days....
The best parts about Snowflake are the ease of implementation, the no maintenance scalability and integration partner availability. From a storage perspective, it is extremely efficient. You can create a complete clone of a 5TB database (like a pointer)...
My main disappointment was with their support. We had an issue as soon as we signed a contract and it was about billing which seemed to be pushed off with no urgency and still not completed. Something like this I would have expected to be resolved within...
Google Cloud BigQuery allows me to explore and analyze large-sized structured data files with millions of rows. The service is fast and has seamless data import capabilities, especially with Google Cloud Storage.
The best parts about Snowflake are the ease of implementation, the no maintenance scalability and integration partner availability. From a storage perspective, it is extremely efficient. You can create a complete clone of a 5TB database (like a pointer)...
Cons: Resource limits. Because of how Google Cloud BigQuery uses nodes, typical SQL processes involving window functions can fail. We've regularly hit resources exceeded limits on data sets of a few million records, which seems absurd these days....
My main disappointment was with their support. We had an issue as soon as we signed a contract and it was about billing which seemed to be pushed off with no urgency and still not completed. Something like this I would have expected to be resolved within...