We upgraded our account from P1 to F64 and it enabled us with lot of new capabilites. Adding a blob storage container to LH etc.
But moving data (lakehouse tables / sql endpoint) was not easy and was not just setting change (in workspace setting)
below workaround worked like a charm and I wanted to share with community if it can help someone that will be a +1 for all of us. :)