Hello!

I'm new to Databricks.

Assume, I need to migrate 2 Tb Oracle Datamart to Databricks on Azure. Serverless SQL Warehouse seems as a valid choice.

What is a better option ( cost vs performance) to store the data?

Should I upload Oracle Extracts to Azure BLOB and create External tables?

Or it is better to use COPY INTO FROM to create managed tables?

Data size will grow by ~1 Tb per year.

Thank you!