Need help deciding domain change

My company recently offered me (an intern) to become a cloud database engineer and I have been highly conflicted whether it would be good for my future or not as I am in a full stack role currently. I am fairly comfortable with learning new things and have experience with both SQL and PostgreSQL and want to know if it would be the right choice for me to switch domains as I am a fresher and have little to no knowledge about the future scope of this role. I am mostly concerned whether I would be able to find jobs in the future for this role or can I expand more into the cloud domain by getting into this role. Any help is appreciated.