data-dwh-dbt-project

counterweight/data-dwh-dbt-project

Fork 0

Commit graph

fb89652159 added credit note reporting models Pablo Martin 2024-05-17 15:27:58 +02:00
791cbd47e8 more credit note work Pablo Martin 2024-05-17 11:43:42 +02:00
8f6e92c187 credit notes intermediate model Pablo Martin 2024-05-16 18:21:32 +02:00
2faa47e7cb staging model for credit notes Pablo Martin 2024-05-16 18:11:53 +02:00
79521d723d Merged PR 1863: specifying numeric precision so that pbi doesn't go crazy Pablo Martín 2024-05-17 09:56:48 +00:00
22e85af8a5 spoecifying numeric precision so that pbi doesn't go crazy Pablo Martin 2024-05-17 11:56:18 +02:00
e1af049400 Merged PR 1853: Xero Line Items Pablo Martín 2024-05-16 15:06:30 +00:00
08ea22eee9 docs formatting Pablo Martin 2024-05-16 16:22:41 +02:00
9068774f35 more docs Pablo Martin 2024-05-16 16:06:07 +02:00
fa2a79e973 more docs Pablo Martin 2024-05-16 16:02:23 +02:00
5d2cc0c17b more docs Pablo Martin 2024-05-16 15:47:12 +02:00
e559c62bd6 updates on schema Pablo Martin 2024-05-15 19:20:59 +02:00
751219a768 add dependency on exposure Pablo Martin 2024-05-15 19:11:28 +02:00
4191e4af50 Merge branch 'master' into models/xero-line-items Pablo Martin 2024-05-15 15:00:23 +02:00
58a675c849 Merged PR 1847: Checkin Hero Complentess Patch Pablo Martín 2024-05-15 12:26:23 +00:00
c25a8a7964 add new field in complentess summary Pablo Martin 2024-05-15 13:13:57 +02:00
7a2663989c exclude checkincover to account for bug Pablo Martin 2024-05-15 13:09:27 +02:00
eba636b16c a few small details Pablo Martin 2024-05-14 16:20:48 +02:00
bc4ca1cbc3 lots of currency stuff Pablo Martin 2024-05-14 12:26:02 +02:00
908ec75d17 denormalized line item table to ease pbi Pablo Martin 2024-05-13 18:08:53 +02:00
f8fcf7f2b5 reporting models Pablo Martin 2024-05-13 16:52:55 +02:00
d0b8d4a8df contacts Pablo Martin 2024-05-13 16:09:56 +02:00
60d462315e fixed typo Pablo Martin 2024-05-13 15:53:44 +02:00
bfd7267600 line items model Pablo Martin 2024-05-13 15:47:53 +02:00
a797f85dc2 fix naming Pablo Martin 2024-05-13 15:47:44 +02:00
9d4b104374 int invoice model Pablo Martin 2024-05-13 15:17:46 +02:00
824ff8da9e a few quick and dirty improvements Pablo Martin 2024-05-10 00:31:27 +02:00
a902abfa24 Merged PR 1806: propagating renames Pablo Martín 2024-05-08 10:05:28 +00:00
9c338a31ce propagating renames Pablo Martin 2024-05-08 12:03:44 +02:00
a719aa2331 Merged PR 1804: change core models to incremental where possible, set a 7 day safety window Pablo Martín 2024-05-08 09:54:04 +00:00
78df0e4721 change core models to incremental where possible, set a 7 day safety window Pablo Martin 2024-05-08 11:52:44 +02:00
97ef7f2763 Merged PR 1798: CheckIn Hero Reporting Pablo Martín 2024-05-07 16:01:58 +00:00
9b9e5c32b5 missing exposure Pablo Martin 2024-05-07 17:55:03 +02:00
83e48ab6c6 mroe docs Pablo Martin 2024-05-07 17:52:35 +02:00
18b319de00 add exposure Pablo Martin 2024-05-06 17:52:42 +02:00
001b59540a add docs for reporting model Pablo Martin 2024-05-06 17:50:08 +02:00
3b1301ff6e a few more details Pablo Martin 2024-05-03 17:24:35 +02:00
180c005e3c more useful stuff for the dashboard Pablo Martin 2024-05-02 18:44:11 +02:00
a83cb7f100 final reporting model Pablo Martin 2024-04-29 14:41:46 +02:00
429d0ad679 small comment Pablo Martin 2024-04-29 14:00:38 +02:00
71b0862f04 staging model for payment validation set to currency Pablo Martin 2024-04-26 17:36:50 +02:00
1d8fc0d6fa add payment validation set stg model Pablo Martin 2024-04-26 16:54:26 +02:00
eb16df007d add two more sources Pablo Martin 2024-04-26 16:54:11 +02:00
a55b355f11 moving forward with the checkincover specific model Pablo Martin 2024-04-26 16:45:43 +02:00
fd9b241cb6 added to VR Pablo Martin 2024-04-24 17:01:35 +02:00
c7120bd49c finished the ugly model Pablo Martin 2024-04-24 16:50:48 +02:00
8e97b97377 Add verification type Pablo Martin 2024-04-24 15:11:24 +02:00
d4eeeb964e wip for the big completeness monster Pablo Martin 2024-04-24 15:05:33 +02:00
94c87de4d4 add verification model Pablo Martin 2024-04-23 14:57:30 +02:00
53eb97accc Created staging model for verification set to verification type Pablo Martin 2024-04-23 13:33:15 +02:00
d7b810df73 Add host booking fees exposure. Pablo Martin 2024-04-17 17:15:03 +02:00
8be9e700bb Merged PR 1681: Xero Raw Pablo Martín 2024-04-17 15:10:53 +00:00
8ab6d27241 invoices and schema Pablo Martin 2024-04-17 17:05:08 +02:00
2a2fa613ee add invoices to sources Pablo Martin 2024-04-16 16:27:44 +02:00
7d79dc8e4b contacts model and schema Pablo Martin 2024-04-16 16:07:25 +02:00
cf0f1f9a0c start source with contacts Pablo Martin 2024-04-16 15:41:23 +02:00
5000928f7d Merged PR 1598: Booking Fees Pablo Martín 2024-04-08 07:51:48 +00:00
67991800ef docs and moving stuff Pablo Martin 2024-04-08 09:44:32 +02:00
df61682d90 a lot of changes Pablo Martin 2024-04-04 16:33:08 +02:00
5101a2a45e tons of work, dear god what a spaghetti Pablo Martin 2024-04-04 10:54:56 +02:00
dbd2f44795 removed testing filter Pablo Martin 2024-03-20 17:33:01 +01:00
d8cf15be4a basic bookings and duplicates Pablo Martin 2024-03-20 17:23:08 +01:00
09a62c701a stg model for user verification Pablo Martin 2024-03-20 10:38:06 +01:00
18c4121d62 stg model for booking state Pablo Martin 2024-03-20 10:36:23 +01:00
964ccbaa24 add a couple tables to sources Pablo Martin 2024-03-20 10:36:14 +01:00
4e14702014 Merged PR 1489: More core staging Pablo Martín 2024-03-20 08:47:22 +00:00
8cb7073184 typo in name Pablo Martin 2024-03-18 15:08:17 +01:00
b03633f650 staging for charge by type Pablo Martin 2024-03-18 15:00:45 +01:00
71e2b86521 staging price plan to user Pablo Martin 2024-03-18 14:56:07 +01:00
19deb8f21e Merged PR 1468: More sources for core Pablo Martín 2024-03-18 12:03:23 +00:00
14b779ffa7 remove verification: we won't use it yet Pablo Martin 2024-03-18 13:02:15 +01:00
1ea4b49c31 add verification request staging model Pablo Martin 2024-03-18 13:01:26 +01:00
71cae21cea staging model for booking Pablo Martin 2024-03-18 12:37:36 +01:00
1a5db1a8c4 add verification request to sources Pablo Martin 2024-03-18 12:20:27 +01:00
db493db8d9 add new tables to sources Pablo Martin 2024-03-18 12:05:55 +01:00
68ddbf23c6 add link to pbi exposure Pablo Martin 2024-03-15 11:58:02 +01:00
4fda12446b Merged PR 1450: Guest Payments models Pablo Martín 2024-03-13 16:54:46 +00:00
1f58a6ba03 only hardcode starting point of rates, not ending Pablo Martin 2024-03-13 17:49:26 +01:00
689d5eff16 docs Pablo Martin 2024-03-13 15:47:58 +01:00
224954525e restructuring, dates schema Pablo Martin 2024-03-13 11:09:22 +01:00
89aed285db lot of things, should have committed way earlier Pablo Martin 2024-03-13 10:11:46 +01:00
8b2dca174f refactor to remove unnecessary bloat Pablo Martin 2024-03-12 10:40:53 +01:00
6d734cc398 add notes Pablo Martin 2024-03-12 10:36:49 +01:00
e84294c4b7 refactoring Pablo Martin 2024-03-08 18:38:47 +01:00
c4b9c42a3c more refactoring Pablo Martin 2024-03-08 18:08:05 +01:00
1a347c721b use it in downstream Pablo Martin 2024-03-08 17:58:14 +01:00
999ae0dd10 add verification payment type Pablo Martin 2024-03-08 17:56:15 +01:00
606eed9754 some progress Pablo Martin 2024-03-08 17:28:19 +01:00
f911912b45 pushing back Pablo Martin 2024-03-08 17:12:12 +01:00
8de993ddba ugly but working thing Pablo Martin 2024-03-08 16:55:17 +01:00
30ede54df7 Merged PR 1424: Hardcoded Currency Exchange rates Pablo Martín 2024-03-12 10:36:49 +00:00
134580c3f6 hardcoded rates for all dates Pablo Martin 2024-03-12 11:33:10 +01:00
05d8640417 add hardcoded rates Pablo Martin 2024-03-12 11:22:20 +01:00
49fba0667f Merged PR 1414: add dates master Pablo Martín 2024-03-08 14:29:29 +00:00
58dc5ba18f add dates master Pablo Martin 2024-03-08 15:11:58 +01:00
d5f2a7f9fe Merged PR 1409: Upgrade Core User Pablo Martín 2024-03-07 16:24:08 +00:00
e7edcff175 a few final changes Pablo Martin 2024-03-07 17:22:16 +01:00
cd42340bc2 finished User Pablo Martin 2024-03-07 17:06:01 +01:00
c059599ad6 more work Pablo Martin 2024-03-07 16:53:42 +01:00
3620401037 work Pablo Martin 2024-03-07 16:29:50 +01:00