We performed a comparison between Snowflake and Teradata based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Both solutions received high marks from users. Snowflake comes out on top in this comparison. It is a powerful and reliable product that is easy to deploy. In addition, its users feel that it is reasonably priced.
"Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"A user-friendly and reliable solution."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"Can be leveraged with respect to better performance, auto tuning and competition."
"The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
"It's ultra-fast at handling queries, which is what we find very convenient."
"The key advantages are Performance when processing Terabytes of data and scalability."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"Sometimes it can be tricky to manage multiple environments if you're purely using Snowflake as your scripting and pipeline environment."
"Pricing is an issue for many customers."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"It would help to make scaling easier with a reduced cost. "
"Apart from Control-M, it would be nice if it could integrate with other tools."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"Teradata's UI could be more user-friendly."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"The cloud is the new challenge and the new opportunity."
"Teradata hardly supports unstructured data or semi-structured data"
Snowflake is ranked 1st in Data Warehouse with 40 reviews while Teradata is ranked 3rd in Data Warehouse with 21 reviews. Snowflake is rated 8.4, while Teradata is rated 8.4. The top reviewer of Snowflake writes "Easy to set up with great cloning and time travel". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". Snowflake is most compared with BigQuery, Azure Data Factory, Vertica, AWS Lake Formation and Microsoft Azure Synapse Analytics, whereas Teradata is most compared with SQL Server, MySQL, Oracle Exadata, BigQuery and Amazon Redshift. See our Snowflake vs. Teradata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.