That is correct. Unity catalog designates a storage location for all data within a metastore so when you save as a table it is stored in an ADLS account.

This would create a managed table which means that data and metadata are coupled. i.e. if I drop the table the data is also deleted.

If you create an external table then they are decoupled. i.e. if I drop a table then the data is still available in storage.

I would recommend reaching out to yours or your customer's Databricks account team to learn more and help with the overall architecture.