Update on CTE

MC97 — Wed, 30 Oct 2024 21:13:11 GMT

I am reflecting a business logic from on prem to azure databricks .
what on prem did is

created the table and after that updated .
I have to construct that as a single query .
Example

Create or replace table table1

with CTE 1 as (

) ,

CTE 2 as (

select some columns from cte1

) ,

CTE 3 as (

select some columns from CTE2

)

select * from CTE3

but there are some updates from on prem which I need to apply to CTE2 .
can I apply those updates after CTE2 before CTE 3 ?

Re: Update on CTE

VZLA — Thu, 31 Oct 2024 11:27:12 GMT

An actual "Update", it may not be possible, but have you consider and will something like this work for you? This is simulating updates within the query without actual UPDATE statements:

CREATE OR REPLACE TABLE table1 AS WITH CTE1 AS ( -- Your initial query for CTE1 ), CTE2 AS ( SELECT CASE WHEN condition THEN updated_value ELSE original_value END AS column_name, ... FROM CTE1 ), CTE3 AS ( SELECT * FROM CTE2 ) SELECT * FROM CTE3;

Feel free to clarify if there's a misunderstanding about the requirement. Meanwhile, hope it helps.

topic Re: Update on CTE in Get Started Discussions

Update on CTE

Re: Update on CTE