Commit graph

  • a1e3174700 e-deposit verifications data to intermediate Joaquin Ossa 2024-08-27 16:57:55 +02:00
  • 7786f2e770 1st commit edeposit_verifications Joaquin Ossa 2024-08-27 14:55:29 +02:00
  • 2facaceec0 Merged PR 2662: New Dash MVP - with. fix on production issue Oriol Roqué Paniagua 2024-08-28 10:09:08 +00:00
  • f6f4ca83b7 Merged PR 2658: fixed testing for core__check_in_cover_listings Joaquin Ossa 2024-08-28 10:07:11 +00:00
  • a0b5b0bda1 Merged PR 2660: Revert 'Automating new dash query' Oriol Roqué Paniagua 2024-08-28 09:40:09 +00:00
  • 8f38e94a5c Merged PR 2657: Automating new dash query Oriol Roqué Paniagua 2024-08-28 09:32:17 +00:00
  • 46a6ff057d fixed testing for core__check_in_cover_listings Joaquin Ossa 2024-08-28 10:47:31 +02:00
  • 00b8c66709 Merged PR 2652: Adds accommodation to product bundle in intermediate Oriol Roqué Paniagua 2024-08-27 14:05:24 +00:00
  • 67468a3220 Merged PR 2653: fixed bookings test to include null for verification_request_booking_source Joaquin Ossa 2024-08-27 13:48:52 +00:00
  • 87eac12281 fixed bookings test to include null for verification_request_booking_source Joaquin Ossa 2024-08-27 15:45:22 +02:00
  • b927635cf1 Merged PR 2650: Added int_core__booking_to_product_bundle in intermediate Oriol Roqué Paniagua 2024-08-27 12:51:55 +00:00
  • c613d2859f Merged PR 2648: Fixes int_dates_by_deal tests Oriol Roqué Paniagua 2024-08-27 09:34:07 +00:00
  • 3c73bcf965 Merged PR 2646: Add missing edeposit columns Pablo Martín 2024-08-27 09:22:52 +00:00
  • cb3d1e628b Merged PR 2647: Adding accommodation_to_product_bundle to stg Oriol Roqué Paniagua 2024-08-27 08:57:23 +00:00
  • 4cc456c3b0 add missing columns to model Pablo Martin 2024-08-27 10:33:18 +02:00
  • 9432313adc pending todo so i don't forget Pablo Martin 2024-08-26 16:30:18 +02:00
  • 9564ea1d46 add script Pablo Martin 2024-08-26 16:28:32 +02:00
  • 46ff9514a6 Merged PR 2644: Fix deployment alerts Pablo Martín 2024-08-26 14:19:47 +00:00
  • 5c55aa8094 add exec, remove pipes Pablo Martin 2024-08-26 12:55:51 +02:00
  • 5e41e88b59 typo in docker compose Pablo Martin 2024-08-26 12:38:09 +02:00
  • 05f82ed2e1 Merged PR 2640: Change recommended local postgres settings Pablo Martín 2024-08-26 10:18:55 +00:00
  • 3d9c7cf571 Merged PR 2636: First version of User Product Bundle Oriol Roqué Paniagua 2024-08-26 09:18:56 +00:00
  • c21d77b8ae Merged PR 2641: Add version to e-deposit verifications table Pablo Martín 2024-08-26 09:07:33 +00:00
  • c0f4a59aeb add version field to staging table Pablo Martin 2024-08-26 09:30:10 +02:00
  • 43ec5866d1 add note in readme Pablo Martin 2024-08-23 16:27:00 +02:00
  • cd93fe381f add settings Pablo Martin 2024-08-23 16:25:21 +02:00
  • a24c2efb5a Merged PR 2631: Accounting Report Exposures Pablo Martín 2024-08-22 12:23:14 +00:00
  • c8f4d2be70 Merged PR 2629: Integrates logic to detect New Dashboard users within DWH Oriol Roqué Paniagua 2024-08-22 12:10:25 +00:00
  • 3d09d04068 Merged PR 2624: Configuring by number of listings to prod Oriol Roqué Paniagua 2024-08-22 06:49:15 +00:00
  • 78838cb7f6 Merged PR 2619: edeposit verifications container to staging Pablo Martín 2024-08-21 15:59:39 +00:00
  • 4214c6b1c5 schema, small fixes on model Pablo Martin 2024-08-21 17:48:06 +02:00
  • 85131985d8 Merged PR 2615: Beautification of KPIs dimensions Oriol Roqué Paniagua 2024-08-21 14:42:05 +00:00
  • 40168f74b3 reorder fields Pablo Martin 2024-08-21 15:13:19 +02:00
  • 34a2279387 some casts Pablo Martin 2024-08-21 15:12:05 +02:00
  • 64e5d78578 progress in staging, ordered fields Pablo Martin 2024-08-21 12:56:45 +02:00
  • 2331db2803 add source file Pablo Martin 2024-08-21 12:46:05 +02:00
  • 83d913f9fc Merged PR 2607: Propagates and exposes multiple dimension handling for KPIs Oriol Roqué Paniagua 2024-08-20 15:42:27 +00:00
  • d65675fe03 Merged PR 2604: Finished adding address_validation to reporting Joaquin Ossa 2024-08-20 12:16:19 +00:00
  • bf9652f258 Finished adding address_validation to reporting Joaquin Ossa 2024-08-20 14:11:21 +02:00
  • db9f9a6c25 Merged PR 2599: Added address_validation to int_core__vr_check_in_cover Joaquin Ossa 2024-08-20 12:06:51 +00:00
  • 80abac494a Merged PR 2583: Invoicing metrics per customer segmentation Oriol Roqué Paniagua 2024-08-20 12:05:53 +00:00
  • 68f490f9fa Merged PR 2593: Modifying int_core__user_host to take into account KYG users Oriol Roqué Paniagua 2024-08-20 11:27:43 +00:00
  • 45f7f640ba Changed names for easier understanding Joaquin Ossa 2024-08-20 12:56:52 +02:00
  • c9fb99743a Merge remote-tracking branch 'origin/models/17069_addressvalidation_to_reporting' into models/17069_addressvalidation_to_reporting Joaquin Ossa 2024-08-20 12:32:58 +02:00
  • 8171fda345 Merged PR 2578: Created address_validations in intermediate Joaquin Ossa 2024-08-20 09:46:27 +00:00
  • 1c60099b0b Removed coalesce so it includes NULL for failed validations Joaquin Ossa 2024-08-20 10:02:04 +02:00
  • 798fc7b937 Removed coalesce so it includes NULL for failed validations Joaquin Ossa 2024-08-20 09:49:34 +02:00
  • ff962608ad Added Address_validation to int_core__vr_check_in_cover Joaquin Ossa 2024-08-20 09:27:49 +02:00
  • e1d04c2e4e Merged PR 2580: Guest Payments metrics per customer segmentation Oriol Roqué Paniagua 2024-08-19 11:45:42 +00:00
  • 997cb85c6c Merged PR 2577: Adding get_kpi_dimensions_for_production Oriol Roqué Paniagua 2024-08-19 09:57:28 +00:00
  • e8b76e130e Created address_validations in intermediate Joaquin Ossa 2024-08-19 11:43:54 +02:00
  • 89dd8845cc Merged PR 2575: Accommodation metrics per customer segmentation Oriol Roqué Paniagua 2024-08-19 09:03:42 +00:00
  • 52f42b9e9b Revert "Created address_validation in staging" Joaquin Ossa 2024-08-16 12:57:54 +02:00
  • 4a6fdd5ac7 Created address_validation in staging Joaquin Ossa 2024-08-16 12:51:13 +02:00
  • 63d7ebb6d1 Merged PR 2564: New model for verification_to_address_validation Joaquin Ossa 2024-08-16 09:21:31 +00:00
  • be9757b886 Modified source and included test for id_address_validation as unique as well Joaquin Ossa 2024-08-16 11:15:40 +02:00
  • 34ba2a2e4a Merged PR 2563: new address_validation model in staging Joaquin Ossa 2024-08-14 15:37:12 +00:00
  • 1d4a2d7b34 reorganized columns Joaquin Ossa 2024-08-14 17:36:28 +02:00
  • 1e818ea306 organized columns Joaquin Ossa 2024-08-14 17:34:04 +02:00
  • fa5cfb8c66 removed extra _airbyte_raw_id Joaquin Ossa 2024-08-14 17:31:36 +02:00
  • fd44f94b78 new verification_to_address_validation model in staging Joaquin Ossa 2024-08-14 17:30:09 +02:00
  • cdd3b6a58f new address_validation model in staging Joaquin Ossa 2024-08-14 17:16:35 +02:00
  • cb3cf24b60 Merged PR 2540: Add UserProductBundle to staging Pablo Martín 2024-08-12 09:20:35 +00:00
  • 2ebf6a711c add tests Pablo Martin 2024-08-12 11:20:09 +02:00
  • 419f07e77c rename Pablo Martin 2024-08-12 11:19:32 +02:00
  • a39f4d24aa add staging model Pablo Martin 2024-08-12 11:18:49 +02:00
  • 501a063635 add source Pablo Martin 2024-08-12 11:16:53 +02:00
  • 8c78f880ec change column name, previous was not accurate Pablo Martin 2024-08-12 11:08:28 +02:00
  • 22ccae5b9a add tests Pablo Martin 2024-08-12 11:05:12 +02:00
  • 6c77eed984 Merged PR 2539: Claim model to staging Pablo Martín 2024-08-12 09:03:32 +00:00
  • 59477a4641 typo Pablo Martin 2024-08-12 11:01:09 +02:00
  • 51fd0cf3bc add staging model Pablo Martin 2024-08-12 11:00:13 +02:00
  • e4b0f54241 add to sources Pablo Martin 2024-08-12 10:47:55 +02:00
  • cfe02fb99c add PK test Pablo Martin 2024-08-12 10:42:40 +02:00
  • 81b900b6d2 add claim to staging Pablo Martin 2024-08-12 10:42:29 +02:00
  • 0ba3f13055 add claim to sources Pablo Martin 2024-08-12 10:37:40 +02:00
  • d323460d1a Merged PR 2534: Deal metrics per customer segmentation Oriol Roqué Paniagua 2024-08-09 10:03:35 +00:00
  • 6a660aeac8 Merged PR 2533: Guest Journey metrics per customer segmentation Oriol Roqué Paniagua 2024-08-09 08:41:14 +00:00
  • 6116633590 Merged PR 2531: Fixed models for mtd_aggregated_metrics Joaquin Ossa 2024-08-09 07:11:58 +00:00
  • 87bee4a95a Fixed models for mtd_aggregated_metrics Joaquin Ossa 2024-08-08 17:06:11 +02:00
  • 6caac0bb02 Merged PR 2527: Revert 'Added relative_increment_with_sign_format' Oriol Roqué Paniagua 2024-08-08 13:27:33 +00:00
  • 661f9b9245 Merged PR 2526: Revert 'Modified mtd_aggregated_metrics to reporting' Oriol Roqué Paniagua 2024-08-08 13:27:06 +00:00
  • 0777b3210a Merged PR 2525: Modified mtd_aggregated_metrics to reporting Joaquin Ossa 2024-08-08 13:20:31 +00:00
  • b61fe3f70d Merged PR 2522: Don't Repeat Yourself for KPIs - Applied to Bookings Oriol Roqué Paniagua 2024-08-08 13:19:57 +00:00
  • d11f639562 Modified mtd_aggregated_metrics to reporting Joaquin Ossa 2024-08-08 15:08:11 +02:00
  • 90a7ad5eea Merged PR 2524: Added relative_increment_with_sign_format Joaquin Ossa 2024-08-08 13:02:25 +00:00
  • 8ac1eb4717 Added relative_increment_with_sign_format Joaquin Ossa 2024-08-08 14:48:12 +02:00
  • afc20f0e20 Merged PR 2519: mtd bookings with 2 dimensions Oriol Roqué Paniagua 2024-08-08 09:11:01 +00:00
  • 7177b41e19 Merged PR 2516: Create host_user and user_role in intermediate Oriol Roqué Paniagua 2024-08-07 14:28:34 +00:00
  • ad7d94b604 Merged PR 2511: Adding stg_core__role and stg_core__user_role in staging Oriol Roqué Paniagua 2024-08-07 13:17:31 +00:00
  • 94bdc53adf Merged PR 2498: Materialise int_dates_mtd and int_dates_by_deal as table to improve performance Oriol Roqué Paniagua 2024-08-06 15:03:32 +00:00
  • b1bdbc0f39 Merged PR 2459: duplicated_bookings modification Joaquin Ossa 2024-08-05 09:44:11 +00:00
  • 7fe2d779e2 Merged PR 2469: Included the exchange rate to GBP in the model Joaquin Ossa 2024-08-02 11:10:13 +00:00
  • a82ab121f1 Deleted an extra line Joaquin Ossa 2024-08-01 16:18:25 +02:00
  • 02ddac3167 Added a coalesce for the booking_fee_in_gbp calculation for old cases where there is no preferred currency for the user_guest Joaquin Ossa 2024-08-01 16:15:48 +02:00
  • 25e657014a Modified filter and table used Joaquin Ossa 2024-08-01 14:32:45 +02:00
  • 0281e6e72e Included the exchange rate to GBP in the model Joaquin Ossa 2024-08-01 12:58:36 +02:00
  • 161f4c1645 Merged PR 2467: Added host_booking_fees model to report Joaquin Ossa 2024-08-01 10:01:54 +00:00
  • a75a4e9763 Added host_booking_fees model to report Joaquin Ossa 2024-07-31 17:35:14 +02:00
  • adefe2d3ce Merged PR 2465: Creating model host_booking_fees Joaquin Ossa 2024-07-31 15:19:12 +00:00