Snowflake and BigQuery are major competitors in the data warehousing category. Snowflake has the upper hand in scalability and flexibility, while BigQuery offers cost-efficient performance.
Features: Snowflake enables dynamic scaling without downtime and supports various file formats, making it suitable for high-performance tasks. Snowpipe enhances its real-time data processing ability, while the zero-copy cloning feature facilitates easy creation of test environments. BigQuery stands out with its serverless architecture and rapid query performance, making it ideal for handling large datasets. Its machine learning integration and flexible pricing models appeal to businesses seeking cost efficiencies.
Room for Improvement: Snowflake could improve its geo-spatial query capabilities and provide clearer pricing structures for better cost management. Enhancing its user interface and developing embedded analytics would also be beneficial. BigQuery requires more flexibility in data caching for external tables and better special character recognition. It would also benefit from improvements in machine learning features and local data residency options.
Ease of Deployment and Customer Service: Snowflake offers deployment on public, private, and hybrid clouds, which BigQuery does not. Snowflake users generally appreciate its rapid support, although SLAs are absent. BigQuery's customer service is perceived to be slower, with reported delays, but both platforms have robust documentation and community support to aid user experience.
Pricing and ROI: Snowflake's flexible credit-based model allows users to pay for actual usage, though its pricing transparency is often questioned, leading to potential consumer confusion. BigQuery's pricing model, based on data processing and storage, is considered cost-effective for extensive queries. Both platforms have demonstrated positive ROI potential with proper optimization and usage.
rating the customer support at ten points out of ten
I have been self-taught and I have been able to handle all my problems alone.
I received great support in migrating data to Snowflake, with quick responses and innovative solutions.
The technical support from Snowflake is very good, nice, and efficient.
It is a 10 out of 10 in terms of scalability.
The scalability is definitely good because we are migrating to the cloud since the computers on the premises or the big database we need are no longer enough.
The billing doubles with size increase, but processing does not necessarily speed up accordingly.
Snowflake is very scalable and has a dedicated team constantly improving the product.
Snowflake as a SaaS offering means that maintenance isn't an issue for me.
Snowflake is very stable, especially when used with AWS.
BigQuery is already integrating Gemini AI into the data extraction process directly in order to reduce costs.
Troubleshooting requires opening each pipeline individually, which is time-consuming.
In general, if I know SQL and start playing around, it will start making sense.
Enhancements in user experience for data observability and quality checks would be beneficial, as these tasks currently require SQL coding, which might be challenging for some users.
Cost reduction is one area I would like Snowflake to improve.
Being able to optimize the queries to data is critical. Otherwise, you could spend a fortune.
The price is perceived as expensive, rated at eight out of ten in terms of costliness.
Snowflake's pricing is on the higher side.
Snowflake lacks transparency in estimating resource usage.
It is really fast because it can process millions of rows in just a matter of one or two seconds.
The features I find most valuable in this solution are the ability to run and handle large data sets in a very efficient way with multiple types of data, relational as SQL data.
BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes.
One key feature is the separation of compute and storage, which eliminates storage limitations.
The scalability options it provides, addressing issues without tying workloads into one virtual machine, enhance functionality.
BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. ... You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.
Snowflake provides a modern data warehousing solution with features designed for seamless integration, scalability, and consumption-based pricing. It handles large datasets efficiently, making it a market leader for businesses migrating to the cloud.
Snowflake offers a flexible architecture that separates storage and compute resources, supporting efficient ETL jobs. Known for scalability and ease of use, it features built-in time zone conversion and robust data sharing capabilities. Its enhanced security, performance, and ability to handle semi-structured data are notable. Users suggest improvements in UI, pricing, on-premises integration, and data science functions, while calling for better transaction performance and machine learning capabilities. Users benefit from effective SQL querying, real-time analytics, and sharing options, supporting comprehensive data analysis with tools like Tableau and Power BI.
What are Snowflake's Key Features?In industries like finance, healthcare, and retail, Snowflake's flexible data warehousing and analytics capabilities facilitate cloud migration, streamline data storage, and allow organizations to consolidate data from multiple sources for advanced insights and AI-driven strategies. Its integration with analytics tools supports comprehensive data analysis and reporting tasks.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.