Forum Discussion
Solved
Managed Delta Table Error
I am trying to create a managed table in lakehouse using NB with rows manually entered (SQL equivalent INSERT INTO) but I am getting this following error, i have no idea how to debug this. it seems t...
This issue can be solved by using tablebuilder api
Or maybe this could work (I asked ChatGPT how to create a similar table with SQL syntax)
%%sql
-- Step 1: Create the Table
CREATE TABLE watermark (
id INT,
schema_name VARCHAR(255),
table_name VARCHAR(255),
watermark_value TIMESTAMP,
full_path VARCHAR(255)
);
-- Step 2: Insert Data into the Table
INSERT INTO watermark (id, schema_name, table_name, watermark_value, full_path)
VALUES (1, 'lorem', 'ipsum', '0001-01-01 00:00:00', NULL);
-- Step 3: Update the `full_path` Column
UPDATE watermark
SET full_path = schema_name || '.'
|| table_name;