https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28023#M19861 <P>A workaround could be to disable access to that table to the user who is connecting.</P> Sun, 16 Oct 2022 17:58:21 GMT Hubert-Dudek 2022-10-16T17:58:21Z https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28022#M19860 <P>Hi there,</P><P></P><P>I am using <B>apply_changes </B>(aka. Delta Live Tables Change Data Capture) and it works fine. However, it seems to automatically create a secondary table in the database metastore called <B>_apply_storage_changes_{tableName}</B></P><P></P><P>So for every table I use <B>apply_changes </B>with I get two tables. For example, if I create a table called <B>item_prices_history</B>, I will get two tables in the database...</P><P></P><P>1) <B><I>item_prices_history</I></B></P><P>2) <B><I>_apply_storage_changes_item_prices_history</I></B></P><P></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/1380i7DD03E681A056522/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>&nbsp;</P><P>This is an issue because Power BI users are getting confused about the purpose of these tables. Ideally the <B>_apply_changes_storage_{tableName} </B>would not reside in the database. </P><P></P><P>Here are the tables in Power BI:</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1384i3861BD9DEB5EF526/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>Is there a way to stop the tables prefixed with <B>_apply_changes_storage </B>being created when using <B>apply_changes</B>?</P><P></P><P>Please note, I am using Azure Premium pricing tier (PySpark)</P> Tue, 11 Oct 2022 10:26:13 GMT https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28022#M19860 J_M_W 2022-10-11T10:26:13Z https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28023#M19861 <P>A workaround could be to disable access to that table to the user who is connecting.</P> Sun, 16 Oct 2022 17:58:21 GMT https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28023#M19861 Hubert-Dudek 2022-10-16T17:58:21Z https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28025#M19863 <P>Hi - Thanks @Hubert Dudek​&nbsp;I will look into disabling access for the users!</P> Fri, 18 Nov 2022 14:56:48 GMT https://community.databricks.com/t5/data-engineering/databricks-is-automatically-creating-a-apply-changes-storage/m-p/28025#M19863 J_M_W 2022-11-18T14:56:48Z