Thanks @yashag2255 for your reply, it's worked for me but I have an issue
There is a field in entites called owner I use owner to set permissions and privalages
in sql there is a field contains user_Id, I can map user_id to email but I can't migrate owner field
I'm completely new to CDS, but this doesn't appear to be do-able if you are using a On-premise Data Gateway?
I am finding it a bit unbelievable and hoping I'm just wrong because PowerApps, Flow, PowerBI is all built around CDS from my understanding, seems silly if all these can talk to a data gateway but CDS itself cannot get data from one!
Did I miss something?