We hold financed data on the Vertica database, and clients use the data for reporting and other purposes.
Vertica provides benefits to our customers and helps with their performance.
The most valuable feature is Vertica's performance and the ease of using the database. Also, it is great for partnering with data.
We faced some challenges when trying to use the temporary tables feature. First, we installed Vertica on the AWS cloud and tried to read the data from Bitbucket to Vertica. We were able to read the data, but when we were trying to transform the data and load it into Vertica physical tables, we experienced performance issues.
Regarding additional features, we are unsure if Vertica has updated its features, but we've experienced difficulty in integrating with third-party tools. Clients use multiple technologies and value that integration. Sharing data with third parties should also be improved.
We have been using this solution for two years and are using the latest version.
It is a scalable solution. Initially, we had issues with the scalability, but with the new version, Vertica resolved the issues.
Regarding how many users are using this solution, I do not have a specific number, but our organization is large. So, for example, in a unit with about fifteen clients, two to three clients use Vertica.
I rate this solution a seven out of ten.
Snowflake claims to have many more features than Vertica, but we cannot compare both solutions as we have not used Snowflake. However, if Vertica integrates the use of third-party tools, it would be great and more competitive.
