Commit Graph

Select branches

Hide Pull Requests

add-column-order-refund-datetime

add_company_type_rep_exchange__company_conversion_funnels

build-exchange-rate-analysis

build-voucher-users

build-wallet-cash-flow-analysis

compile_company_dimension_for_dedupe

fix-exchange-delivery-on-time-logic

fix-exchange-rep-orders

fix-exchange-service-type-rename

fix-new-order-refund-status

fix-shipping-invoice-value-sum-error

fix-shipping-stg-packages-node

lee_adhoc_analysis

lee_build_int_get_latest_cost

lee_build_rep_frozen_account_incidents

lee_debug_rep_daily_orders

lee_exchange_source_testcase

main

seasonal_segments_join_with_daily_orders

shipping-build-contacts

shipping-fix-order-created-datetime

test_only

yam_seasonal_segment_apply_to_fct

Mono Color

• 79ed4deef2 Merge branch 'lee_debug_rep_daily_orders' into 'main' CIEF ACC1 2023-08-28 02:23:22 +00:00
• 2ec4184064 debug estimated_order_delivery_datetime_customer_expectation to include existing time CIEF ACC1 2023-08-25 08:12:51 +00:00
• 0f319ab6d0 Merge branch 'build_new_fct_daily_orders' into 'main' CIEF ACC1 2023-08-24 17:38:28 +00:00
• 338277119b added updated_datetime and deleted_datetime to cte CIEF ACC1 2023-08-24 05:48:47 +00:00
• 140249008e changed primary key column name for fct_exchange__transaction_orders CIEF ACC1 2023-08-24 05:40:47 +00:00
• 8e749565d3 resolved conflict - order_expected_expired_datetime CIEF ACC1 2023-08-24 04:39:16 +00:00
• 159c5c82a8 replaced fct transaction orders CIEF ACC1 2023-08-24 04:33:02 +00:00
• f32ccded38 updated logic to include data cleaning for datetime CIEF ACC1 2023-08-23 09:02:33 +00:00
• c5aff88531 changed name to fct_transaction_orders CIEF ACC1 2023-08-23 09:01:52 +00:00
• eee76d9a82 changed name to fct_transaction_orders CIEF ACC1 2023-08-23 09:01:43 +00:00
• d99072a27c changed name to fct_transaction_orders CIEF ACC1 2023-08-23 09:01:33 +00:00
• e32bddd3c9 changed name to fct_transaction_orders CIEF ACC1 2023-08-23 09:01:22 +00:00
• 9f0b206350 changed name to fct_transaction_orders CIEF ACC1 2023-08-23 09:01:03 +00:00
• 8abc7b4e34 replaced new fct orders table CIEF ACC1 2023-08-23 08:14:20 +00:00
• 9b3cdc7140 replaced new fct orders table CIEF ACC1 2023-08-23 08:14:09 +00:00
• 3824bbe56d replaced new fct orders table CIEF ACC1 2023-08-23 08:13:57 +00:00
• 991db604ff replaced new fct orders table CIEF ACC1 2023-08-23 08:13:47 +00:00
• 2a90f2cef2 replaced new fct orders table CIEF ACC1 2023-08-23 08:13:30 +00:00
• 412f72f0a6 Merge branch 'compile_company_dimension_for_dedupe' into 'main' compile_company_dimension_for_dedupe Yam ZhengLim 2023-08-20 14:00:11 +00:00
• 21fdbe4d2e Debug cause added a new status "EXPIRED" crash with the transaction order expired_datetime Yam ZhengLim 2023-08-20 13:59:00 +00:00
• 427a4779d6 Merge branch 'yam_seasonal_segment_apply_to_fct' into 'main' CIEF DataTeam 2023-08-17 07:09:57 +00:00
• 4d4c6aceb7 New stg model seasonal segments CIEF DataTeam 2023-08-17 07:08:05 +00:00
• 4d5d88ac89 Merge branch 'compile_company_dimension_for_dedupe' into 'main' Yam ZhengLim 2023-08-08 03:15:40 +00:00
• 52173653c0 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into compile_company_dimension_for_dedupe Yam ZhengLim 2023-08-08 03:10:52 +00:00
• 4679a4693c debug next_order_created_datetime Yam ZhengLim 2023-08-08 03:10:39 +00:00
• 2b9cc0403c debug Yam ZhengLim 2023-08-08 02:59:38 +00:00
• 8b91ce7d9c Analysis temporary model Yam ZhengLim 2023-08-08 02:58:37 +00:00
• c17c909695 Analysis temporary model Yam ZhengLim 2023-08-08 02:58:20 +00:00
• 924ca4e25c base model Yam ZhengLim 2023-08-06 07:17:36 +00:00
• 4e227b02aa base model Yam ZhengLim 2023-08-06 07:17:28 +00:00
• ac6c297da2 base model Yam ZhengLim 2023-08-06 07:17:10 +00:00
• 0ea657fcdc base model Yam ZhengLim 2023-08-06 07:16:58 +00:00
• b510a3ee03 base model Yam ZhengLim 2023-08-06 07:16:46 +00:00
• 3af686d875 new base model Yam ZhengLim 2023-08-06 07:08:46 +00:00
• 9876184b6f dates model Yam ZhengLim 2023-08-02 15:32:33 +00:00
• 9bc6c74ad1 dates model Yam ZhengLim 2023-08-02 15:32:23 +00:00
• a365b87988 Merge branch 'compile_company_dimension_for_dedupe' into 'main' Yam ZhengLim 2023-08-02 14:43:30 +00:00
• f8c337e731 Add google_sheet dbt project Yam ZhengLim 2023-08-02 14:42:43 +00:00
• 9a5f4ad669 dates model Yam ZhengLim 2023-08-02 14:26:54 +00:00
• 93868e8da2 dates model Yam ZhengLim 2023-08-02 14:24:14 +00:00
• f034809493 add packages Yam ZhengLim 2023-08-02 14:21:14 +00:00
• 032cdf0960 Merge branch 'YAM_rep_shipping_company_purchase_frequency' into 'main' CIEF DataTeam 2023-08-02 12:19:09 +00:00
• 9b9b694210 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into YAM_rep_shipping_company_purchase_frequency CIEF DataTeam 2023-08-02 12:17:57 +00:00
• f426376997 Remove Super high usage CIEF DataTeam 2023-08-02 12:17:43 +00:00
• 028f851deb Base model Yam ZhengLim 2023-08-02 04:17:57 +00:00
• cf6bc44baa Merge branch 'compile_company_dimension_for_dedupe' into 'main' Yam ZhengLim 2023-08-02 04:14:07 +00:00
• da82a4f190 sales exchange lead activations Yam ZhengLim 2023-08-02 04:12:49 +00:00
• 4eb48eb070 sales exchange lead activations Yam ZhengLim 2023-08-02 04:12:39 +00:00
• 851c9afbb9 sales exchange lead activations Yam ZhengLim 2023-08-02 04:12:27 +00:00
• 973f835d15 Change name Yam ZhengLim 2023-08-02 04:12:14 +00:00
• 22723bdd05 Sales activation model Yam ZhengLim 2023-08-02 03:54:13 +00:00
• bcaf25ac7f Merge branch 'YAM_rep_shipping_company_purchase_frequency' into 'main' CIEF DataTeam 2023-08-01 09:29:51 +00:00
• 6d67b90470 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into YAM_rep_shipping_company_purchase_frequency CIEF DataTeam 2023-08-01 09:29:23 +00:00
• ba58612204 Duplicate Report CIEF DataTeam 2023-08-01 09:27:53 +00:00
• 4ee816e0ee Merge branch 'YAM_rep_shipping_company_purchase_frequency' into 'main' CIEF DataTeam 2023-08-01 09:08:41 +00:00
• 7e3c0cdc48 Only with company_id who order before CIEF DataTeam 2023-08-01 09:08:23 +00:00
• 9e61dc25d6 Merge branch 'YAM_rep_shipping_company_purchase_frequency' into 'main' CIEF DataTeam 2023-08-01 06:57:47 +00:00
• 31effe69f0 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into YAM_rep_shipping_company_purchase_frequency CIEF DataTeam 2023-08-01 06:56:50 +00:00
• 5f176c61fb remove unorder company CIEF DataTeam 2023-08-01 06:56:41 +00:00
• 3c8bad31d1 Merge branch 'YAM_rep_shipping_company_purchase_frequency' into 'main' CIEF DataTeam 2023-07-31 16:13:01 +00:00
• 86115d7fa0 Develop dashboard CIEF DataTeam 2023-07-31 16:09:04 +00:00
• 66b79b6ece Migrate Metrics from REP to FCT CIEF DataTeam 2023-07-31 16:08:46 +00:00
• 631e7769b9 Migrate Metrics from REP to FCT CIEF DataTeam 2023-07-31 16:08:35 +00:00
• 101fe1d0d3 Merge branch 'compile_company_dimension_for_dedupe' into 'main' Yam ZhengLim 2023-07-25 15:16:12 +00:00
• 9699185b27 Debug parent company and sub company Yam ZhengLim 2023-07-25 15:14:36 +00:00
• aba4be5c5d Merge branch 'compile_company_dimension_for_dedupe' into 'main' Yam ZhengLim 2023-07-17 05:18:51 +00:00
• c58e22bdfa Update company_adds increamental bug Yam ZhengLim 2023-07-17 05:17:50 +00:00
• 00e67c55c7 Update company_adds increamental bug Yam ZhengLim 2023-07-17 05:16:37 +00:00
• 26dc527126 Update company_adds increamental bug Yam ZhengLim 2023-07-17 05:16:28 +00:00
• 5b982e089a Update company_adds increamental bug Yam ZhengLim 2023-07-17 05:16:19 +00:00
• a596811404 Update company_adds increamental bug Yam ZhengLim 2023-07-17 05:16:11 +00:00
• 98d6d8da20 Exchange add source Yam ZhengLim 2023-07-15 04:01:34 +00:00
• 732c0c516e googlesheet .gitkeep Yam ZhengLim 2023-07-13 15:28:35 +00:00
• 3c71b9b80d googlesheet docs Yam ZhengLim 2023-07-13 15:28:09 +00:00
• 725d2ef24a googlesheet sources Yam ZhengLim 2023-07-13 15:27:56 +00:00
• c9e81d9958 Debug Yam ZhengLim 2023-07-13 15:26:52 +00:00
• 77f4144c74 Change miss spelling Yam ZhengLim 2023-07-13 15:25:46 +00:00
• e4ebb5ce10 Merge branch 'compile_company_dimension_for_dedupe' into 'main' Yam ZhengLim 2023-07-13 15:24:43 +00:00
• c7d10aeacb Use in dedupe to remove duplicate Yam ZhengLim 2023-07-13 15:24:06 +00:00
• baad61847b Merge branch 'create_shipping_modeling' into 'main' Yam ZhengLim 2023-07-06 08:45:12 +00:00
• 327168bc9d Merge branch 'main' of gitlab.com:CIEFWorldwideSdnBhd/dbt_cloud into create_shipping_modeling CIEF DataTeam 2023-07-06 08:42:18 +00:00
• ee8665519c Shipping Model CIEF DataTeam 2023-07-06 08:41:56 +00:00
• 6571dd6afe Merge branch 'Exchange_build_dim_users' into 'main' Yam ZhengLim 2023-07-03 07:28:41 +00:00
• 96076eb89d dim_exchange_users create Yam ZhengLim 2023-07-03 07:28:14 +00:00
• 01470d6166 Merge branch 'lee_address_geoloc' into 'main' Yam ZhengLim 2023-06-30 09:09:34 +00:00
• 9d98540674 Modified unique key in incremental model Yam ZhengLim 2023-06-30 09:08:36 +00:00
• f81a31b3a1 Merge branch 'Exchange_Funnel_Debug' into 'main' Yam ZhengLim 2023-06-30 08:19:27 +00:00
• 9379fdbdb7 Debug wrong dataset name Yam ZhengLim 2023-06-30 08:19:04 +00:00
• 06e42f6bc3 Merge branch 'Exchange_Funnel_Debug' into 'main' Yam ZhengLim 2023-06-30 03:38:46 +00:00
• 9cb21155b4 Debug daily_orders and company_conversion Yam ZhengLim 2023-06-30 03:37:16 +00:00
• 53aadf5c05 Merge branch 'lee_address_geoloc' into 'main' Yam ZhengLim 2023-06-22 14:33:33 +00:00
• 4c57a0d721 update target_name to dbt_prod Yam ZhengLim 2023-06-22 14:33:06 +00:00
• f2c8057886 Merge branch 'lee_address_geoloc' into 'main' Yam ZhengLim 2023-06-22 09:14:08 +00:00
• f21902d575 Exchange address get geo cordinate Yam ZhengLim 2023-06-22 09:12:58 +00:00
• 69a7512dc3 Added comments on address_to_coordinates macro Yam ZhengLim 2023-05-22 03:14:54 +00:00
• d0eb132ca7 Moved parse_json from main sql to macro sql Yam ZhengLim 2023-05-21 01:48:48 +00:00
• 1df446e6d2 Geocoder function working Yam ZhengLim 2023-05-21 01:31:57 +00:00
• 382b8d5866 geocode function returning more rows than expected, to be fixed. Yam ZhengLim 2023-05-20 13:44:19 +00:00
• f08ed4ef0e geocode external function define Yam ZhengLim 2023-05-20 13:28:46 +00:00
• 2775f41dfc Worked on calling external user defined functions. Yam ZhengLim 2023-05-15 07:49:58 +00:00