Icon

FEATURE_​OMNI_​040

create or replace temp table _fo21_90d as from ( select '$${Sd}$$' as DAY_ID ,customer_id ,max(FEATURE_OMNI_0512) as kh_login_success_abbank_90d ,max(FEATURE_OMNI_0513) as kh_login_failed_abbank_90d ,max(FEATURE_OMNI_0514) as kh_login_initiated_abbank_90d ,max(FEATURE_OMNI_0515) as kh_login_abbank_90d from feature_omni_021 where day_id > ('$${Sd}$$'::date - interval 90 day)::date::string and day_id <= '$${Sd}$$' group by customer_id ) create or replace view fs_result as select DAY_ID ,CUSTOMER_ID ,kh_login_success_abbank_90d as FEATURE_OMNI_0625 ,kh_login_failed_abbank_90d as FEATURE_OMNI_0626 ,kh_login_initiated_abbank_90d as FEATURE_OMNI_0627 ,kh_login_abbank_90d as FEATURE_OMNI_0628 from _fo21_90d order by 1, 2 @contain folder path copy fs_result to '$${Sfs_filepath}$$' ; FEATURE_OMNI_040 Node 4590 create view if not exists FEATURE_OMNI_021 as from read_parquet('/Users/toannk986/abb/Feature Store EOM/Data/FEATURE_OMNI_021/*.parquet') DB SQL Executor DB SQL Executor Create Folder DB SQL Executor Feature File Path Workflow Input dim_date v2 duckdb memory DB SQL Executor create or replace temp table _fo21_90d as from ( select '$${Sd}$$' as DAY_ID ,customer_id ,max(FEATURE_OMNI_0512) as kh_login_success_abbank_90d ,max(FEATURE_OMNI_0513) as kh_login_failed_abbank_90d ,max(FEATURE_OMNI_0514) as kh_login_initiated_abbank_90d ,max(FEATURE_OMNI_0515) as kh_login_abbank_90d from feature_omni_021 where day_id > ('$${Sd}$$'::date - interval 90 day)::date::string and day_id <= '$${Sd}$$' group by customer_id ) create or replace view fs_result as select DAY_ID ,CUSTOMER_ID ,kh_login_success_abbank_90d as FEATURE_OMNI_0625 ,kh_login_failed_abbank_90d as FEATURE_OMNI_0626 ,kh_login_initiated_abbank_90d as FEATURE_OMNI_0627 ,kh_login_abbank_90d as FEATURE_OMNI_0628 from _fo21_90d order by 1, 2 @contain folder path copy fs_result to '$${Sfs_filepath}$$' ; FEATURE_OMNI_040 Node 4590 create view if not exists FEATURE_OMNI_021 as from read_parquet('/Users/toannk986/abb/Feature Store EOM/Data/FEATURE_OMNI_021/*.parquet') DB SQL Executor DB SQL Executor Create Folder DB SQL Executor Feature File Path Workflow Input dim_date v2 duckdb memory DB SQL Executor

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: toannk986
Created at: 2025-07-15
On NodePit since: 2026-06-09
Last update: 2026-06-09
Created with KNIME version: v5.5.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!