Hello, I am vetting different solutions for our particular use case. We have multiple customers with their own on-premise databases as well as customers with their data in the cloud. We are beginning the process of curating relevant datasets from these databases (which have almost identical schemas) and piping them into the cloud to use as a data source for a saas analytics platform such as redash as well as embedded analytics into our existing software.
My question would be: is it possible to have a single instance hosted in the cloud or through redash that can partition our users based on which organization they are a part of and only allow a user from a particular organization to view that organization’s data?
or, must we set up an instance per customer in order to use redash for our purposes?
Thanks!