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

Commit graph

  • 72c966631e Merged PR 2824: Propagates Billing Country and Deal Name into int_dates_by_deal Oriol Roqué Paniagua 2024-09-12 10:27:56 +00:00
  • 83d98c59b1 Merged PR 2796: Fixed model that wasn't mapping correctly Joaquin Ossa 2024-09-10 10:30:08 +00:00
  • 91296fa91c Fixed model that wasn't mapping correctly Joaquin Ossa 2024-09-10 12:09:16 +02:00
  • d5151e2e90 Merged PR 2788: Update edeposit users table Joaquin Ossa 2024-09-10 08:35:37 +00:00
  • 6ed48a39fc Included explanation in schema Joaquin Ossa 2024-09-09 18:36:13 +02:00
  • a54bc78c53 Fixed mapping Joaquin Ossa 2024-09-09 18:32:25 +02:00
  • 7ea70d3f4c Update of users table Joaquin Ossa 2024-09-09 17:51:06 +02:00
  • 2733adfd31 Merged PR 2774: Inline CTEs on int_core__mtd_booking_metrics Pablo Martín 2024-09-09 12:55:24 +00:00
  • 599f00093e Merged PR 2760: Adding latest_date_is_yesterday test Oriol Roqué Paniagua 2024-09-09 12:52:53 +00:00
  • 3bef513443 Merged PR 2768: Specifying sqlfmt instructions to follow for dbt Power User Oriol Roqué Paniagua 2024-09-09 12:51:47 +00:00
  • afaceefe88 comment a bit more Pablo Martin 2024-09-09 12:31:34 +02:00
  • 6daec3135c Merged PR 2770: First version of name unification for a deal Oriol Roqué Paniagua 2024-09-09 10:23:03 +00:00
  • c22a840084 inline the CTEs of the model Pablo Martin 2024-09-09 12:05:44 +02:00
  • f18a2eb520 First version of name unification for a deal uri 2024-09-06 17:08:50 +02:00
  • 8756d21d8c Specifying sqlfmt instructions to follow for dbt Power User uri 2024-09-06 15:46:19 +02:00
  • cb1f00849d Updated exposures for E-deposit Joaquin Ossa 2024-09-06 09:16:14 +02:00
  • cb8beab129 Modifying strenght by tolerance to clarify naming uri 2024-09-06 09:15:33 +02:00
  • 0f73b70942 Adding new column test: latest_date_is_yesterday uri 2024-09-06 09:13:27 +02:00
  • 1e89966153 Merged PR 2756: guesty_verifications model Joaquin Ossa 2024-09-05 15:32:43 +00:00
  • 7036b24847 guesty_verifications model Joaquin Ossa 2024-09-05 17:21:48 +02:00
  • 00a97a3aff Merged PR 2755: Exposes By Billing Country dimension in KPIs to production Oriol Roqué Paniagua 2024-09-05 14:55:30 +00:00
  • f553e73089 Merged PR 2753: Remove distincts from booking counts Pablo Martín 2024-09-05 14:54:50 +00:00
  • 836be7903b Fix config - again uri 2024-09-05 16:34:17 +02:00
  • 05058f9e05 Fix - wrong config uri 2024-09-05 16:18:49 +02:00
  • 2662527790 Enable By Billing Country dimension in prod uri 2024-09-05 16:17:05 +02:00
  • 4322206091 Merged PR 2752: Adding specific business tests for kpis Oriol Roqué Paniagua 2024-09-05 14:01:58 +00:00
  • 01c9c0d8ad remove distincts from booking counts Pablo Martin 2024-09-05 15:17:45 +02:00
  • d7c8e2a84e Merged PR 2750: Changed model for bookings with 0 nights Joaquin Ossa 2024-09-05 12:27:50 +00:00
  • 920f6f7e51 Changed model for bookings with 0 nights Joaquin Ossa 2024-09-05 13:56:07 +02:00
  • 81f57e0b5a Merged PR 2748: guesty_verifications to reporting Joaquin Ossa 2024-09-05 11:38:04 +00:00
  • 01115e0594 Merged PR 2749: Silly mistake fixed Joaquin Ossa 2024-09-05 10:47:13 +00:00
  • 82629e040b Silly mistake fixed Joaquin Ossa 2024-09-05 12:45:09 +02:00
  • 8a49580888 guesty_verifications to reporting Joaquin Ossa 2024-09-05 11:59:57 +02:00
  • 435db55c1e Merged PR 2743: Fixes deal-based issues on the billing country dimension Oriol Roqué Paniagua 2024-09-05 09:53:16 +00:00
  • bc77e5df08 Merged PR 2744: verifications model for Guesty Joaquin Ossa 2024-09-05 09:51:08 +00:00
  • 7087e9193c changed ok_status_fee_in_gbp and added to description Joaquin Ossa 2024-09-05 11:26:37 +02:00
  • 126973ce1c included filter of number of nights as a temporary solution for the problem with the data Joaquin Ossa 2024-09-05 09:09:40 +02:00
  • fc95bd481a Merged PR 2742: Creation of int_core__deal Oriol Roqué Paniagua 2024-09-04 16:03:36 +00:00
  • d189aaa797 1st commit Joaquin Ossa 2024-09-04 17:24:55 +02:00
  • dd57c28768 Merged PR 2728: edeposit verifications docs and small refactors Pablo Martín 2024-09-04 11:07:58 +00:00
  • 556a52e991 Merged PR 2689: KPIs by Billing Country Oriol Roqué Paniagua 2024-09-04 10:17:12 +00:00
  • 940896824f Merged PR 2730: Exposing Billable Bookings metric for KPIs Oriol Roqué Paniagua 2024-09-04 08:15:37 +00:00
  • 7e92037c66 Merged PR 2731: edeposit_verifications_fees to reporting Joaquin Ossa 2024-09-04 08:07:22 +00:00
  • a3e6ad27c2 Set at 5% Joaquin Ossa 2024-09-04 10:06:37 +02:00
  • f8131d9111 edeposit_verifications_fees to reporting, this would be the model to use in the business overview report Joaquin Ossa 2024-09-04 09:27:13 +02:00
  • 08abcb5373 add date fields to docs Pablo Martin 2024-09-04 09:21:22 +02:00
  • 443216bfaf more fixes in docs Pablo Martin 2024-09-04 09:15:33 +02:00
  • cfab0b4b33 add missing field Pablo Martin 2024-09-04 09:12:21 +02:00
  • 475116a32b rename field in docs Pablo Martin 2024-09-04 09:12:17 +02:00
  • 470e5c7990 Merged PR 2679: edeposit_agg_fee_per_user to reporting Joaquin Ossa 2024-09-04 07:08:38 +00:00
  • e750e288c5 fix typo in schema Pablo Martin 2024-09-03 18:19:17 +02:00
  • 9f80f0a916 shit date casts left Pablo Martin 2024-09-03 18:03:19 +02:00
  • 37856ec606 shift renames left, remove deprecated fields from int Pablo Martin 2024-09-03 17:54:36 +02:00
  • c35c5cb033 schema and tests Pablo Martin 2024-09-03 17:52:00 +02:00
  • 9a6490e7fd minor change in model Pablo Martin 2024-09-03 17:51:54 +02:00
  • 97e9f0cf76 Merged PR 2727: changed athena name Joaquin Ossa 2024-09-03 15:23:57 +00:00
  • 2602be2567 changed athena name Joaquin Ossa 2024-09-03 17:09:52 +02:00
  • 7d8983e0dd Fixed model, added created_date and checkout_date Joaquin Ossa 2024-09-03 17:05:13 +02:00
  • 6d59e21310 Merged PR 2725: Force id user field to lower in staging Oriol Roqué Paniagua 2024-09-03 14:36:21 +00:00
  • 1b30fbbca9 Merged PR 2724: Removing coalesce from gbp conversion in int_core__host_booking_fees Oriol Roqué Paniagua 2024-09-03 13:34:08 +00:00
  • c24c875336 Fixed test error Joaquin Ossa 2024-09-03 15:04:44 +02:00
  • 560e2a5994 Modified model to only have fees Joaquin Ossa 2024-09-03 12:15:14 +02:00
  • 920733fceb Updating with Ray's comments Joaquin Ossa 2024-09-02 11:16:51 +02:00
  • a99d4f622f Modified model to only have fees Joaquin Ossa 2024-09-03 12:15:14 +02:00
  • 906bccce0e modified model Joaquin Ossa 2024-08-30 11:33:55 +02:00
  • 4cfc0dcd45 Merged PR 2642: Booking Charge Events to have a similar logic as invoicing Oriol Roqué Paniagua 2024-09-03 13:15:40 +00:00
  • 0cb03e0808 Merged PR 2707: E-Deposit users to staging Joaquin Ossa 2024-09-03 12:53:41 +00:00
  • 322b122925 Added missing tests Joaquin Ossa 2024-09-03 10:21:23 +02:00
  • fa6f7f8ff8 Filtering out test users so all tests work correctly Joaquin Ossa 2024-09-03 10:15:20 +02:00
  • ccef428020 Merged PR 2694: Basic model changes for edeposit Joaquin Ossa 2024-09-02 15:01:40 +00:00
  • 89792cf0b7 final comments Joaquin Ossa 2024-09-02 17:01:18 +02:00
  • 6dedbc04d7 Added more tests but still waiting confirmation on tests users from Ray and Ana Joaquin Ossa 2024-09-02 16:55:56 +02:00
  • ffef9e3ff2 Added all date_utc fields Joaquin Ossa 2024-09-02 12:52:16 +02:00
  • 129b00e29b Added more description and tests to schema Joaquin Ossa 2024-09-02 12:44:05 +02:00
  • ee4d213274 edeposit_users to staging Joaquin Ossa 2024-09-02 11:33:25 +02:00
  • b6a752fd74 edeposit_users to staging Joaquin Ossa 2024-09-02 11:33:21 +02:00
  • 46d5e7c3c5 Updating with Ray's comments Joaquin Ossa 2024-09-02 11:16:51 +02:00
  • d8e6ee3ab0 Merged PR 2704: Adding New Dash exposures Oriol Roqué Paniagua 2024-09-02 07:22:29 +00:00
  • dad16f28b9 Merged PR 2690: VAT rates for guest services seed model Pablo Martín 2024-08-30 10:49:30 +00:00
  • 7a77691b89 deleted schema from edeposit reporting Joaquin Ossa 2024-08-30 10:58:24 +02:00
  • fd98f31fdd Kept basic models to reduce complexity of models/20125_edeposit_migration_agg_model_reporting Joaquin Ossa 2024-08-30 10:54:00 +02:00
  • 42510bbb4d Just committing to save change and create a new branch for basic to push basic changes Joaquin Ossa 2024-08-30 10:33:43 +02:00
  • a839aa4eb3 fix typo Pablo Martin 2024-08-29 17:29:21 +02:00
  • 7ba65999c3 Merged PR 2687: Materialize int_core__verification_payments as a table Oriol Roqué Paniagua 2024-08-29 14:25:18 +00:00
  • 6adc424963 addressed Pablo's comments, removed the repetitive casts, added some nut_null tests and fixed some of the names and descriptions discrepancies Joaquin Ossa 2024-08-29 14:25:00 +02:00
  • ad2eb2544c edeposit_agg_fee_per_user to reporting Joaquin Ossa 2024-08-29 11:09:09 +02:00
  • 951bc70123 Merged PR 2671: New aggregated model for E-deposit report Joaquin Ossa 2024-08-29 08:33:45 +00:00
  • 2f77c8eea8 Merged PR 2676: Propagates Billing Country information Oriol Roqué Paniagua 2024-08-29 08:25:05 +00:00
  • 189e77dd76 fixed variable definitions and added comments for currency-less fees Joaquin Ossa 2024-08-29 09:30:36 +02:00
  • 60ae3f2844 wip, but tests are not picked up Pablo Martin 2024-08-28 17:15:33 +02:00
  • be59ab258a Fixed test Joaquin Ossa 2024-08-28 16:42:10 +02:00
  • 0137179396 Merged PR 2669: Scheduled tests Pablo Martín 2024-08-28 14:40:41 +00:00
  • 0b6239e5c2 New aggregated model in intermediate for e-deposit report Joaquin Ossa 2024-08-28 16:38:30 +02:00
  • 10aace0d3f fix log file path Pablo Martin 2024-08-28 16:21:07 +02:00
  • 2481863536 update readme Pablo Martin 2024-08-28 16:20:51 +02:00
  • 958dc97ac2 Merged PR 2656: e-deposit verifications data to intermediate Joaquin Ossa 2024-08-28 13:51:07 +00:00
  • b333b45891 Added some comments to make it clear that ids here are unrelated to core dwh, I will come back to modify the schemas when Ray answers all of our questions related to this data Joaquin Ossa 2024-08-28 15:00:22 +02:00
  • 167645428e renamed columns Joaquin Ossa 2024-08-28 12:04:05 +02:00
  • 5892fe7cbb Changed it to basic model Joaquin Ossa 2024-08-28 10:27:36 +02:00
  • a4dc798f86 e-deposit model WIP Joaquin Ossa 2024-08-28 09:58:14 +02:00