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

Commit graph

  • bc3a364891 Merged PR 5677: Athena/Guesty high risk clients master Oriol Roqué Paniagua 2025-07-11 10:28:24 +00:00
  • ddc0a6a3f4 Merged PR 5678: Revert 'Prettify alerts in test script' Pablo Martin 2025-07-11 09:20:01 +00:00
  • 2f14b3305c Merged PR 5652: Remove third party and guest involvements tests Oriol Roqué Paniagua 2025-07-09 12:31:15 +00:00
  • a1b67d20f1 change materialization of heavy tables Pablo Martin 2025-07-09 11:33:54 +02:00
  • 7488400cbb fix bugs in orphan model detection Pablo Martin 2025-07-08 17:05:45 +02:00
  • 717590513f Merged PR 5617: Orphan Models Script Pablo Martin 2025-07-08 12:45:30 +00:00
  • a1429ccec8 Merged PR 5634: Adapt Revenue Churn Rate Targets from 3% to 1% Oriol Roqué Paniagua 2025-07-07 12:54:39 +00:00
  • 900c73b076 Merged PR 5632: Resolution incidents in status Incomplete now have reduced test coverage Oriol Roqué Paniagua 2025-07-07 12:53:52 +00:00
  • ad67a79a24 script and docs Pablo Martin 2025-07-04 12:25:21 +02:00
  • e0e97709c0 Merged PR 5607: stay confident inclusion Joaquin Ossa 2025-07-02 13:42:45 +00:00
  • b9fe9a0552 stay confident inclusion Joaquin 2025-07-02 14:37:44 +02:00
  • 8bc525e4c2 Merged PR 5589: Limits data test coverage on resolutions data Oriol Roqué Paniagua 2025-07-01 09:44:54 +00:00
  • ca939e0c69 Merged PR 5573: Duplicated payments temporal fix Joaquin Ossa 2025-07-01 08:46:59 +00:00
  • 412e242f42 Merged PR 5586: Fix duplications on 1st of Month for Billable Items Growth Score Oriol Roqué Paniagua 2025-07-01 08:38:21 +00:00
  • 7bf9168796 Merged PR 5582: Update exposures gj ab test Joaquin Ossa 2025-07-01 08:19:53 +00:00
  • 9630001f01 new a/b test model in reporting and updated exposure Joaquin 2025-07-01 09:59:36 +02:00
  • 7330848ed0 Update exposures gj ab test Joaquin 2025-07-01 09:27:02 +02:00
  • 4cda82fe48 duplicated payments temporal fix Joaquin 2025-06-30 14:25:39 +02:00
  • 61c1509337 add sqlfluff to deps Pablo Martin 2025-06-27 11:21:18 +02:00
  • f11945519e Merged PR 5551: Prettify alerts in test script Pablo Martin 2025-06-26 13:23:17 +00:00
  • 71a1bd6da6 modify test script Pablo Martin 2025-06-26 14:58:08 +02:00
  • 8b1c32367d Merged PR 5538: Fixed tests from resolutions Joaquin Ossa 2025-06-25 08:41:57 +00:00
  • 52e351e0ba Fixed tests from resolutions Joaquin 2025-06-20 10:39:21 +02:00
  • 6924d927c3 Merged PR 5508: Finished reporting tests Joaquin Ossa 2025-06-19 12:51:45 +00:00
  • f567b233aa Merged PR 5507: finished updating tests in reporting model Joaquin Ossa 2025-06-19 12:51:26 +00:00
  • d0464bfd1c Finished reporting tests Joaquin 2025-06-19 14:47:13 +02:00
  • df267d605e finished updating tests in reporting model Joaquin 2025-06-19 14:39:57 +02:00
  • 5005b72323 Merged PR 5506: Removed not_null tests Joaquin Ossa 2025-06-19 10:12:16 +00:00
  • a279e78fa2 Merged PR 5505: Remove new deals without lifecycle Joaquin Ossa 2025-06-19 10:12:08 +00:00
  • 76f243a486 Removed not_null tests Joaquin 2025-06-19 11:58:37 +02:00
  • 147197c92d Modified test Joaquin 2025-06-19 11:35:52 +02:00
  • ecf38144cb fixed schema Joaquin 2025-06-19 09:09:56 +02:00
  • 986c9f85a8 exclude deals without lifecycle Joaquin 2025-06-19 09:04:48 +02:00
  • a8927b7a44 Merged PR 5463: New Dash user categorisation + revamp model Oriol Roqué Paniagua 2025-06-13 14:05:30 +00:00
  • 11bdc7d4b3 stay disrupt exposure Pablo Martin 2025-06-13 09:38:30 +02:00
  • 2c5ad8c228 updated CIH exposures Pablo Martin 2025-06-13 09:19:40 +02:00
  • efe3f50a37 relax test that didn't make sense, revert wrong solution to issue from this morning Pablo Martin 2025-06-12 17:56:24 +02:00
  • 2a5c82f62b Merged PR 5455: Bump dbt version to 1.9.8 Pablo Martin 2025-06-12 14:27:45 +00:00
  • 9d100192c0 bump dbt version Pablo Martin 2025-06-12 16:13:53 +02:00
  • 20ce96cd29 Merged PR 5449: silly me Joaquin Ossa 2025-06-12 10:16:47 +00:00
  • ae373a4fc9 silly me Joaquin 2025-06-12 12:07:16 +02:00
  • 20477dcc2c Merged PR 5447: Fix GJ Payments consistency with VRs Pablo Martin 2025-06-12 08:06:08 +00:00
  • 5abbff9560 Merged PR 5441: New fields for Invoicing & Crediting Joaquin Ossa 2025-06-12 07:23:11 +00:00
  • 6c7e80eb75 Addressed comments Joaquin 2025-06-12 09:22:22 +02:00
  • 9c4b12e985 Merged PR 5438: Add Flex API into KPI models Joaquin Ossa 2025-06-11 15:01:22 +00:00
  • fcff46144f Merged PR 5431: Update accounting aggregation Joaquin Ossa 2025-06-11 15:01:17 +00:00
  • 80651ce60e New fields for Invoicing & Crediting Joaquin 2025-06-11 16:57:10 +02:00
  • 940d8b3bcf Updated test Joaquin 2025-06-11 15:26:44 +02:00
  • 84e8100706 Merged PR 5439: Removed test Joaquin Ossa 2025-06-11 13:09:30 +00:00
  • f482b64528 Removed test Joaquin 2025-06-11 14:51:20 +02:00
  • 4a4e17f068 Add Flex API into KPI models Joaquin 2025-06-11 14:44:07 +02:00
  • 3e3b7f049e Removed changes Joaquin 2025-06-11 14:34:44 +02:00
  • 55699a1647 Addressed comments and all KPI model changes Joaquin 2025-06-11 12:25:14 +02:00
  • 44b59aafd2 Update accounting aggregation Joaquin 2025-06-11 09:09:57 +02:00
  • 0021827368 Merged PR 5429: Rework Booking Source in int_core__bookings Oriol Roqué Paniagua 2025-06-10 14:38:35 +00:00
  • 47c51dd18d missing filter to avoid new vrs appearing in the old cte Pablo Martin 2025-06-10 16:35:16 +02:00
  • 61ceda5234 Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2025-06-10 15:08:24 +02:00
  • 70cf3ce312 missing cast to make union work Pablo Martin 2025-06-10 15:08:18 +02:00
  • 8b415fc726 Merged PR 5427: data alert fix Joaquin Ossa 2025-06-10 12:57:05 +00:00
  • 5f2bd33eed addressed comments Joaquin 2025-06-10 14:45:53 +02:00
  • c5c25af59b addressed comments Joaquin 2025-06-10 14:42:59 +02:00
  • 1bd2fd9585 updated comments Joaquin 2025-06-10 14:22:40 +02:00
  • a543fa1d83 changed names Joaquin 2025-06-10 14:20:28 +02:00
  • e85de15d22 data alert fix Joaquin 2025-06-10 13:58:50 +02:00
  • c8e4c88074 rename model to make version name explicit Pablo Martin 2025-06-10 12:43:49 +02:00
  • dd17dff93a Merged PR 5424: Bump int_core__check_in_cover_users version Pablo Martin 2025-06-10 10:22:20 +00:00
  • 1f8debc41b bump version Pablo Martin 2025-06-10 12:04:34 +02:00
  • 3518d09970 Merged PR 5423: Update guest_products_feature_flag_activation_timestamp to real value Pablo Martin 2025-06-10 10:21:13 +00:00
  • f185f8fe4b update var to actual timestamp Pablo Martin 2025-06-10 12:00:30 +02:00
  • 58df9fbe87 Merged PR 5422: Change if block to avoid whitespace trimming Pablo Martin 2025-06-10 10:19:23 +00:00
  • ad518c3083 change if block to avoid whitespace trimming Pablo Martin 2025-06-10 11:55:11 +02:00
  • dc0abe6098 Merged PR 5403: Removes test accounts Oriol Roqué Paniagua 2025-06-06 12:17:49 +00:00
  • 08678427ad Bugfix - Host Resolutions Payments not filtering credit notes relevant status uri 2025-06-05 13:35:34 +02:00
  • 9cbb748b0f Merged PR 5389: Adapt Test Account flag with Claim dedicated source Oriol Roqué Paniagua 2025-06-04 12:58:40 +00:00
  • 7f2a8a98b6 Merged PR 5385: id_deal unique test Joaquin Ossa 2025-06-04 12:26:14 +00:00
  • 5fdb5ffcde id_deal unique test Joaquin 2025-06-04 12:28:52 +02:00
  • 8b8b8441d3 Merged PR 5365: New version of CIH users through activity Pablo Martin 2025-06-04 08:55:55 +00:00
  • a401153472 be more precise Pablo Martin 2025-06-04 10:54:27 +02:00
  • 0c11cfe739 removed unused upstream models Pablo Martin 2025-06-04 10:53:24 +02:00
  • 159813544f comment on why user and not host Pablo Martin 2025-06-04 10:53:01 +02:00
  • 54fca806b9 6 months, not one Pablo Martin 2025-06-04 10:48:16 +02:00
  • 8b8e4143ce Merged PR 5381: Removes multi-user test on New Dash onboarding Oriol Roqué Paniagua 2025-06-04 08:08:40 +00:00
  • 536ab9b2a1 Merged PR 5364: Outstanding Payments Joaquin Ossa 2025-06-03 12:53:59 +00:00
  • 1b362024f1 addressed comments Joaquin 2025-06-03 14:17:47 +02:00
  • d50442e887 New model for deals total due amount Joaquin 2025-06-03 11:53:40 +02:00
  • 2746977671 commit wip Joaquin 2025-06-03 10:53:22 +02:00
  • f768be9ea5 commit wip Joaquin 2025-06-03 09:31:56 +02:00
  • affeac612a Merged PR 5366: Adds Incident data to Booking Summary Oriol Roqué Paniagua 2025-06-02 15:56:54 +00:00
  • 92b144d78e Merged PR 5357: Adapt vr_check_in_cover model for Guest Products Pablo Martin 2025-06-02 14:22:58 +00:00
  • 1a35839deb new version and docs Pablo Martin 2025-06-02 16:02:33 +02:00
  • cf5eaac593 Removed total Joaquin 2025-06-02 15:59:34 +02:00
  • 0fdfe651a2 Outstanding Payments Joaquin 2025-06-02 15:58:01 +02:00
  • c6a06b49e9 mention double logic in docs Pablo Martin 2025-05-30 15:50:30 +02:00
  • 7339cf4c87 change logic in new CTE to use new tables Pablo Martin 2025-05-30 15:47:35 +02:00
  • 58c1ae5b8f put var in proper format Pablo Martin 2025-05-30 15:46:45 +02:00
  • d33e5ff2b2 Merged PR 5353: Switch int_core__booking_summary to int_booking_summary Oriol Roqué Paniagua 2025-05-30 12:51:10 +00:00
  • a9a1e68624 Merged PR 5333: Reporting version of Stay Disrupt Conversion Funnel Oriol Roqué Paniagua 2025-05-29 14:57:07 +00:00
  • 5ddba42e12 Merged PR 5342: Booking Summary - add months Oriol Roqué Paniagua 2025-05-28 12:37:43 +00:00
  • f1883aaa7a second cte, then we union Pablo Martin 2025-05-27 15:03:48 +02:00
  • 34985f3de1 wrap final select in cte Pablo Martin 2025-05-27 15:01:47 +02:00