World's only SQL IDE that can Write SQL
BI and Data Visualizations tools are good, but every great data engineer needs a great SQL IDE. Most current SQL clients web or desktop only provide basic keyword hinting. Vero goes beyond keywords by generating complete queries, automatically resolving complex join trees, and providing Alias Aware code completions
Start Your Free Trial Today
Vero generates Multi-Pass SQL Scripts that Data Engineers and Analysts write manually. When querying across fact tables at various grains a multi-pass approach is required. Everything from automatic join resolution, in database blending, and federated queries are made easy.
Run queries across separate databases as if they are collocated. Drag and drop to generate a data blending query scaffold and then proceed to hack the query. Vero's high performance data blending tech takes care of moving data, translating data types, and efficiently executing queries. Writing Federated Queries have never been easier.
Smart code hints and autocomplete unlike anything else on the market. Vero provides intelligent hints that are Alias Aware. Now you have an IDE that writes useful analytical SQL, query across databases, and provide contextual code hints.
Exporting data to SQL databases has never been easier. Vero handles data type resolutions and data movement. Move data into the cloud and use SSH tunnels to secure access with ease. You can also export data to Amazon S3 and CSV files as well. Data exports can be automated with Vero Command line scripting.
Easily wrangle and upload CSV and Excel files to Amazon RedShift, MySQL, or Postgres. You can also instantly load it into Vero directly and start writing SQL on files with ease.
Vero comes with a world class metadata layer that work's with you in a natural way. Drag and drop to create new concepts and use a micro-IDE to define complex formulas. Now you can compose complex queries from a reusable Metadata layer. All metadata is expressed using SQL so there is no new language or framework to learn.
Supported Data Sources
LATEST BLOG POSTS
We have been a bit quiet the last two months for good reason. Vero 3 will be one of the greatest releases in our company's history. After surveying our users and prospective customers we decided to build a full fledged BI platform rather than just a data prep tool.
How do you access databases behind a firewall?
Here at Vero we have our company databases hosted on Amazon, but they are not exposed to the internet. You can only access these databases from the same network. This means we have to SSH to a secure box and from there connect and run our queries.
Two new exciting export capabilities: Append & Merge data. Append is pretty straightforward in that we are simply adding data to an existing table. In the event the table structure changes, it will automatically be dropped and recreated. Merge on the other hand allows us to incrementally add data to a table.
On the heels of our groundbreaking 2.0 Release, the Vero team launches yet another major update, Vero 2.1. Now you can control more precisely how two blocks in Vero are blended. Set the join type and the join key. Additionally, the Vero data exported will now allow you to configure DDL options for your exported tables.
One of the great things about using Vero for Data Prep, is that you can use the familiar paradigms of Measures and Dimensions and you don't have to be an expert coder. We like to think of Vero as the Tableau for Data Prep.
Internally, Tableau executes a query for each data source and joins the two sources inside the visualization (your desktop or your Tableau server).
Here at Vero, we're having a ton of fun with Amazon's RedShift database. It is a powerful cloud-based columnar database designed for analytical workloads. We love it so far, but there have been moments some of us let a few curse words slip. I'm going to share our experiences with you relating to loading data into RedShift and the lessons learned.
This is the story of one of our favorite customers, a Marketing Pro at a leading hotel chain who totally revolutionized the way he does data. Six months ago our Marketing Pro was doing business as usual that many of you can relate to. Once a month he would pull data from Google Analytics, internal data tools, and other third party sources. He was all about linked tables and query tables in the veritable Microsoft Access. It was a great solution that worked for a while.
In this post, I will describe how you can use Vero to quickly load data into a RedShift table, describe some of the technology underpinning our high speed data loader, and a few gotchas we learned the hard way.
To say this is a huge improvement would be an understatement. From faster data blending to direct high speed data uploads to Amazon RedShift, almost every component saw an upgrade while several key features were added. I want to thank our customers for working closely with us providing us with clear use cases, access to their source data, and amazing feedback.