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

Commit graph

  • 20425495f9 staging Hubspot contacts Joaquin Ossa 2024-09-27 10:44:48 +02:00
  • c6e14adad5 Merged PR 2988: Added new role Joaquin Ossa 2024-09-27 08:01:41 +00:00
  • 37d9f5250a Added new role Joaquin Ossa 2024-09-27 09:55:37 +02:00
  • a280f79d18 Merged PR 2971: Fix no tax bug Pablo Martín 2024-09-25 14:24:35 +00:00
  • 0cd8f71889 remove variable that doesn't make sense anymore Pablo Martin 2024-09-25 16:12:55 +02:00
  • bea2e0d926 fix broken case logic Pablo Martin 2024-09-25 16:12:36 +02:00
  • 070d067709 Merged PR 2918: Integrates screening API verifications into DWH staging Oriol Roqué Paniagua 2024-09-25 10:52:50 +00:00
  • 260b46171c Merged PR 2888: No taxes for host takes risk waivers Pablo Martín 2024-09-25 10:34:46 +00:00
  • 73753092fa yolo activate vacuum analyze Pablo Martin 2024-09-20 18:11:59 +02:00
  • e401efdd5d Merged PR 2933: Financial rate metrics Joaquin Ossa 2024-09-20 14:29:30 +00:00
  • 838628c7a8 deleted the collate Joaquin Ossa 2024-09-20 15:16:53 +02:00
  • 5ac1a65e90 Financial rate metrics Joaquin Ossa 2024-09-20 14:53:43 +02:00
  • b3620cc695 Merged PR 2920: Adapt user migration configuration to take into account V2 migrated users Oriol Roqué Paniagua 2024-09-20 10:42:12 +00:00
  • 3723cf0e57 DRY on stg cosmos db models uri 2024-09-19 15:17:33 +02:00
  • 1c1f8ea82e First working version of stg_screening__verifications uri 2024-09-19 14:54:31 +02:00
  • ea430b1f23 Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2024-09-19 11:57:18 +02:00
  • cf7a8917a8 add explanatory comment Pablo Martin 2024-09-19 11:57:13 +02:00
  • feaedb2a06 Merged PR 2911: Bugfix core__bookings failing dbt test Oriol Roqué Paniagua 2024-09-19 07:00:15 +00:00
  • 01eca0dbcc Merged PR 2877: Update model core__verification_payments to include amounts without taxes Joaquin Ossa 2024-09-18 14:30:23 +00:00
  • 7ceeabbe7b Revert "commit" Joaquin Ossa 2024-09-18 14:22:33 +02:00
  • 923bfa7091 Update exposures to pull from version 1 Joaquin Ossa 2024-09-18 14:20:48 +02:00
  • 94ebe67be1 Merged PR 2898: Remove .sql in the xero__bank_transaction_denom_mart Oriol Roqué Paniagua 2024-09-18 12:19:23 +00:00
  • 5620ecbe68 Remove .sql in the xero__bank_transaction_denom_mart uri 2024-09-18 13:52:55 +02:00
  • 985ddb8e4d Merged PR 2887: Check-In Hero - Removing unused fields + schema changes Oriol Roqué Paniagua 2024-09-18 11:48:49 +00:00
  • 40bfa60016 core__verification_payments_v2 Joaquin Ossa 2024-09-18 12:41:00 +02:00
  • 9e62786aa9 commit2 Joaquin Ossa 2024-09-18 11:26:23 +02:00
  • 136c297683 add logic Pablo Martin 2024-09-17 17:56:56 +02:00
  • e854f2a99a commit Joaquin Ossa 2024-09-17 17:10:14 +02:00
  • 78e7e37c5e Update model core__verification_payments to include amounts without taxes Joaquin Ossa 2024-09-17 15:07:00 +02:00
  • 17f7b11a79 Merged PR 2885: update int_core__guest_satisfaction_responses to version 2 of verification_pa... Joaquin Ossa 2024-09-17 15:21:59 +00:00
  • 2dd4f66189 update int_core__guest_satisfaction_responses to version 2 of verification_payments Joaquin Ossa 2024-09-17 17:12:46 +02:00
  • 4bafeba787 Merged PR 2883: Payaway per month and user Pablo Martín 2024-09-17 14:13:01 +00:00
  • a20d511b93 missing text Pablo Martin 2024-09-17 16:12:38 +02:00
  • 049c2d3e31 model and docs+tests Pablo Martin 2024-09-17 15:47:45 +02:00
  • 140da0a75d Merged PR 2874: Add Payaway table to intermediate Pablo Martín 2024-09-17 12:07:07 +00:00
  • f3e9985d0f model and docs Pablo Martin 2024-09-17 12:16:52 +02:00
  • 07db97b79e Merged PR 2870: Add core.PayAway to staging Pablo Martín 2024-09-17 09:59:26 +00:00
  • 1c04c69e89 fix comments Pablo Martin 2024-09-17 11:59:04 +02:00
  • ac87ab4cfd create file Pablo Martin 2024-09-17 11:56:21 +02:00
  • 624c70872f docs and tests Pablo Martin 2024-09-17 11:16:01 +02:00
  • 68a9eafb14 typo in file name Pablo Martin 2024-09-17 10:36:58 +02:00
  • 96d18116ed add staging model Pablo Martin 2024-09-17 10:36:43 +02:00
  • 68c509050f add payway to sources Pablo Martin 2024-09-17 10:32:11 +02:00
  • ae1e45a937 Merged PR 2869: Update mtd_aggregated_metrics guest payments to be tax-exclusive Joaquin Ossa 2024-09-17 07:27:08 +00:00
  • 7b9ba021c1 Merged PR 2865: Propagate tax exclusive check in hero payments Oriol Roqué Paniagua 2024-09-17 07:25:09 +00:00
  • cc837ecd7a Merged PR 2861: Update mtd_aggregated_metrics Joaquin Ossa 2024-09-17 07:09:03 +00:00
  • b21590ab1d Simplified it Joaquin Ossa 2024-09-16 16:20:36 +02:00
  • c3e4a07050 Update mtd_aggregated_metrics Joaquin Ossa 2024-09-16 16:01:49 +02:00
  • 60ea19f5ef remove dangling comment Pablo Martin 2024-09-16 14:45:09 +02:00
  • fcbaae1381 update schemas Pablo Martin 2024-09-16 14:40:01 +02:00
  • fd3b67935b remove old booking metrics Pablo Martin 2024-09-16 14:35:12 +02:00
  • bbbfaeabdf refactor booking metrics children to use new models Pablo Martin 2024-09-16 13:02:42 +02:00
  • 4b5c4d1967 create individual models for each booking metric Pablo Martin 2024-09-16 13:02:09 +02:00
  • 50a8a512fe Update mtd_aggregated_metrics guest payments to be tax-exclusive Joaquin Ossa 2024-09-17 08:38:33 +02:00
  • 02520d87ee Merged PR 2858: Split Booking Metrics Pablo Martín 2024-09-16 14:34:42 +00:00
  • 3d8ede273e Simplified it Joaquin Ossa 2024-09-16 16:20:36 +02:00
  • 54af8af30e Update mtd_aggregated_metrics Joaquin Ossa 2024-09-16 16:01:49 +02:00
  • aeb4538e50 remove dangling comment Pablo Martin 2024-09-16 14:45:09 +02:00
  • fda6647637 update schemas Pablo Martin 2024-09-16 14:40:01 +02:00
  • 385c49bf2c remove old booking metrics Pablo Martin 2024-09-16 14:35:12 +02:00
  • aa06b28a69 refactor booking metrics children to use new models Pablo Martin 2024-09-16 13:02:42 +02:00
  • 4140f5b917 create individual models for each booking metric Pablo Martin 2024-09-16 13:02:09 +02:00
  • 2c17df3742 Merged PR 2854: Exposure for e-deposit invoice Joaquin Ossa 2024-09-16 10:25:19 +00:00
  • c1b97e17e6 Merged PR 2852: Fix: ensure priority selection on user migration Oriol Roqué Paniagua 2024-09-16 09:34:44 +00:00
  • 8fd5061989 Exposure for e-deposit invoice Joaquin Ossa 2024-09-16 11:14:43 +02:00
  • cf1d6e28cc Merged PR 2849: Fix: KYG lite migration with proper date migration handling Oriol Roqué Paniagua 2024-09-16 07:57:41 +00:00
  • 80a6b225b3 Merged PR 2846: removing duplicates from guesty and removing tests for edeposit_users Joaquin Ossa 2024-09-13 15:16:08 +00:00
  • d8501e2df7 kept first updated record instead of last Joaquin Ossa 2024-09-13 17:14:34 +02:00
  • 32c8ffb655 removef all tests for edeposit_verification_fees Joaquin Ossa 2024-09-13 16:31:47 +02:00
  • 5551c97db0 removing duplicates from guesty and removing tests for edeposit_users Joaquin Ossa 2024-09-13 16:14:03 +02:00
  • a8b4c08328 Merged PR 2771: Compute Taxes in intermediate Pablo Martín 2024-09-13 13:24:25 +00:00
  • 6434c5c88d replace custom generic test with standard range between one Pablo Martin 2024-09-13 15:14:32 +02:00
  • 4cf74db49a replace hardcode with variable Pablo Martin 2024-09-13 15:10:58 +02:00
  • 092b8bd725 clarify refund is not in GBP Pablo Martin 2024-09-13 13:09:01 +02:00
  • ec8490527d reorder case for readability Pablo Martin 2024-09-13 13:07:26 +02:00
  • 0312a1ccd8 remove explicit version reference, rely on latest Pablo Martin 2024-09-12 15:00:58 +02:00
  • da3070949a finish columns and schema Pablo Martin 2024-09-12 14:37:45 +02:00
  • 63599d7a9b add columns Pablo Martin 2024-09-10 17:10:37 +02:00
  • 15139e00d0 percentage test Pablo Martin 2024-09-10 17:10:30 +02:00
  • 8c96b96ee5 small comment Pablo Martin 2024-09-10 16:23:41 +02:00
  • 6136db8403 cte for pre-defining if vat is applicable or not Pablo Martin 2024-09-10 16:23:02 +02:00
  • f58e97a3f2 set references for v1 Pablo Martin 2024-09-10 12:49:32 +02:00
  • 2cd115eede remove unnecessary alias, remove unrelated errors in yaml Pablo Martin 2024-09-10 12:49:01 +02:00
  • 1974da99f7 fix typos Pablo Martin 2024-09-10 12:48:40 +02:00
  • d4b797c741 add alias Pablo Martin 2024-09-06 17:31:54 +02:00
  • 4efc1ba50f v1 goes back to original state Pablo Martin 2024-09-06 17:27:56 +02:00
  • bbb9558f62 yaml for new version, plus deprecation Pablo Martin 2024-09-06 17:22:52 +02:00
  • 4ba6c80d6f v2 model Pablo Martin 2024-09-06 17:19:30 +02:00
  • bde6f12404 add new columns Pablo Martin 2024-09-06 16:59:46 +02:00
  • 0aaec6a619 fuck around with Uri Pablo Martin 2024-09-06 16:36:19 +02:00
  • ac1aed029d Merged PR 2832: Format YAML on save + complements Pablo Martín 2024-09-13 08:33:26 +00:00
  • 1043c9e80b final files Pablo Martin 2024-09-12 15:41:34 +02:00
  • df16cdb00c reporting schema Pablo Martin 2024-09-12 15:39:49 +02:00
  • 05d5cc6d10 fix schemas in intermediate Pablo Martin 2024-09-12 15:38:50 +02:00
  • aabb45dbd5 format files in staging Pablo Martin 2024-09-12 15:36:15 +02:00
  • 8fdb88afc7 update readme Pablo Martin 2024-09-12 15:35:13 +02:00
  • 51275b9513 add autoformat on save Pablo Martin 2024-09-12 15:25:45 +02:00
  • 2295679fc9 Merged PR 2828: Exposing Deal info to reporting Oriol Roqué Paniagua 2024-09-12 12:29:37 +00:00
  • 0e94022544 Exposing Deal info to reporting uri 2024-09-12 14:08:36 +02:00
  • c336081d3d Merged PR 2825: Propagates deal Name and Billing Country in int_monthly_aggregated_metrics_history_by_deal Oriol Roqué Paniagua 2024-09-12 12:04:04 +00:00