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

Commit graph

  • 913c07dad6 docs Pablo Martin 2024-06-14 16:44:48 +02:00
  • 84cd5ed7d0 simple model Pablo Martin 2024-06-14 16:44:40 +02:00
  • fe304442a1 add dbt utils to deps Pablo Martin 2024-06-14 16:39:07 +02:00
  • 670cf9f30f Merged PR 2036: Create int rates table Pablo Martín 2024-06-14 14:30:15 +00:00
  • 41a7f7a510 replace hardcode with global var Pablo Martin 2024-06-14 16:28:25 +02:00
  • bceb81ea18 more detail in docs Pablo Martin 2024-06-14 16:22:00 +02:00
  • d4decdcd8b remove years into the future hardcode Pablo Martin 2024-06-14 16:15:00 +02:00
  • 2b878e9478 union all instead of union Pablo Martin 2024-06-14 15:57:36 +02:00
  • e9ed1cfe02 wrong comment Pablo Martin 2024-06-14 15:56:23 +02:00
  • eaeb7cb936 schema and tests for new table Pablo Martin 2024-06-14 15:48:24 +02:00
  • 15ec3db1f2 fixed off by one errors in date projections Pablo Martin 2024-06-14 15:36:38 +02:00
  • 9d11aa165b past working Pablo Martin 2024-06-14 15:31:46 +02:00
  • 3431f46502 little comment to explain var Pablo Martin 2024-06-14 15:12:44 +02:00
  • a07a50793b ctes for first isntead of last xe rate Pablo Martin 2024-06-14 15:10:18 +02:00
  • 7707bc1254 compiles and runs Pablo Martin 2024-06-14 15:06:02 +02:00
  • 71be833123 start cross folder in int to stop piling models at int root Pablo Martin 2024-06-14 14:34:03 +02:00
  • 7d245a3b08 Merged PR 2037: Make XE Rates stg model incremental Pablo Martín 2024-06-14 14:20:28 +00:00
  • 79345a6ab7 make model incremental Pablo Martin 2024-06-14 16:01:33 +02:00
  • eaf1a87ab3 Merged PR 2034: Add XE rates to staging Pablo Martín 2024-06-14 12:30:46 +00:00
  • 97f1c6216b fix typos Pablo Martin 2024-06-14 14:28:26 +02:00
  • 589656d1bf place test in proper folder Pablo Martin 2024-06-14 14:27:20 +02:00
  • 3a66358338 add test Pablo Martin 2024-06-14 14:18:09 +02:00
  • bf97a947ed small text fixes Pablo Martin 2024-06-14 13:24:23 +02:00
  • 0d6e980832 documentation Pablo Martin 2024-06-14 13:21:21 +02:00
  • 8979f4d092 add composite key Pablo Martin 2024-06-14 13:15:35 +02:00
  • 7e548f5feb staging model Pablo Martin 2024-06-14 12:21:36 +02:00
  • e41774e6a4 typo Pablo Martin 2024-06-14 12:19:52 +02:00
  • cf0019fd20 add to sources Pablo Martin 2024-06-14 12:18:45 +02:00
  • 4f6728003a Merged PR 2029: Guest Journey - start date based on used link Oriol Roqué Paniagua 2024-06-13 14:53:58 +00:00
  • 7914d7d8d7 Merged PR 2028: guest journey estimated completed date Oriol Roqué Paniagua 2024-06-13 13:30:22 +00:00
  • 6b4490b017 Merged PR 2020: Verification request completeness for intermediate steps + schema documentation Oriol Roqué Paniagua 2024-06-13 08:14:11 +00:00
  • 6ef278a271 Merged PR 2009: Added core__unified_user to reporting with the documentation Joaquin Ossa 2024-06-12 13:19:16 +00:00
  • c4f87d9403 Applied changes according to comments Joaquin Ossa 2024-06-12 12:13:23 +02:00
  • 33aac0be1a Added core__unified_user to reporting with the documentation Joaquin Ossa 2024-06-11 12:12:39 +02:00
  • 328723b9ab Merged PR 2003: Business KPIs first draft Oriol Roqué Paniagua 2024-06-11 15:45:57 +00:00
  • 366aa7d1ac Merged PR 2005: Replace Guest Details in CheckIn Cover models with details coming from User table Pablo Martín 2024-06-10 15:30:26 +00:00
  • d18b47f597 Merged PR 2001: Add phone number to unified user Pablo Martín 2024-06-10 14:30:56 +00:00
  • 2ea2817627 add tests Pablo Martin 2024-06-10 16:23:45 +02:00
  • 723bbf1ebe add phone number Pablo Martin 2024-06-10 16:14:07 +02:00
  • 8b99d9babd add table aliases to track col origin Pablo Martin 2024-06-10 15:51:40 +02:00
  • 06e5112cfc Merged PR 1986: Created verification_requests model in report Joaquin Ossa 2024-06-10 09:38:48 +00:00
  • 1bb4229dce updated docs for core__verification_requests from Pablo's comments Joaquin Ossa 2024-06-10 11:32:04 +02:00
  • 5e7504499f Added description document for core__verification_requests Joaquin Ossa 2024-06-06 12:00:07 +02:00
  • a5074a1545 Created verification_requests model in report Joaquin Ossa 2024-06-06 10:11:34 +02:00
  • 8ba2ece28b Merged PR 1985: Accommodation and AccommodationToUser to staging Pablo Martín 2024-06-05 15:54:48 +00:00
  • 7aa100d115 add tests Pablo Martin 2024-06-05 17:39:53 +02:00
  • 85a299da96 staging accommodation to user Pablo Martin 2024-06-05 17:38:02 +02:00
  • cd8fc9893d add accommodationtouser in sources Pablo Martin 2024-06-05 17:31:19 +02:00
  • 21f9a63db2 add test Pablo Martin 2024-06-05 17:30:19 +02:00
  • 26ce452a0c accommodation staging model Pablo Martin 2024-06-05 17:24:59 +02:00
  • f216e7708a add accommodation to sources Pablo Martin 2024-06-05 17:24:39 +02:00
  • 60063b5455 propagate fix Pablo Martin 2024-06-05 17:15:35 +02:00
  • c87efc7d1d low-hanging fruit refactor. Fix name Pablo Martin 2024-06-05 16:50:14 +02:00
  • 42a3190f50 Merged PR 1969: Integration models Pablo Martín 2024-06-04 16:24:32 +00:00
  • bfd05a6410 add missing _utc suffix Pablo Martin 2024-06-04 18:21:56 +02:00
  • f5ae39e443 add integration type model Pablo Martin 2024-06-04 15:05:26 +02:00
  • 8ec14a14c1 add integration type to sources Pablo Martin 2024-06-04 14:58:16 +02:00
  • a312b1730b staging model for integration table Pablo Martin 2024-06-04 14:51:03 +02:00
  • 929628bc7c add integration to sources Pablo Martin 2024-06-04 14:42:50 +02:00
  • 76b5b7a1ea Merged PR 1954: add a few more conventions to readme Pablo Martín 2024-05-31 08:36:18 +00:00
  • d81c0b5e74 add a few more conventions to readme Pablo Martin 2024-05-31 10:35:57 +02:00
  • ae10d30cd1 Merged PR 1952: Automated Slack Alerts Pablo Martín 2024-05-30 15:10:55 +00:00
  • 2f661c098b updated deploy instructions in readme Pablo Martin 2024-05-30 16:52:41 +02:00
  • 77b4a8264c now we have both failure and success messages Pablo Martin 2024-05-30 16:38:39 +02:00
  • b1aa29b228 add failure states, .env file and message sending Pablo Martin 2024-05-30 16:12:51 +02:00
  • 3610c447f5 Merged PR 1949: Fix documentation in DWH and include exposure Oriol Roqué Paniagua 2024-05-30 10:37:41 +00:00
  • dfb1fba46f Merged PR 1943: Created xero__net_fees_by_deal with guesty Oriol Roqué Paniagua 2024-05-30 09:49:07 +00:00
  • f021f3cb29 Changed schema.yaml with the correct field uri 2024-05-30 10:03:05 +02:00
  • e360c1c785 Setting xero__net_fees_by_deal as per deal id, not dedicated to guesty uri 2024-05-30 10:00:39 +02:00
  • bf0010ceeb Adding model xero__net_fees_by_deal documentation in schema.yaml. Added Waiver Fees in xero__net_fees documentation. uri 2024-05-30 09:15:53 +02:00
  • de4ab5b6e5 Created xero__net_fees_by_deal with guesty uri 2024-05-29 18:03:58 +02:00
  • 822f698ce3 Merged PR 1942: add dump files to gitignore Pablo Martín 2024-05-29 15:26:04 +00:00
  • fab98092c5 add dump files to gitignore Pablo Martin 2024-05-29 17:22:48 +02:00
  • 186d5804f8 Merged PR 1938: Add Damage Waiver to Net Fees models Pablo Martín 2024-05-29 11:25:14 +00:00
  • 053024e507 add proper value to waiver_items array Pablo Martin 2024-05-29 13:23:05 +02:00
  • 7148220061 add net fees Pablo Martin 2024-05-28 09:53:48 +02:00
  • 307887126c add venv to gitignore Pablo Martin 2024-05-29 11:27:33 +02:00
  • 4e5424b3b6 couple of small readme details Pablo Martin 2024-05-29 11:27:21 +02:00
  • e9af710ae8 Merged PR 1930: 16879 Remove duplicate field Pablo Martín 2024-05-28 12:41:13 +00:00
  • 3d11622ae1 remove duplicate field Pablo Martin 2024-05-28 14:37:48 +02:00
  • 40a12df950 a few tiny changes in readme and profiles template Pablo Martin 2024-05-28 14:29:31 +02:00
  • b59c0a96fb Merged PR 1923: User Currency Pablo Martín 2024-05-24 10:03:00 +00:00
  • 90f67d6321 include currency in unified user Pablo Martin 2024-05-24 11:54:40 +02:00
  • 9c293e8bf4 add currency source and stg Pablo Martin 2024-05-24 11:32:54 +02:00
  • 322fcb8eb0 add id account type to int model Pablo Martin 2024-05-23 17:51:04 +02:00
  • 69f11c5d4a propagate id account currency Pablo Martin 2024-05-23 17:50:08 +02:00
  • 5588444943 add account currency id to User model Pablo Martin 2024-05-23 17:49:41 +02:00
  • 7d8ed7768e reordering some ids Pablo Martin 2024-05-23 17:47:52 +02:00
  • d8c5485431 Merged PR 1917: Xero Credit Notes Pablo Martín 2024-05-23 14:24:22 +00:00
  • 3706a0c21c Revert "remove unnecessary nested objects since they can be joined in dwh" Pablo Martin 2024-05-23 16:23:52 +02:00
  • 4cc9644feb remove unnecessary nested objects since they can be joined in dwh Pablo Martin 2024-05-23 16:22:02 +02:00
  • e2645814e4 update exposures Pablo Martin 2024-05-23 16:15:43 +02:00
  • 1f24965a23 remove outdated denom invoicing mart Pablo Martin 2024-05-23 16:14:44 +02:00
  • 65f5b7377a use date field instead of breaking things down Pablo Martin 2024-05-23 16:13:53 +02:00
  • b0528ec2c0 switch to a single model with a case, docs for it Pablo Martin 2024-05-23 15:22:42 +02:00
  • b34da23a94 update docs Pablo Martin 2024-05-22 11:45:04 +02:00
  • fcb951211d remove a couple of unnecessary cols Pablo Martin 2024-05-22 11:44:59 +02:00
  • 319c743cec macros docs Pablo Martin 2024-05-22 11:42:42 +02:00
  • 93c2de6f03 macro logic, need to clean a bit Pablo Martin 2024-05-17 17:54:20 +02:00
  • 75fe0e510a kind of done, checkpoint before macro-ing Pablo Martin 2024-05-17 15:44:58 +02:00