@Rama There are 2 things in terms of photon
1. Interactive cluster (we need to enable when you config or edit your cluster )
2. SQL warehouse (by default it is enabled)
it is beneficial when you have long running queries and performance can be improved, photon does'nt support ML and it has few limitations
karthik.p