59 Commits

Author SHA1 Message Date
CIEF ACC1 d4ef402cb9 replaced model name in yml file 2024-07-01 06:56:18 +00:00
CIEF ACC1 9de1c91e50 Fixed corrupted stage model 2024-04-01 02:20:04 +00:00
CIEF ACC1 1b107599f6 updated logic to calculate wallet balance 2024-03-22 06:27:27 +00:00
CIEF ACC1 05339a85ad Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis 2024-03-14 02:24:37 +00:00
CIEF ACC1 d1e09ff1a6 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis 2024-03-12 07:17:12 +00:00
CIEF ACC1 809763ab80 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into lee_build_exchange_rate_fact 2024-03-12 01:08:49 +00:00
CIEF ACC1 3c0ced171a Build cash flow analysis 2024-03-12 01:08:06 +00:00
Yam ZhengLim 1b90eb6eda Changed file name for consistency 2024-03-07 09:04:01 +00:00
Yam ZhengLim 3341e41e9b change join reference 2024-03-07 07:57:01 +00:00
CIEF ACC1 7acfcad86a Merge branch 'main' into 'lee_build_exchange_rate_fact'
# Conflicts:
#   models/marts/warehouse/fct_exchange__transaction_orders.sql
2024-03-07 02:11:48 +00:00
CIEF ACC1 715f51ee35 Total order/cost value formula redefined 2024-03-07 02:05:22 +00:00
Yam ZhengLim dd42248cdd build base wallets 2024-03-06 03:42:37 +00:00
Yam ZhengLim 3853e54dcf build exchange rate analysis 2024-03-06 02:25:59 +00:00
CIEF ACC1 5297dd0756 build 2024-01-12 01:25:15 +00:00
CIEF ACC1 021cd467dc Added logic to identify migrated_companies 2023-12-29 10:32:28 +00:00
CIEF ACC1 5f1a9b361d added is_credit_term_company variable 2023-12-29 09:48:22 +00:00
CIEF ACC1 775cc58358 Bank Slip 2023-11-22 16:08:39 +00:00
CIEF ACC1 436cd7ed92 Exclude Internal Purchase 2023-11-22 16:07:39 +00:00
CIEF ACC1 bcddb754ec White Form 2023-11-22 16:06:25 +00:00
CIEF ACC1 95e49fed81 Exclude Internal Purchase 2023-11-22 16:04:31 +00:00
CIEF ACC1 8cac940a65 Exclude Internal Purchase 2023-11-22 16:04:13 +00:00
CIEF ACC1 8ad1d143d0 Exclude Internal Purchase 2023-11-22 16:02:56 +00:00
CIEF ACC1 52348351a7 Migrate to new airbyte format 2023-11-03 08:43:32 +00:00
CIEF ACC1 ed72fe1a6e Migrate to new airbyte format 2023-11-03 08:39:06 +00:00
CIEF ACC1 ea8317d5a3 Changed to new airbyte format and included frozen account google sheet 2023-11-02 09:37:35 +00:00
CIEF ACC1 ce381e8c74 split deduplicate function in intermediate 2023-10-03 06:50:43 +00:00
CIEF ACC1 7c377b793a spacing readjust 2023-10-03 06:46:23 +00:00
CIEF ACC1 d1c0ff2319 PO stg file 2023-09-29 07:36:34 +00:00
CIEF ACC1 6e671ca880 Transaction Invoice stg file 2023-09-29 07:36:22 +00:00
CIEF ACC1 362cec7fa0 Clean wrong data 2023-09-24 11:47:14 +00:00
CIEF DataTeam 4d4c6aceb7 New stg model seasonal segments 2023-08-17 07:08:05 +00:00
Yam ZhengLim 2b9cc0403c debug 2023-08-08 02:59:38 +00:00
Yam ZhengLim 924ca4e25c base model 2023-08-06 07:17:36 +00:00
Yam ZhengLim 4e227b02aa base model 2023-08-06 07:17:28 +00:00
Yam ZhengLim ac6c297da2 base model 2023-08-06 07:17:10 +00:00
Yam ZhengLim 0ea657fcdc base model 2023-08-06 07:16:58 +00:00
Yam ZhengLim b510a3ee03 base model 2023-08-06 07:16:46 +00:00
Yam ZhengLim 3af686d875 new base model 2023-08-06 07:08:46 +00:00
Yam ZhengLim 93868e8da2 dates model 2023-08-02 14:24:14 +00:00
Yam ZhengLim 028f851deb Base model 2023-08-02 04:17:57 +00:00
Yam ZhengLim 851c9afbb9 sales exchange lead activations 2023-08-02 04:12:27 +00:00
Yam ZhengLim 973f835d15 Change name 2023-08-02 04:12:14 +00:00
Yam ZhengLim 22723bdd05 Sales activation model 2023-08-02 03:54:13 +00:00
Yam ZhengLim 9699185b27 Debug parent company and sub company 2023-07-25 15:14:36 +00:00
Yam ZhengLim 00e67c55c7 Update company_adds increamental bug 2023-07-17 05:16:37 +00:00
Yam ZhengLim a596811404 Update company_adds increamental bug 2023-07-17 05:16:11 +00:00
Yam ZhengLim 98d6d8da20 Exchange add source 2023-07-15 04:01:34 +00:00
Yam ZhengLim 732c0c516e googlesheet .gitkeep 2023-07-13 15:28:35 +00:00
Yam ZhengLim 3c71b9b80d googlesheet docs 2023-07-13 15:28:09 +00:00
Yam ZhengLim 725d2ef24a googlesheet sources 2023-07-13 15:27:56 +00:00