Blog
Totally Integrate Snowflake, Databricks, BigQuery, Redshift, and Synapse
I wrote my first 50 books on Teradata, but then I got smarter and wrote my next 50 on all the other incredible databases. Of course, you have access to my books for free. I will show you today what nobody else can do for the next decade: integrate Snowflake, Databricks, BigQuery, Amazon Redshift, and…
Read MoreThe Mission Impossible of Data
Mr. Coffing: Your mission, if you decide to accept it, is to make data flow like water between every major database. And you must finish the task within 20 years. Mission accomplished! The most difficult thing about every database is they cannot and will not communicate with other databases. However, I accepted the mission to…
Read MoreThe Technology that Flatfooted Snowflake, Microsoft, Oracle, Teradata, and Google.
Most people have never imagined writing a two-table join where tables reside on different database platforms. However, today, you will see a join of 20 tables from 20 separate systems in a single query! And the entire process is automated, so anyone can do it without technical expertise. The architectural superiority it takes to pull…
Read MoreFREE Books – Snowflake, Redshift, BigQuery, Synapse and More
To show appreciation to our fellow data professionals, we are giving away our incredible books for FREE. For example, the Snowflake Architecture and SQL book, an 1130-page masterpiece with hundreds of brilliant Snowflake tips and tricks, best practices, and SQL examples, is now FREE. But you can also download our books on Synapse, Redshift, Google…
Read MoreFREE – Snowflake Architecture and SQL Book
To show appreciation to our LinkedIn group members, we are giving away our Snowflake Architecture and SQL book, an 1130-page masterpiece with hundreds of brilliant Snowflake tips and tricks, best practices, and SQL examples, for FREE. You can download the PDF from our CoffingDW.com website immediately. Here is how you do it. Go to CoffingDW.com…
Read MoreJoin Databricks to Snowflake to BigQuery to Synapse to Redshift to Everything
The greatest breakthrough became official yesterday with the latest release of Nexus because the world can now join tables from Databricks and Snowflake in a single query. And Nexus does all of the intelligence work automatically. Almost impossible to believe that you can join Databricks and Snowflake tables with Google BigQuery, Azure Synapse, Amazon Redshift,…
Read MoreThe Complexity of Analytics In the Year 2024
Twenty years ago, we thought computing would change so quickly and dramatically that nobody would see it coming, so we got to work. What did we miss in our quest to prepare you for 2024 computing? Nothing! Even today, most people don’t believe joining data across legacy and cloud computing is possible, but it is…
Read MoreSo Intelligent It Writes The SQL For You
It is so intelligent that it writes the SQL for you across all systems. Even better yet, it writes the SQL to join data across systems. That is why they call it the Nexus Super Join Builder, the greatest tool for data ever invented. According to Safari books which company has written 96 percent of…
Read MoreHow to use the Amazing Nexus Super Join Builder for Federated Queries – Tutorial
Here is a tutorial to show you how to use the Nexus Super Join Builder for federated queries. You will see all the amazing features the Nexus places at your fingertips. Joining tables from separate systems in a single query is often considered an unattainable goal by most individuals and database companies. However, Nexus defies…
Read More20 Table Join Spans 20 Systems To Shock The World
Most people have never imagined writing a two-table join where tables reside on different database platforms, called a federated query. However, federated queries are so easy that Nexus writes them for you. There is so much data out there that no single system can hold it all, so joining across systems is the new standard.…
Read MoreThe Friendliest Yet Most Powerful Federated Data Tool Ever Invented
After programming for ten years, writing 85 books, and teaching over 1,000 classes on the architecture and SQL for all databases, I knew I could design the friendliest yet most powerful federated tool ever invented. Most people believe that Nexus is a query tool that works across all databases, and yes, it is true, but…
Read MoreUnite All Databases Into One Giant Ecosystem
My dream to unite all database systems into one giant ecosystem began 20 years ago when I realized the value of data would create a data tsunami that no single system could hold. There was only one problem. Database vendors hate one another, and no database integrates with another. The solution took 20 years to…
Read More“Unleashing the Power: Seamlessly Unite Databricks and Snowflake Across All Systems with Nexus!”
Every single day at Coffing Data Warehousing is an electrifying adventure that pushes the boundaries of what’s possible in the realm of data. We are trailblazers, constantly shattering records and achieving feats that no one else on this planet has ever dared to dream of. And the exhilaration doesn’t stop there! Our latest triumph involves…
Read MoreNexus – Closest Data Tool To AI With No AI
Nexus has no AI functionality like ChatGPT, yet, Nexus automates the integration and conversion functions across all database platforms. Nexus is the closest thing to AI without using any AI. My goal as a designer has always been to automate the most difficult and impossible tasks of working with big data. At the beginning of…
Read More20-Table Join Across 20 Systems is 20X Faster
We have found a technique on all Postgres databases to move 20X faster, so our migrations and federated queries have blistering speeds. I put together a 2-minute video showing a 20-table join that spans 20 systems to show the speed, versatility, and impact this will have on everyone in the computer industry. Why put all…
Read MoreGreat Teradata Date Functions To Know
Below the video are great date functions on Teradata. However, you can first witness a two-minute video that joins a Teradata table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, MySQL, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…
Read MoreGreat MySQL Date Functions to Know
Below the video are great date functions on MySQL. However, you can first witness a two-minute video that joins a MySQL table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…
Read MoreGreat Postgres Date Functions To Know
Below the video are great date functions on Postgres. However, you can first witness a two-minute video that joins a Postgres table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…
Read MoreGreat Greenplum Date Functions To Know
Below the video are great date functions on Greenplum. However, you can first witness a two-minute video that joins a Greenplum table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on…
Read MoreGreat Date Functions for Azure Synapse
Below the video are great date functions on Azure Synapse. However, you can first witness a two-minute video that joins a Synapse table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on…
Read More