Forum Discussion
Duplicated Rows In Tables Built By Notebook
I was seeing incorrect numbers after joining two tables together. I have isolated the issue as shown in the following example: I take the existing delta table named Rainbow_Accounting_Adjustments...
If you run this code in Notebook:
%%sql
SELECT COUNT(*) FROM Rainbow_Accounting_Adjustments
And this code in SQL Analytics Endpoint:
SELECT COUNT(*) FROM Rainbow_Accounting_Adjustments
You get the double number in Notebook?
I've created a workaround by using a separate notebook to drop the table each time before the Dataflow runs, createing a new table. Because of this I can't reproduce the problem at the moment.