Hello all, 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, but I am not able to interact with a tenant-specific view based off of that table. Furthermore, 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. It appears there is not yet support for connecting as a tenant when using Phoenix-Spark integration. I'm hoping someone can confirm. Thanks, Nico
