Here is what I have:
- 2 buckets, both of which are password protected
- a query that has a join between these two buckets
- Java SDK
I connect to one of the buckets, providing the password, of course. When I run the query I get an authorisation error.
I did some searching around, and people are suggesting removing the password, which is a poor solution. There has to be a better solution out there.