I've been working with a tool DBVisualizer. This tool allows development against a variety of databases. I happen to be working against AWS Data Lake Hive tables. After you configure the Connection, you can go to the tables tree view, expand, highlight all objects, right click, script objects, to a file or window. I selected the "Create" button and ran it. 544 objects to create, runs for a while. So we have a file containing all table objects.
From there, we connect to another environment. Assuming I had access to the Production Environment, I would perform same steps, generate a second file.
From there, you can click the Tools dropdown, Compare option, select your 2 new files, and see the differences.
Now to view the differences, green indicates new:
This is a handy feature when developing, as sometimes the objects do differ between environments, and it's no fun to deploy a report that's been fully validated, only to have it fail in production, with different objects. Missing Views or Tables, fields renamed or missing.
And there you have it~!
This blog post is in no way an attempt to steal other people's work. It's basically an conglomeration of notes from research I did...
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...