Domo Workbench importing too many rows
I'm importing a table from my DataWarehouse (Microsoft SQL server). The workbench is telling me it imported ~51M rows, but checking the database, I only have ~46M rows in the table. So it is somehow importing ~5M rows that don't even exist. Has anyone seen this?
0
Best Answer
-
Nevermind. It has been solved.
0
Answers
-
@rhettshipp, if you can post your solution to help others who might run into the same issue, that would be great!
1 -
We ended up having duplicate entries to no fault of the Domo workbench. We had a data problem causing our join key to be non-unique, so we ended up with about 5 million duplicate rows.
0
This discussion has been closed.
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部