Deploy a table

Deploying builds a table in the Lake with its current column configuration. Until a table is deployed, parts of its popup stay locked. This page covers deploying from the table popup and the changes that drop and recreate a deployed table.

Deploy from the table popup

  1. Open the table: double-click it in the Lake tree, or right-click it and choose Edit.
  2. A banner above the form reads This table is ready to deploy. Deploy to access settings and lake preview. Click Deploy. While the deploy runs, the button reads Deploying.
  3. A notification reports the result, with the message the server returns.
  4. The Settings tab opens and the Lake mode of Preview unlocks.

One banner shows at a time: a deploy error comes first, then the primary-key notice, then the ready notice. The popup deploys this table only; to deploy several tables together, see Deploy tables.

Add a primary key first

A table needs at least one primary key column to deploy. Without one, the banner reads Primary key required. Define a primary key column before this table can be deployed. and offers Go to Columns:

  1. Click Go to Columns.
  2. Tick PK on the column that identifies each row.
  3. Click Apply, then click Deploy in the banner.

The key check comes first: while the table has no key, the popup asks for one even when the table is otherwise ready to deploy. Set up a table's columns covers the PK flag and its rules.

Why the Settings tab is locked

Until a table is deployed, its Settings tab shows Table Not Deployed with Deploy this table to access settings. Deployment creates the table in the lake with your current column configuration. The Lake mode of Preview stays unavailable with the tooltip Deploy the table to preview lake data, and Refresh stays disabled.

If the table also has no primary key, the tab shows Primary Key Required with This table must have at least one primary key column before it can be deployed. Define a primary key in the Columns tab to continue. instead.

Deploy the table and the locked parts open; see Preview table data and Run, stop and troubleshoot loads.

When a deploy fails

A failed deploy shows an error banner above the form. The whole banner is clickable, and it offers:

The notification uses the first failed reason, or Failed to deploy table when the server gives none. For the messages and their fixes, see Lake troubleshooting.

Changes that drop and recreate a deployed table

Some changes to a deployed table cannot be applied in place. The table is dropped and recreated, and its existing data is permanently lost. Each of these changes asks for confirmation first:

You changeThe dialogWhat it warns
The sync type to one in another DDL familyChange DDL Type from {old} to {new}?This will drop and recreate the table. All existing data will be permanently lost.
The Date Column of an incremental tableChange Date Column?The same data-loss warning.
A primary key or partition column's definition: key status, data type or data domainPrimary Key Change DetectedThe dialog warns that the change drops and recreates the table and all existing data will be permanently lost, then asks Do you want to proceed?

A sync type change inside the same DDL family still confirms with Change sync type from {old} to {new}?, without the data-loss warning; the change applies after you confirm. A table that is not deployed yet changes sync type with no confirmation. See Choose a sync type for the families, and Configure a table for what a sync type change updates.

Warning

A drop and recreate cannot be undone, and the table holds no data until its next load. Run the table again after the change; see Run, stop and troubleshoot loads.

Permissions

Deploying needs Add/Modify Lake Objects, like saving the table's settings. See Who can do what in the Lake.

Questions, answered

How do I deploy a table from its popup?

Open the table, then click Deploy in the banner that reads This table is ready to deploy. When the deploy finishes, the Settings tab and the Lake preview open. The popup builds this table only; to deploy several tables from the tree, see Deploy tables.

Why does the popup ask for a primary key before deploying?

A table cannot be deployed without at least one primary key column. The banner reads Primary key required. Define a primary key column before this table can be deployed. Click Go to Columns, tick PK on the column that identifies each row, and click Apply. See Set up a table's columns.

Why does the Settings tab show Table Not Deployed?

The table has not been deployed yet. The tab opens once it is: Deploy this table to access settings. Deployment creates the table in the lake with your current column configuration. The Lake mode of Preview and Refresh unlock with it.

Which sync type changes drop and recreate a deployed table?

Moving to a sync type in another DDL family, for example from Full Reload (Truncate Insert) to Full Reload (Upsert), drops and recreates the table after you confirm Change DDL Type from {old} to {new}?. The dialog warns that all existing data will be permanently lost. A change inside the same family confirms without the warning.

Why am I asked to confirm a Date Column change?

The confirmation appears on a deployed table that already has a date column. Changing the Date Column drops and recreates the table, so the popup asks Change Date Column? and warns that all existing data will be permanently lost. After the change, the table loads fresh data on its next run.

Which column edits trigger Primary Key Change Detected?

On a deployed table, the dialog appears when a column's PK or partition status changes, or when a column that is a primary key or partition column changes its data type or data domain. It warns that the definition change drops and recreates the table, and asks whether to proceed; cancel the dialog to keep the table as it is.

My deploy failed. Where can I see why?

The error banner above the form holds the message; click it or View details to read the full error. Redeploy retries this table. If the server gave no reason, the notification reads Failed to deploy table. For the messages and their fixes, see Lake troubleshooting.

A change dropped and recreated my table. How do I get the data back?

The previous data is gone; the table holds nothing until its next load. Run the table again from the Settings tab, or let its workflow run. What the next run reads depends on the sync type. See Run, stop and troubleshoot loads and Choose a sync type.