INSERT INTO

Function

Inserts one or more rows of data into a table.

Syntax Format Supported for Lineage Parsing

INSERT INTO/INSERT OVERWRITE INTO {schema_name}.{table_name}

Example Statement 1

INSERT INTO mySchema.tbl_1(code, title) SELECT code, title FROM mySchema.tbl_2 WHERE date_prod < '2026-05-07';

Example Statement 2

INSERT INTO mySchema.inner_order (region, product, product_units, product_sales) 
WITH 
regional_sales AS (SELECT region, SUM(amount) AS total_sales FROM mySchema.orders_1 GROUP BY region), 
top_regions AS (SELECT region FROM regional_sales WHERE total_sales > (SELECT SUM(total_sales)/10 FROM regional_sales))
SELECT region, product,SUM(quantity) AS product_units, SUM(amount) AS product_sales FROM mySchema.orders WHERE region IN	(SELECT region FROM mySchema.top_regions) GROUP BY region, product;