I am trying to design an executeQuerySynchronously() method. I first execute the query by make a POST request to execute the query Asynchronously, which returns a response including the statementhandle of that execution. I then keeps checking the status of that query by making a GET request to that statementHandle.
I was able to make the POST request, a response was successfully returned. However, I couldn’t make the GET request. And I got this error: “No default role has been assigned to the user, contact a local system administrator to assign a default role and retry.”
My question is: 1.Does a GET request absolutely need the role specified? If so, there’s nothing documented on Snowflake SQL API about specifying a role. The POST request has documentation however on specifying the role in request body. Or is it automatically assumed to use the default role?
2.Or is this error caused by other reason?
3.How do I solve this?