Meeting Title: Revenue Model Adjustment Discussion Date: 2025-11-03 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:00:37.940 ⇒ 00:00:38.920 Demilade Agboola: Hi, Emily.
2 00:00:39.290 ⇒ 00:00:41.040 Emily Giant: Hi, how was your weekend?
3 00:00:41.860 ⇒ 00:00:45.610 Demilade Agboola: Pretty good, flew into the UK, so I’m currently in the UK right now.
4 00:00:45.790 ⇒ 00:00:49.079 Emily Giant: Oh, nice! Are you just, like, doing a trip?
5 00:00:49.620 ⇒ 00:00:51.320 Demilade Agboola: Yeah, yeah, I came to see my best friend.
6 00:00:51.480 ⇒ 00:00:53.530 Emily Giant: Oh, sweet. What part of the UK?
7 00:00:53.700 ⇒ 00:00:54.580 Demilade Agboola: London.
8 00:00:55.150 ⇒ 00:00:56.310 Emily Giant: Love it.
9 00:00:56.520 ⇒ 00:01:00.520 Demilade Agboola: So, I’m here for a couple, like, a week, then I’m back.
10 00:01:00.520 ⇒ 00:01:05.879 Emily Giant: Nice! Do you have anything planned, or are you just gonna, like, hang out and do whatever you want to do?
11 00:01:06.320 ⇒ 00:01:08.079 Demilade Agboola: hang out, whatever I want to do, so…
12 00:01:08.080 ⇒ 00:01:10.530 Emily Giant: Love it. Does he play tennis, or is she?
13 00:01:10.760 ⇒ 00:01:18.170 Demilade Agboola: he doesn’t, but I brought two rackets, and we’re gonna find a way to play, so… he’s… he’s gonna… he’s gonna…
14 00:01:18.170 ⇒ 00:01:22.529 Emily Giant: Yeah, he’s gonna be playing tennis, great. How’s your ankle?
15 00:01:23.060 ⇒ 00:01:26.780 Demilade Agboola: Still sore, to be honest, but it’s… it’s better.
16 00:01:27.270 ⇒ 00:01:30.299 Emily Giant: That’s good. Ankles take a while.
17 00:01:32.190 ⇒ 00:01:35.660 Emily Giant: And it doesn’t sound like you’re letting up on it too much, so…
18 00:01:35.660 ⇒ 00:01:35.990 Demilade Agboola: I love it.
19 00:01:35.990 ⇒ 00:01:37.680 Emily Giant: I think it’s a good thing to,
20 00:01:37.850 ⇒ 00:01:41.960 Emily Giant: Do less tennis for a minute, and then let the ankle get better.
21 00:01:42.320 ⇒ 00:01:44.949 Demilade Agboola: Sacrilege. I mean, to be…
22 00:01:44.950 ⇒ 00:01:46.820 Emily Giant: I take it, but…
23 00:01:46.820 ⇒ 00:01:53.580 Demilade Agboola: I mean, to be fair, though, I did only play, like, once last week. I only played on Saturday. Or Friday, actually.
24 00:01:53.910 ⇒ 00:02:01.580 Demilade Agboola: So now, that was it, you know? So I think, I think I have… I have tried. And I didn’t play… I only played… oh yeah, I played football on Tuesday.
25 00:02:02.240 ⇒ 00:02:09.959 Demilade Agboola: That’s it. You’re like, oh, I only played 5 times last week. It’s no big deal. I only played sports twice last week, I think that’s a pretty, like, chill.
26 00:02:09.960 ⇒ 00:02:13.910 Emily Giant: For you? For you, it’s pretty good. So…
27 00:02:13.910 ⇒ 00:02:30.590 Emily Giant: Yeah, I’ll give you that. That’s pretty good for you. Matt twisted his ankle really badly. I don’t even remember what he was doing, but, you know, we’re always doing, like, manual labor and stuff, so… something terrible. And, it was, like, 3 weeks ago, and he’s still, like, it’s better.
28 00:02:30.590 ⇒ 00:02:33.950 Emily Giant: But, like, every now and then, he’s like, it’s creeping back, like…
29 00:02:34.240 ⇒ 00:02:41.489 Emily Giant: They’re just annoying things to twist, but… yeah. I, so…
30 00:02:41.490 ⇒ 00:02:42.080 Demilade Agboola: And…
31 00:02:42.080 ⇒ 00:02:47.299 Emily Giant: It was… it was good. What did I do? Oh, I played croquet.
32 00:02:48.070 ⇒ 00:02:53.210 Emily Giant: We have a big yard, so we set up croquet and did speed croquet, so that it’s not, like.
33 00:02:53.400 ⇒ 00:02:54.700 Emily Giant: So slow.
34 00:02:55.100 ⇒ 00:02:56.909 Emily Giant: It was pretty fun.
35 00:02:56.910 ⇒ 00:02:59.320 Demilade Agboola: Was the weather compatible for that?
36 00:02:59.320 ⇒ 00:03:11.109 Emily Giant: Completely. It was beautiful. It’s, like, chilly, but not cold. And if you have enough beer, any weather is compatible. So…
37 00:03:12.370 ⇒ 00:03:28.249 Emily Giant: So in that way, it was perfect out. Yeah, did that, watched some scary movies, you know, Halloween stuff. But we live out in the country, so we didn’t get, like, a lot of trick-or-treaters or anything. Thank God, because I don’t want to deal with that.
38 00:03:28.320 ⇒ 00:03:36.739 Demilade Agboola: But, yeah, it was… it was… and then yesterday, I took our power washer into the basement, because we got the whole, like, foundation relayed on that one side, and…
39 00:03:36.740 ⇒ 00:03:48.689 Emily Giant: I was… the other walls are still, like, really, really old brick with, like, chipping paint, and I just went to town, like, power washing the walls and getting the old paint off, and I swear to you, I have, like, concrete in my scalp.
40 00:03:48.690 ⇒ 00:04:03.199 Emily Giant: That has, like, embedded itself in my head from all the chunks that were, like, flying everywhere. So, didn’t see that coming, but when I go down to finish it, I’m gonna have to put, like, a swim cap on, or something, so that I don’t get, like, concrete head.
41 00:04:03.830 ⇒ 00:04:08.099 Demilade Agboola: I think we… I think, protective gear will be very.
42 00:04:08.100 ⇒ 00:04:09.020 Emily Giant: Yeah.
43 00:04:09.220 ⇒ 00:04:21.089 Emily Giant: Yeah, there were learnings. There were definitely learnings yesterday, but it was one of those where, like, I am not a gun enthusiast, but, like, when I use a power washer, I get it. I’m like, yeah, this is fun.
44 00:04:21.200 ⇒ 00:04:28.069 Emily Giant: It’s just so powerful, and with stuff just, like, flying everywhere, I’m like, oh, I could go skeet shooting. This could be fun.
45 00:04:29.550 ⇒ 00:04:34.410 Demilade Agboola: That is fair. Surprisingly, I’d been to… I’ve been to a gun range once, when I was in Poland.
46 00:04:35.030 ⇒ 00:04:37.220 Demilade Agboola: My friend took me there,
47 00:04:37.930 ⇒ 00:04:41.639 Demilade Agboola: And… I was actually surprisingly good at it. I mean…
48 00:04:41.840 ⇒ 00:04:48.650 Demilade Agboola: I’m not surprised when you’re good at anything, I’m surprised when you’re bad at something, so that is… I’m bad at a lot of things.
49 00:04:49.360 ⇒ 00:04:50.820 Emily Giant: Correct.
50 00:04:50.820 ⇒ 00:04:54.329 Demilade Agboola: dancing, I can’t dance to save my life. Also.
51 00:04:55.220 ⇒ 00:04:58.599 Demilade Agboola: Drawing, like, art, paintings, drawings, that sort of thing.
52 00:04:58.850 ⇒ 00:05:03.680 Emily Giant: Really? Now, are you, like, inspired at all to…
53 00:05:04.110 ⇒ 00:05:10.480 Emily Giant: do it because of being not good at it, because I can see you, like, taking up drawing.
54 00:05:10.760 ⇒ 00:05:14.379 Emily Giant: Because of not… Thinking you’re good at it.
55 00:05:14.640 ⇒ 00:05:18.330 Demilade Agboola: I have considered it, to be honest,
56 00:05:18.600 ⇒ 00:05:26.360 Demilade Agboola: both, and I just felt like, because I’m learning to be fine with not always trying to be good at everything, and just, like.
57 00:05:26.750 ⇒ 00:05:29.960 Demilade Agboola: It’s fine to… not to suck at some things, and…
58 00:05:30.350 ⇒ 00:05:36.449 Demilade Agboola: Because I was going to take, like, you know, classes online and just, like, figure out how people draw and get better at it, but…
59 00:05:36.550 ⇒ 00:05:42.499 Demilade Agboola: to be fair, I don’t need it, and it would just be… I just didn’t feel it was necessary, to be honest.
60 00:05:42.500 ⇒ 00:05:49.150 Emily Giant: Yeah. Well, maybe, maybe when you’re older, and, like, you don’t want to… maybe when you’re, like, 85,
61 00:05:49.450 ⇒ 00:05:54.919 Emily Giant: And don’t want to play tennis every day, only every other day, then you can take up drawing.
62 00:05:54.920 ⇒ 00:05:56.450 Demilade Agboola: Yeah, I could see that, I could see that.
63 00:05:56.750 ⇒ 00:05:59.010 Emily Giant: It’s just… it’s gonna be a later in life…
64 00:05:59.140 ⇒ 00:06:06.660 Emily Giant: type of journey. Matt’s doing that now, like, he used to, like, rock climb and do more, like, athletic…
65 00:06:07.050 ⇒ 00:06:23.910 Emily Giant: goal-oriented stuff, like marathons, yada yada. And now, like, with his heart surgery and stuff, he bought a bunch of art kits and learned to draw when he couldn’t do anything active over that year that, like, he couldn’t do anything. So now he’s pretty good. Like, and he did not have… he did not have…
66 00:06:23.910 ⇒ 00:06:27.069 Emily Giant: a natural ability. Let’s just put it like that.
67 00:06:27.070 ⇒ 00:06:28.049 Demilade Agboola: Forget it. Yeah.
68 00:06:28.690 ⇒ 00:06:33.490 Demilade Agboola: Yeah, I mean, to be fair, I truly do believe that almost anything can be learned if you just
69 00:06:34.070 ⇒ 00:06:40.269 Demilade Agboola: time to, like, learn the foundations and the proper technique, and be consistent with it, so…
70 00:06:40.920 ⇒ 00:06:44.410 Emily Giant: I’m a big believer of that with almost everything except for singing.
71 00:06:44.640 ⇒ 00:06:49.989 Emily Giant: Like, if you’re tone deaf, you cannot sing. You cannot learn it. Like, it’s just not gonna happen.
72 00:06:51.220 ⇒ 00:06:57.630 Demilade Agboola: I’m pretty sure there are people who learned how to, I mean, sing decently, maybe not be Beyonce or Amara Carey or something, but…
73 00:06:57.630 ⇒ 00:07:03.049 Emily Giant: You can learn if you have pitch, but if you can’t hear pitch.
74 00:07:03.280 ⇒ 00:07:04.140 Demilade Agboola: Fair.
75 00:07:04.140 ⇒ 00:07:09.880 Emily Giant: I don’t know. I don’t know. But, you know what, they can probably get better, to your point, so…
76 00:07:10.440 ⇒ 00:07:11.420 Demilade Agboola: Definitely.
77 00:07:11.780 ⇒ 00:07:23.860 Emily Giant: Alright, so, I think that this last piece is kind of a doozy, but I know that there are ways to do it, it’s just, like, a bit of a doozy. So, okay, let me show you first the
78 00:07:24.520 ⇒ 00:07:31.590 Emily Giant: what I’m… the changes from… The sheet to now,
79 00:07:31.830 ⇒ 00:07:39.750 Emily Giant: And I’m re… I’m running it all in production, so that before people, like, really get into their day, what’s this?
80 00:07:39.990 ⇒ 00:07:42.079 Emily Giant: Shouldn’t be an error.
81 00:07:43.650 ⇒ 00:07:44.819 Emily Giant: Okay, now it’s…
82 00:07:46.020 ⇒ 00:07:51.639 Emily Giant: Anyway, I’ll look into that, because it should not have aired, because that model was legitimately not touched.
83 00:07:51.790 ⇒ 00:07:55.600 Emily Giant: In this… So it’s probably just, like, a database error.
84 00:07:58.400 ⇒ 00:08:02.500 Emily Giant: Okay, so, anyway… We were having…
85 00:08:03.400 ⇒ 00:08:07.630 Emily Giant: issues with this list that we pulled.
86 00:08:08.270 ⇒ 00:08:13.329 Emily Giant: This, previous to the fix, was showing multiple lines.
87 00:08:13.980 ⇒ 00:08:19.509 Emily Giant: If I go back to… for the same thing, and then it was inflating revenue.
88 00:08:21.460 ⇒ 00:08:23.240 Emily Giant: Act legacy.
89 00:08:34.270 ⇒ 00:08:36.700 Emily Giant: So this was that massive order with, like.
90 00:08:36.700 ⇒ 00:08:37.280 Demilade Agboola: Yeah.
91 00:08:37.289 ⇒ 00:08:41.699 Emily Giant: All of those gift, gummy bears that we’re showing as $0, also.
92 00:08:42.059 ⇒ 00:08:52.179 Emily Giant: So now, it’s got one line per gummy bear, and correctly shows the piece revenue, there’s no fan out, like, all good.
93 00:08:52.640 ⇒ 00:08:53.550 Demilade Agboola: Nice.
94 00:08:53.550 ⇒ 00:08:54.370 Emily Giant: Yup.
95 00:08:54.540 ⇒ 00:09:02.230 Emily Giant: So that was one of the issues, and that was the worst order of the bunch, so felt like a good one to start with. This one had…
96 00:09:02.390 ⇒ 00:09:05.740 Emily Giant: multiple lines, because
97 00:09:05.970 ⇒ 00:09:14.680 Emily Giant: the care team… this is what the origin of this is. I kind of forgot, and then was like, oh, it’s not pulling flowers from two different lots, it’s because
98 00:09:14.830 ⇒ 00:09:22.480 Emily Giant: The finance team used to have them go and change the lot to an earlier one to match our accounting strategy, so…
99 00:09:22.600 ⇒ 00:09:29.060 Emily Giant: I was able to, like, put in the logic of choose the earliest lot, since we do first in…
100 00:09:29.160 ⇒ 00:09:30.960 Emily Giant: First out.
101 00:09:31.340 ⇒ 00:09:40.829 Emily Giant: And that way, I knew which was the actual lot the floral wound up on, but because it was showing two different lots, it was putting two different rows. So…
102 00:09:41.410 ⇒ 00:09:43.260 Emily Giant: Checking on that…
103 00:09:48.120 ⇒ 00:09:50.000 Emily Giant: Make sure all of these are unique.
104 00:09:51.040 ⇒ 00:09:54.100 Emily Giant: Floral 12, floral 40. That’s a little weird.
105 00:09:55.730 ⇒ 00:09:57.860 Emily Giant: Oh, that’s piece costs per unit.
106 00:10:00.250 ⇒ 00:10:01.770 Emily Giant: Where’s peace revenue?
107 00:10:05.810 ⇒ 00:10:07.900 Emily Giant: Hmm, this one’s still weird.
108 00:10:12.590 ⇒ 00:10:14.470 Demilade Agboola: So, it has the…
109 00:10:18.290 ⇒ 00:10:19.750 Demilade Agboola: So that’s 2.
110 00:10:20.410 ⇒ 00:10:21.969 Demilade Agboola: the… the Maya’s?
111 00:10:22.340 ⇒ 00:10:24.630 Emily Giant: Oh, it isn’t weird.
112 00:10:24.630 ⇒ 00:10:28.299 Demilade Agboola: It’s that this is a parent SKU. It’s a bundle.
113 00:10:28.300 ⇒ 00:10:34.920 Emily Giant: So, that one… it’s the components of the bundle. The only one I don’t know about is this Juliet.
114 00:10:35.890 ⇒ 00:10:39.520 Emily Giant: Component… this component rank is also insane.
115 00:10:39.870 ⇒ 00:10:44.290 Emily Giant: Oh, I know why, sorry, I was working… In a different branch.
116 00:10:44.870 ⇒ 00:10:45.440 Demilade Agboola: Okay.
117 00:10:45.440 ⇒ 00:10:48.699 Emily Giant: and doing… Trying to figure out the…
118 00:10:48.930 ⇒ 00:10:51.390 Emily Giant: I was like, I just checked this before…
119 00:10:51.720 ⇒ 00:10:55.730 Emily Giant: Okay, so now my branch is all messed up. Let me do a quick run here, sorry.
120 00:11:00.090 ⇒ 00:11:09.010 Emily Giant: I had to… I was working in cursor to try to figure out how to append the price of the original item to the forced upgrade.
121 00:11:09.510 ⇒ 00:11:14.620 Emily Giant: And it just… didn’t. It just didn’t, let’s put it that way, but now let me run it.
122 00:11:35.080 ⇒ 00:11:36.170 Emily Giant: Hold on.
123 00:11:58.060 ⇒ 00:12:00.090 Emily Giant: I’ll check on this while we’re…
124 00:12:01.540 ⇒ 00:12:03.759 Emily Giant: Okay, so I guess it’s still running.
125 00:12:12.980 ⇒ 00:12:20.460 Emily Giant: Alright, you were telling me, like, I don’t need everything upstream of this, I just need those, like, incremental.
126 00:12:20.780 ⇒ 00:12:21.780 Emily Giant: models that are…
127 00:12:21.950 ⇒ 00:12:30.190 Demilade Agboola: what you can do is, right before the plus, you could put the number, like, maybe 2 or 3, so it would run everything two layers down. Like, let’s look at the…
128 00:12:30.430 ⇒ 00:12:33.840 Demilade Agboola: Can we look at the… what’s it called? The lineage? Can we see how many?
129 00:12:33.840 ⇒ 00:12:34.620 Emily Giant: Yeah.
130 00:12:34.620 ⇒ 00:12:35.340 Demilade Agboola: Terrah.
131 00:12:35.880 ⇒ 00:12:45.119 Emily Giant: I just can’t remember the last time I refreshed staging totals, and that’s the only, like… I guess I can run that as a separate job, but it’s this one, and I need…
132 00:12:46.380 ⇒ 00:12:53.460 Emily Giant: This… This, this, this… Two back would work.
133 00:12:53.590 ⇒ 00:12:57.389 Emily Giant: this, this… I don’t want this, though.
134 00:13:01.370 ⇒ 00:13:06.130 Demilade Agboola: Okay, so I think you could just do it 2… 2 backwards, like, 2+.
135 00:13:09.810 ⇒ 00:13:11.319 Demilade Agboola: Alright, to save.
136 00:13:17.060 ⇒ 00:13:17.620 Emily Giant: Okay.
137 00:13:17.810 ⇒ 00:13:19.409 Emily Giant: Alright, back to this.
138 00:13:19.730 ⇒ 00:13:21.349 Emily Giant: It’s still running.
139 00:13:23.430 ⇒ 00:13:34.980 Emily Giant: But the long and the short is everything… I checked, like, 50 of them, and all of them were fixed, except for these. The piece revenue is $0, and it’s because…
140 00:13:35.130 ⇒ 00:13:36.809 Emily Giant: Where’s my spreadsheet?
141 00:13:45.260 ⇒ 00:13:50.180 Emily Giant: Oh, I have two open now. Anyway… So…
142 00:13:50.300 ⇒ 00:13:52.029 Emily Giant: I pulled one of the orders.
143 00:13:52.500 ⇒ 00:13:57.009 Emily Giant: This is, the final, the marked table, where it shows
144 00:13:57.120 ⇒ 00:14:01.269 Emily Giant: That the, piece revenue is $9, which we know is wrong.
145 00:14:04.250 ⇒ 00:14:10.399 Emily Giant: Because it’s not a re-delivery. And then, this is the one upstream, where it’s still showing the price as…
146 00:14:10.620 ⇒ 00:14:18.659 Emily Giant: 0, which is wrong. And then if you go one more upstream to the line item union,
147 00:14:19.100 ⇒ 00:14:34.080 Emily Giant: this is where you see the, these are the forced upgrades, all the zero-down ones. This is the original, like, what was charged to the customer for these two items. And, then there’s that has been deleted.
148 00:14:34.850 ⇒ 00:14:37.339 Emily Giant: And because that was deleted and that was deleted.
149 00:14:37.460 ⇒ 00:14:49.149 Emily Giant: And they are currently filtered out of this intermediate model, without having the price that was charged to the customer, pulled into
150 00:14:50.060 ⇒ 00:14:55.770 Emily Giant: its own… or either… Tied back to the new floral.
151 00:14:56.090 ⇒ 00:14:58.860 Emily Giant: Or… in a row.
152 00:14:59.010 ⇒ 00:15:02.230 Emily Giant: That says, like, this revenue was still captured.
153 00:15:02.240 ⇒ 00:15:19.220 Emily Giant: But not on this item. But the item wasn’t sent. So I don’t know, like, the best way to represent it, number one, because I know you have something like that already in the new table, and I started to do work and was like, no, I need to talk to Demulati about, like, how we should even display this in the first place.
154 00:15:22.790 ⇒ 00:15:25.460 Demilade Agboola: So, let me see, they all have the same suborder ID.
155 00:15:26.440 ⇒ 00:15:29.299 Demilade Agboola: And so now what you want to do is you want to take the price.
156 00:15:30.570 ⇒ 00:15:35.399 Demilade Agboola: Do you want to take this… both prices? Because there are two rows that have been canceled.
157 00:15:35.750 ⇒ 00:15:41.019 Demilade Agboola: Have been deleted, so you want to take 264 plus 16, right?
158 00:15:42.820 ⇒ 00:15:44.750 Demilade Agboola: And how do you want to spread it across?
159 00:15:45.060 ⇒ 00:15:46.599 Demilade Agboola: the new support ID.
160 00:15:48.200 ⇒ 00:15:53.979 Emily Giant: That is a great question. I think it should probably be by the,
161 00:15:54.150 ⇒ 00:15:58.650 Emily Giant: The weight of the original item cost, So, like…
162 00:16:01.610 ⇒ 00:16:07.880 Emily Giant: Okay, this is where I get really cloudy-headed, because this is obviously revenue that was captured.
163 00:16:08.040 ⇒ 00:16:12.840 Emily Giant: But it wasn’t captured against the item that was sent.
164 00:16:13.020 ⇒ 00:16:18.509 Emily Giant: And I feel like in your new model, you maintain That the item that was…
165 00:16:18.630 ⇒ 00:16:27.720 Emily Giant: Purchase is what garnered the revenue, but that the total revenue is…
166 00:16:29.320 ⇒ 00:16:35.310 Emily Giant: not recognized on that item. So there’s, like, a column of, like, this is…
167 00:16:35.540 ⇒ 00:16:38.559 Emily Giant: how the revenue was… I would call this accrued.
168 00:16:38.850 ⇒ 00:16:39.600 Demilade Agboola: Yeah.
169 00:16:39.840 ⇒ 00:16:44.009 Emily Giant: And then recognized, If we were to add another…
170 00:16:54.570 ⇒ 00:16:55.450 Emily Giant: Okay.
171 00:16:55.620 ⇒ 00:17:02.350 Emily Giant: And then recognized would be… The price of what was sent, right?
172 00:17:03.080 ⇒ 00:17:04.240 Emily Giant: And it won’t it.
173 00:17:05.119 ⇒ 00:17:07.360 Emily Giant: Not… it would not apply.
174 00:17:07.950 ⇒ 00:17:12.069 Emily Giant: I have to write this down so that it’s all in my head. It would not apply to…
175 00:17:12.180 ⇒ 00:17:14.719 Emily Giant: Has been deleted.
176 00:17:15.599 ⇒ 00:17:16.829 Emily Giant: items.
177 00:17:18.119 ⇒ 00:17:23.390 Emily Giant: And then… In this, model.
178 00:17:24.450 ⇒ 00:17:30.269 Emily Giant: It… oh, no, it doesn’t do it until the final model, where it pulls in the,
179 00:17:31.070 ⇒ 00:17:35.680 Emily Giant: The piece original revenue, or the piece cost per item.
180 00:17:36.830 ⇒ 00:17:38.480 Emily Giant: That’s one way to do it.
181 00:17:39.370 ⇒ 00:17:47.040 Emily Giant: Pieced product cost should… okay, piece product cost is another good one that you could use. Because it’s…
182 00:17:47.740 ⇒ 00:17:50.140 Emily Giant: The piece cost times how many?
183 00:17:53.650 ⇒ 00:17:56.190 Emily Giant: And then, this should show zero.
184 00:17:56.470 ⇒ 00:18:02.770 Emily Giant: Yeah, it does. It shows zero for the ones that… weren’t actually fulfilled.
185 00:18:05.160 ⇒ 00:18:08.729 Emily Giant: But I need to do this, I need to pull that logic in.
186 00:18:10.850 ⇒ 00:18:14.550 Emily Giant: I guess I need to pull the deleted items all the way through to the end.
187 00:18:15.180 ⇒ 00:18:18.100 Emily Giant: Or have a separate model that does this.
188 00:18:19.560 ⇒ 00:18:20.150 Demilade Agboola: Hmm…
189 00:18:20.450 ⇒ 00:18:21.600 Emily Giant: You know what I mean?
190 00:18:21.970 ⇒ 00:18:22.600 Demilade Agboola: Yeah.
191 00:18:31.290 ⇒ 00:18:34.629 Demilade Agboola: So where does this, like… where do all this, like, pace…
192 00:18:35.020 ⇒ 00:18:39.270 Demilade Agboola: product, cost coming from? Like, where do we get that data from?
193 00:18:39.450 ⇒ 00:18:40.460 Emily Giant: NetSuite.
194 00:18:42.020 ⇒ 00:18:43.259 Emily Giant: Or polytopic.
195 00:18:50.740 ⇒ 00:18:51.480 Demilade Agboola: So…
196 00:18:52.210 ⇒ 00:18:59.459 Demilade Agboola: Do you think it might be helpful to have a, like, maybe an intermediate adjustment table, or an intermediate…
197 00:19:00.000 ⇒ 00:19:05.870 Demilade Agboola: Our revenue adjustment table, where… For every… for every suborder.
198 00:19:06.170 ⇒ 00:19:08.490 Demilade Agboola: That has a has been deleted.
199 00:19:10.160 ⇒ 00:19:13.670 Demilade Agboola: Has been deleted.
200 00:19:14.140 ⇒ 00:19:14.980 Demilade Agboola: Rule.
201 00:19:15.720 ⇒ 00:19:17.819 Demilade Agboola: We take the price that was…
202 00:19:18.370 ⇒ 00:19:22.400 Demilade Agboola: Gotten, and then we distribute it across what’s left.
203 00:19:22.680 ⇒ 00:19:23.320 Emily Giant: Yep.
204 00:19:26.270 ⇒ 00:19:28.450 Demilade Agboola: And so then we can use that, like, further downstream.
205 00:19:29.230 ⇒ 00:19:29.890 Emily Giant: Yeah.
206 00:19:36.370 ⇒ 00:19:41.930 Emily Giant: So, that would have to be intermediate after this.
207 00:19:42.690 ⇒ 00:19:43.940 Demilade Agboola: Yeah.
208 00:19:45.190 ⇒ 00:19:57.270 Emily Giant: we filter out… let me see what these look like. If I compile that model, it should have run successfully. Okay, so let me at least make sure that this isn’t…
209 00:19:57.600 ⇒ 00:20:01.819 Emily Giant: messed up and insane, like it looked when I just ran it for you.
210 00:20:02.020 ⇒ 00:20:03.800 Emily Giant: Okay…
211 00:20:09.220 ⇒ 00:20:11.810 Emily Giant: Or is those components? Like, what is this?
212 00:20:15.120 ⇒ 00:20:17.410 Emily Giant: Something very weird is happening.
213 00:20:18.260 ⇒ 00:20:19.980 Demilade Agboola: How is comprank calculated?
214 00:20:20.060 ⇒ 00:20:21.350 Emily Giant: It is…
215 00:20:25.200 ⇒ 00:20:31.159 Emily Giant: It’s something in that partition. Component… Rank, or it’s comp rank.
216 00:20:37.250 ⇒ 00:20:42.320 Emily Giant: It’s the component ID, split part.
217 00:20:44.550 ⇒ 00:20:48.709 Emily Giant: Alright, it just needs to be, like, the parsed-out version of this.
218 00:20:48.990 ⇒ 00:20:51.000 Emily Giant: And I think that will happen.
219 00:20:53.630 ⇒ 00:21:03.020 Emily Giant: Okay, so instead of component ID, it has to be, like, HEVO, the line item ID, HEVO REFID, or HIVO array index, HEVO array index 1.
220 00:21:03.450 ⇒ 00:21:06.820 Demilade Agboola: Yeah, I think because the component can be across multiple…
221 00:21:07.690 ⇒ 00:21:09.830 Demilade Agboola: Orders, that’s why the comp rank is so high.
222 00:21:10.030 ⇒ 00:21:11.779 Emily Giant: Yeah, okay, gotcha.
223 00:21:11.780 ⇒ 00:21:15.599 Demilade Agboola: In partitioned by the combination of the company ID.
224 00:21:15.820 ⇒ 00:21:21.190 Demilade Agboola: As well as, like, order ID or suborder ID, if that’s what you just want to focus on.
225 00:21:21.410 ⇒ 00:21:25.160 Emily Giant: Yeah, okay, that’s… that’s an easy fix.
226 00:21:25.790 ⇒ 00:21:30.749 Emily Giant: Very weird. I feel like something happened in the merge, that that got, like…
227 00:21:32.680 ⇒ 00:21:40.850 Emily Giant: I don’t know, that just was not happening this weekend, so I’m a little, like, what happened? But anyway, not a difficult fix.
228 00:21:41.960 ⇒ 00:21:47.030 Emily Giant: So… In this model, one upstream from that.
229 00:21:47.630 ⇒ 00:21:53.800 Emily Giant: We… we do filter out, the… Right here.
230 00:21:56.370 ⇒ 00:21:58.309 Emily Giant: Is that the appropriate move?
231 00:21:58.630 ⇒ 00:22:01.539 Emily Giant: Something tells me that’s, like, not something we should do.
232 00:22:02.760 ⇒ 00:22:03.660 Demilade Agboola: What’d dreamer.
233 00:22:04.310 ⇒ 00:22:06.819 Emily Giant: If we want to,
234 00:22:08.320 ⇒ 00:22:18.280 Emily Giant: see what was ordered, and what was accrued, and what was recognized. Filtering out the original item that was ordered is gonna…
235 00:22:18.630 ⇒ 00:22:20.060 Emily Giant: obscure.
236 00:22:20.680 ⇒ 00:22:25.089 Emily Giant: What unit actually accrued the revenue?
237 00:22:25.850 ⇒ 00:22:32.910 Demilade Agboola: Yeah, but we wouldn’t be filtering out what was… we’re filtering out sub-orders that don’t have any
238 00:22:33.340 ⇒ 00:22:42.410 Demilade Agboola: deleted rows. So, in that case, if there’s a suborder that has one deleted row, or, like, one deleted item.
239 00:22:42.520 ⇒ 00:22:49.119 Demilade Agboola: That entire suborder will be part of what we… will… Put into this model.
240 00:22:49.230 ⇒ 00:22:57.289 Demilade Agboola: Okay. Where we then distribute. So we’re not doing it by the line item, we’re doing it by the order, the sub-order.
241 00:22:57.680 ⇒ 00:23:06.820 Emily Giant: Gotcha. Okay. So… I think it would… My thought is… To, instead of having this…
242 00:23:08.940 ⇒ 00:23:11.759 Emily Giant: Instead of having this feed directly to this.
243 00:23:13.130 ⇒ 00:23:16.960 Emily Giant: We should use this as the base.
244 00:23:17.200 ⇒ 00:23:26.960 Emily Giant: For… the, I guess I don’t know, really. Like, what base should be used for…
245 00:23:27.580 ⇒ 00:23:37.769 Emily Giant: the logic of has been deleted, hasn’t been deleted, because I, like, this one is as complete and filled in as possible before sending it over to fact.
246 00:23:37.910 ⇒ 00:23:39.789 Emily Giant: Legacy Order Components.
247 00:23:40.050 ⇒ 00:23:41.200 Demilade Agboola: Yeah, yeah.
248 00:23:41.200 ⇒ 00:23:45.479 Emily Giant: But also, if that were true, then why do we still have this?
249 00:23:45.590 ⇒ 00:23:50.259 Emily Giant: You know? Because that’s the, line item union.
250 00:23:52.360 ⇒ 00:23:58.639 Emily Giant: I think it has to be, like, this logic… and this.
251 00:24:00.110 ⇒ 00:24:07.370 Emily Giant: In its own model, with… The logic you had said.
252 00:24:08.580 ⇒ 00:24:10.659 Emily Giant: And then distributed amongst.
253 00:24:11.620 ⇒ 00:24:12.980 Emily Giant: the pieces.
254 00:24:13.120 ⇒ 00:24:18.700 Emily Giant: It’s almost like this exact same model, but just for deleted line items.
255 00:24:20.120 ⇒ 00:24:23.270 Emily Giant: In which case, I would have to, like, unfilter out.
256 00:24:24.290 ⇒ 00:24:26.220 Demilade Agboola: Yeah, so basically, yeah.
257 00:24:27.270 ⇒ 00:24:36.699 Demilade Agboola: Yeah, I think in that case, the reason why I would like to do this is because I… or, like, why I’m considering that is because instead of having so many things, it literally would just be, like.
258 00:24:36.830 ⇒ 00:24:38.579 Demilade Agboola: Max 10 columns.
259 00:24:39.590 ⇒ 00:24:45.490 Demilade Agboola: Where it’s just basically the line… the SOBOT ID, the line… like, the line SM ID,
260 00:24:46.090 ⇒ 00:24:48.660 Demilade Agboola: The revenue has been deleted.
261 00:24:48.830 ⇒ 00:24:53.129 Demilade Agboola: on, like… the type, basically. Like, it’s just…
262 00:24:53.750 ⇒ 00:25:04.229 Demilade Agboola: The focus is literally just the recalculation, and just redistributing all the revenue that was accrued across what’s left of
263 00:25:05.990 ⇒ 00:25:12.769 Demilade Agboola: The order after that, so we can easily just take that and put it forward, like, using whatever model we want to use.
264 00:25:14.630 ⇒ 00:25:17.009 Emily Giant: Okay, that makes sense to me.
265 00:25:17.010 ⇒ 00:25:18.510 Demilade Agboola: Also, yeah.
266 00:25:20.530 ⇒ 00:25:23.370 Demilade Agboola: Yeah, so that’s kind of the basic idea with that.
267 00:25:27.540 ⇒ 00:25:28.480 Emily Giant: So…
268 00:25:30.290 ⇒ 00:25:35.730 Demilade Agboola: So probably, like, client at MIT, the… Revenue… Yeah, from…
269 00:25:39.210 ⇒ 00:25:40.470 Demilade Agboola: the P-Suite.
270 00:25:42.590 ⇒ 00:25:43.660 Demilade Agboola: aren’t,
271 00:25:47.180 ⇒ 00:25:48.990 Demilade Agboola: And then…
272 00:25:49.790 ⇒ 00:25:52.660 Emily Giant: act… the… what’s it called? Fulfilled revenue.
273 00:25:52.660 ⇒ 00:25:53.350 Demilade Agboola: Yeah?
274 00:25:55.340 ⇒ 00:26:01.179 Emily Giant: I think it needs the component ID, though, right? Because this will pull… pull in kits, and then it.
275 00:26:01.180 ⇒ 00:26:01.530 Demilade Agboola: Okay.
276 00:26:01.530 ⇒ 00:26:02.770 Emily Giant: Broken up again.
277 00:26:02.960 ⇒ 00:26:06.809 Demilade Agboola: Yeah, I was gonna say, yeah, so the line item, or, like, the product type, too.
278 00:26:07.020 ⇒ 00:26:10.959 Emily Giant: Yeah. Oh yeah, is primary product is probably the
279 00:26:11.690 ⇒ 00:26:13.919 Emily Giant: I guess that doesn’t actually really matter.
280 00:26:13.920 ⇒ 00:26:18.050 Demilade Agboola: Because we’re not using it. Yeah, because, like, maybe…
281 00:26:18.420 ⇒ 00:26:26.060 Demilade Agboola: I think the only thing that we… isn’t to just redistribute the weight, it’s the piece weight, like, the piece weight, or, like, the other thing that really matters.
282 00:26:26.330 ⇒ 00:26:27.140 Demilade Agboola: I did.
283 00:26:28.820 ⇒ 00:26:33.040 Demilade Agboola: It needs the piece product cost in order to distribute the weight.
284 00:26:33.990 ⇒ 00:26:34.560 Demilade Agboola: Okay.
285 00:26:34.560 ⇒ 00:26:35.700 Emily Giant: That makes sense.
286 00:26:35.850 ⇒ 00:26:39.699 Demilade Agboola: And then we’ll need to put the component ID.
287 00:26:40.160 ⇒ 00:26:41.590 Emily Giant: Yup, yep, yep, yep.
288 00:26:47.700 ⇒ 00:26:50.860 Emily Giant: Okay, that is… Nice and clean.
289 00:26:51.030 ⇒ 00:26:56.599 Emily Giant: So I can technically, as long as I…
290 00:26:59.090 ⇒ 00:27:07.090 Emily Giant: I’m trying to still wrap my head around the… whether or not I need to remove the filter for has been deleted from the components. I think I do.
291 00:27:08.520 ⇒ 00:27:14.839 Demilade Agboola: from the component. So, you know, so what would happen here is… All we’ll need is…
292 00:27:19.270 ⇒ 00:27:22.310 Demilade Agboola: Because this will be coming in… would it?
293 00:27:26.770 ⇒ 00:27:31.300 Demilade Agboola: So this perform the components? So this will… so you can use this…
294 00:27:31.990 ⇒ 00:27:34.739 Emily Giant: And get the… the new…
295 00:27:35.200 ⇒ 00:27:42.260 Demilade Agboola: revenue associated with each of these into this model, and that would be the fact legacy component.
296 00:27:45.130 ⇒ 00:27:47.000 Emily Giant: Gotcha, that makes sense.
297 00:27:52.940 ⇒ 00:27:55.739 Emily Giant: So this is essentially the accrued revenue table.
298 00:27:57.910 ⇒ 00:27:58.710 Demilade Agboola: Pardon?
299 00:27:58.880 ⇒ 00:28:04.210 Emily Giant: So this is essentially, like, the accrued revenue… no, the fulfilled revenue table.
300 00:28:06.240 ⇒ 00:28:09.910 Emily Giant: In the fact legacy, the in-components union.
301 00:28:10.530 ⇒ 00:28:13.659 Demilade Agboola: Yes, sir. Oh, I was trying to ask if you should remove…
302 00:28:15.620 ⇒ 00:28:18.739 Demilade Agboola: Okay, so is this… and can I see the lineage again?
303 00:28:18.740 ⇒ 00:28:19.330 Emily Giant: Yeah.
304 00:28:22.540 ⇒ 00:28:24.419 Demilade Agboola: This is the only thing.
305 00:28:24.420 ⇒ 00:28:31.230 Emily Giant: Of the components, and… Oh, no, that’s not true. Here.
306 00:28:32.420 ⇒ 00:28:36.590 Emily Giant: Cuz… Line item union still goes into it as well.
307 00:28:37.050 ⇒ 00:28:40.839 Emily Giant: Which maintains whether or not the item has been deleted.
308 00:28:41.160 ⇒ 00:28:44.500 Demilade Agboola: Okay, so yeah, that, that… That could be fine, then.
309 00:28:48.060 ⇒ 00:28:49.770 Emily Giant: Yeah, so I… yeah, okay.
310 00:28:54.750 ⇒ 00:28:56.220 Emily Giant: So…
311 00:29:00.840 ⇒ 00:29:02.700 Emily Giant: In… in the end.
312 00:29:06.610 ⇒ 00:29:10.150 Emily Giant: would this CTE be replaced with…
313 00:29:11.460 ⇒ 00:29:17.709 Emily Giant: the accrued… or the fulfilled… no, I cannot talk. Accrued revenue table?
314 00:29:18.170 ⇒ 00:29:21.330 Emily Giant: Or would this… Or would it just be another…
315 00:29:21.770 ⇒ 00:29:24.449 Emily Giant: Model pulled in to the final table.
316 00:29:25.730 ⇒ 00:29:29.220 Demilade Agboola: I’m not sure of the structure of this final, because I can’t really say, but…
317 00:29:29.220 ⇒ 00:29:29.890 Emily Giant: Oh, okay.
318 00:29:29.890 ⇒ 00:29:34.020 Demilade Agboola: There it is, yeah, we’ll have to integrate the revenue adjustment table in here.
319 00:29:35.130 ⇒ 00:29:35.630 Emily Giant: Okay.
320 00:29:35.670 ⇒ 00:29:42.140 Demilade Agboola: So that we can have how much they’re, accrued and how much the… What field revenue was.
321 00:29:43.120 ⇒ 00:29:53.119 Emily Giant: Gotcha. Okay, I can work on that. I think I just need to start working on it, and then it will become easier to understand, but I’ll start by just building that table that we talked about.
322 00:29:53.450 ⇒ 00:29:59.700 Emily Giant: And then we can, like, Huddle after that, and work it into the final model.
323 00:30:00.400 ⇒ 00:30:01.120 Demilade Agboola: Okay.
324 00:30:01.120 ⇒ 00:30:02.130 Emily Giant: Does that make sense?
325 00:30:02.310 ⇒ 00:30:03.289 Demilade Agboola: Yeah, that makes sense.
326 00:30:03.290 ⇒ 00:30:07.859 Emily Giant: Okay, cool. And then I’ll go ahead and fix that weird partition.
327 00:30:13.100 ⇒ 00:30:18.470 Demilade Agboola: So this legacy order component, I can use it to fit into… the…
328 00:30:18.470 ⇒ 00:30:19.890 Emily Giant: historical revenue.
329 00:30:19.890 ⇒ 00:30:21.340 Demilade Agboola: Historical revenue, okay, gotcha.
330 00:30:24.940 ⇒ 00:30:26.060 Emily Giant: Aaron, okay.
331 00:30:29.730 ⇒ 00:30:34.239 Emily Giant: It needs to be, like, the same… I just gotta figure out where these references are.
332 00:30:34.570 ⇒ 00:30:35.780 Emily Giant: to make sure…
333 00:30:36.800 ⇒ 00:30:43.649 Emily Giant: that I have what I need to build that component piece. It… it… I really sometimes just don’t understand where…
334 00:30:45.160 ⇒ 00:30:46.930 Emily Giant: These errors come from.
335 00:30:47.550 ⇒ 00:30:54.050 Emily Giant: Okay, so it’s gotta be partitioned by… Line item ID…
336 00:31:01.340 ⇒ 00:31:02.820 Emily Giant: Nope, nope, nope.
337 00:31:09.000 ⇒ 00:31:10.399 Emily Giant: In that… or is it…
338 00:31:14.560 ⇒ 00:31:16.639 Emily Giant: line item ID, and then…
339 00:31:20.970 ⇒ 00:31:23.960 Emily Giant: Because you don’t want to use the component ID for the component rank.
340 00:31:24.620 ⇒ 00:31:31.370 Emily Giant: Because you want to maintain Hold on, so Component Rank is… it’s ranking…
341 00:31:32.050 ⇒ 00:31:39.649 Emily Giant: the weight of the components within a suborder. So you don’t want to use the line item ID, because they’re all… you just want to use the…
342 00:31:43.140 ⇒ 00:31:45.339 Emily Giant: You could use the PK ref.
343 00:31:46.100 ⇒ 00:31:48.110 Emily Giant: Or something like that, but…
344 00:31:49.550 ⇒ 00:31:54.059 Emily Giant: you don’t want to use the line item ID, because then they’ll all partition as one, right?
345 00:31:55.030 ⇒ 00:31:58.179 Demilade Agboola: No, but if we’re using line item ID.
346 00:31:58.670 ⇒ 00:32:01.440 Emily Giant: And a combination of the…
347 00:32:01.820 ⇒ 00:32:06.829 Demilade Agboola: Competent ID, So it’s only do the partition.
348 00:32:07.010 ⇒ 00:32:12.080 Demilade Agboola: Based off each line item and the components within that line item, which is what we want, right?
349 00:32:13.010 ⇒ 00:32:18.120 Emily Giant: This one is, it’s not meant to…
350 00:32:18.660 ⇒ 00:32:22.729 Emily Giant: filter anything. It’s just meant to say, this is the most expensive.
351 00:32:23.100 ⇒ 00:32:27.689 Emily Giant: This is the least expensive. And, like, put them in order by their cost.
352 00:32:29.010 ⇒ 00:32:31.890 Demilade Agboola: Okay, but within each line item, right?
353 00:32:33.790 ⇒ 00:32:34.609 Demilade Agboola: Or just a quick…
354 00:32:34.610 ⇒ 00:32:38.499 Emily Giant: within each row of the suborder. So, it’s…
355 00:32:40.470 ⇒ 00:32:45.670 Emily Giant: Orders, yeah, each item within a suborder.
356 00:32:46.470 ⇒ 00:32:47.570 Emily Giant: by price.
357 00:32:48.620 ⇒ 00:32:53.390 Demilade Agboola: Okay, and so… Basically, what does the line item ID represent?
358 00:32:54.410 ⇒ 00:32:58.580 Emily Giant: An individual… Row within a suborder.
359 00:32:59.610 ⇒ 00:33:03.250 Demilade Agboola: So, each line item ID is unique across the suborder.
360 00:33:03.600 ⇒ 00:33:10.600 Emily Giant: No, component ID is… line item ID will bundle… will be only one for a bundle.
361 00:33:11.750 ⇒ 00:33:12.449 Demilade Agboola: Oh, okay.
362 00:33:12.700 ⇒ 00:33:17.270 Demilade Agboola: Basically, if you notice, maybe we could use suborda ID instead, but the idea is…
363 00:33:17.480 ⇒ 00:33:22.989 Demilade Agboola: for each suborder, commission of each suborder, and the company ID, that’s what we want to do this ranking.
364 00:33:24.150 ⇒ 00:33:25.610 Demilade Agboola: Yeah, so…
365 00:33:27.150 ⇒ 00:33:29.039 Emily Giant: So, yeah, suborder ID.
366 00:33:29.040 ⇒ 00:33:29.930 Demilade Agboola: Yeah.
367 00:33:33.080 ⇒ 00:33:35.570 Demilade Agboola: Combined with the component ID.
368 00:33:41.010 ⇒ 00:33:51.699 Emily Giant: But then won’t that, like, not order… it will just order it within the component ID, and these all… every row has a different component ID from within the same suborder. So I would think suborder would be…
369 00:33:52.620 ⇒ 00:33:53.490 Emily Giant: enough.
370 00:33:55.130 ⇒ 00:33:58.850 Demilade Agboola: Yeah, it should be… Enough.
371 00:34:07.750 ⇒ 00:34:10.520 Demilade Agboola: It should be enough,
372 00:34:14.909 ⇒ 00:34:16.670 Demilade Agboola: Yeah, it should be enough, actually.
373 00:34:16.679 ⇒ 00:34:17.489 Emily Giant: Yeah.
374 00:34:17.599 ⇒ 00:34:22.439 Emily Giant: Let me try building… It’s fine.
375 00:34:37.379 ⇒ 00:34:38.109 Emily Giant: Ugh.
376 00:34:56.009 ⇒ 00:34:58.939 Emily Giant: Yeah, I think that that seems like it should fix it.
377 00:35:00.169 ⇒ 00:35:01.939 Emily Giant: But, we shall see.
378 00:35:03.859 ⇒ 00:35:05.489 Emily Giant: See how this is Dylan.
379 00:35:16.909 ⇒ 00:35:19.079 Emily Giant: This doesn’t even make sense.
380 00:35:20.809 ⇒ 00:35:24.999 Emily Giant: Like, why does it build just fine for me in…
381 00:35:27.720 ⇒ 00:35:34.120 Demilade Agboola: Union types, cocktails, so there’s a… an integer… Merging with PAU.
382 00:35:34.530 ⇒ 00:35:35.520 Demilade Agboola: Votra.
383 00:35:35.690 ⇒ 00:35:44.230 Emily Giant: Right, but, like, I have built that 1 million times. It’s just gotta be a refresh issue. Like, it needs to refresh on its own or something.
384 00:35:44.920 ⇒ 00:35:52.769 Demilade Agboola: Yes, I… Yeah, but we should be able to, like, just quickly do the… Data type, cost.
385 00:35:53.590 ⇒ 00:36:04.079 Emily Giant: I’m telling you, it’s not real, though. Like, it just needs its own full refresh. There’s no way I ever would have put something in production that I didn’t, like, test 1 billion times.
386 00:36:04.230 ⇒ 00:36:10.980 Emily Giant: Either that, or something weird is happening, that when I deploy some, like, a fix, it stops right around. Yeah.
387 00:36:14.190 ⇒ 00:36:20.400 Emily Giant: I, yeah, let me try the full refresh, because, okay, this… this ran, so let’s just test this real quick.
388 00:36:29.040 ⇒ 00:36:33.309 Emily Giant: I don’t know if it totally refreshed it, because it’s incremental.
389 00:36:33.900 ⇒ 00:36:37.650 Emily Giant: I think it only refreshed the ones that were recent.
390 00:36:38.560 ⇒ 00:36:41.679 Emily Giant: And I bet you when I fully refresh it, it will fix it.
391 00:36:44.080 ⇒ 00:36:45.049 Emily Giant: Let’s do this.
392 00:36:47.330 ⇒ 00:36:48.100 Emily Giant: Nope.
393 00:37:02.600 ⇒ 00:37:05.160 Emily Giant: And then in here, I’m gonna do this.
394 00:37:14.590 ⇒ 00:37:15.540 Emily Giant: Nope.
395 00:37:46.040 ⇒ 00:37:53.759 Emily Giant: I think what needs to happen is that, like, every single upstream thing of this needs to run on its own.
396 00:37:54.820 ⇒ 00:37:57.079 Emily Giant: As a full refresh, because…
397 00:37:57.810 ⇒ 00:38:03.439 Emily Giant: They all had to be fixed in the steps up into that table.
398 00:38:04.330 ⇒ 00:38:04.660 Demilade Agboola: Okay.
399 00:38:04.660 ⇒ 00:38:08.649 Emily Giant: Like, it’s gonna crap out until those are fixed.
400 00:38:11.240 ⇒ 00:38:14.269 Demilade Agboola: But when you do the full refresh, it seems to break out some points.
401 00:38:14.710 ⇒ 00:38:20.680 Emily Giant: Yeah, it’s… As though it doesn’t actually fully refresh every table.
402 00:38:20.810 ⇒ 00:38:36.720 Emily Giant: upstream, it, like, runs the ones upstream, and then doesn’t fully refresh, and only fully refreshes the final one. I’ve noticed this recently because, of, like, just making sure the jobs go through, that if I do, like.
403 00:38:37.310 ⇒ 00:38:39.040 Emily Giant: Run by run.
404 00:38:39.210 ⇒ 00:38:46.069 Emily Giant: of each table, they will all work, but if I try to do, like, full refresh plus upstream, it doesn’t.
405 00:38:47.180 ⇒ 00:38:49.190 Emily Giant: It’s like a DBT weirdness.
406 00:38:50.150 ⇒ 00:38:55.770 Demilade Agboola: I think you might need to reach out to the dbt team, because that’s a very… I haven’t noticed it, to be honest.
407 00:38:56.090 ⇒ 00:38:57.110 Emily Giant: You have not?
408 00:38:57.110 ⇒ 00:38:58.570 Demilade Agboola: No, I haven’t.
409 00:38:58.570 ⇒ 00:38:59.420 Emily Giant: Okay.
410 00:38:59.540 ⇒ 00:39:03.849 Emily Giant: Well, it’s… been an issue.
411 00:39:04.470 ⇒ 00:39:10.159 Emily Giant: Okay, let me see… What is this?
412 00:39:11.490 ⇒ 00:39:13.090 Emily Giant: Whatever. Okay.
413 00:39:14.790 ⇒ 00:39:23.440 Emily Giant: All right, well, I will work on getting this run through. Let’s… once this is refreshing and we can see that that issue’s fixed, then.
414 00:39:24.690 ⇒ 00:39:34.019 Emily Giant: I can go back to working on getting those tables to run. But this has been a thing with dbt that I’ve dealt with, like, not recently, like, for a very long time.
415 00:39:34.410 ⇒ 00:39:41.800 Emily Giant: No. Like, break each table, or each model, into its own… Full refresh, if anything changed.
416 00:39:42.780 ⇒ 00:39:46.450 Demilade Agboola: Alright, can you just focus… if you focus on the…
417 00:39:46.620 ⇒ 00:39:49.680 Demilade Agboola: Creating revenue, I can get this job to run.
418 00:39:49.680 ⇒ 00:39:50.430 Emily Giant: Okay.
419 00:39:51.810 ⇒ 00:39:55.610 Demilade Agboola: So I’ll just focus on that. Yeah, I would say that the tables that are…
420 00:39:56.530 ⇒ 00:39:57.710 Emily Giant: almost like…
421 00:39:57.980 ⇒ 00:40:05.570 Emily Giant: entirely changed and will take forever to refresh, but I did it Friday, so I… maybe it shouldn’t be as bad, is the staging totals.
422 00:40:06.070 ⇒ 00:40:08.770 Emily Giant: The one leading into the dim light item union.
423 00:40:09.680 ⇒ 00:40:12.070 Emily Giant: Or, int, OMS line item union.
424 00:40:13.550 ⇒ 00:40:14.380 Demilade Agboola: Gotcha.
425 00:40:14.590 ⇒ 00:40:15.220 Emily Giant: Yeah.
426 00:40:16.220 ⇒ 00:40:16.800 Demilade Agboola: Alright.
427 00:40:16.800 ⇒ 00:40:18.029 Emily Giant: Everything looks…
428 00:40:19.230 ⇒ 00:40:26.409 Emily Giant: Yeah, it’s this CTE here that, like, there’s incremental models that might need to refresh on their own leading up to it.
429 00:40:29.590 ⇒ 00:40:31.970 Emily Giant: Alright, cool. Alright, I’ll work on that model.
430 00:40:33.310 ⇒ 00:40:34.250 Demilade Agboola: Sounds good.
431 00:40:34.810 ⇒ 00:40:37.699 Emily Giant: Alrighty, I’ll talk to you soon.
432 00:40:39.420 ⇒ 00:40:41.639 Demilade Agboola: Alright then, have a good day.
433 00:40:41.640 ⇒ 00:40:43.170 Emily Giant: You too, bye.
434 00:40:43.170 ⇒ 00:40:43.880 Demilade Agboola: Right.