20 table join spans 20 systems to shock the world
Have you ever even imagined writing a two-table join where the tables reside on different database platforms? Today I will do what many thought impossible and join 20 tables that reside on 20 systems! And the SQL will be built automatically for me.
What is even more shocking is that I will choose which system I want to process the join, which we call the hub. And I will change the hub several times to demonstrate how quickly Nexus automatically changes the SQL, converts the tables and the data types, and moves the data.
If I choose the hub of Snowflake, Nexus converts SQL and all tables to Snowflake. When I choose the hub of SQL Server, the SQL converts to T-SQL, and the join processes on SQL Server.
Welcome to the greatest query tool that ever lived.