The closest parity would be about 400 DBU on 8 core. the assumption is of same source and same SQL query in notebook. Also, the DC region has an iota of contribution to the speed. An assumption also includes the cost is out of the equation.
Yes we can, If the jobs run are low on CPU and use same data mart. However, the performance takes a beating if the tuning is not on auto mode for increase in Delta load.
Python is the choice for the ML/AI workloads while SQL would be for data based MDM modeling. Pretty much similar performance with certain assumptions. DB optimization is a must assumption for performance benchmarking.
