The Lake Builder Mind

The Lake Builder Mind does an import for you the way a Lake Administrator does it by hand, with the same steps and the same checks. It reads your source, imports the tables you choose, sets them up and loads them. You supervise every build: anything that touches the running Lake waits for your decision.

How a build runs, step by step

  1. Reuse the connector. It looks for a connector that already covers the source, reads it and works from there. It never creates one; you add the data source first, on Add a data source.
  2. Read the source and propose the tables. It walks the source's structure, sizes the candidate tables and proposes the list that fits your request, before anything is imported.
  3. Import the tables. Importing registers each table in the Lake; no data is loaded yet. See Import tables.
  4. Save comments and primary keys. It proposes a primary key and column comments from what the source shows, and saves what you settle on. Deploying needs at least one primary key.
  5. Deploy. It deploys each table once its key is in place. See Deploy a table.
  6. Set the load pattern. The starting point is Full Reload (Truncate Insert), the same name the Sync Type list shows. It chooses from what you ask for, never moves a table to an incremental pattern on its own, and uses a snapshot pattern only when someone asks for one. See Choose a sync type.
  7. Set the workflow. It places the tables in the workflow that runs their loads. See Workflows in the Lake.
  8. Run and verify. It starts a load and waits for the run to finish, then checks the result in its own reads (see below). Runs and their logs live on Run, stop and troubleshoot loads.
  9. Hand the schedule to you. Switching the schedule on is a person's step in the Lake. The build ends with a report that names what was built and what is left for you.

What it asks before it acts

While a step waits for a decision, the chat shows Awaiting human approval. This action has NOT been executed., and the build continues only after you decide. Reject the card and nothing is executed: the call then reports that an administrator rejected it (A Datawarehouse Administrator rejected this action). The cards themselves are on Change approval in a builder chat.

Which steps wait is set by the chat's mode:

The modes, who may set them and what each needs are on Warehouse Builder and Lake Builder. Two more rules apply:

Outside Unrestricted, a step that removes rows or objects is asked for alone: it reads the target first and states what would be lost before its card appears. It never asks for permission in the chat text itself; the approval card is how it asks.

What stays with you

How the result is checked

A build is not called done because it should work. Each step is checked with a read of the real thing:

When everything checks out, the build is reported as done, with the tables, their state and what is left for you. Anything less is reported as still running, waiting on you, or stopped by something you need to clear.

If a load fails, the Mind reads the failure first and changes one thing at a time. A cause inside the connector goes to the connector's own Mind, and that fix counts as done only when its report arrives and the reload and checks here pass. The same error that survives three attempts ends the attempt and comes back to you as a question with what was found.

Questions, answered

How do I start an import with the Lake Builder?

Open a chat with the Lake Builder Mind and describe what you want in the Lake. It reads the source first, states back what it understood and asks for one confirmation before it builds. See Warehouse Builder and Lake Builder.

Why does it ask me to confirm the tables before it builds?

So a wrong reading is caught before anything is imported. It states the task back with concrete choices, such as Correct, build it, Different tables or Different connector. When your message already leaves no doubt, it goes ahead.

Can it create a new connector for me?

No. You create the connector in the Lake, and credentials go into its form, never into the chat. It works from a connector that exists and imports the tables from it. If a connector needs work of its own, such as a custom connector or an API recipe, the task is handed to that connector's own Mind. See Manage connectors from a chat.

What does "Awaiting human approval. This action has NOT been executed." mean?

A step is waiting on its approval card, and nothing has run. Decide on the card: approve it and the step runs as you; reject it and the change is not made, with the call reporting that an administrator rejected it (A Datawarehouse Administrator rejected this action). See Change approval in a builder chat.

Which load pattern will it choose for a table?

It starts from Full Reload (Truncate Insert) and picks from what you ask for: a rolling window that must accumulate leads to an upsert, a one-off load to Onetime. It never moves a table to an incremental pattern on its own, and snapshot patterns are used only when you ask for one. All the patterns are on Choose a sync type.

How do I know a build is finished and its load worked?

It checks before it reports: the deployed state is read back, the run is read once it has finished, and the rows are counted from the table itself. A build is reported as done only when every step is met, including the verified load; anything less says what is still running or waiting for you.

What happens when a load fails?

It reads the failure first and changes one thing at a time, then loads and checks again. If the cause is in the connector, the connector's own Mind takes that work, and the fix counts as done only after its report and a clean reload here. When the same error survives three attempts, the Mind stops and comes back to you with what it found.

Can it approve a new host or a table grant?

No. Approving a host or a data access grant is a person's decision, made with the admin role in the connector's Hosts list or its Data access section. The Mind can revoke an approved host, but it cannot approve one. See Hosts, streams and data access.

Can it set up row-level security?

No. RLS is configured by hand in the table's RLS step, and the Mind neither reads nor changes it; it also never reports a table as having RLS set. See Conditions and row-level security.

Does it notice rows deleted in the source?

No. No sync type detects a source deletion, and the Mind never offers delete detection. What happens to a deleted row depends on the table's pattern, and the Mind says so plainly before it relies on an incremental pattern. See Choose a sync type.