We broke another record by joining 19 Excel spreadsheets with a production table on Postgres, and the process took minutes to set up and execute. Our previous blog and video demonstrated how easily we could join 20 tables spanning 20 different systems in a single query. So, we decided to stress-test our ability to import…

Read More

The secret behind a non-technical user joining 20 tables across 20 systems in a single query is a modern software architecture we call Nexus. We provide Nexus software for the user’s desktop or laptop with an option to schedule jobs on a Nexus Server, which is software that companies install on a windows server on-premises…

Read More

For the record, I am not the world’s greatest data scientist. I am 63 years young, but I will celebrate 50 years of working in the computer industry in three years. People continue to tell me I am the greatest data scientist the world has ever known, but it is not true. I only appear…

Read More

For almost 30 years, the largest companies in their vertical have trusted Tom Coffing and the Nexus for their data warehouse books, training, and software. Tom’s Nexus development team has been evolving and improving the product for 18 years with a mission to query all systems, migrate data between any two systems, and join data…

Read More

Migrate to Postgres, use advanced analytics, and save money. This blog teaches you how to use the ROW_NUMBER ordered analytic to find specific rows. Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual? Use the ROW_NUMBER analytic…

Read More

My team and I celebrate Halloween by using Nexus to do a 15-table join across 15 different systems in a single query, which has taken us 18 years to accomplish. Scary, but slow and steady wins the race! In this example, Nexus joins tables across the cloud, enterprise data warehouse, legacy, OLTP, and open-source systems…

Read More

You have data in about 18,000 places, and you know that if you could integrate the right data, you are minutes away from world domination. You are two minutes away from understanding that migration across all systems is now an automated process. It took almost 20 years to make the Nexus software act like a…

Read More

So, you are moving to the cloud to save money. Save even more money by mixing your Teradata, Oracle, and Snowflake systems with inexpensive and open-source systems like Hadoop, MySQL, Aurora, Athena, and Postgres, also available on the cloud. The biggest hurdle is fear and uncertainty because 95% of people don’t know how easy migration…

Read More

Are you considering migrating from Oracle to Amazon Redshift? Smart move! Converting the table structures and data types from Oracle to Redshift takes seconds with Nexus. Building the load scripts for each table takes the Nexus half a second. Large Oracle systems can take time because many companies want to gradually migrate the data to…

Read More

Are you considering migrating from Oracle to Postgres? Smart move! Converting the table structures and data types from Oracle to Postgres takes seconds. Building the load scripts for each table takes seconds. Large Oracle systems can take time because many companies want to gradually migrate the data to Postgres. Another smart move! So, customers also…

Read More

Only one query tool is so sophisticated that a business user with no technical knowledge can migrate 20 different database platforms to Snowflake or between any two database systems. You are about to see a video of how business users are migrating data to Snowflake with the click of a button in the blink of…

Read More

Survival is not the norm; it’s the exception. Humans have evolved more than any other species on Earth. Plants, insects, fish, and other mammals are beautiful, but humans are the dominating force. Nothing evolves faster in today’s world than business because of the power of data and analytics. A company’s survival and the survival of…

Read More

Thomas Edison spent 10,000 hours testing to build one of the great inventions of all time, the electric lightbulb. As a kid, I dreamed of becoming Thomas Edison, not Thomas Coffing, but I have spent what seems like 1,000,000 hours attempting to get all databases to integrate seamlessly. It took Thomas Edison two years to…

Read More

I will always be grateful to HCSC, Blue Cross Blue Shield of Illinois, Texas, and New Mexico for sponsoring my company to build customized software back in 2002, which gave me the start I needed.

Read More

Johnny Cash on Snowflake Cache saving Cash I hear the train a comingIt’s coming round the bendMy second Snowflake queryFlies faster than a wrenI’m stuck in Snowflake Heavenand time travel keeps rolling backwhen I hear that whistleblowingI know my Cache saves Cash The Snowflake architecture consists of cloud services, virtual warehouses, and data storage. Cloud…

Read More

Let me once again explain the rules. Snowflake rules when it comes to unstructured data. Tera-Tom Coffing, Teradata and Snowflake guru, will explain Snowflake unstructured data with great structure. Read the last blog of this series here.

Read More

In the example below, the current_date will return today’s date.  Add or subtract a number from the CURRENT_DATE, and you are adding or subtracting days from the date.  If you subtract from two dates, you get the number of days between the two dates. The Dateadd command below adds a specified time interval to a…

Read More

I am fortunate to have the experience of working with one of the largest insurance companies in the world on a big data cloud migration project. This particular company, which I will call big insurance, has one side of their company utilizing a Teradata enterprise data warehouse and the other a Netezza enterprise data warehouse.…

Read More

Snowflake PDF is a masterpiece by Tom Coffing and Dave Cook. Tom Coffing is considered the best technical book author in the world. Tom has written over 75 books on the architecture and SQL of all major database platforms. The Snowflake book is possibly his best work, and Tom’s co-author Dave Cook is the mastermind…

Read More

There is no such thing as a free lunch, but there is free analytics! If you break down an analytic, it is nothing more than math running against a data set. Most vendors have the same fundamental analytics, but each has a few analytics that only they provide. That is when the idea hit me…

Read More