counterweight/data-dwh-dbt-project
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

Commit graph

  • 0c311d02e8 Update name of fields Joaquin Ossa 2025-01-09 16:31:22 +01:00
  • bd25b473fb Adding PMS info for Account Margin report Joaquin Ossa 2025-01-09 15:56:58 +01:00
  • 198a71dee8 bump versions Pablo Martin 2025-01-07 17:56:39 +01:00
  • 04a10cf9c5 Merged PR 3968: Updating exposures Joaquin Ossa 2025-01-07 15:27:47 +00:00
  • 0ec1484846 Merged PR 3967: Adds an "All History" time window to Account Margin Oriol Roqué Paniagua 2025-01-07 15:22:30 +00:00
  • 9784cb6022 Updating exposures Joaquin Ossa 2025-01-07 16:18:45 +01:00
  • f5e417c7db Merged PR 3957: ordered names to select oldest one created Joaquin Ossa 2025-01-07 12:55:00 +00:00
  • 55539ab2c9 ordered names to select oldest one created Joaquin Ossa 2025-01-07 11:47:14 +01:00
  • f2abd16a44 Merged PR 3939: Fixes DWH models for new PBI on AM Oriol Roqué Paniagua 2025-01-03 16:17:26 +00:00
  • 6d261e281e Merged PR 3937: deals consolidation to reporting Joaquin Ossa 2025-01-03 14:49:38 +00:00
  • 36290f19b3 deals consolidation to reporting Joaquin Ossa 2025-01-03 14:59:47 +01:00
  • c81af72602 Merged PR 3922: Id_deal consolidation model Joaquin Ossa 2025-01-03 13:30:48 +00:00
  • dbf807639e fixing copy paste Joaquin Ossa 2025-01-03 12:00:14 +01:00
  • 0aeb558a9b fixed booleans Joaquin Ossa 2025-01-03 11:43:58 +01:00
  • 6516a0fdc6 Updated schema with rebase Joaquin Ossa 2025-01-03 11:29:58 +01:00
  • 58dc823d27 Added boolean fields and counts per each deal source Joaquin Ossa 2025-01-03 11:23:06 +01:00
  • 35e7144efd Changed the logic for the model Joaquin Ossa 2025-01-02 16:10:51 +01:00
  • 84f2156c99 commit wip Joaquin Ossa 2025-01-02 15:14:41 +01:00
  • e406bc89ad Merged PR 3926: Propagate to reporting + fix documentation Oriol Roqué Paniagua 2025-01-03 09:30:33 +00:00
  • 564a4f307d Merged PR 3925: Bugfix Oriol Roqué Paniagua 2025-01-03 08:24:16 +00:00
  • a61da137fa Merged PR 3924: First version of time window aggregated metrics by deal Oriol Roqué Paniagua 2025-01-03 08:07:16 +00:00
  • 0d7b5ac88a Merged PR 3914: Include Hubspot deals for KPIs Oriol Roqué Paniagua 2024-12-31 15:12:38 +00:00
  • 29a005297a Merged PR 3906: Adds 2 new retained income metrics Oriol Roqué Paniagua 2024-12-31 12:10:12 +00:00
  • d26e08bffd Merged PR 3909: Fixes created_date_utc and updated_date_utc in SH User and its dependencies Oriol Roqué Paniagua 2024-12-31 08:04:03 +00:00
  • 803c5ed3d5 Merged PR 3905: Update exposures Oriol Roqué Paniagua 2024-12-27 15:49:03 +00:00
  • fda6c06222 Merged PR 3902: Exposes New Dash Booking Summary Oriol Roqué Paniagua 2024-12-27 12:22:19 +00:00
  • a51ad3dd69 Merged PR 3901: Booking Service Detail improvements Oriol Roqué Paniagua 2024-12-27 10:42:47 +00:00
  • 5fd69b7101 Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2024-12-23 12:19:55 +01:00
  • b7541b9a2a add grant for billingreader Pablo Martin 2024-12-23 12:19:52 +01:00
  • 3b17fa231e Merged PR 3879: Feedback on current process Joaquin Ossa 2024-12-23 09:09:13 +00:00
  • 392ba792d8 Merged PR 3888: Check in Hero users table Joaquin Ossa 2024-12-20 15:27:50 +00:00
  • 10f42d1146 Check in Hero users table Joaquin Ossa 2024-12-20 15:36:00 +01:00
  • 19d883ccd7 Simplify PR Joaquin Ossa 2024-12-20 14:03:58 +01:00
  • 79b408f3d2 update booking_fee calculation Joaquin Ossa 2024-12-20 11:18:52 +01:00
  • 3d2477f8f9 Feedback on current process Joaquin Ossa 2024-12-19 17:18:27 +01:00
  • 7728eb73c1 Merged PR 3882: Fix naming error Joaquin Ossa 2024-12-20 10:35:03 +00:00
  • 2113430e26 Fix naming error Joaquin Ossa 2024-12-20 08:37:31 +01:00
  • b20b819456 Merged PR 3878: Propagates account type to intermediate Oriol Roqué Paniagua 2024-12-19 16:33:35 +00:00
  • 7b28bbb925 Merged PR 3875: Propagates AccountType to staging Oriol Roqué Paniagua 2024-12-19 14:23:47 +00:00
  • 14fd52bb36 Merged PR 3871: Add FX rates integration exposure. Pablo Martín 2024-12-19 11:32:16 +00:00
  • 6fd9c16e59 Merged PR 3872: Staging model for all screen & protect price tables Joaquin Ossa 2024-12-19 10:24:10 +00:00
  • 2a87e4860c Added _in_local_currency to fees namings Joaquin Ossa 2024-12-19 11:13:53 +01:00
  • 5475bdd513 Merged PR 3869: S&P models update Joaquin Ossa 2024-12-19 10:02:35 +00:00
  • 5a92337b43 Clarification of long stay Joaquin Ossa 2024-12-18 14:52:46 +01:00
  • 463226a44b Staging model for all screen & protect price tables Joaquin Ossa 2024-12-18 14:48:36 +01:00
  • 4dbecae0ba add exposure Pablo Martin 2024-12-18 14:39:23 +01:00
  • 0cebdcf160 new approach for S&P users data extraction Joaquin Ossa 2024-12-18 11:46:54 +01:00
  • 24aa9b7021 Helped with readability on test Joaquin Ossa 2024-12-18 10:52:52 +01:00
  • c95f551acf s&p update models Joaquin Ossa 2024-12-17 19:09:54 +01:00
  • 384665c487 Merged PR 3857: Propagate Amount of Properties in HS deal Oriol Roqué Paniagua 2024-12-17 09:02:11 +00:00
  • defa36de8a Merged PR 3855: fixed number of nights in edeposit Joaquin Ossa 2024-12-16 13:58:49 +00:00
  • 3653ad8adf fixed number of nights in edeposit Joaquin Ossa 2024-12-16 13:53:57 +01:00
  • 2426d5c6fd Merged PR 3843: Added the has_user_moved_from_old_dash field Joaquin Ossa 2024-12-13 10:00:08 +00:00
  • 4569c5d0da Added the has_user_moved_from_old_dash field Joaquin Ossa 2024-12-13 10:56:56 +01:00
  • bcff898e45 Merged PR 3842: update exposures Joaquin Ossa 2024-12-12 16:37:47 +00:00
  • f2394d89ac new link Joaquin Ossa 2024-12-12 17:06:31 +01:00
  • 52ecdc1046 update exposures Joaquin Ossa 2024-12-12 16:46:45 +01:00
  • f2e5df0fa5 Merged PR 3834: Added nbr of nights to avoid calculation in PBI Joaquin Ossa 2024-12-12 11:13:08 +00:00
  • dbbfe2eb44 Changed description Joaquin Ossa 2024-12-12 11:29:11 +01:00
  • e18750d720 Added nbr og nights to avoid calculation in PBI Joaquin Ossa 2024-12-12 11:27:48 +01:00
  • 85a02f8a1e Merged PR 3826: Check in Hero models Joaquin Ossa 2024-12-11 16:23:12 +00:00
  • 8052581a3d Merged PR 3827: S&P models update Joaquin Ossa 2024-12-11 15:59:11 +00:00
  • 34a5b0d86e Adding missing field in S&P models Joaquin Ossa 2024-12-11 16:35:40 +01:00
  • 11eecfec99 addressed comments Joaquin Ossa 2024-12-11 16:13:34 +01:00
  • a564afea3c wip Joaquin Ossa 2024-12-11 15:42:35 +01:00
  • cbb93982d0 Check in Hero models Joaquin Ossa 2024-12-11 14:32:39 +01:00
  • c0e6ec2de8 Merged PR 3825: Removing Booking fields soon to be dropped Oriol Roqué Paniagua 2024-12-11 13:06:28 +00:00
  • af7a194840 Merged PR 3823: Apim User staging models Joaquin Ossa 2024-12-11 11:23:31 +00:00
  • ae80c6eb7f fixed id_apim_user description Joaquin Ossa 2024-12-11 12:18:33 +01:00
  • 0c9c284e3c Apim User staging models Joaquin Ossa 2024-12-11 12:05:01 +01:00
  • ca0fa8b62d Merged PR 3821: fixed name Joaquin Ossa 2024-12-11 09:50:22 +00:00
  • baa437708f fixed name Joaquin Ossa 2024-12-11 10:47:33 +01:00
  • 15fd885f8a Merged PR 3814: staging model check in hero Joaquin Ossa 2024-12-10 17:19:45 +00:00
  • b17e865162 local currency Joaquin Ossa 2024-12-10 17:12:14 +01:00
  • 92dd5b0960 Updated currency description Joaquin Ossa 2024-12-10 15:53:22 +01:00
  • 902e474148 staging model check in hero Joaquin Ossa 2024-12-10 12:03:34 +01:00
  • c3d75bb143 Differentiate exposures uri 2024-12-09 17:22:16 +01:00
  • 06603d01e2 Merged PR 3810: Adds is_end_of_month_or_yesterday for Main KPIs Oriol Roqué Paniagua 2024-12-09 16:13:52 +00:00
  • 8586dc2aec Merged PR 3802: exposures update Joaquin Ossa 2024-12-09 13:54:33 +00:00
  • dfd7e50edd Changed it to API Reports and added E-Deposit Verifications Joaquin Ossa 2024-12-09 11:12:37 +01:00
  • be6e87efb1 exposures update Joaquin Ossa 2024-12-09 09:20:15 +01:00
  • 0c82a9592d Remove accepted values test from service status in stg_core__booking_view_to_service uri 2024-12-04 16:49:07 +01:00
  • 32f1dd68a1 Merged PR 3775: Final clarifications Joaquin Ossa 2024-12-04 15:42:14 +00:00
  • 1f683ec651 Final clarifications Joaquin Ossa 2024-12-04 16:33:50 +01:00
  • 0b6612f25b Merged PR 3771: Intermediate and reporting models Joaquin Ossa 2024-12-04 13:51:03 +00:00
  • 2a19f1d19a Added ProtectionType Joaquin Ossa 2024-12-04 14:36:49 +01:00
  • c8ee8bd456 intermediate and reporting models Joaquin Ossa 2024-12-04 11:15:21 +01:00
  • fba05c5dd3 Merged PR 3763: Staging model for S&P Joaquin Ossa 2024-12-04 09:59:51 +00:00
  • 588e94ed7c Upper cased Joaquin Ossa 2024-12-04 10:59:13 +01:00
  • 616b949ba4 Merged PR 3769: Adds int_core__ab_test_monitoring_guest_journey Oriol Roqué Paniagua 2024-12-04 09:45:09 +00:00
  • 37c508fa69 Merged PR 3766: First version of ab_test_tracking_guest_journey Oriol Roqué Paniagua 2024-12-04 07:58:14 +00:00
  • 896526fe15 Merged PR 3761: Remove no longer existing fields from Accommodation Oriol Roqué Paniagua 2024-12-03 16:39:05 +00:00
  • d5f0db71fd Staging model for S&P Joaquin Ossa 2024-12-03 17:29:37 +01:00
  • e8f7278032 Merged PR 3756: First version of verification request feature flag Oriol Roqué Paniagua 2024-12-03 16:01:23 +00:00
  • 62e1b6ea3b Merged PR 3752: Adds new PROTECTED accepted value for new pricing services Oriol Roqué Paniagua 2024-12-03 13:36:24 +00:00
  • c5b7d919c5 Merged PR 3743: Hotfix for staging core accommodation Oriol Roqué Paniagua 2024-12-03 11:26:52 +00:00
  • 7ef6fb3031 Merged PR 3740: Added missing values Joaquin Ossa 2024-12-03 11:11:17 +00:00
  • 1af03e2b42 included id_accommodation Joaquin Ossa 2024-12-03 11:58:42 +01:00
  • 63b3cae062 Removed null fields Joaquin Ossa 2024-12-03 11:35:03 +01:00
  • 4d0c45e49d updated schemas Joaquin Ossa 2024-12-03 10:46:01 +01:00