I've been doing some experimenting trying to get Phoenix-Spark to
read/write from a tenant specific view but have had no success. Judging by
the docs and from the source code I've looked at I haven't found any
options for connecting as the tenant, which is required when interacting
with a tenant specific view. Note, I am able to read/write to a multitenant
table, and I can use the predicate option for TenantId to filter on tenants
in the multi-tenant table, but I am not able to interact with a
tenant-specific view based off of that table when connected as a global
user (i.e. not connected as the tenant).
I can't use the multitenant table to for my use-case as the tenant specific
view has additional columns that the base table does not have.
Using DriverManager.getConnection(zkhost, props) where props has the tenant
id specified via TenantId=theTenantId I can connect as the tenant and read
and write to the view using plain Phoenix SQL, but it appears there is not
yet support for connecting as a tenant when using Phoenix-Spark
integration. I'm hoping someone can confirm.