mhamedbenjmaa commented on issue #6907: URL: https://github.com/apache/hop/issues/6907#issuecomment-4185141755
Actually this is a killing feature it remove the need the think about dbt of stuff like that ,here how its suppose to work: lets assume a simple job input T1 --> derivation A*B --> sort by C -- FIlter (remove null on D) --> destination T2 you run the job by default ETL mode, all the suff is happening in the engine and then insert on T2 so far so good now we want to add ELT mode (for any reason , we are using snowflake , or we want to avoid igress or whatever reason) , if we check the box 'Run this job in ELT mode) apache hop will analyse the job components and instead of working as ETL it will generate this SQL Inset into T2 Select A,B,C,D,A*B as derivation from T1 where D is not null sort by C asc and push this SQL at the destination , BINGO we are in ELT Mode now , no engine, no data movement no nothing Major ELT vendor are proposing this feature now here an example https://dataplatform.cloud.ibm.com/docs/content/dstage/dsnav/topics/elt-mode.html?context=cpdaas -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
