#Datalake #GotSimplified

Data lake: queries, row changes, table structure and sharing (datalake_query, datalake_mutate, datalake_manage, datalake_share)

MCP Server URL

New to MCP? Learn how to connect this server in our Setup Guide → (Cursor, Claude, OpenCode, Windsurf, Goose).

What you can do

Create, move, change or drop data lake tables and roll them back to an earlier version.

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
columnsobjectoptional
Create table: the columns and their types, e.g. id as a number and name as text
partition_byarray of stringoptional
New tables: how to split the data for faster reads, e.g. by month or region (up to 3)

Example prompts

>Create a table for orders with id, customer and amount
>Create a sales table partitioned by month of order_date and region

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
column_namestringoptional
The column to add, rename or drop
data_typestringoptionaldefault: "string"
Add column: the type, e.g. text, whole number, decimal or date

Example prompts

>Add a discount column to the orders table

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
column_namestringoptional
The column to add, rename or drop

Example prompts

>Drop the old notes column from customers

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
column_namestringoptional
The column to add, rename or drop
new_column_namestringoptional
Rename column: the new name

Example prompts

>Rename the column qty to quantity in sales

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
target_namespacestringoptional
Move: the destination namespace
target_tablestringoptional
Move: the new table name

Example prompts

>Move the staging table into the reporting namespace

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
forcebooleanoptionaldefault: false
Drop a table even if it is protected from deletion

Example prompts

>Delete the old_logs table
>Force delete the temp_export table even though it is protected

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
cascadebooleanoptionaldefault: true
Drop namespace: also delete every table in it

Example prompts

>Delete the empty scratch namespace
>Delete the archive namespace and all its tables

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
target_snapshot_idintegeroptional
Restore: the earlier version to go back to

Example prompts

>Roll sales_orders back to yesterday's version

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
partition_byarray of stringoptional
New tables: how to split the data for faster reads, e.g. by month or region (up to 3)
confirmbooleanoptionaldefault: false
Set partitioning: preview first, then confirm to apply

Example prompts

>Partition the events table by day of event_ts

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on

Example prompts

>Show the saved versions of the sales table

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'. Letters of any language, digits and _
table_namestringoptional
The table to work on
snapshot_idsarray of integeroptional
Clean up: specific versions to remove
from_snapshot_idintegeroptional
Clean up: first version of the range to remove
to_snapshot_idintegeroptional
Clean up: last version of the range to remove
from_datestringoptional
Clean up: remove versions from this date
to_datestringoptional
Clean up: remove versions up to this date (inclusive)
older_than_daysintegeroptional
Clean up: remove versions older than this many days
keep_lastintegeroptional
Clean up: always keep this many of the newest versions
purge_historybooleanoptionaldefault: false
Clean up: remove all history and keep only the current version
confirmbooleanoptionaldefault: false
Set partitioning: preview first, then confirm to apply

Example prompts

>Keep only the last 10 versions of sales
>Delete versions older than 7 days from logs

Works with every action: wait (False (default): start the job and return a job id to check later. True: wait for the result)

Add, replace, upsert, update or delete rows in a table you own, with a safe preview before changes are applied.

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'
table_namestringrequired
The table to change, e.g. 'employee'
recordsarray of objectoptional
Rows to add or merge, for small batches
urlstringoptional
For insert/upsert/overwrite: link to a CSV, Parquet or JSON file
file_formatstringoptional
File type: CSV, Parquet or JSON (detected from the link if left out)
delimiterstringoptionaldefault: ","
CSV separator character (default comma)
partition_byarray of stringoptional
New tables: how to split the data for faster reads, e.g. by month or region (up to 3)

Example prompts

>Add these 20 rows to the customers table
>Load the orders file from this link into the orders table

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'
table_namestringrequired
The table to change, e.g. 'employee'
key_columnsarray of stringoptional
Merge: the columns that identify a row, e.g. id
recordsarray of objectoptional
Rows to add or merge, for small batches
urlstringoptional
For insert/upsert/overwrite: link to a CSV, Parquet or JSON file
file_formatstringoptional
File type: CSV, Parquet or JSON (detected from the link if left out)
delimiterstringoptionaldefault: ","
CSV separator character (default comma)
confirmbooleanoptionaldefault: false
Preview the change first, then confirm to apply it

