Live Access source schema and compound tables
Live Access Source Schema
Birst provides the ability for Enterprise users to change the schema of a Live Access source. Schema names are changed on a per object basis, but similarly to caching options, can be mass updated for all objects in each connection.
The schema name can be changed for tables or compound tables. For query-based objects, you must update the query itself if the schema name needs to be changed.
The schema name can either be a string to denote a static schema name, or a variable, enter in the format V{variable_name}.
![](msa1655272147755.png)
Live Access Compound Tables
Live Access Compound tables allows the capability to take multiple tables and merge them in a join transformation sense.