Forum Discussion
Lakehouse data discrepancy between notebook and SQL endpoint or Dataflow
Possibly related topic: https://community.fabric.microsoft.com/t5/Data-Engineering/Duplicated-rows-between-notebook-and-SQL-Endpoint/m-p/3707317
In that case (and another thread also https://community.fabric.microsoft.com/t5/Data-Engineering/Duplicated-Rows-In-Tables-Built-By-Notebook/m-p/3661271) the issue was not that the Notebook returned blank. However there was a discrepancy between data displayed in Notebook (which gave unexpected results) and SQL Analytics Endpoint (which gave expected results).
Do you get any error message when creating the dataframe? (I.e. table missing, table name not found, or something like that).
Or it just returns 0 rows?
Did you try querying the table using %%sql in the Notebook?
%%sql
SELECT * FROM tableName;
or
%%sql
DESCRIBE HISTORY tableName;
Hi,
Thank you for the links and your suggestion.
I do not receive any error messages when creating the DataFrame. There is no message indicating that the table is missing or that the table name was not found; it simply returns 0 rows.
I tried querying the table using %%sql in the Notebook with the following commands:
%%sql
SELECT * FROM tableName;
%%sql
DESCRIBE HISTORY tableName;
Both commands executed without errors, but the SELECT also returned 0 rows. The DESCRIBE HISTORY command showed a history consistent with recent modifications.