Save and deploy Batch Edit changes

After you edit settings in Batch edit, use this page to save or revert them, read what each result message means, deploy a table from the grid and retry a row whose details failed to load. The Warehouse-wide message index is on Troubleshooting.

Save or revert your edits

  1. Change the cells you need in the Tables or Transformations grid.
  2. Click Save in the popup footer. It stays greyed out until at least one cell differs from its saved value, and it shows a spinner while the save runs.
  3. Read the message that follows. The table below lists each one.

Revert drops every unsaved edit in both grids and puts the rows back to their saved values.

Two checks can hold a save back while table rows load their details:

Wait for the loading to finish, or retry the failed rows, then click Save again.

Read the result of a save

You seeWhat it means
Saved, then All N item(s) updated successfully.Every edited row was saved.
Partially saved, then N of M item(s) updated.Some rows were saved and the rest failed. The failed rows keep your edits; open Failed Updates to see why.
Save failed, then No items were updated. Check the error bar for details.Nothing was saved. Your edits stay in the grid, and the failure list shows the reasons.
No changes, then There are no changes to save.The save found nothing left to send.
Saved, but the grid could not refresh, then The changes were saved. The rows will catch up when details finish loading.Your changes were saved; only the grid refresh failed. Rows update as their details finish loading.

After a clean save the grid reloads, and the saved rows load their details again.

Follow up on rows that failed

When at least one row fails to save, a button with the number of failures appears in the grid toolbar, and its tooltip reads N item(s) failed - click to view. Click it to open Failed Updates.

Each entry in the list:

Rows that failed keep their edits. Fix the cause in the table's or transformation's popup, then click Save again. Rows that saved show their new values.

Wait for row details, and retry a failed row

The Tables grid loads details for every row after it opens.

A row that has not loaded its details cannot be edited, and it blocks the save until it loads. Hover over Failed to read the reason (the fallback text is Failed to load table details), then click Retry to load that row again.

Deploy a table from the grid

  1. In the Status column, click Deployable on the row you want to deploy. The badge is clickable and its tooltip reads Click to deploy this table. A row that is already deployed shows Deployed instead.
  2. Read the confirmation. It asks Deploy table?, then Deploy "TableName" to the warehouse with the current column configuration?, with Deploy as the confirm button.
  3. Click Deploy. The confirmation cannot be closed while the deploy runs.
  4. Read the message. A success shows Table deployed successfully; if the deploy fails, the message names the reason, with Deploy failed as the fallback.

Deploying creates the table in the warehouse from its current definition; see Deploy, run, truncate and monitor tables for what deploying does.

After a successful deploy, the table stops showing Pending in the tree straight away, and its Status cell locks with This table is deployed and cannot be redeployed from here.

Deploying a table needs Add/Modify Warehouse Objects. See Warehouse permissions and row-level security.

Questions, answered

Why is Save greyed out?

Save and Revert stay greyed out until at least one cell differs from its saved value. Save also greys out while a save is running.

Why can't I save while table details are loading?

The grid needs each edited row's details before it can save its settings. If details are still arriving you see Still loading details; wait for the loading to finish, then save. If an edited row failed to load its details you see Table details not ready; click Retry in its Details cell, then save.

What does "Partially saved" mean?

Some rows were saved and some failed. Rows that saved show their new values, and rows that failed keep your edits. Open Failed Updates from the grid toolbar for the reason on each failed row, fix the cause, then click Save again.

My save failed. Are my edits lost?

No. When nothing was updated you see Save failed, and your edits stay in the grid. Open the failure list from the toolbar button, fix the reason it gives, then click Save again.

Where can I see which rows failed and why?

The grid toolbar shows a button with the number of failures, and its tooltip reads N item(s) failed - click to view. It opens Failed Updates: each entry names the row, shows the reason, and offers Edit to open that table or transformation. A transformation's entry carries (transformation) after its name.

What does "Saved, but the grid could not refresh" mean?

Your changes were saved; only the reload of the grid failed. The rows update to their new values as their details finish loading. If the grid still looks stale after that, close the popup and open Batch Edit again.

What does "Failed" in the Details column mean?

That row's details did not load, so the row is locked for editing until they do. Hover over Failed to read the reason, then click Retry to load the row again. A row without details also blocks the save.

How do I deploy an undeployed table from Batch Edit?

Click Deployable in the table's Status cell, then confirm in Deploy table?. A success shows Table deployed successfully, and the table stops showing Pending in the tree.

Can I deploy a table from Batch Edit once it is deployed?

No. A deployed row shows Deployed, and its Status cell is locked with This table is deployed and cannot be redeployed from here.

Does saving deploy the tables too?

No. Saving applies the edits you made in the grid, nothing more. Deploying is separate: it happens only when you click Deployable in the Status column, or deploy the table from its own popup.

Are my unsaved edits kept if I minimise or close the popup?

They are kept as a draft with that Batch Edit popup, so you can return to it and continue. The popup asks for confirmation before closing with unsaved changes, and a draft saved before a later update to the grid is discarded when the popup loads.