In a world where data is the linchpin of success, joining tables across different systems is not just a convenience; it’s a necessity. Combining tables across any two systems in a single query is even more important as organizations migrate to the cloud. As we navigate the complexities of modern business, data integration should be a cornerstone of our strategy.
The two hottest systems on the cloud today are Databricks and Snowflake. Both are considered giants vying for everyone’s business, but why not use both? Snowflake has revolutionized the cloud with its elasticity and management of relational data, but Databricks has rocked everyone with its machine-learning capabilities.
In a quick demo today, I will use Snowflake and Databricks to show you how to integrate the two and even join tables from both in a single query. But please recognize that everything you see today can be done by any two systems you can access in your enterprise.
Organizations often use a variety of databases, systems, and data formats. Integrating these diverse sources into a cohesive federated query system is complex because each source may have its own query language, schema, and access methods.
We strive to make federated queries user-friendly and accessible to a wide range of users, even those without deep technical expertise.
We have been working on the Nexus, the name of which means the intersection of all databases, for 20 years so organizations can join data from all sources using a beautiful and easy-to-use interface.
If you’re interested in exploring how we can leverage data integration to drive success in our organization, I’d be happy to discuss this further. Please feel free to reach out to me at Tom.Coffing@CoffingDW.com.
You can download the PDFs from our CoffingDW.com website immediately.
Here is how you do it. Go to CoffingDW.com and click on Books from the top right menu. You will then be in the CoffingDW bookstore, where you will see the Snowflake book. Add the Snowflake book to your cart.
Add any book you want to your cart.
When you check out, you use the coupon FRIEND2023.
You won’t have to enter any credit card information. Just put in your name and email, and the price will be discounted to zero. You can then download the book immediately at no cost to you.
The book is even watermarked with your name.
Enjoy the books, and keep in touch! Please let us know your thoughts. And feel free to share this coupon with your friends, family, and co-workers.
Tom Coffing, better known as Tera-Tom, founded Coffing Data Warehousing, where he has been CEO for the past 30 years. Tom has written over 90 books on Architecture, performance tuning, and SQL on all relevant systems. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus, which celebrates 20 years of brilliantly integrating all databases.