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

Commit graph

  • 487f6701e3 apply transaction sign in line items Pablo Martin 2024-07-01 11:45:03 +02:00
  • dd5882a564 propagate transaction sign Pablo Martin 2024-07-01 11:44:55 +02:00
  • 0e9c608894 more docs Pablo Martin 2024-07-01 11:39:40 +02:00
  • 1b942b7506 add col Pablo Martin 2024-07-01 11:39:36 +02:00
  • f0f6382bbd update docs Pablo Martin 2024-07-01 11:34:26 +02:00
  • e963ba274d implement transaction sign Pablo Martin 2024-07-01 11:27:18 +02:00
  • de4309b397 Merged PR 2160: Added id_deal to both intermediate and report model Joaquin Ossa 2024-07-01 08:55:01 +00:00
  • 256c638b04 Added id_deal to both intermediate and report model Joaquin Ossa 2024-07-01 10:48:00 +02:00
  • a3b1decb08 Merged PR 2158: Allow last day of the month to appear on 1st of month Oriol Roqué Paniagua 2024-07-01 07:53:38 +00:00
  • d9fcf65a67 Merged PR 2133: Created check_in_cover_users in reporting for check-in hero report Joaquin Ossa 2024-06-28 06:02:29 +00:00
  • 50f93a2980 Created check_in_cover_users in reporting for check-in hero report Joaquin Ossa 2024-06-27 12:24:45 +02:00
  • 618ce087a5 Merged PR 2116: Created model in intermediate Joaquin Ossa 2024-06-27 10:14:02 +00:00
  • cab300f7dd Addressed comments Joaquin Ossa 2024-06-27 12:13:27 +02:00
  • a4b16e7410 Completed the schema for the model Joaquin Ossa 2024-06-27 10:40:44 +02:00
  • 9950c4d9ae Fixed merge error Joaquin Ossa 2024-06-27 10:18:29 +02:00
  • 04de0c8227 Changed name of model Joaquin Ossa 2024-06-27 10:00:47 +02:00
  • 431182a098 Removed accommodations from the model Joaquin Ossa 2024-06-27 08:40:25 +02:00
  • 2a897c6ead fixed model name and dump tables Joaquin Ossa 2024-06-26 10:02:40 +02:00
  • cbd1b4414f Created int model for host accommodations with check in hero Joaquin Ossa 2024-06-25 16:51:10 +02:00
  • 5cc248de9c Merged PR 2124: Denormalized Bank Transactions Mart Pablo Martín 2024-06-26 14:47:18 +00:00
  • 5c12dd3b13 Merged PR 2125: Fixing accommodation host Oriol Roqué Paniagua 2024-06-26 14:47:15 +00:00
  • 69ad42af63 model and schema Pablo Martin 2024-06-26 15:35:44 +02:00
  • 6446dfdb9e Merged PR 2118: Bank Transactions Line Items to Reporting schema Pablo Martín 2024-06-26 12:57:16 +00:00
  • b3263e82b1 docs typos Pablo Martin 2024-06-26 13:40:07 +02:00
  • e8f9432507 add docs and tablesfor table Pablo Martin 2024-06-26 11:43:29 +02:00
  • a22d85340d reporting model Pablo Martin 2024-06-26 11:24:34 +02:00
  • bb17b7a646 put back accidentally removed column that breaks dbt run Pablo Martin 2024-06-25 17:20:36 +02:00
  • 7ba9ca0527 Merged PR 2113: Bank Transactions to reporting Pablo Martín 2024-06-25 15:11:13 +00:00
  • 5182a804b2 fix typos Pablo Martin 2024-06-25 17:09:02 +02:00
  • be24725b7d remove a couple of wrong tests Pablo Martin 2024-06-25 16:44:19 +02:00
  • f9fcb76ed1 schemas Pablo Martin 2024-06-25 16:42:40 +02:00
  • 86ca7411af remove line items: they have their own tables now Pablo Martin 2024-06-25 16:41:41 +02:00
  • 5fbf5a76fd add documentation placeholder Pablo Martin 2024-06-25 16:16:28 +02:00
  • 71278abbb9 remove outdated docs Pablo Martin 2024-06-25 15:24:59 +02:00
  • 8b1d949f73 add bank transactions to reporting Pablo Martin 2024-06-25 15:24:13 +02:00
  • ffc8985362 Merged PR 2110: Bank Transactions and Line Items Pablo Martín 2024-06-25 14:24:50 +00:00
  • 88e13182a5 convert currency after subtracting in local currency Pablo Martin 2024-06-25 16:24:39 +02:00
  • 3973f0a4a6 rename field Pablo Martin 2024-06-25 15:06:43 +02:00
  • 854afffc1c add account code Pablo Martin 2024-06-25 14:47:11 +02:00
  • 8dc31f3489 add accounts to staging Pablo Martin 2024-06-25 14:29:46 +02:00
  • 7a9c913b8a line items Pablo Martin 2024-06-25 14:07:45 +02:00
  • d86b6b8627 add tests Pablo Martin 2024-06-25 13:37:53 +02:00
  • 33d072015c remove full jsons with ids Pablo Martin 2024-06-25 12:00:50 +02:00
  • 25e9d040ff add internal exchange rates Pablo Martin 2024-06-25 11:56:51 +02:00
  • 4b0b15814e add date converted in staging Pablo Martin 2024-06-25 11:45:26 +02:00
  • bf54548654 table alias Pablo Martin 2024-06-25 11:44:00 +02:00
  • 200c324b68 add converted fields Pablo Martin 2024-06-25 11:41:03 +02:00
  • 08ff92b3e9 make stg naming coherent with other xero models Pablo Martin 2024-06-25 11:39:37 +02:00
  • 447cb3926c bring over bank transactions to int Pablo Martin 2024-06-25 11:38:37 +02:00
  • 6c053a0753 Merged PR 2107: Adds host lifecycle metrics into biz kpis Oriol Roqué Paniagua 2024-06-25 12:20:59 +00:00
  • cebd6f6485 Merged PR 2106: Add VerificationSet to staging Pablo Martín 2024-06-25 09:13:11 +00:00
  • cfd752843b add tests Pablo Martin 2024-06-25 11:07:53 +02:00
  • c23e79b5fe add staging model Pablo Martin 2024-06-25 11:04:28 +02:00
  • 8fbbb1d10b add source Pablo Martin 2024-06-25 11:04:16 +02:00
  • 0655ac8997 Merged PR 2105: Adding listing lifecycle metrics into business KPIs Oriol Roqué Paniagua 2024-06-25 08:14:23 +00:00
  • f23e210129 Merged PR 2094: Removing lifecycle logic from int_core__accommodation Oriol Roqué Paniagua 2024-06-21 14:13:42 +00:00
  • ef80637a9b Merged PR 2090: Adding int_core__mtd_accommodation_lifecycle Oriol Roqué Paniagua 2024-06-21 13:59:14 +00:00
  • fe93f594f5 Merged PR 2084: Adding int_core__accommodation Oriol Roqué Paniagua 2024-06-20 16:02:16 +00:00
  • 80120e68a2 Merged PR 2087: Add Xero Bank Transactions to staging Pablo Martín 2024-06-20 14:42:03 +00:00
  • 696490aecb docs for bank transactions table Pablo Martin 2024-06-20 15:52:55 +02:00
  • 26e7358648 credit notes docs Pablo Martin 2024-06-20 15:26:33 +02:00
  • e1a4faf3b9 more contact tests Pablo Martin 2024-06-20 15:15:19 +02:00
  • 8f14f5d37d add length between test Pablo Martin 2024-06-20 15:13:21 +02:00
  • 7aa667f7cf boy scout: tests for invoices Pablo Martin 2024-06-20 15:00:59 +02:00
  • 34b678df26 new not_negative test Pablo Martin 2024-06-20 14:43:51 +02:00
  • c671701071 boy scout: contact tests Pablo Martin 2024-06-20 14:37:55 +02:00
  • 79d69a9286 staging model Pablo Martin 2024-06-20 14:31:12 +02:00
  • cd9c797f02 add source Pablo Martin 2024-06-20 14:12:30 +02:00
  • 05f35fcb69 add value to test Pablo Martin 2024-06-19 18:25:49 +02:00
  • 5bea450428 Merged PR 2083: Add values to Stripe tests Pablo Martín 2024-06-19 16:23:49 +00:00
  • 6ad203b92f add some comments Pablo Martin 2024-06-19 18:18:38 +02:00
  • 839e5fae1b Merged PR 2077: Adding Country to intermediate Oriol Roqué Paniagua 2024-06-19 15:34:15 +00:00
  • 4a80625eeb Merged PR 2064: Created currency exchange tables Joaquin Ossa 2024-06-19 10:01:20 +00:00
  • 31feff162a Fixed names of tables Joaquin Ossa 2024-06-19 11:59:45 +02:00
  • f64b17a223 Created currency exchange tables Joaquin Ossa 2024-06-19 11:52:28 +02:00
  • fb86850ffe Merged PR 2074: Adding country to staging Oriol Roqué Paniagua 2024-06-19 08:40:08 +00:00
  • 771b226888 Merged PR 2068: Adding cancelled bookings metric Oriol Roqué Paniagua 2024-06-18 14:58:55 +00:00
  • 06fc35e58d Merged PR 2063: Part 2 of the previous PR Pablo Martín 2024-06-18 11:41:55 +00:00
  • 344419e660 formatting Pablo Martin 2024-06-18 13:41:32 +02:00
  • 3d3f3fb9ab fix docs Pablo Martin 2024-06-18 13:40:36 +02:00
  • 27759374b8 add docs and tests Pablo Martin 2024-06-18 13:10:47 +02:00
  • c051831d6d upper in payments Pablo Martin 2024-06-18 13:09:45 +02:00
  • 361b1b6a7f Merged PR 2061: Deprecate hardcoded rates Pablo Martín 2024-06-18 10:34:32 +00:00
  • 662c7b8ba8 remove hardcoded rates and seed, remove docs Pablo Martin 2024-06-18 11:35:07 +02:00
  • 8b91babad6 remove old table from cte Pablo Martin 2024-06-18 11:31:59 +02:00
  • 1f9df9ea5c remove old table Pablo Martin 2024-06-18 11:24:03 +02:00
  • d96c8b2abb change which field we join on: payment date is not always informed Pablo Martin 2024-06-18 11:23:10 +02:00
  • 6f625ec7db do both rates to compare and test Pablo Martin 2024-06-18 11:13:51 +02:00
  • e3be2708ad add new rates to CTEs Pablo Martin 2024-06-18 11:06:27 +02:00
  • 4958976733 Merged PR 2053: Added number_format category in mtd_aggregated_metrics Oriol Roqué Paniagua 2024-06-17 14:59:01 +00:00
  • a686c16978 Merged PR 2041: Fix Backward Currency Projection Bug Pablo Martín 2024-06-17 13:42:52 +00:00
  • 484060df47 Merged PR 2046: Guest Journey KPIs Oriol Roqué Paniagua 2024-06-17 13:13:03 +00:00
  • c8807ddf60 Adding exposure of main kpis dashboard uri 2024-06-17 14:04:51 +02:00
  • 0606f2c93d go back to var, made a mistake in the last commit Pablo Martin 2024-06-17 11:32:20 +02:00
  • cc930c5202 Extra documentation in the int_core__mtd_aggregated_metrics model uri 2024-06-17 11:32:13 +02:00
  • 1203d0921b use proper table, proper col, and remove off by one error Pablo Martin 2024-06-17 11:31:54 +02:00
  • a8892e7d5d this max should have been an int Pablo Martin 2024-06-17 11:27:44 +02:00
  • 17f2e92ddc Adding guest journey KPIs. Updating gitignore uri 2024-06-17 11:10:13 +02:00
  • f900ca794f Merged PR 2039: Simple rates Pablo Martín 2024-06-14 15:33:01 +00:00
  • 4c68df570f tests Pablo Martin 2024-06-14 16:46:28 +02:00