cief/dbt_cloud
1
0
Fork 0
mirror of https://gitlab.com/cief-data/dbt_cloud.git synced 2026-08-19 04:14:00 +00:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • df36b5dc5b Merge branch 'add-column-order-refund-datetime' into 'main' main add-column-order-refund-datetime CIEF ACC1 2024-10-09 03:54:23 +00:00
  • 3b2a2555ae Added order refund datetime column to rep order table CIEF ACC1 2024-10-09 03:53:28 +00:00
  • f074644647 Merge branch 'fix-shipping-invoice-value-sum-error' into 'main' shipping-build-contacts fix-shipping-invoice-value-sum-error CIEF ACC1 2024-08-07 09:55:09 +00:00
  • a00089a40c Fix logic for summing invoice value CIEF ACC1 2024-08-07 09:53:15 +00:00
  • 82158d80dd Merge branch 'fix-shipping-stg-packages-node' into 'main' fix-shipping-stg-packages-node CIEF ACC1 2024-07-01 06:57:08 +00:00
  • d4ef402cb9 replaced model name in yml file CIEF ACC1 2024-07-01 06:56:18 +00:00
  • c35214025f Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into shipping-fix-order-created-datetime shipping-fix-order-created-datetime CIEF ACC1 2024-05-20 01:53:50 +00:00
  • 6bea95c49f Merge branch 'fix-exchange-service-type-rename' into 'main' fix-exchange-delivery-on-time-logic CIEF ACC1 2024-05-13 05:21:47 +00:00
  • ff552ebd0d renamed to new service type fix-exchange-service-type-rename CIEF ACC1 2024-05-13 02:21:08 +00:00
  • 0326ab2ee0 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into fix-exchange-rep-orders fix-exchange-rep-orders Yam ZhengLim 2024-05-09 07:15:34 +00:00
  • 0db6785bc2 Merge branch 'build-wallet-cash-flow-analysis' into 'main' CIEF ACC1 2024-05-08 08:27:33 +00:00
  • 49fcb7f6e5 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis build-wallet-cash-flow-analysis CIEF ACC1 2024-05-08 08:24:48 +00:00
  • 85e7d4e61b Fix time logic operator Yam ZhengLim 2024-04-29 04:22:58 +00:00
  • ca09264c80 Merge branch 'fix-exchange-delivery-on-time-logic' into 'main' build-exchange-rate-analysis CIEF ACC1 2024-04-05 03:15:37 +00:00
  • 6cbc293e25 Accommodate new service type and update on-time logic Yam ZhengLim 2024-04-05 03:14:14 +00:00
  • 1fc8922cd4 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-voucher-users build-voucher-users CIEF ACC1 2024-04-03 06:12:35 +00:00
  • 4ffb64a78b Merge branch 'build-exchange-rate-analysis' into 'main' CIEF ACC1 2024-04-03 06:10:55 +00:00
  • 75910a77fe Added metrics CIEF ACC1 2024-04-03 06:10:11 +00:00
  • cca60ea20f Merge branch 'build-exchange-rate-analysis' into 'main' CIEF ACC1 2024-04-01 10:00:15 +00:00
  • 5fabf779d9 Changed comparison competitor CIEF ACC1 2024-04-01 09:58:59 +00:00
  • bd446b3f1f Build voucher users CIEF ACC1 2024-04-01 09:48:53 +00:00
  • 9de1c91e50 Fixed corrupted stage model CIEF ACC1 2024-04-01 02:20:04 +00:00
  • 16428b7acb Refactored shipping dataset and fixed order created datetime from the right column. CIEF ACC1 2024-03-27 07:22:19 +00:00
  • 1b107599f6 updated logic to calculate wallet balance CIEF ACC1 2024-03-22 06:27:27 +00:00
  • c778e4ec5c fixing in progress CIEF ACC1 2024-03-21 02:01:29 +00:00
  • 0550be2ed3 build wallet cash flow analysis CIEF ACC1 2024-03-15 07:15:38 +00:00
  • 05339a85ad Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis CIEF ACC1 2024-03-14 02:24:37 +00:00
  • e52857c521 Merge branch 'lee_build_exchange_rate_fact' into 'main' lee_exchange_source_testcase Yam ZhengLim 2024-03-12 16:23:59 +00:00
  • d1e09ff1a6 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis CIEF ACC1 2024-03-12 07:17:12 +00:00
  • 809763ab80 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into lee_build_exchange_rate_fact CIEF ACC1 2024-03-12 01:08:49 +00:00
  • 3c0ced171a Build cash flow analysis CIEF ACC1 2024-03-12 01:08:06 +00:00
  • 96b2b4861f Merge branch 'build-exchange-rate-analysis' into 'main' CIEF ACC1 2024-03-07 09:05:51 +00:00
  • 1b90eb6eda Changed file name for consistency Yam ZhengLim 2024-03-07 09:04:01 +00:00
  • 3341e41e9b change join reference Yam ZhengLim 2024-03-07 07:57:01 +00:00
  • 7acfcad86a Merge branch 'main' into 'lee_build_exchange_rate_fact' CIEF ACC1 2024-03-07 02:11:48 +00:00
  • 715f51ee35 Total order/cost value formula redefined CIEF ACC1 2024-03-07 02:05:22 +00:00
  • 2bee6b91ef Redefined on-time logic CIEF ACC1 2024-03-07 02:04:48 +00:00
  • dd42248cdd build base wallets Yam ZhengLim 2024-03-06 03:42:37 +00:00
  • 3853e54dcf build exchange rate analysis Yam ZhengLim 2024-03-06 02:25:59 +00:00
  • 85b6720569 Merge branch 'fix-new-order-refund-status' into 'main' CIEF ACC1 2024-03-05 09:51:47 +00:00
  • 57a700cc5d added new status to order fix-new-order-refund-status Yam ZhengLim 2024-03-05 09:50:11 +00:00
  • fde8d9b5c1 Merge branch 'lee_build_rep_frozen_account_incidents' into 'main' CIEF ACC1 2024-03-05 09:31:32 +00:00
  • 9042df4c20 Merge branch 'lee_build_exchange_rate_fact' into 'main' add_company_type_rep_exchange__company_conversion_funnels Yam ZhengLim 2024-02-20 02:01:37 +00:00
  • b174496caa Fix total_value_rm formula CIEF ACC1 2024-01-29 09:53:27 +00:00
  • 5c000c02fc Fix total_value_rm formula CIEF ACC1 2024-01-29 09:53:16 +00:00
  • b6b7663bc2 build lee_build_rep_frozen_account_incidents CIEF ACC1 2024-01-12 01:25:25 +00:00
  • c959a292d6 build CIEF ACC1 2024-01-12 01:25:21 +00:00
  • 5297dd0756 build CIEF ACC1 2024-01-12 01:25:15 +00:00
  • 50b7679080 Merge branch 'lee_build_rep_frozen_account_incidents' into 'main' test_only lee_debug_rep_daily_orders Yam ZhengLim 2023-12-30 06:05:42 +00:00
  • 021cd467dc Added logic to identify migrated_companies CIEF ACC1 2023-12-29 10:32:28 +00:00
  • 20db620d27 added is_migrated_company, company_created_datetime, and next_order_datetime variable CIEF ACC1 2023-12-29 10:31:33 +00:00
  • 2912022f84 added next order datetime variable CIEF ACC1 2023-12-29 10:29:37 +00:00
  • 5f1a9b361d added is_credit_term_company variable CIEF ACC1 2023-12-29 09:48:22 +00:00
  • c453c6189d added is_credit_term and is_migrated_company variable CIEF ACC1 2023-12-29 09:44:17 +00:00
  • 1b60be4522 Shipping data model - survival analysis CIEF ACC1 2023-12-29 09:43:22 +00:00
  • a4c4fc83cb Shipping data model - rfm CIEF ACC1 2023-12-29 09:42:53 +00:00
  • cfc1e36d9a Shipping data model - company lists CIEF ACC1 2023-12-29 09:42:08 +00:00
  • 4514c35db4 Shipping data model - company engagement behavior CIEF ACC1 2023-12-29 09:41:36 +00:00
  • b285a9546d Shipping data model - cohort analysis development CIEF ACC1 2023-12-29 09:40:01 +00:00
  • 6c63f37d0c Debug calculation formula to avoid infinity when log(0) is encountered CIEF ACC1 2023-12-29 09:39:15 +00:00
  • 0b0af14e2a migrated_company_list for shipping CIEF ACC1 2023-12-22 07:36:03 +00:00
  • 21e3ecf9a6 Merge branch 'lee_build_rep_frozen_account_incidents' of gitlab.com:cief-data/dbt_cloud into lee_build_rep_frozen_account_incidents CIEF ACC1 2023-12-14 06:00:33 +00:00
  • 6ecff261f6 Logic fix for is_on_time_delivery CIEF ACC1 2023-12-14 06:00:32 +00:00
  • 2712fb88db Merge branch 'lee_build_rep_frozen_account_incidents' into 'main' Yam ZhengLim 2023-12-10 06:57:04 +00:00
  • 42202ccea1 Merge branch 'main' into 'lee_build_rep_frozen_account_incidents' Yam ZhengLim 2023-12-10 06:56:45 +00:00
  • eea798478c fix service_type CIEF ACC1 2023-12-01 01:37:57 +00:00
  • 68908bf57c Enhance company detail only CIEF ACC1 2023-11-22 16:26:31 +00:00
  • eefb32db93 Change status into business driven naming CIEF ACC1 2023-11-22 16:25:16 +00:00
  • 01fa0f61d6 Change status into business naming driven CIEF ACC1 2023-11-22 16:13:47 +00:00
  • 8feb447f89 1688 cost calculation 0.4% fix CIEF ACC1 2023-11-22 16:11:57 +00:00
  • 775cc58358 Bank Slip CIEF ACC1 2023-11-22 16:08:39 +00:00
  • 436cd7ed92 Exclude Internal Purchase CIEF ACC1 2023-11-22 16:07:39 +00:00
  • bcddb754ec White Form CIEF ACC1 2023-11-22 16:06:25 +00:00
  • 95e49fed81 Exclude Internal Purchase CIEF ACC1 2023-11-22 16:04:31 +00:00
  • 8cac940a65 Exclude Internal Purchase CIEF ACC1 2023-11-22 16:04:13 +00:00
  • 8ad1d143d0 Exclude Internal Purchase CIEF ACC1 2023-11-22 16:02:56 +00:00
  • d1108da3e5 Moved variable into correct category for final cte. CIEF ACC1 2023-11-03 09:40:45 +00:00
  • 52348351a7 Migrate to new airbyte format CIEF ACC1 2023-11-03 08:43:32 +00:00
  • ed72fe1a6e Migrate to new airbyte format CIEF ACC1 2023-11-03 08:39:06 +00:00
  • 30a08de7a0 fixed snowpark and pandas dataframe type error CIEF ACC1 2023-11-02 09:50:30 +00:00
  • ea8317d5a3 Changed to new airbyte format and included frozen account google sheet CIEF ACC1 2023-11-02 09:37:35 +00:00
  • 78b65467da Merge branch 'Enhance_rep_daily_orders_order_created_date' into 'main' lee_build_int_get_latest_cost lee_adhoc_analysis Yam ZhengLim 2023-10-23 16:58:27 +00:00
  • 0f5f6665ec Add order_created_dates Yam ZhengLim 2023-10-23 16:57:28 +00:00
  • ff56b3c02e Merge branch 'lee_build_int_get_latest_cost' into 'main' CIEF ACC1 2023-10-10 06:56:27 +00:00
  • d59b6908ef Merge branch 'main' into 'lee_build_int_get_latest_cost' CIEF ACC1 2023-10-10 06:55:55 +00:00
  • 6fa24f0a96 Because cost move to INT, delete some code CIEF ACC1 2023-10-10 05:23:46 +00:00
  • 9206cfa02e Added Model CIEF ACC1 2023-10-10 05:23:11 +00:00
  • 5d9f357837 Add Business Term status CIEF ACC1 2023-10-10 05:23:03 +00:00
  • c27858b932 Added Model CIEF ACC1 2023-10-10 05:22:45 +00:00
  • 48870313ca Added Model CIEF ACC1 2023-10-10 05:22:41 +00:00
  • ce381e8c74 split deduplicate function in intermediate CIEF ACC1 2023-10-03 06:50:43 +00:00
  • 7c377b793a spacing readjust CIEF ACC1 2023-10-03 06:46:23 +00:00
  • 23aa258e68 Merge branch 'lee_customer_life_time_value' into 'main' Yam ZhengLim 2023-10-03 06:41:18 +00:00
  • 656d584da9 order lifetime value compute Yam ZhengLim 2023-10-03 06:36:22 +00:00
  • c1efd26ef5 Change 5 working day to 7 working day CIEF ACC1 2023-09-29 07:37:04 +00:00
  • d1c0ff2319 PO stg file CIEF ACC1 2023-09-29 07:36:34 +00:00
  • 6e671ca880 Transaction Invoice stg file CIEF ACC1 2023-09-29 07:36:22 +00:00
  • 362cec7fa0 Clean wrong data CIEF ACC1 2023-09-24 11:47:14 +00:00
  • 772de3711a Merge branch 'get_current_dbt_version' into 'main' yam_seasonal_segment_apply_to_fct seasonal_segments_join_with_daily_orders Yam ZhengLim 2023-08-28 07:03:29 +00:00
  • eb1b4b6d5e dbt command get dbt version Yam ZhengLim 2023-08-28 07:02:59 +00:00