We were checking that and figured out that only unity catalog enabled workspace we can execute local code on databricks using databricks connect.