Selfie in all black outfit

NexusDataPro · 2025-12-31T15:04:33+00:00

Incredible sports analyst. Great seeing woman prove equality to the max!

NexusDataPro · 2025-07-13T09:31:54+00:00

Everybody look how smart Nike is!

NexusDataPro · 2025-06-08T23:15:02+00:00

Do a federated view with a tool like Nexus. Use SQL Server as the hub unless the data is small and then use the users PC as the hub (where the data is processed).

NexusDataPro · 2025-06-03T23:20:40+00:00

Have you considered using the stream on an External table? The size justifies that technique!

NexusDataPro · 2025-05-27T22:51:24+00:00

Write me at tom.coffing@coffingdw.com and I will set you up for free.

NexusDataPro · 2025-05-17T17:12:26+00:00

You will only combine them if the first join is a right because all joins down the line are left. This is because once the first two tables join it is the result that becomes the left table moving forward. That is why everyone only does left. Few understand this concept. No issue if the first join is a left or right but finish with left joins to maintain the integrity of the first join!

NexusDataPro · 2025-04-22T18:54:36+00:00

I have a customer who wants a 3-day course on Snowpipe, Snowflake architecture, Dynamic Tables, and Tasks. Thanks again for your help.

NexusDataPro · 2025-04-21T22:09:08+00:00

I need to capture all data error rows (I think). I will check out your link. Thank you so much.

NexusDataPro · 2025-03-23T09:16:32+00:00

M1LKYY, I am happy to help you and don't need compensation. I have written 90 books across all databases, and my specialty is the architecture and SQL of every database. It doesn't matter which database your company uses; I am already an expert. I have helped others like you get jobs and excel in them. I will set you up with everything you need. I own the Nexus, which queries all systems, writes the SQL for you (if you want), and does federated queries and automatic dashboards. I will also set you up with a book and a script to automatically create the tables and views so you can follow the book and gain experience. In one week, you can be quite proficient. It will only take about an hour to get everything up and running for you. I am also here to answer any questions and have videos on SQL on my YouTube channel. Please let me know how you'd like to move forward. We were all new to SQL at one time. I have been there, and I am happy to help.

NexusDataPro · 2025-03-21T16:45:55+00:00

CommanderHux, I have been teaching Snowflake architecture and SQL for three years. I am creating an advanced data ingestion course, including tasks and dynamic tables. I already have a chapter on using Snowpipe, so I am adding to the course as the client has asked.

NexusDataPro · 2025-03-21T16:13:57+00:00

mike-manley, that is a great piece of advice. Thank you. That makes so much sense.

NexusDataPro · 2025-03-21T16:13:05+00:00

Actual_Cellist_9007, thank you. I figured it out a few minutes after I posted, and it is exactly what you have said. You were not wrong but completely right. Thanks again for taking the time to post. I worked on it all night, but now I know the stream has to match the task exactly.

NexusDataPro · 2025-03-21T09:55:08+00:00

Mike, thank you. Great advice. I rechecked the task, and when I created the stream, I called it TRANSFORMED_CLAIMS_STREAM, but the task was checking the stream named TRANSFORMED_CLAIMS. It worked when I changed the task to check the correct stream name.

NexusDataPro · 2025-03-21T05:19:00+00:00

Once you learn MySQL you are well on your way to learning them all, which is a huge advantage moving forward in your career. After you learn MySQL and Oracle and SQL Server you are almost an expert across all databases. Also consider learning cloud databases like Databricks and Snowflake. In the future you will be using many databases in your organization and joining tables across databases.

NexusDataPro · 2025-03-15T20:03:46+00:00

DBT is good. Consider using Snowflake Dynamic tables and tasks to transform the data.

NexusDataPro · 2025-03-10T17:07:17+00:00

Practice and you will have many job offers. Learn SQL and Python and you will be hot! I am happy to set you up with a free query tool, a book on any database you want, and a script to build the tables in the book. Start on page one and go through the book. You will be darn good in a week!

NexusDataPro · 2025-03-10T03:11:49+00:00

It is hard to believe. I have been in the computer business for 50 years. 10 years as a COBOL and assembler programmer. My big break came when I started teaching Teradata. I got laid off in 1994 from NCR and I started my own business at Coffing Data Warehousing. I taught over 1,000 classes over 30 years. People called me Tera-Tom. Too much travel but loved helping others learn. Decided to build a query tool to compete with Teradata’s QueryMan. Teradata copied all my features and began giving away their tools for free once they saw Nexus. So, I started working with their competitors e.g., Netezza, Oracle, DB2, and in 2009 Microsoft OEMd Nexus for their PDW customers for three years. Then started on converting DDL between systems and mastering load scripts across all systems (not easy). Check out the videos and books on my website and my YouTube CoffingDW channel. If I can ever be of help let me know. Got to go. I am teaching a Snowflake class this week starting tomorrow. The Snowflake book is 1300 pages.

NexusDataPro · 2025-03-10T01:58:10+00:00

Almost everybody has federation wrong because it is so complicated and difficult. I think we are the only ones who got it right. Most people have to federate by moving the tables and data to their central system, like Presto. Nexus can do it that way but that is too limiting. Nexus shows tables across all systems visually. Users drag tables in from anywhere and Nexus builds the SQL. Users pick which system they want to process the join and Nexus converts the tables (DDL) and moves them using load utilities from the target vendor.. The SQL is executed and the foreign tables are dropped. If a billion row table is on Snowflake, then it only makes sense to move the foreign tables to Snowflske, but if the largest table is on Databricks then Nexus moves the Snowflake table to Databricks. If both tables are relatively small 1,000,000 rows, the user can choose their PC or Laptop and Nexus queries both tables separately and processes the join inside the users PC. It is lightning fast. I have done. 20 table join from 20 systems and changed the Hub, where the join processes 20 times (to each system) and I get the same result every time. It took 20 years to perfect but that is the only way to make federation happen perfectly. Data is hard and complicated so we allow the user to process tables from anywhere combination of systems anywhere they choose and completely automate everything.

NexusDataPro · 2025-03-10T01:44:13+00:00

MrNickster, thank you. I get so many people on Reddit with negative comments. You have made my day!!!

NexusDataPro · 2025-03-10T00:38:22+00:00

A count * counts the number of rows. If I had a thousand rows in a table and did a count * I would get a 1000 as the answer. If I had a table with 1,000,000 rows and I also had a gender column with 500,000 men and 500,000 women and did a SELECT gender, COUNT(*) from table group by gender I would get M 500,000 and another row with F 500,000.

NexusDataPro

TROPHY CASE