I saw some posts that had the same issue but in those they couldn’t have a succesful test connection on the connector definition and even couln’t execute the discover/preview schema attributes. In my case I can execute those operations correctly, but then the aggregation fails:
The problem could be related to the privileges of the service account; make sure that the user has the permission needed. And also in schema you should have proper identity attribute. Besides this, please check the logs; you might find more details.
Thank you all @bhanuprakashkuruva , @arjun_sengupta and @enistri_devo you were right about the permissions, now it’s working! I was really confused 'cause you would spec to not have a correct test connection or schema discovery if you don’t have the correct permissions.