I figured out what was causing the issue. Previously, my connection string included the database name at the end, like <connection_ui>/dbName, but when I copied the new private connection string from Atlas, this part was not included anymore, so I was effectively querying an empty database.
Lesson learned…