Came across this as I hit the same error. The documentation suggests that using classic compute is supported, albeit in beta  - https://learn.microsoft.com/en-gb/azure/databricks/ingestion/lakeflow-connect/query-based-overview#c...