Change Connected Table Owner

I did this somewhat recently, and if I remember correctly, you would have make a new connection and then reconnect the table. There is not much down time, you make the connection, then just switch it over, but I understand the annoyance. You also have to transfer ownership of Pipelines and Automations. If you use 3rd party add-ons....the list goes on.

My solution? Don't transfer anything. Change your account email and name to the Service Account. Then, simply create a new account for your personal email.

I did this and it worked almost flawlessly. The only slight annoyance is the name in the pipelines never changes. It all works just fine, it's just that I changed my Name (Mike) to the Name 'Service_Account'. When I log in to the service account pipelines, it still says 'you are using the Pipelines of Mike'.

Small annoyance, but worth it for the ease of everything else.