topic The REFRESH TABLE command doesn't seem to invalidate the local cache. Am I missing something? in Data Engineering https://community.databricks.com/t5/data-engineering/the-refresh-table-command-doesn-t-seem-to-invalidate-the-local/m-p/34876#M25569 <P>Hi Team,</P><P></P><P>As part of "Data Enginering with Databricks" course section "DE 4.2 - Providing Options for External Sources", </P><OL><LI>I can read total number of records of sales_csv table as 10510. </LI><LI>The append command in Cmd17 is supposed to increase this number 2x, in my view</LI></OL><P>But even after running command 21, the count doesn't change.</P><P></P><P>Q1: Is my understanding correct on point 2</P><P>Q2: Is my observation correct, or it's something to do with my workspace</P><P></P><P>Image attached</P><P>regards,</P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1623i1A91A1AE1C73C1F3/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></P> Wed, 10 Aug 2022 21:13:56 GMT Jhaji 2022-08-10T21:13:56Z The REFRESH TABLE command doesn't seem to invalidate the local cache. Am I missing something? https://community.databricks.com/t5/data-engineering/the-refresh-table-command-doesn-t-seem-to-invalidate-the-local/m-p/34876#M25569 <P>Hi Team,</P><P></P><P>As part of "Data Enginering with Databricks" course section "DE 4.2 - Providing Options for External Sources", </P><OL><LI>I can read total number of records of sales_csv table as 10510. </LI><LI>The append command in Cmd17 is supposed to increase this number 2x, in my view</LI></OL><P>But even after running command 21, the count doesn't change.</P><P></P><P>Q1: Is my understanding correct on point 2</P><P>Q2: Is my observation correct, or it's something to do with my workspace</P><P></P><P>Image attached</P><P>regards,</P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1623i1A91A1AE1C73C1F3/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></P> Wed, 10 Aug 2022 21:13:56 GMT https://community.databricks.com/t5/data-engineering/the-refresh-table-command-doesn-t-seem-to-invalidate-the-local/m-p/34876#M25569 Jhaji 2022-08-10T21:13:56Z