Good morning! I have a similar case:
I have an external table to which I apply a row filter, in our data flow the first step is to check if the table actually exists and otherwise create it at a said location.
So the SQL statement will be like:

 create table if not exists <catalog>.<schema>.<table_name>
()
partitioned by(`<partition_column>`)
location 'abfss://<external_location>'

If the table exists and the Row filter is applied to the table, it will throw an error.

As you can see, we're using unity catalog. Any tips/best practices?