How to prevent creation of __apply_changes_* table creation during DLT create_target_table process

BenBauer
New Contributor III

Hey, we are using DLT along with SCD I via the create_target_table function.

It does actually not create the table as defined, but rather a view., however on top of the expected table we see system generated tables e.g.: __apply_changes_*

Is there a way to prevent this, as we don't want to present these tables to our users.

Furthermore, is there a way to enfore that delta live tables are manged tables?

Best Ben