Support for different table schemas from SQL Server in the TSDB
We have a SQL Server database containing flow survey and rainfall data. All of the raw data is saved in one table and views are created for each monitor via a stored procedure,
We use schemas to control permissions on the database tables. Only the database owner can add or delete to the raw table (dbo schema) while any user can read from the views ("user interface" schema).
Currently, TSDB can see tables in any schema but can only read from those in the default (dbo) schema. Therefore, an error happens when trying to read from a view that has the "user interface" schema.
Putting the views into the default schema limits the users that can update TSDB
It would be nice if TSDB could support other schemas from SQL Server.
1
vote
David Blades
shared this idea