 CIEF ACC1
|
2912022f84
|
added next order datetime variable
|
2023-12-29 10:29:37 +00:00 |
|
|
CIEF ACC1
|
c453c6189d
|
added is_credit_term and is_migrated_company variable
|
2023-12-29 09:44:17 +00:00 |
|
|
CIEF ACC1
|
01fa0f61d6
|
Change status into business naming driven
|
2023-11-22 16:13:47 +00:00 |
|
|
CIEF ACC1
|
d1108da3e5
|
Moved variable into correct category for final cte.
|
2023-11-03 09:40:45 +00:00 |
|
|
CIEF ACC1
|
30a08de7a0
|
fixed snowpark and pandas dataframe type error
|
2023-11-02 09:50:30 +00:00 |
|
|
CIEF ACC1
|
d59b6908ef
|
Merge branch 'main' into 'lee_build_int_get_latest_cost'
# Conflicts:
# models/marts/reporting/rep_exchange__daily_orders.sql
|
2023-10-10 06:55:55 +00:00 |
|
|
CIEF ACC1
|
6fa24f0a96
|
Because cost move to INT, delete some code
|
2023-10-10 05:23:46 +00:00 |
|
 Yam ZhengLim
|
656d584da9
|
order lifetime value compute
|
2023-10-03 06:36:22 +00:00 |
|
|
CIEF ACC1
|
c1efd26ef5
|
Change 5 working day to 7 working day
|
2023-09-29 07:37:04 +00:00 |
|
|
CIEF ACC1
|
338277119b
|
added updated_datetime and deleted_datetime to cte
|
2023-08-24 05:48:47 +00:00 |
|
|
CIEF ACC1
|
140249008e
|
changed primary key column name for fct_exchange__transaction_orders
|
2023-08-24 05:40:47 +00:00 |
|
|
CIEF ACC1
|
8e749565d3
|
resolved conflict - order_expected_expired_datetime
|
2023-08-24 04:39:16 +00:00 |
|
|
CIEF ACC1
|
f32ccded38
|
updated logic to include data cleaning for datetime
|
2023-08-23 09:02:33 +00:00 |
|
|
Yam ZhengLim
|
21fdbe4d2e
|
Debug cause added a new status "EXPIRED" crash with the transaction order expired_datetime
|
2023-08-20 13:59:00 +00:00 |
|
|
Yam ZhengLim
|
52173653c0
|
Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into compile_company_dimension_for_dedupe
|
2023-08-08 03:10:52 +00:00 |
|
|
Yam ZhengLim
|
9876184b6f
|
dates model
|
2023-08-02 15:32:33 +00:00 |
|
|
Yam ZhengLim
|
9bc6c74ad1
|
dates model
|
2023-08-02 15:32:23 +00:00 |
|
 Yam ZhengLim
|
cf6bc44baa
|
Merge branch 'compile_company_dimension_for_dedupe' into 'main'
Sales lead activation model
See merge request cief-data/dbt_cloud!17
|
2023-08-02 04:14:07 +00:00 |
|
|
Yam ZhengLim
|
da82a4f190
|
sales exchange lead activations
|
2023-08-02 04:12:49 +00:00 |
|
 CIEF DataTeam
|
631e7769b9
|
Migrate Metrics from REP to FCT
|
2023-07-31 16:08:35 +00:00 |
|
|
Yam ZhengLim
|
c58e22bdfa
|
Update company_adds increamental bug
|
2023-07-17 05:17:50 +00:00 |
|
|
Yam ZhengLim
|
5b982e089a
|
Update company_adds increamental bug
|
2023-07-17 05:16:19 +00:00 |
|
|
CIEF DataTeam
|
327168bc9d
|
Merge branch 'main' of gitlab.com:CIEFWorldwideSdnBhd/dbt_cloud into create_shipping_modeling
|
2023-07-06 08:42:18 +00:00 |
|
|
CIEF DataTeam
|
ee8665519c
|
Shipping Model
|
2023-07-06 08:41:56 +00:00 |
|
|
Yam ZhengLim
|
96076eb89d
|
dim_exchange_users create
|
2023-07-03 07:28:14 +00:00 |
|
|
Yam ZhengLim
|
f21902d575
|
Exchange address get geo cordinate
|
2023-06-22 09:12:58 +00:00 |
|
|
Yam ZhengLim
|
f08ed4ef0e
|
geocode external function define
|
2023-05-20 13:28:46 +00:00 |
|
|
Yam ZhengLim
|
2775f41dfc
|
Worked on calling external user defined functions.
|
2023-05-15 07:49:58 +00:00 |
|
|
Yam ZhengLim
|
8bcace6545
|
lee - snowpark_geolocator modified
|
2023-05-10 09:12:31 +00:00 |
|
|
Yam ZhengLim
|
dbe3c1f716
|
Lee - geolocation finder
|
2023-05-10 03:11:22 +00:00 |
|
|
Yam ZhengLim
|
2d2501cbfe
|
DBT structure change
|
2023-05-09 09:53:28 +00:00 |
|