Features

Open Idea

DELETing from a table specific rows is quite common, and Re-Writing the whole table is an unnecessary workload on the DB. Please add the DELETE FROM functionality. Currently we are using SQL SCRIPT to achieve this. <a target="_blank" rel="noopener noreferrer nofollow" href="https://docs.databricks.com/aws/en/sql/language-manual/delta-delete-from">https://docs.databricks.com/aws/en/sql/language-manual/delta-delete-from</a> <a target="_blank" rel="noopener noreferrer nofollow" href="https://docs.snowflake.com/en/sql-reference/sql/delete">https://docs.snowflake.com/en/sql-reference/sql/delete</a>eg: Try to code this in Matillion<pre><code>DELETE P
  FROM Product P
  LEFT JOIN OrderItem I ON P.Id = I.ProductId
 WHERE I.Id IS NULL</code></pre>

Add DELETE FROM functionality

DELETing from a table specific rows is quite common, and Re-Writing the whole table is an unnecessary workload on the DB. Please add the DELETE FROM functionality. Currently we are using SQL SCRIPT to achieve this.https://docs.databricks.com/aws/en/sql/language-manual/delta-delete-fromhttps://docs.snowflake.com/en/sql-reference/sql/deleteeg: Try to code this in MatillionDELETE P
  FROM Product P
  LEFT JOIN OrderItem I ON P.Id = I.ProductId
 WHERE I.Id IS NULL

10705360@thyssenkrupp-materials.com

DELETing from a table specific rows is quite common, and Re-Writing the whole table is an unnecessary workload on the DB. Please add the DELETE FROM functionality. Currently we are using SQL SCRIPT to achieve this.  
  
[https://docs.databricks.com/aws/en/sql/language-manual/delta-delete-from](https://docs.databricks.com/aws/en/sql/language-manual/delta-delete-from)

[https://docs.snowflake.com/en/sql-reference/sql/delete](https://docs.snowflake.com/en/sql-reference/sql/delete)

eg: Try to code this in Matillion

    DELETE P
      FROM Product P
      LEFT JOIN OrderItem I ON P.Id = I.ProductId
     WHERE I.Id IS NULL



Add DELETE FROM functionality

Subscribe to post