No Accessible Data Message in SQL Runner

Hello!

We have a database which we are able to run queries on, but it shows up as “No Accessible Data” in the SQL Runner left panel. Do you know what could be going on here?

image

Hey Zachary!

Is this the schema that you have assigned write access to in your database? If so, you will see this “No Accessible Data” in SQL Runner for any schema that is the destination of write access.

Oh, yes it is! Why is that?

So the reason why is because if you want to reference the data that’s written back to the warehouse you should reference the sigma object, not the warehouse view. That is why we block access in the SQL Runner view!