Issue creating a MS SQL Server instance on GCP using Terraform

I was trying to create a MS SQL Server Instance in GCP, I’m having issues with the root_password parameter. I was able to create the instance using Provider=Google-beta where i had to provide the root_password. But when i’m trying to create in Provider=gooogle (the latest version), i’m having an error regarding root_password. If I add the parameter root_password, Terraform plan gives an error saying root_password is not expected here. I f i remove it Terraform Plan works but when i run Terraform apply it gives a error saying missing parameter Root Password. If I add it and run terraform apply it says root_password is not expected here. Can someone please help me out on how to fix this issue.