Example prompts

>Update or add customers by their email address
>Keep the leads table in sync with this file

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'
table_namestringrequired
The table to change, e.g. 'employee'
recordsarray of objectoptional
Rows to add or merge, for small batches
urlstringoptional
For insert/upsert/overwrite: link to a CSV, Parquet or JSON file
file_formatstringoptional
File type: CSV, Parquet or JSON (detected from the link if left out)
delimiterstringoptionaldefault: ","
CSV separator character (default comma)
confirmbooleanoptionaldefault: false
Preview the change first, then confirm to apply it

Example prompts

>Replace all rows in the prices table with this new list

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'
table_namestringrequired
The table to change, e.g. 'employee'
wherestringoptional
For update/delete: condition selecting the rows, e.g. "id = 4"
set_valuesobjectoptional
Update: the new values, e.g. salary = 120000
confirmbooleanoptionaldefault: false
Preview the change first, then confirm to apply it
all_rowsbooleanoptionaldefault: false
Must be turned on when the change affects every row
max_rowsintegeroptionaldefault: 5000000
Safety limit on how many rows a large change may rewrite

Example prompts

>Change the status of order 1042 to shipped
>Mark all orders older than 90 days as archived

Parameters for this action

namespacestringrequired
The namespace (folder) of the table, e.g. 'hr'
table_namestringrequired
The table to change, e.g. 'employee'
wherestringoptional
For update/delete: condition selecting the rows, e.g. "id = 4"
confirmbooleanoptionaldefault: false
Preview the change first, then confirm to apply it
all_rowsbooleanoptionaldefault: false
Must be turned on when the change affects every row
max_rowsintegeroptionaldefault: 5000000
Safety limit on how many rows a large change may rewrite

Example prompts

>Delete duplicate rows from the leads table

Works with every action: wait (False (default): start the job and return a job id to check later. True: wait for the result)

Ask questions of your data lake, export results, and explore its namespaces and tables.

Parameters for this action

sqlstringrequired
The read-only query to run. Your assistant normally writes it for you from your question.
limitintegeroptionaldefault: 10
Maximum number of rows to return (default 10, -1 for all)
export_to_s3booleanoptionaldefault: false
Export the result to a file and return a temporary download link
export_formatstringoptionaldefault: "csv"
Export file format: 'csv' or 'parquet'
waitbooleanoptionaldefault: false
False (default): start the job and return a job id to check later. True: wait for the result

Example prompts

>Show total sales by region for last month
>List all tables in my data lake
>Which customers spent over 500 this year?
>Show the 10 most recent orders
>Count rows in the orders table per status
>Join customers and orders to show each customer's total spend
>Show the schema of the sales table
>List the namespaces I have

Share a table with another user via an independent grant (column and row restrictions), list your grants, or revoke one.

Parameters for this action

namespacestringoptional
The namespace (folder) of the table to share, e.g. 'hr'
table_namestringoptional
The table to share, e.g. 'employee'
share_withstringoptional
Email address of the person to share with (must have an active account)
permissionstringoptionaldefault: "read"
Read only (default), or write: the person can add, change or delete the rows they are allowed to see, but not change the table itself
allowed_columnsarray of stringoptional
Which columns the person may see (all by default)
row_filterstringoptionaldefault: "1=1"
For 'grant': condition limiting which rows the recipient sees (e.g. "department = 'Engineering'")

Example prompts

>Share my sales table with alex@example.com, region and amount only
>Share customers with sam@example.com, only EU rows

Parameters for this action

namespacestringoptional
The namespace (folder) of the table to share, e.g. 'hr'
table_namestringoptional
The table to share, e.g. 'employee'

Example prompts

>Show who I have shared tables with

Parameters for this action

grant_idstringoptional
The share to take back

Example prompts

>Stop sharing the sales table with Alex