If anyone has yet this same problem, I found out in my datastax astraDb database that I just had to wait a little. I guess the command works but doesn't tell you when is it it finishes creating the index, returning back an error if you're querying it and it isn't up yet