data-dwh-dbt-project

counterweight/data-dwh-dbt-project

Fork 0

Commit graph

229ab901d1 restrict list to models, tests and exposures Pablo Martin 2025-03-21 15:02:31 +01:00
5d92c43215 add ls step Pablo Martin 2025-03-21 14:38:48 +01:00
40f28a9411 remove master trigger Pablo Martin 2025-03-21 14:25:36 +01:00
e0fbf093b8 undo stupid change Pablo Martin 2025-03-21 12:32:31 +01:00
395c064365 edit one model to test state detection Pablo Martin 2025-03-21 12:30:25 +01:00
bc7ea8d001 make dbt docs a bit more efficient, hopefully Pablo Martin 2025-03-21 12:28:18 +01:00
14b927b8d4 typo Pablo Martin 2025-03-21 12:23:09 +01:00
d26c70bba4 add steps in ci Pablo Martin 2025-03-21 12:15:50 +01:00
8924778a52 Merged PR 4770: Same freshness in MTD and YTD/target for Resolutions Payouts Oriol Roqué Paniagua 2025-03-21 11:10:26 +00:00
36e6a35d12 Merged PR 4753: Add sqlfluff check Pablo Martín 2025-03-21 10:10:44 +00:00
98c40d21d2 Merged PR 4769: Refactors display exclusion in main metrics Oriol Roqué Paniagua 2025-03-21 09:40:20 +00:00
240d6ec59e Merged PR 4763: Align metrics within KPIs report Oriol Roqué Paniagua 2025-03-20 17:00:36 +00:00
6a38a4ec48 modify ugly name Pablo Martin 2025-03-20 17:03:13 +01:00
6b9434355a Merged PR 4759: Adds Booking Fee per Billable Booking Oriol Roqué Paniagua 2025-03-20 16:01:27 +00:00
61007cff09 exclude sources as well Pablo Martin 2025-03-20 16:55:23 +01:00
a56a96d1c4 exclude test generated sql files Pablo Martin 2025-03-20 16:49:31 +01:00
098ab51439 Merged PR 4757: Creates a Total Booking Fees metric (Old dash + New dash) Oriol Roqué Paniagua 2025-03-20 13:45:44 +00:00
93b31854f7 Merged PR 4754: Updates targets FY25 & FY26 Oriol Roqué Paniagua 2025-03-20 13:10:22 +00:00
fa914e8e26 try with more cores Pablo Martin 2025-03-20 13:17:05 +01:00
00ea2ff146 parallelize with xargs Pablo Martin 2025-03-20 12:51:04 +01:00
2dd13e84d7 add steps in ci pipeline Pablo Martin 2025-03-20 12:39:43 +01:00
478e953700 add sqlfluff dep and script and config Pablo Martin 2025-03-20 12:37:47 +01:00
a4965ed9b2 Merged PR 4752: Move pipeline YAML Pablo Martín 2025-03-20 11:30:12 +00:00
48528033d9 move file there Pablo Martin 2025-03-20 12:24:40 +01:00
daea8d229b start ci folder Pablo Martin 2025-03-20 12:24:32 +01:00
5d28f787a6 Merged PR 4743: Filtered test accounts Joaquin Ossa 2025-03-20 08:36:49 +00:00
d06f58b76e Removed test users from staging Joaquin 2025-03-20 09:30:33 +01:00
9e59fa4933 Merged PR 4723: Adding id_deal Joaquin Ossa 2025-03-19 15:50:37 +00:00
a85033922c Filtered test accounts Joaquin 2025-03-19 16:50:19 +01:00
c44a099751 Merged PR 4735: Test PR for CI stuff Pablo Martín 2025-03-19 14:34:26 +00:00
918d618f75 adjust naming in deletion step Pablo Martin 2025-03-19 15:26:50 +01:00
d334e95738 typo Pablo Martin 2025-03-19 15:23:59 +01:00
841b64dc85 unfuck variables Pablo Martin 2025-03-19 15:19:27 +01:00
1e19efc89f make temporal db name selection a bit smarter Pablo Martin 2025-03-19 15:17:33 +01:00
bcdb39849d Addressed comments Joaquin 2025-03-19 12:06:05 +01:00
cef363847a Merged PR 4736: adding id_deal to api models Joaquin Ossa 2025-03-19 10:33:49 +00:00
821c7d2850 remove pr stuff because it's fake news Pablo Martin 2025-03-19 09:26:03 +01:00
5d3f2f6908 adding id_deal to api models Joaquin 2025-03-19 09:23:23 +01:00
4b33114d67 modify pipeline Pablo Martin 2025-03-19 09:19:30 +01:00
5928a198b6 Merged PR 4734: Bugfix - Ensures accounts cannot be duplicated in Xero sales monthly trends Oriol Roqué Paniagua 2025-03-19 08:19:20 +00:00
7cc893cad4 silly change just to trigger PR Pablo Martin 2025-03-19 09:14:26 +01:00
c00d02685d add dbt compile step Pablo Martin 2025-03-18 18:12:53 +01:00
a1ed622bee build docs Pablo Martin 2025-03-18 18:02:28 +01:00
43132c41b5 typo Pablo Martin 2025-03-18 17:51:51 +01:00
074ac0e2ce install dbt thingies in CI Pablo Martin 2025-03-18 17:48:49 +01:00
f4769c2e55 delete database Pablo Martin 2025-03-18 17:38:55 +01:00
8c7681581c typo Pablo Martin 2025-03-18 17:35:07 +01:00
32ef6f36a4 create database Pablo Martin 2025-03-18 17:33:49 +01:00
65e2dea2fc smoke test with env var sourcing included Pablo Martin 2025-03-18 17:31:05 +01:00
74222a0007 smoke test postgres connection Pablo Martin 2025-03-18 17:26:20 +01:00
6dea088b8f Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2025-03-18 17:24:01 +01:00
c348430dae prepare env vars on ci script Pablo Martin 2025-03-18 17:23:57 +01:00
06694faa68 Merged PR 4732: Removes accepted values test for guest product display name Oriol Roqué Paniagua 2025-03-18 16:03:48 +00:00
09976bef13 Removes accepted values test for guest product display name uri 2025-03-18 16:34:00 +01:00
a988542679 simple smoke test Pablo Martin 2025-03-18 16:16:04 +01:00
619c87e874 Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2025-03-18 15:55:48 +01:00
525ed77a87 change pool name again cause i fucked up Pablo Martin 2025-03-18 15:55:45 +01:00
f799a8d30f Merged PR 4727: Bookings fees are now Old Dashboard Booking Fees in Main KPIs Oriol Roqué Paniagua 2025-03-18 14:55:32 +00:00
35cd4f4fcd change pool Pablo Martin 2025-03-18 15:54:46 +01:00
c786ccf5c1 remove compile Pablo Martin 2025-03-18 13:44:30 +01:00
e424ed7581 add ci yml Pablo Martin 2025-03-18 13:41:40 +01:00
a145a00b4d Adding id_deal Joaquin 2025-03-18 12:06:25 +01:00
dd9bb8a11b Merged PR 4713: Adds a master table for guest products price plans Oriol Roqué Paniagua 2025-03-18 10:56:33 +00:00
74a76fe8fc Removes configuration status and adds config id for further joins uri 2025-03-18 09:20:31 +01:00
91e7fe09b1 Adds end date uri 2025-03-18 09:09:59 +01:00
cba4b97082 Adds a master table for guest products price plans uri 2025-03-17 16:35:50 +01:00
b518c536f2 Merged PR 4698: Added business scope to models Joaquin Ossa 2025-03-14 13:33:10 +00:00
e9cfb6c2bd Addressed comments Joaquin 2025-03-14 14:20:57 +01:00
918ed969d8 Merged PR 4699: Creates a master table for guest products Oriol Roqué Paniagua 2025-03-14 13:04:46 +00:00
89b3989d19 Added business scope to models Joaquin 2025-03-14 11:48:22 +01:00
72118389d6 Merged PR 4693: Live Dates according to HubSpot Joaquin Ossa 2025-03-14 10:20:34 +00:00
c33253b10a addressed comments Joaquin 2025-03-14 11:19:22 +01:00
525720ea0a Changes in deals lifecycle Joaquin 2025-03-14 10:39:01 +01:00
8c97f03487 Merged PR 4697: Churn update Joaquin Ossa 2025-03-14 09:33:19 +00:00
e0d18acf8e Churn update Joaquin 2025-03-14 10:12:54 +01:00
e827c0f9d5 Updated schema Joaquin 2025-03-13 17:31:15 +01:00
a2b3b7fa6b Updated schema Joaquin 2025-03-13 17:29:24 +01:00
d6426b0066 change in new deals Joaquin 2025-03-13 17:19:34 +01:00
1ced79ca0a commit wip Joaquin 2025-03-13 11:33:15 +01:00
bf1e125856 Merged PR 4687: Bugfix - Removal of SH fields that no longer exist Oriol Roqué Paniagua 2025-03-13 12:25:13 +00:00
eb26252784 Merged PR 4686: Guest Products - Sync Guest Products Oriol Roqué Paniagua 2025-03-13 11:53:04 +00:00
7ef460a59e Merged PR 4685: Guest Products - sync core tables Oriol Roqué Paniagua 2025-03-13 09:27:02 +00:00
9ca9c827fe Merged PR 4665: Projected Bookings to the end of the current month Oriol Roqué Paniagua 2025-03-11 14:34:30 +00:00
a0b2f9b657 Merged PR 4649: Updated exposures Joaquin Ossa 2025-03-10 10:22:47 +00:00
459b1b3833 Updated exposures Joaquin Ossa 2025-03-10 10:57:21 +01:00
cc9b4ade71 Merged PR 4628: Churn deals Joaquin Ossa 2025-03-07 10:48:52 +00:00
f8362c4a71 addressed comments Joaquin Ossa 2025-03-07 11:32:09 +01:00
2d4cded48c Addressed comments and included changes in reporting Joaquin Ossa 2025-03-07 11:13:03 +01:00
2461286c9c Updated model Joaquin Ossa 2025-03-07 10:17:11 +01:00
0536cfb0e2 Fixing formatting Joaquin Ossa 2025-03-06 17:19:15 +01:00
f8b551a75c Updated existing model with some new fields for churning report Joaquin Ossa 2025-03-06 17:12:32 +01:00
24d13185eb Added year and month Joaquin Ossa 2025-03-06 15:02:44 +01:00
1245a88867 New churned deals model Joaquin Ossa 2025-03-06 14:57:23 +01:00
089a1c37bd commit wip Joaquin Ossa 2025-03-06 11:02:46 +01:00
9f580867c0 Merged PR 4622: New Dash bug fix Joaquin Ossa 2025-03-06 08:23:27 +00:00
d065d4beb6 New Dash bug fix Joaquin Ossa 2025-03-06 08:16:40 +01:00
39fc6a7d13 Merged PR 4618: Bugfix - Ensure the PMS is active Oriol Roqué Paniagua 2025-03-05 14:57:57 +00:00
5ddbe5d5af Merged PR 4616: Adds first day month for reporting purposes Oriol Roqué Paniagua 2025-03-05 14:31:36 +00:00
5d6e860e2b Merged PR 4596: Propagates Client Type to KPIs by Deal and AM models Oriol Roqué Paniagua 2025-03-05 13:02:07 +00:00
1a4a9fac37 Merged PR 4578: Propagates the month attribution from invoicing data Oriol Roqué Paniagua 2025-03-04 14:13:53 +00:00