Batch edit changes settings on many Warehouse tables or transformations in one grid, instead of opening each one. Use it to move tables into a logical model, change who can read a group of tables, or switch off the schedules of a whole model.
The place you open Batch Edit from decides which rows the grid shows.
If the popup cannot tell which table type to use, it shows Error: No table type selected with a Close button. Close it and open Batch Edit again from the tree.
The tree and its toolbar are described on the Warehouse workspace tour, the row menus on Right-click menus. To create the source systems and logical models you assign here, see Semantic sources, source systems and logical models.
Use the Tables and Transformations tabs to switch modes. Each tab shows how many rows the scope holds. Batch Edit opens on Tables.
While the popup loads, it shows Loading batch edit. If the load fails, it shows Failed to load batch edit data with the reason; close the popup and open Batch Edit again.
To change one row only, edit it without ticking any checkboxes, or leave only that row ticked.
A change copies only to rows where that column applies. Query Settings and Status change one row at a time.
Long lists are paged: the grid opens at 50 rows per page, and you can switch to 20, 100 or 500.
Some columns appear only when a table in the scope needs them. If the scope holds no tables, the grid shows No tables found. These columns can be edited:
| Column | What it does |
|---|---|
| Logical Models | Assigns the table to one or more logical models. An empty cell shows Logical models…, and the value copies to the ticked rows. |
| Source Systems | Links the table to one or more source systems. An empty cell shows Source systems…. Not available for Views: the cell is locked and says Views do not have source systems. |
| Permission Groups | Sets the groups that can read the table. An empty cell shows Add groups. The admin group is always included. |
| Refresh Interval and Refresh Unit | Sets how often the table refreshes. Units are Minute, Hour, Day, Week and Month, and empty cells show Interval and Unit. Only for Dictionaries and for Refreshing or Appending views; other tables keep the cell locked with Available for Dictionaries and Refreshing/Appending views. |
| Name | Click the name to open the table. The comment icon next to it opens Description, where you write the table's description. |
These columns are read-only:
Permission groups decide who can read a table. Check the ticked rows before you save a change to their permission groups.
While the transformations load, the grid shows Loading transformations; a scope with none shows No transformations found. These columns can be edited:
| Column | What it does |
|---|---|
| Schedule | Switches the transformation's schedule between Enabled and Disabled. |
| Synchronize Days | Sets how many days each run synchronizes. Only for Fact transformations with a periodic pattern; other rows keep the cell locked with Only for Fact periodic patterns. |
| Full Reload When Partition Empty | Switches between Enabled and Disabled. Only for Fact transformations with a periodic pattern. |
| Loop Increment Value | Sets the back-fill step size. Shown for the periodic loop pattern, and for the other periodic patterns when Full Reload When Partition Empty is Enabled. |
| Query Settings | Opens the query settings dialog for the transformation. The cell shows Configure or Configured. Only for Fact and Dimension transformations; other rows keep the cell locked with Query settings are available for Fact and Dimension transformations. |
These columns are read-only:
For the patterns and what each setting does, see Transformation patterns and load settings.
For the full list of Warehouse permissions, see Warehouse permissions and row-level security.
Right-click the logical model, semantic source, source system or table type in the tree and choose Batch Edit. The grid then covers only the tables in that scope, and the popup title names it. From the tree toolbar, Batch Edit covers every table.
The popup could not tell which table type to use. Click Close, then open Batch Edit again from the tree.
How many rows the scope holds in each mode: Tables counts the tables, and Transformations counts their transformations.
A change copies only to ticked rows where that column applies: refresh settings reach only Dictionaries and Refreshing or Appending views, source systems never apply to Views, and periodic settings reach only the transformations that have them. Other rows keep their value. Query Settings and Status change one row at a time.
No. A transformation's pattern cannot be changed after it is created, so the Pattern column is read-only in Batch Edit. See Transformation patterns and load settings to choose the right pattern when you create a transformation.
Right-click the logical model in the tree and choose Batch Edit. Choose Transformations, tick the rows you want to change, click the Schedule toggle on one of them so that it shows Disabled, then click Save. The change is copied to the other ticked rows.
Views do not have source systems, so their Source Systems cell is locked: Views do not have source systems. Change the source systems on the other table kinds instead.
Refresh Interval and Refresh Unit apply only to Dictionaries and to Refreshing and Appending views. For other tables the cell is locked with Available for Dictionaries and Refreshing/Appending views; set how often the table refreshes from the table's own popup instead.
It shows the semantic sources behind the table's source systems. It is derived from those source systems, so it is read-only and says Derived from source systems. To change it, change the table's source systems.
The cell is locked, or there is no value for it. Locked cells show - and say why they cannot be changed.
Yes. One save carries at most 500 updated tables and 500 removals, and if a table is both updated and removed in the same save the removal wins.
Click the comment icon next to the table's name. The icon appears on hover when the table has no description, and stays highlighted when it has one. Type the text in Description and click Save; Clear removes the description.