Import or Direct query

[NimaiAhluwalia]

Hey Guys,

I have a source databricks and I have 2 tables that consist of more than 62,312,943 rows each, so which mode of import would be preferable for me in this case

also in the same file, there are other 10 small tables with 1-2M rows each

Regards

[amitchandak · Accepted solution]

@NimaiAhluwalia , I vote for the composite Model. 😀

If that 60M row table is very thin(Not many columns) or you are on Premium, you can use import mode.