2025-10-31_historical_revenue_model_debugging_sessi_13b30ddb

Meeting Title: Historical Revenue Model Debugging Session Date: 2025-10-31 Meeting participants: Demilade Agboola, Emily Giant

---

WEBVTT

1 00:00:42.680 ⇒ 00:00:43.830 Emily Giant: Good morning.

2 00:00:45.820 ⇒ 00:00:47.929 Emily Giant: Or afternoon, in your case.

3 00:00:47.930 ⇒ 00:00:51.560 Demilade Agboola: Yeah, it’s afternoon, it’s like 2PM. How are you?

4 00:00:52.430 ⇒ 00:00:54.670 Emily Giant: Pretty, pretty good.

5 00:00:55.360 ⇒ 00:01:01.799 Emily Giant: Yeah. I was trying to think of something to complain about, and I couldn’t, so that’s good. It’s a good one. Yeah.

6 00:01:02.060 ⇒ 00:01:03.500 Demilade Agboola: That’s a good spot to be.

7 00:01:03.780 ⇒ 00:01:05.489 Emily Giant: Yeah, how are you?

8 00:01:06.040 ⇒ 00:01:11.799 Demilade Agboola: I’m pretty good. I play tennis today, so I’m excited about that.

9 00:01:12.160 ⇒ 00:01:15.059 Emily Giant: Nice. Are you… are you addicted yet?

10 00:01:15.200 ⇒ 00:01:17.319 Demilade Agboola: Oh yeah, I am, I am.

11 00:01:17.320 ⇒ 00:01:19.660 Emily Giant: It seems like it.

12 00:01:19.860 ⇒ 00:01:36.409 Demilade Agboola: I played last week, Saturday, and I had, like, messed up my knee… oh, no, not my knee, my ankle from, soccer the day before, so I had very little mobility, but I still played. And everyone’s just like, you know you could rest, right? I’m like, yeah, I know, but, like, I just wanted to be on the court.

13 00:01:36.790 ⇒ 00:01:42.740 Emily Giant: Yeah. Do you wear, like, tennis, clothing when you do it? Did you buy any?

14 00:01:43.380 ⇒ 00:01:48.919 Demilade Agboola: I wouldn’t necessarily, like, the only, like, tennis-specific clothing I bought was, like, the shoes.

15 00:01:49.160 ⇒ 00:01:49.880 Emily Giant: Yeah.

16 00:01:49.880 ⇒ 00:01:56.400 Demilade Agboola: Rather than… I have, like, active wear, so I just… I just have, like, my… because, you know, like I said, I play football quite a bit.

17 00:01:56.400 ⇒ 00:01:56.840 Emily Giant: I am.

18 00:01:57.060 ⇒ 00:01:58.629 Demilade Agboola: So I just…

19 00:01:59.180 ⇒ 00:02:05.279 Demilade Agboola: Also, I bought some pair of, like, tennis shorts, because they apparently have, like, pockets… pockets that can hold, like, two, three balls in…

20 00:02:05.280 ⇒ 00:02:07.880 Emily Giant: Oh, yeah, yeah, I didn’t think about that.

21 00:02:08.710 ⇒ 00:02:15.939 Demilade Agboola: Yeah, but apart from that, every other thing is just, like, regular activewear. I have two rackets.

22 00:02:16.700 ⇒ 00:02:17.520 Demilade Agboola: Cause…

23 00:02:17.840 ⇒ 00:02:24.080 Demilade Agboola: I’m really into stuff like that, because different rackets have different feels, and I was just trying to, like, figure out what worked for me best.

24 00:02:24.290 ⇒ 00:02:25.000 Emily Giant: Yeah.

25 00:02:25.000 ⇒ 00:02:25.660 Demilade Agboola: Boom.

26 00:02:25.930 ⇒ 00:02:27.739 Emily Giant: Do you have one that you like better?

27 00:02:27.740 ⇒ 00:02:31.139 Demilade Agboola: Yeah, yeah, yeah, I do. I have, Wilson.

28 00:02:32.010 ⇒ 00:02:36.289 Demilade Agboola: And I have a head racket, and I’ve heard the Wilson racket.

29 00:02:36.520 ⇒ 00:02:37.309 Demilade Agboola: It’s one of those…

30 00:02:37.310 ⇒ 00:02:39.399 Emily Giant: I mean, that’s the classic, right?

31 00:02:39.400 ⇒ 00:02:40.460 Demilade Agboola: Yeah.

32 00:02:40.930 ⇒ 00:02:42.170 Demilade Agboola: the pro staff.

33 00:02:42.380 ⇒ 00:02:50.079 Demilade Agboola: So I have that, I have a… so when I go play, I also have a tripod that I set up, so I record myself playing.

34 00:02:50.640 ⇒ 00:02:51.330 Emily Giant: Oh, wow.

35 00:02:51.330 ⇒ 00:02:58.300 Demilade Agboola: like, go back home and, like, watch and try and see, like, things I’m doing well, things are not doing well. I didn’t do that last week, because, like, I was not moving…

36 00:02:58.520 ⇒ 00:03:01.280 Demilade Agboola: Well, so there was no point in recording, because everything was…

37 00:03:01.280 ⇒ 00:03:04.600 Emily Giant: With a, like, a messed up…

38 00:03:05.070 ⇒ 00:03:09.770 Emily Giant: What did you hurt? Your… your ankle? Sorry, I forget what you hurt, yeah.

39 00:03:10.180 ⇒ 00:03:14.599 Demilade Agboola: Because I was playing, like, soccer, and there was, like, a collision on my ankle kind of twisted.

40 00:03:15.180 ⇒ 00:03:16.070 Emily Giant: Ugh.

41 00:03:16.260 ⇒ 00:03:17.440 Demilade Agboola: Man…

42 00:03:17.440 ⇒ 00:03:22.759 Emily Giant: That’s like… once an ankle gets hurt, I swear, they’re never the same.

43 00:03:22.990 ⇒ 00:03:26.580 Demilade Agboola: Like… Great news to hear.

44 00:03:26.580 ⇒ 00:03:41.739 Emily Giant: I mean, you’ll recover, I’m sure. You’ve probably heard it all the time, playing football, but, like, it’s like, once your ankle gets, like, a little bit weaker, it takes so long to, like…

45 00:03:41.850 ⇒ 00:03:45.520 Emily Giant: It’ll feel better, but you’re, like, likely to twist it again.

46 00:03:46.630 ⇒ 00:03:50.439 Emily Giant: There’s something to it, where, like, it just, it’s ready to twist.

47 00:03:52.020 ⇒ 00:03:58.840 Demilade Agboola: Not bad. I got some ankle support, though, like the ankle support, thing that you can wear, so…

48 00:03:58.970 ⇒ 00:04:03.589 Demilade Agboola: That helped, especially in the first couple of days, because I was really struggling to walk.

49 00:04:04.020 ⇒ 00:04:04.590 Demilade Agboola: But…

50 00:04:04.590 ⇒ 00:04:06.060 Emily Giant: Oof, not bad.

51 00:04:06.240 ⇒ 00:04:07.940 Demilade Agboola: Yeah, it was that bad. But…

52 00:04:08.860 ⇒ 00:04:11.729 Demilade Agboola: That’s why everyone’s like, why did you come and play tennis? And I’m like…

53 00:04:11.730 ⇒ 00:04:15.140 Emily Giant: Yeah, I can see now why they were asking.

54 00:04:15.140 ⇒ 00:04:19.560 Demilade Agboola: I was like, I was gonna come, don’t worry about it, I’ll figure it out, so…

55 00:04:19.950 ⇒ 00:04:25.660 Emily Giant: Oh my gosh. Well, you’re very inspiring. Are you still doing the swimming?

56 00:04:26.120 ⇒ 00:04:28.830 Demilade Agboola: Oh, yeah, yeah, I went swimming yesterday, I’m going swimming tomorrow.

57 00:04:28.830 ⇒ 00:04:30.209 Emily Giant: Oh my gosh!

58 00:04:31.290 ⇒ 00:04:32.519 Emily Giant: You’re a machine.

59 00:04:33.220 ⇒ 00:04:34.350 Emily Giant: In a good way.

60 00:04:35.280 ⇒ 00:04:49.100 Demilade Agboola: Yeah, sometimes my brother asks me, like, because my brother’s a doctor, and he has two kids, and so, like, wife and kids, and, like, he’s just like, how… how do you see the time? And I’m like, I mean, to be fair, I am, like, single.

61 00:04:49.420 ⇒ 00:04:51.110 Demilade Agboola: along in, like, Malta.

62 00:04:51.400 ⇒ 00:04:52.410 Emily Giant: Yeah.

63 00:04:52.410 ⇒ 00:04:58.170 Demilade Agboola: easy to go, like, oh, in the mornings I’m going swimming. Then I come here, I come back home, like, 12.

64 00:04:58.410 ⇒ 00:05:04.509 Demilade Agboola: Into the, into the, you know, night, and I go play tennis at, like, 9pm.

65 00:05:05.170 ⇒ 00:05:06.130 Emily Giant: Oh my gosh!

66 00:05:06.130 ⇒ 00:05:06.900 Demilade Agboola: Not that…

67 00:05:06.900 ⇒ 00:05:10.789 Emily Giant: Are you indoors when you do that? Is it, like, an indoor court, or is it just lit?

68 00:05:10.790 ⇒ 00:05:12.030 Demilade Agboola: No, it’s outdoor.

69 00:05:12.200 ⇒ 00:05:13.389 Demilade Agboola: It’s not awkward.

70 00:05:14.660 ⇒ 00:05:16.290 Emily Giant: It also sounds magical.

71 00:05:16.520 ⇒ 00:05:20.439 Emily Giant: If you’re playing outdoors at 9pm, that’s some nice weather.

72 00:05:21.510 ⇒ 00:05:30.660 Demilade Agboola: Yeah, I mean, it’s decent. It doesn’t get too cold, and to be fair, I do… do pretty well be cold, but, like, no, it’s pretty fair. It’s usually, like…

73 00:05:31.260 ⇒ 00:05:32.930 Demilade Agboola: I don’t know, maybe…

74 00:05:33.570 ⇒ 00:05:39.909 Demilade Agboola: my Celsius to Fahrenheit conversion is a bit off, but it should be, like, in the 60s, I believe?

75 00:05:40.270 ⇒ 00:05:45.300 Emily Giant: Yeah. Oh, that’s perfect. That’s my favorite running weather. That’s the only time I can run well.

76 00:05:45.300 ⇒ 00:05:49.200 Demilade Agboola: Like, if it’s too hot, I’m slow. If it’s too cold, I’m slow.

77 00:05:49.440 ⇒ 00:06:01.009 Emily Giant: If it’s in the 60s, I can get my mile under 8 minutes, which is still slow, to be honest. But, in my current age and state, it’s the best I can do.

78 00:06:01.180 ⇒ 00:06:01.720 Demilade Agboola: Right.

79 00:06:02.200 ⇒ 00:06:10.489 Demilade Agboola: You’re running. I really can’t… I, like, running sucks for me, so I’m not… I cannot… I have no judgments, like, definitely no judgments for me.

80 00:06:10.730 ⇒ 00:06:18.119 Emily Giant: Yeah, well, I still want to get… get down with tennis, or at least pickleball, so that when I’m old, I have something to do.

81 00:06:18.330 ⇒ 00:06:22.739 Emily Giant: Which is soon. It’s gonna… it’s coming before I know it, so…

82 00:06:22.740 ⇒ 00:06:24.470 Demilade Agboola: don’t be like that.

83 00:06:24.470 ⇒ 00:06:25.100 Emily Giant: Hell no.

84 00:06:25.100 ⇒ 00:06:25.830 Demilade Agboola: I’m just talking…

85 00:06:25.830 ⇒ 00:06:26.390 Emily Giant: Great.

86 00:06:27.550 ⇒ 00:06:33.329 Demilade Agboola: 60, like, Last week? Oh, no, sorry, it was last week? 27th, so this week.

87 00:06:33.920 ⇒ 00:06:41.439 Demilade Agboola: Very fun fact, she had this… she and my dad had the same date, like, same birth date, but different, obviously, yeah.

88 00:06:41.440 ⇒ 00:06:45.479 Emily Giant: Their parents are, they have rituals, it sounds like.

89 00:06:45.480 ⇒ 00:06:51.729 Demilade Agboola: Yeah. Well, here’s the funny thing, right? I call her my aunt, but she’s technically my cousin. She’s just much older.

90 00:06:51.730 ⇒ 00:06:53.039 Emily Giant: Oh,

91 00:06:53.040 ⇒ 00:06:56.920 Demilade Agboola: she’s, like, you know, like I said, she’s… she turned 60, so she’s just much older.

92 00:06:57.180 ⇒ 00:06:57.850 Emily Giant: Hmm.

93 00:06:58.420 ⇒ 00:07:01.019 Demilade Agboola: But, yeah, it’s… it’s quite…

94 00:07:01.450 ⇒ 00:07:09.499 Demilade Agboola: But she doesn’t look 60. Like, if I showed you a picture of her, you would never, ever guess that she was 60. And that’s what I mean, like, you know, just…

95 00:07:10.580 ⇒ 00:07:13.899 Emily Giant: Yeah. You just… if you keep doing what you’re doing.

96 00:07:14.170 ⇒ 00:07:21.059 Emily Giant: like, as long as that’s a healthy doing. It’s like people in New York, they look young, because they’re walking everywhere.

97 00:07:21.260 ⇒ 00:07:24.550 Emily Giant: And they’re always walking… once they look old, they look…

98 00:07:24.790 ⇒ 00:07:38.080 Emily Giant: like, like they’ve come up from the grave to go to the grocery store. It hits hard, but they’re, like, 95 when they are still, like, walking around and going to the grocery, and I just think that, like, we’re supposed to walk more.

99 00:07:38.380 ⇒ 00:07:40.289 Emily Giant: And it keeps the life longer.

100 00:07:40.760 ⇒ 00:07:46.339 Emily Giant: But, what am I… this is not… sorry, I was looking at the model that I was trying to…

101 00:07:46.630 ⇒ 00:07:52.739 Emily Giant: Something’s wrong with the join, maybe you can help me. I was trying yesterday…

102 00:07:52.970 ⇒ 00:07:57.159 Emily Giant: To, get the new versions of all of the…

103 00:07:57.810 ⇒ 00:08:04.659 Emily Giant: component models for historical revenue, like, just into the place. I’ll show you what I changed.

104 00:08:04.920 ⇒ 00:08:07.580 Emily Giant: Can you see my screen? And is it the correct screen?

105 00:08:08.410 ⇒ 00:08:11.300 Demilade Agboola: Like I said, the repository, yeah.

106 00:08:11.300 ⇒ 00:08:13.720 Emily Giant: Nope, wrong screen, alright.

107 00:08:13.720 ⇒ 00:08:15.180 Demilade Agboola: It hurts in.

108 00:08:15.180 ⇒ 00:08:21.880 Emily Giant: Yeah, no, that’s not what I meant to show you. There’s something wrong with the order ID and suborder ID right now, maybe you can…

109 00:08:21.990 ⇒ 00:08:26.360 Emily Giant: put eyes on it real quick, but… hold on, I need to…

110 00:08:27.440 ⇒ 00:08:34.150 Emily Giant: once I lose the regular Zoom screen, I cannot find it. Like, Okay, stop.

111 00:08:34.740 ⇒ 00:08:38.230 Demilade Agboola: Can you… or do you click on the icon at the bottom?

112 00:08:39.200 ⇒ 00:08:51.389 Emily Giant: Oh, there it is, okay. Sorry, it’s, like, hidden in my laptop, and I don’t look at my laptop, I look at my external monitor, so I’m always looking on my external monitor for… okay.

113 00:08:52.390 ⇒ 00:08:56.350 Emily Giant: So… lineage.

114 00:08:57.140 ⇒ 00:08:58.780 Emily Giant: So…

115 00:08:59.340 ⇒ 00:09:11.589 Emily Giant: we were use… oh, this is the old one, still. Why is it still connected to DIM… oh, no, it’s DIM Product Union, okay. So, the things I switched out in… this used to be OMS,

116 00:09:12.220 ⇒ 00:09:29.579 Emily Giant: Comp XF base, because we don’t really need ComponentsXF, and we don’t really need those, like, plant component models, the two, like, kit models that lead up to ComponentsXF, like, nothing really happens between OMS CompXF and

117 00:09:29.970 ⇒ 00:09:37.389 Emily Giant: like, Rev… them using ComponentsXF, so I think we could… and I think you had done this, like, hooked…

118 00:09:38.040 ⇒ 00:09:42.730 Emily Giant: OMS CompExF base directly into the new revenue mart.

119 00:09:43.480 ⇒ 00:09:55.130 Emily Giant: But… Yeah. Yeah. So… what was different was so minimal, but it will totally screw up the results.

120 00:09:55.630 ⇒ 00:09:57.519 Emily Giant: In order line items.

121 00:09:58.700 ⇒ 00:10:05.310 Emily Giant: it was using index to create the IDs, so I just switched it out to Hivo Array Index.

122 00:10:05.670 ⇒ 00:10:21.640 Emily Giant: for one reason or another, Index, like, crapped out along the way, and stopped populating, so, like, it will work for a period of time, but then it stops. So, it’s essentially the same model outside of switching that out. And then I did the same thing for…

123 00:10:21.900 ⇒ 00:10:24.370 Emily Giant: The split line items.

124 00:10:24.810 ⇒ 00:10:37.429 Emily Giant: And then, instead of having, like, 15 different models that do nothing… Here, the union is… pretty similar…

125 00:10:37.970 ⇒ 00:10:45.640 Emily Giant: In fact, it’s, like, identical outside of having the new Shopify thing, but the components union,

126 00:10:46.150 ⇒ 00:10:48.250 Emily Giant: this might be where I’m getting the issues.

127 00:10:48.730 ⇒ 00:10:56.140 Emily Giant: But before, the staging models were, like, intermediate models. They were filling in,

128 00:10:56.440 ⇒ 00:11:06.929 Emily Giant: all of the line items that were missing in the staging models, so instead of doing that, I made, like, real staging models for components and components split.

129 00:11:07.340 ⇒ 00:11:13.490 Emily Giant: And then… in the union, Because it’s, like, the same…

130 00:11:14.900 ⇒ 00:11:18.969 Emily Giant: Logic that applies to both, but from the separate

131 00:11:19.910 ⇒ 00:11:28.789 Emily Giant: split line items versus order line… order line items. I just applied it directly in this, like, union model.

132 00:11:29.100 ⇒ 00:11:32.110 Emily Giant: So that it’s a little more, like, consolidated and clean.

133 00:11:34.440 ⇒ 00:11:49.290 Emily Giant: This, I need to test. I was doing some of it through Cursor, and I will say Cursor has good ideas, but I use them, like, maybe 10% of the time. A lot of times it gets me on the right train of thought, and then I have to completely redo everything it does.

134 00:11:49.500 ⇒ 00:11:51.869 Emily Giant: Do you have that experience with cursors?

135 00:11:52.280 ⇒ 00:11:56.390 Demilade Agboola: Sometimes, yeah, I would say about…

136 00:11:59.820 ⇒ 00:12:01.570 Demilade Agboola: I’m trying to think of a percentage.

137 00:12:03.060 ⇒ 00:12:08.799 Demilade Agboola: I wouldn’t say half the time, maybe a little over half the time. I… when I use cursor, it’s a bit…

138 00:12:08.980 ⇒ 00:12:09.830 Demilade Agboola: like…

139 00:12:12.350 ⇒ 00:12:29.069 Demilade Agboola: it’s a bit fine, it just… I just try to use it to do smaller bits, instead of, like, a huge, like, lump sum of stuff, because, like, it can do what I want it to do to a certain point, then it kind of just goes off the rails, and so I have to do, like, bits by bits, like, prompting.

140 00:12:29.070 ⇒ 00:12:29.590 Emily Giant: I agree.

141 00:12:29.590 ⇒ 00:12:35.540 Demilade Agboola: So, like, okay, I have this, I want you to do this, and so it’s easier to, like, fix that.

142 00:12:35.790 ⇒ 00:12:37.939 Demilade Agboola: Thing, if it does, goes a bit wrong.

143 00:12:38.410 ⇒ 00:12:46.699 Demilade Agboola: Well, yeah, if… it definitely can go off the rails, or sometimes forget to, like, Accommodate certain things.

144 00:12:47.250 ⇒ 00:12:51.500 Demilade Agboola: So yeah, I kind of… I kind of use cursor sometimes as a…

145 00:12:53.420 ⇒ 00:13:02.909 Demilade Agboola: platform to, like, build things on, rather than, like… and also the prompting, like, sometimes I think that’s part of what can be frustrating, but I’m learning to get better with.

146 00:13:03.800 ⇒ 00:13:08.810 Demilade Agboola: Is that, like, prompting, like, really requires you to be… As specific as possible.

147 00:13:09.520 ⇒ 00:13:22.929 Emily Giant: Yeah, sometimes when I’m lazy, I’m like, well, I can’t use this today, can I? Because if I’m not using my words well, it doesn’t know what the hell I’m trying to get from it. And it will go crazy.

148 00:13:24.090 ⇒ 00:13:27.820 Emily Giant: So, I guess there’s something still wrong with my fact model.

149 00:13:28.540 ⇒ 00:13:33.550 Emily Giant: because it’s not pulling in order ID, but what I did was,

150 00:13:35.420 ⇒ 00:13:39.809 Emily Giant: Okay, so the line item base, this shouldn’t have to look like that. It should just…

151 00:13:40.540 ⇒ 00:13:42.100 Emily Giant: Be able to split it.

152 00:13:42.360 ⇒ 00:13:47.620 Emily Giant: It’s pretty much the same outside of…

153 00:13:48.130 ⇒ 00:13:52.100 Emily Giant: Subscriptions overwrite, I switched it to using fax subscriptions.

154 00:13:52.460 ⇒ 00:13:56.110 Emily Giant: Because this is much more accurate with the subscription revenue.

155 00:13:56.330 ⇒ 00:13:57.030 Demilade Agboola: Okay.

156 00:13:57.210 ⇒ 00:14:13.889 Emily Giant: And then re-delivery overwrite, switched it to the staging OMS re-deliveries, because much more accurate, with, pulling re-delivery IDs. Since we… I think you did this months and months ago, but it, like, synthesizes all of the historical and…

157 00:14:14.610 ⇒ 00:14:15.430 Emily Giant: like…

158 00:14:16.210 ⇒ 00:14:34.700 Emily Giant: active re-deliveries, and the other model, it does… it, like, switches from orders to suborders at some point in history, what records the re-deliveries, so I was like, okay, we’re just gonna switch to this, it’s much more reliable, and the revenue’s always zero, so instead of pulling

159 00:14:35.010 ⇒ 00:14:41.969 Emily Giant: the… There… there was a… field in suborders.

160 00:14:42.120 ⇒ 00:14:50.370 Emily Giant: that was pulling revenue, and just for the sake of reliability, since a re-delivery never has revenue, I just marked it as zero.

161 00:14:50.670 ⇒ 00:14:54.810 Emily Giant: But other than that, I didn’t change anything.

162 00:14:55.020 ⇒ 00:14:57.620 Emily Giant: But something’s weird, because when I…

163 00:14:58.770 ⇒ 00:15:01.750 Emily Giant: something’s weird with the join, because it’s not pulling the order ID.

164 00:15:02.060 ⇒ 00:15:04.209 Emily Giant: Or the suborder ID, and it always should.

165 00:15:06.270 ⇒ 00:15:11.909 Emily Giant: Like… Like, I don’t know why it wouldn’t pull.

166 00:15:12.820 ⇒ 00:15:16.980 Emily Giant: like, the suborder ID is right there. Why is it not pulling it?

167 00:15:17.760 ⇒ 00:15:20.989 Demilade Agboola: Can I go to the… can we go… what’s the order? Can I see the…

168 00:15:20.990 ⇒ 00:15:21.910 Emily Giant: Yeah.

169 00:15:22.440 ⇒ 00:15:25.339 Demilade Agboola: where other ID is coming from. Other ideas about the ID?

170 00:15:25.520 ⇒ 00:15:26.670 Emily Giant: Yeah.

171 00:15:28.290 ⇒ 00:15:32.190 Emily Giant: Okay, so there’s a piece parent build. It’s coming from components.

172 00:15:32.440 ⇒ 00:15:35.500 Emily Giant: And then, they’re both coming from the component model.

173 00:15:36.270 ⇒ 00:15:37.850 Demilade Agboola: Nice of the component model.

174 00:15:37.850 ⇒ 00:15:41.620 Emily Giant: Yeah, it’s… This one…

175 00:15:45.720 ⇒ 00:15:51.279 Emily Giant: So, wait, let me pull that… that order ID that wasn’t, populating.

176 00:15:52.300 ⇒ 00:15:58.859 Emily Giant: And then… Because I have all of the info here.

177 00:16:04.230 ⇒ 00:16:09.180 Demilade Agboola: Also, my guess is, potentially, you might… you might need to actually run the models.

178 00:16:09.600 ⇒ 00:16:10.260 Demilade Agboola: progressive.

179 00:16:10.260 ⇒ 00:16:11.020 Emily Giant: care.

180 00:16:11.330 ⇒ 00:16:12.900 Emily Giant: hurt, where…

181 00:16:16.770 ⇒ 00:16:18.000 Emily Giant: Okay…

182 00:16:22.050 ⇒ 00:16:25.320 Emily Giant: So I think it’s called int OMS Components Union.

183 00:17:10.470 ⇒ 00:17:13.700 Emily Giant: Okay, so it’s something wrong in the upstream model.

184 00:17:14.680 ⇒ 00:17:17.280 Emily Giant: Where it’s not pulling suborder ID correctly.

185 00:17:18.579 ⇒ 00:17:21.539 Emily Giant: The line item and component is coming through.

186 00:17:24.150 ⇒ 00:17:27.709 Demilade Agboola: Can we see how this model gets order ID and suborder ID?

187 00:17:27.710 ⇒ 00:17:28.740 Emily Giant: Yes.

188 00:17:29.800 ⇒ 00:17:32.619 Emily Giant: It’s not this one, it’s this one.

189 00:17:32.830 ⇒ 00:17:33.800 Emily Giant: Okay.

190 00:17:34.240 ⇒ 00:17:37.440 Emily Giant: So, line items, base… as…

191 00:17:39.650 ⇒ 00:17:40.849 Demilade Agboola: What’s supposed to…

192 00:17:41.290 ⇒ 00:17:49.520 Emily Giant: First of all, I don’t know why it needs to do this. It should just… Always… work.

193 00:17:50.360 ⇒ 00:17:55.729 Emily Giant: And there’s also a HIVO array index that is directly in this model.

194 00:17:56.530 ⇒ 00:17:59.360 Emily Giant: So, I don’t know why it’s doing that.

195 00:18:03.810 ⇒ 00:18:07.640 Emily Giant: Strip Shopify, suborder and order.

196 00:18:08.270 ⇒ 00:18:12.609 Emily Giant: Line items… Strike through, that’s fine.

197 00:18:17.830 ⇒ 00:18:20.680 Emily Giant: Okay, so it’s pulling them from the line items model.

198 00:18:20.790 ⇒ 00:18:28.560 Emily Giant: Instead of the… component model, and that might be why. It probably needs to be, like, a coalesce.

199 00:18:29.380 ⇒ 00:18:30.700 Demilade Agboola: Oh, okay, yeah.

200 00:18:30.700 ⇒ 00:18:34.519 Emily Giant: Well… Alright, so if I did…

201 00:18:35.350 ⇒ 00:18:39.090 Emily Giant: Maybe for the sake of just not messing with too many things at once.

202 00:18:39.480 ⇒ 00:18:41.339 Emily Giant: I had to coalesce.

203 00:19:18.550 ⇒ 00:19:20.750 Emily Giant: I’ll have to do it in the other one, too. Whoops.

204 00:19:31.800 ⇒ 00:19:34.399 Emily Giant: Okay, split lines, suborder ID.

205 00:19:34.650 ⇒ 00:19:37.970 Emily Giant: And this is coalescing with… Okay.

206 00:19:44.750 ⇒ 00:19:49.539 Demilade Agboola: James… sorry, what are you getting… what do you want to coalesce it with?

207 00:19:50.390 ⇒ 00:19:53.789 Emily Giant: The order split line items.

208 00:19:54.740 ⇒ 00:19:55.680 Demilade Agboola: Oh, okay.

209 00:19:55.900 ⇒ 00:20:05.910 Emily Giant: So, it’s just that other… Okay, so the run succeeded, but it’s not gonna work until I… Completely…

210 00:20:28.770 ⇒ 00:20:33.299 Emily Giant: No, these are gonna be… sorry, it’s a union, so it has to be in the same order.

211 00:20:37.900 ⇒ 00:20:40.160 Emily Giant: And then I have an extra one there.

212 00:20:41.460 ⇒ 00:20:47.399 Emily Giant: Okay. So, order ID, suborder ID, that’s coming from split line items.

213 00:20:57.070 ⇒ 00:20:59.110 Emily Giant: That says Border ID.

214 00:20:59.260 ⇒ 00:21:02.240 Emily Giant: Okay, let me run it again…

215 00:21:07.220 ⇒ 00:21:09.699 Emily Giant: Oh shit, sorry, this is supposed to be…

216 00:21:11.710 ⇒ 00:21:12.760 Demilade Agboola: Order ID.

217 00:21:12.760 ⇒ 00:21:13.460 Emily Giant: Yeah.

218 00:22:01.440 ⇒ 00:22:06.259 Emily Giant: Come on! Oh man, yesterday mode was so slow.

219 00:22:06.710 ⇒ 00:22:07.630 Emily Giant: that…

220 00:22:08.530 ⇒ 00:22:15.589 Emily Giant: I had to give up on, like, testing things in mode. Like, anytime I put more than… anytime I put a compiled

221 00:22:16.010 ⇒ 00:22:18.630 Emily Giant: Code in it, it would be 7 minutes.

222 00:22:21.840 ⇒ 00:22:23.360 Demilade Agboola: Simple means a lot of time.

223 00:22:23.670 ⇒ 00:22:24.410 Emily Giant: Yeah.

224 00:22:25.530 ⇒ 00:22:27.340 Emily Giant: Make a cup of coffee.

225 00:22:28.040 ⇒ 00:22:29.749 Emily Giant: do some stretches.

226 00:22:36.800 ⇒ 00:22:42.119 Emily Giant: So, yeah, these, like, aren’t substantially changed outside of consolidating

227 00:22:42.240 ⇒ 00:22:53.749 Emily Giant: How weirdly those component models were put together, because those always really bothered me, that, like, they did so much in staging, and it was so messy, that it was, like, hard to understand what was going on.

228 00:22:59.260 ⇒ 00:23:00.850 Emily Giant: Okay, let me pull up…

229 00:23:06.010 ⇒ 00:23:07.280 Emily Giant: It’s a face.

230 00:23:11.390 ⇒ 00:23:12.949 Emily Giant: Just while it’s running.

231 00:23:25.400 ⇒ 00:23:33.840 Emily Giant: Okay, so yeah, this is how I used to do it, without all the rejects, expressions, but… whatever,

232 00:23:38.060 ⇒ 00:23:40.340 Emily Giant: I wanted to see the lineage.

233 00:23:43.690 ⇒ 00:23:50.340 Emily Giant: Okay, yeah, perfect. So, once we’re able to replace this with the new… stuff, then…

234 00:23:51.490 ⇒ 00:23:56.300 Emily Giant: it should feed right into this, as long as I can do some QA and make sure that, like.

235 00:23:56.550 ⇒ 00:23:59.150 Emily Giant: Everything’s showing up how it’s meant to.

236 00:24:00.600 ⇒ 00:24:03.650 Emily Giant: Okay, so that ran. Let me check this now.

237 00:24:04.390 ⇒ 00:24:08.209 Emily Giant: Well, that’s gonna successfully pull it, because it did last time.

238 00:24:21.990 ⇒ 00:24:26.980 Emily Giant: Okay, that’s fixed. Yay, yay, yay. Lovely.

239 00:24:32.810 ⇒ 00:24:39.450 Emily Giant: Okay, cool. Let me run it downstream now… Fact, legacy…

240 00:24:48.650 ⇒ 00:24:52.850 Emily Giant: And then, if this runs, I was hoping we could just go through some of the ones that I QA’d.

241 00:24:53.820 ⇒ 00:25:01.980 Emily Giant: The other day in that sheet, and, like, implement the fixes. If you haven’t had time yet. I know that you’re doing, like, a million things.

242 00:25:04.360 ⇒ 00:25:12.179 Demilade Agboola: Oh, sure. I… I had started looking at it, but, like, effectively, the…

243 00:25:12.670 ⇒ 00:25:20.080 Demilade Agboola: It does appear that in the… 4mx companies.

244 00:25:20.560 ⇒ 00:25:21.120 Emily Giant: Hmm.

245 00:25:21.120 ⇒ 00:25:28.729 Demilade Agboola: partition by is done, like, so it’s not… the comp rank is not used… like, the component rank called line item ID is not used as the…

246 00:25:29.040 ⇒ 00:25:30.470 Demilade Agboola: partition.

247 00:25:30.730 ⇒ 00:25:31.190 Emily Giant: Correct.

248 00:25:31.410 ⇒ 00:25:40.179 Demilade Agboola: Where it’s the Sabodai, the Quales, the Hivo, our index, and call us.

249 00:25:40.520 ⇒ 00:25:42.000 Demilade Agboola: QVR re-index.

250 00:25:42.360 ⇒ 00:25:43.230 Demilade Agboola: 1.

251 00:25:43.720 ⇒ 00:25:45.639 Demilade Agboola: That’s what’s used to partition it.

252 00:25:46.410 ⇒ 00:25:48.649 Demilade Agboola: What’s the key what every index, basically?

253 00:25:48.650 ⇒ 00:25:51.099 Emily Giant: It is… I know, this took me…

254 00:25:51.250 ⇒ 00:26:01.609 Emily Giant: so long to figure out. It is… So… the… Lines in an order.

255 00:26:01.820 ⇒ 00:26:16.649 Emily Giant: It’s essentially the identifying factor of a unit and an order line, and then if it’s a kit, it further breaks down into Hivo Array Index 1. That’s why only the component models have HIVO array index 1.

256 00:26:17.780 ⇒ 00:26:31.729 Emily Giant: So, yeah, but oh my lord, when it broke, this was before y’all came, I had to figure out why none of the revenue models were working, and I was just looking at these random ones and zeros. I was like, is this binary code? Like, what am I doing?

257 00:26:31.770 ⇒ 00:26:40.249 Emily Giant: This is great that this is populating for some of them, too. It’s not going to for all for some reason. It should, but…

258 00:26:40.480 ⇒ 00:26:42.640 Emily Giant: That is a problem for another day.

259 00:26:44.360 ⇒ 00:26:49.680 Demilade Agboola: How, like, what’s the time frame of this model? Like, of these orders, sorry.

260 00:26:49.850 ⇒ 00:26:54.209 Emily Giant: Yeah, these are actually… new orders, I’m pretty sure.

261 00:26:54.440 ⇒ 00:26:58.639 Emily Giant: So it won’t even matter that that’s not there. It’s only for the ones

262 00:26:58.970 ⇒ 00:27:04.270 Emily Giant: For tags. I use this model for the tag model.

263 00:27:04.470 ⇒ 00:27:10.030 Emily Giant: So, I wanted them to work, but whatever. Let’s go to Dash.

264 00:27:14.730 ⇒ 00:27:17.340 Emily Giant: Okay, yeah, this is from yes… today.

265 00:27:18.370 ⇒ 00:27:20.170 Emily Giant: Literally an order from today.

266 00:27:20.280 ⇒ 00:27:21.520 Emily Giant: So…

267 00:27:23.500 ⇒ 00:27:31.100 Emily Giant: we don’t necessarily need to QA that, because it’s not even going to be used for this model. Let me pull up this…

268 00:27:31.550 ⇒ 00:27:32.860 Emily Giant: Nope, wrong one.

269 00:27:37.060 ⇒ 00:27:39.020 Emily Giant: Not revenue hard-coded.

270 00:27:39.330 ⇒ 00:27:40.710 Emily Giant: What do we call it?

271 00:27:51.740 ⇒ 00:27:52.550 Emily Giant: There.

272 00:27:53.080 ⇒ 00:27:53.840 Emily Giant: Okay.

273 00:27:58.000 ⇒ 00:28:01.460 Emily Giant: No, this still isn’t… the right one.

274 00:28:03.640 ⇒ 00:28:05.529 Emily Giant: I made an entire sheet.

275 00:28:05.830 ⇒ 00:28:08.180 Emily Giant: That was just comparing…

276 00:28:11.980 ⇒ 00:28:14.250 Emily Giant: It was, like, just doing QA.

277 00:28:15.020 ⇒ 00:28:16.100 Emily Giant: on…

278 00:28:19.940 ⇒ 00:28:23.650 Demilade Agboola: Did you make it… wait, is it different from the sheet you shared with me? Is it the same sheet?

279 00:28:23.650 ⇒ 00:28:26.600 Emily Giant: No, it is that sheet, and it went through, and like…

280 00:28:27.940 ⇒ 00:28:30.300 Emily Giant: It’s not this, though, this is Perry’s.

281 00:28:32.820 ⇒ 00:28:34.420 Demilade Agboola: If revenue had quitted.

282 00:28:34.420 ⇒ 00:28:36.530 Emily Giant: Okay. So, yeah.

283 00:28:36.750 ⇒ 00:28:37.989 Emily Giant: Oh, there it is.

284 00:28:39.010 ⇒ 00:28:39.980 Emily Giant: Alright.

285 00:29:10.450 ⇒ 00:29:13.509 Emily Giant: I’m gonna rename this to Legacy Order Lines, so that it…

286 00:29:13.740 ⇒ 00:29:16.649 Emily Giant: makes sense that it’s feeding into the order lines, Mark.

287 00:29:19.580 ⇒ 00:29:22.650 Emily Giant: Ugh, why? Why, oh, why?

288 00:29:23.410 ⇒ 00:29:25.000 Emily Giant: Let’s go back one…

289 00:30:05.050 ⇒ 00:30:08.070 Emily Giant: Oh, this is… a completely crazy order.

290 00:30:08.260 ⇒ 00:30:10.160 Emily Giant: Ugh, hold on.

291 00:30:13.200 ⇒ 00:30:14.690 Emily Giant: Oh my god.

292 00:30:15.580 ⇒ 00:30:16.740 Demilade Agboola: What’s going on?

293 00:30:16.740 ⇒ 00:30:17.480 Emily Giant: Mmm!

294 00:30:19.280 ⇒ 00:30:29.140 Emily Giant: What? Alright, so what was at… This person is… Something glitched in their computer.

295 00:30:29.790 ⇒ 00:30:40.130 Emily Giant: However… it does? So it should be the Margo, the Gold Teigen Vase, and 1, 2, 3, 4, 5, 6, 7, 8.

296 00:30:40.130 ⇒ 00:30:41.180 Demilade Agboola: the water.

297 00:30:41.180 ⇒ 00:30:44.720 Emily Giant: 10, 11, 12 sugar bears.

298 00:30:45.930 ⇒ 00:30:50.940 Emily Giant: And it has the price there. It was failing to have the price last time.

299 00:30:51.310 ⇒ 00:31:00.520 Emily Giant: So the dove… Is the dove in here?

300 00:31:03.230 ⇒ 00:31:09.920 Emily Giant: It looks like… The forced upgrade is there, but there should be a has been deleted.

301 00:31:13.150 ⇒ 00:31:15.240 Emily Giant: Yes, okay, so it has been deleted.

302 00:31:15.680 ⇒ 00:31:16.880 Emily Giant: is there.

303 00:31:17.210 ⇒ 00:31:29.290 Emily Giant: And the price is… Correctly attributing to… the new… product.

304 00:31:30.830 ⇒ 00:31:33.660 Emily Giant: So that’s all fine and good.

305 00:31:33.850 ⇒ 00:31:37.170 Emily Giant: And these should all have a different component ID.

306 00:31:37.590 ⇒ 00:31:42.159 Emily Giant: which is the big thing with, like, add-ons. Like, I was noticing that

307 00:31:42.910 ⇒ 00:31:49.290 Emily Giant: the component ID would be the same, and that’s why they weren’t coming through when there were, like, multiples of those. Where is…

308 00:31:50.570 ⇒ 00:31:52.879 Emily Giant: Where are the Kivo array indexes?

309 00:31:54.250 ⇒ 00:31:56.109 Emily Giant: Alright, I need to add those.

310 00:31:56.900 ⇒ 00:32:02.169 Emily Giant: To the union, because that’s confusing, to not be able to see that, like, tick, tick, tick.

311 00:32:02.650 ⇒ 00:32:05.070 Emily Giant: Of the index.

312 00:32:05.570 ⇒ 00:32:07.549 Emily Giant: Oh yeah, no, it’s right here.

313 00:32:07.740 ⇒ 00:32:16.820 Emily Giant: So… 12, 14, 4… So this is all coming through correctly in the line item union now.

314 00:32:18.620 ⇒ 00:32:19.660 Demilade Agboola: Nice.

315 00:32:19.660 ⇒ 00:32:22.860 Emily Giant: But why isn’t it coming through?

316 00:32:22.970 ⇒ 00:32:28.630 Emily Giant: in… the… downstream people.

317 00:32:29.630 ⇒ 00:32:30.779 Demilade Agboola: Have you run it?

318 00:32:32.760 ⇒ 00:32:34.899 Emily Giant: I’ll run it and see if that helps.

319 00:32:50.110 ⇒ 00:32:52.899 Emily Giant: I wonder if I fudged the join.

320 00:32:57.790 ⇒ 00:32:59.660 Demilade Agboola: Let me see…

321 00:33:06.430 ⇒ 00:33:09.500 Emily Giant: So, okay, I think this is a problem here.

322 00:33:09.740 ⇒ 00:33:13.820 Emily Giant: is that it’s joining on components, norm.

323 00:33:19.460 ⇒ 00:33:27.919 Emily Giant: But… And so, if it’s not in that union component model, which I don’t know why it isn’t.

324 00:33:28.740 ⇒ 00:33:38.019 Emily Giant: Because… It should be… it’s gonna not have this in it. What’s the old one doing?

325 00:33:46.440 ⇒ 00:33:48.510 Emily Giant: I hate all of this stuff.

326 00:33:49.210 ⇒ 00:33:50.580 Demilade Agboola: Why is it there?

327 00:33:50.580 ⇒ 00:33:52.140 Emily Giant: Oh, God.

328 00:33:53.290 ⇒ 00:33:54.610 Demilade Agboola: That’s quite something.

329 00:33:54.610 ⇒ 00:34:04.799 Emily Giant: It makes us just look like crazy business owners, does it not? Just like we… we’re like, ugh, then for a week we did this, and then for a week we did this.

330 00:34:05.720 ⇒ 00:34:06.710 Emily Giant: Okay.

331 00:34:06.710 ⇒ 00:34:10.549 Demilade Agboola: I think you could… potentially what I could do is to move it to seeds?

332 00:34:12.440 ⇒ 00:34:17.320 Emily Giant: Yeah, that’d be great. I just don’t want to look at it in there, more than anything.

333 00:34:17.679 ⇒ 00:34:18.560 Emily Giant: Okay.

334 00:34:19.230 ⇒ 00:34:21.180 Emily Giant: It’s the same join.

335 00:34:21.380 ⇒ 00:34:26.720 Emily Giant: Let me see if it pulls that record… well, I know it does, it just pulls it weird in the other one.

336 00:35:09.780 ⇒ 00:35:15.520 Emily Giant: Yeah, it just pulls… a lot of lines here.

337 00:35:15.840 ⇒ 00:35:17.440 Demilade Agboola: Yeah, that’s slow lines.

338 00:35:23.250 ⇒ 00:35:23.840 Demilade Agboola: Rewards.

339 00:35:23.840 ⇒ 00:35:25.970 Emily Giant: if we… Sorry, go ahead.

340 00:35:25.970 ⇒ 00:35:27.549 Demilade Agboola: It was eventually delivered?

341 00:35:28.570 ⇒ 00:35:29.610 Demilade Agboola: And that order.

342 00:35:30.030 ⇒ 00:35:31.419 Demilade Agboola: I wasn’t intrigued for Phil.

343 00:35:32.640 ⇒ 00:35:36.730 Emily Giant: Eventually, everything here but the dove.

344 00:35:37.530 ⇒ 00:35:45.610 Emily Giant: And then… And then this order 2, and then this dash 3 order.

345 00:35:45.830 ⇒ 00:35:50.179 Emily Giant: Gosh, this person… I think this was a bot. This doesn’t look real at all.

346 00:35:52.110 ⇒ 00:35:53.680 Demilade Agboola: Okay, but if it was delivered…

347 00:35:56.540 ⇒ 00:36:00.069 Emily Giant: But it only should show the lines from subordin number 1.

348 00:36:02.450 ⇒ 00:36:03.320 Demilade Agboola: Gotcha.

349 00:36:04.790 ⇒ 00:36:13.560 Emily Giant: Okay, so… Something is wrong with… Cause this is totally correct.

350 00:36:14.270 ⇒ 00:36:15.860 Demilade Agboola: But it’s the…

351 00:36:16.250 ⇒ 00:36:25.040 Emily Giant: Essentially the component union that isn’t correct, because it’s not… let me run this real quick.

352 00:36:25.810 ⇒ 00:36:27.260 Emily Giant: Cause I don’t know if I have.

353 00:36:28.160 ⇒ 00:36:29.440 Emily Giant: So…

354 00:36:33.720 ⇒ 00:36:35.440 Emily Giant: Let me see these joins.

355 00:36:39.670 ⇒ 00:36:41.170 Emily Giant: So this one is…

356 00:36:42.250 ⇒ 00:36:48.900 Emily Giant: just the component level, not the split components, and it’s pulling from line item base L.

357 00:36:49.310 ⇒ 00:36:52.380 Emily Giant: Which is the union where we know it works.

358 00:37:01.500 ⇒ 00:37:07.119 Emily Giant: And let me compare that to… the old version.

359 00:37:10.150 ⇒ 00:37:13.890 Emily Giant: Which all of it happens in the staging model in the old version.

360 00:37:21.890 ⇒ 00:37:22.640 Emily Giant: Okay.

361 00:37:23.740 ⇒ 00:37:25.810 Emily Giant: So, it pulls the components.

362 00:37:28.230 ⇒ 00:37:30.989 Emily Giant: And then it pulls Dimline out of Union.

363 00:37:32.200 ⇒ 00:37:34.650 Emily Giant: Or sources HEVO line items.

364 00:37:36.770 ⇒ 00:37:38.929 Emily Giant: And then it does a bunch of weird shit.

365 00:37:39.280 ⇒ 00:37:41.060 Emily Giant: Where it fills in the blanks.

366 00:37:41.600 ⇒ 00:37:46.350 Emily Giant: Which is all that that is supposed to be doing, because this junk is already done.

367 00:37:46.870 ⇒ 00:37:50.600 Emily Giant: This is done in the staging model, instead of…

368 00:37:52.070 ⇒ 00:37:56.129 Emily Giant: So, it looks like I need to do some form of coalescing here.

369 00:37:57.640 ⇒ 00:38:00.899 Demilade Agboola: Or maybe this is, like, intentionally in this model.

370 00:38:00.920 ⇒ 00:38:11.020 Emily Giant: because it will get obscured downstream, like, I don’t… Totally understand the positioning of creating the suborder ID, after…

371 00:38:11.340 ⇒ 00:38:12.220 Demilade Agboola: Yeah.

372 00:38:12.220 ⇒ 00:38:13.409 Emily Giant: You know what I mean?

373 00:38:14.220 ⇒ 00:38:17.050 Demilade Agboola: We have the soft string suborder ID.

374 00:38:21.970 ⇒ 00:38:30.569 Demilade Agboola: So, at this point, From this table, and those components, what do you want to have?

375 00:38:34.000 ⇒ 00:38:37.969 Emily Giant: So, this table… this old one or the new one?

376 00:38:38.970 ⇒ 00:38:43.760 Demilade Agboola: I mean, the old one, like, this is what it’s doing, but what do you need coming out of it?

377 00:38:44.630 ⇒ 00:38:56.359 Emily Giant: So, it’s pulling the components, but if there are not components, it fills in the lines that don’t have that information with the information from DIM line item union, is what’s happening.

378 00:38:58.500 ⇒ 00:38:59.520 Demilade Agboola: Gotcha.

379 00:39:02.820 ⇒ 00:39:03.700 Emily Giant: And then…

380 00:39:04.600 ⇒ 00:39:14.879 Emily Giant: And then all this does, which, essentially, I just did the logic for both component tables in one intermediate model, instead of doing this pointless model.

381 00:39:17.110 ⇒ 00:39:18.050 Demilade Agboola: Yeah.

382 00:39:19.610 ⇒ 00:39:26.130 Emily Giant: So, there’s just something… something that I don’t understand about

383 00:39:27.550 ⇒ 00:39:31.950 Emily Giant: this final CTE, which feels like it should be in the staging model.

384 00:39:34.640 ⇒ 00:39:38.070 Demilade Agboola: Oh, and the stitching model in our new… Part.

385 00:39:39.460 ⇒ 00:39:44.309 Emily Giant: It is in the staging model in… we’re staging OMS components.

386 00:39:45.330 ⇒ 00:39:49.350 Emily Giant: So, instead of creating the suborder ID and line item ID and everything.

387 00:39:49.770 ⇒ 00:39:53.600 Emily Giant: I just did it in the staging model, because…

388 00:39:54.880 ⇒ 00:39:59.139 Emily Giant: that is where it should be. But I think it’s on the left join.

389 00:40:00.440 ⇒ 00:40:06.730 Emily Giant: that things are getting lost. If I pull it, that suborder ID, Let me see…

390 00:40:07.220 ⇒ 00:40:09.890 Emily Giant: From the new staging model.

391 00:40:10.250 ⇒ 00:40:15.899 Emily Giant: that you made a couple months ago, and I just changed it to HIVO instead of Index.

392 00:40:19.230 ⇒ 00:40:25.529 Emily Giant: And then, of course, did, like, what you’re supposed to do in a staging model, and the staging model. Let’s see if it pulls.

393 00:40:26.520 ⇒ 00:40:35.679 Emily Giant: Because if it doesn’t, which, like, legitimately, the component model is… it doesn’t pull in things that don’t have additional components.

394 00:40:36.010 ⇒ 00:40:36.809 Demilade Agboola: Oh, stop.

395 00:40:36.810 ⇒ 00:40:41.370 Emily Giant: So what’s happening, like, if I go to the source model there.

396 00:40:46.150 ⇒ 00:40:51.499 Demilade Agboola: So what’s the… what’s… what are the components in this… in this transaction? In this order, suborder?

397 00:40:51.980 ⇒ 00:40:53.160 Emily Giant: What’s the water?

398 00:40:53.160 ⇒ 00:40:54.400 Demilade Agboola: for the components.

399 00:40:56.420 ⇒ 00:40:57.569 Emily Giant: What is that?

400 00:40:57.700 ⇒ 00:41:01.009 Demilade Agboola: as you said, like, it’s putting in the competence, so I want to be sure what…

401 00:41:01.010 ⇒ 00:41:05.959 Emily Giant: Components. I thought you said confidence, and I was like, I’m pretty confident that it was in order.

402 00:41:07.270 ⇒ 00:41:11.089 Emily Giant: So… oh, there is no suborder ID.

403 00:41:11.900 ⇒ 00:41:26.659 Emily Giant: the components don’t exist, because it’s not a kit, and that’s how the old thing used to work. So it wouldn’t come through, is my understanding, if there weren’t components not listed in the line item table. So I think the problem is that

404 00:41:27.670 ⇒ 00:41:33.920 Emily Giant: There are no components, and we’re doing a left join with line items, so it’s not making it through.

405 00:41:34.330 ⇒ 00:41:40.599 Emily Giant: as, we were always left joining to component models.

406 00:41:41.210 ⇒ 00:41:44.450 Emily Giant: So it might be in the split line item components instead of…

407 00:41:44.880 ⇒ 00:41:50.460 Demilade Agboola: So, shouldn’t we, in that case, be using… joining from our line items to the components?

408 00:41:50.860 ⇒ 00:41:57.169 Emily Giant: That’s what I was thinking, but I’m like, why did we do it the other way in the past? Like, what gets lost there?

409 00:41:58.920 ⇒ 00:42:02.140 Emily Giant: But I… it may have just been wrong all along.

410 00:42:02.320 ⇒ 00:42:02.950 Demilade Agboola: Yeah.

411 00:42:03.180 ⇒ 00:42:04.300 Emily Giant: That’s not a thing.

412 00:42:04.970 ⇒ 00:42:06.460 Emily Giant: Or HivoRef ID.

413 00:42:06.460 ⇒ 00:42:08.209 Demilade Agboola: I wouldn’t put it past it.

414 00:42:09.510 ⇒ 00:42:12.529 Emily Giant: I mean… We’ve seen things.

415 00:42:12.530 ⇒ 00:42:13.190 Demilade Agboola: We’re dead.

416 00:42:13.190 ⇒ 00:42:26.450 Emily Giant: So… because… My… my thought is that this probably, yep, doesn’t even exist in… the, the source.

417 00:42:27.050 ⇒ 00:42:33.360 Emily Giant: So… Let me see if it exists in the other… Source, though, because it…

418 00:42:33.810 ⇒ 00:42:38.620 Emily Giant: There are two component sources, just like there are two Line item sources.

419 00:42:39.560 ⇒ 00:42:40.710 Emily Giant: Why?

420 00:42:40.950 ⇒ 00:42:43.810 Emily Giant: I… I didn’t know.

421 00:42:44.130 ⇒ 00:42:47.159 Emily Giant: But… our staging components split.

422 00:42:47.450 ⇒ 00:42:49.329 Emily Giant: Staging order… no?

423 00:43:10.940 ⇒ 00:43:14.440 Emily Giant: Oh, I actually made a raw model in this one, for some reason.

424 00:43:15.090 ⇒ 00:43:16.030 Emily Giant: Oh.

425 00:43:16.800 ⇒ 00:43:18.290 Emily Giant: I can’t remember why.

426 00:43:24.300 ⇒ 00:43:26.009 Emily Giant: Do you have a meeting in 2 minutes?

427 00:43:27.090 ⇒ 00:43:32.940 Demilade Agboola: Yeah, but it’s not, it’s not that important, to be honest. Like, this… Missing some of the importance.

428 00:43:33.610 ⇒ 00:43:38.300 Emily Giant: Okay, yeah, I wanna… I wanna get this real bad.

429 00:43:55.850 ⇒ 00:44:01.359 Emily Giant: Okay, so because this isn’t… I just want to make sure that I’m using the right

430 00:44:01.990 ⇒ 00:44:05.050 Emily Giant: comparison here. I’m pretty sure I am.

431 00:44:08.700 ⇒ 00:44:16.879 Emily Giant: Because if it’s not in either tables, it’s never gonna show up. Yeah, HEVO RefID. If it’s, like, I can even do suborder.

432 00:44:17.160 ⇒ 00:44:19.350 Emily Giant: It’s not gonna matter, but…

433 00:44:22.720 ⇒ 00:44:25.940 Emily Giant: Yeah, it’ll never show up if it’s on neither component model.

434 00:44:26.690 ⇒ 00:44:27.759 Emily Giant: what this looks like.

435 00:44:31.320 ⇒ 00:44:32.140 Demilade Agboola: So…

436 00:44:33.990 ⇒ 00:44:41.330 Emily Giant: But it is showing up, in… the old… Lineage.

437 00:44:41.550 ⇒ 00:44:44.350 Emily Giant: And I don’t understand why.

438 00:44:46.790 ⇒ 00:44:48.560 Demilade Agboola: Like the competent model?

439 00:44:48.560 ⇒ 00:44:56.460 Emily Giant: Because when I do this, it’s wrong, but it shows up. But in the new version, it doesn’t show up at all.

440 00:44:57.940 ⇒ 00:44:58.530 Demilade Agboola: Unleashed.

441 00:44:58.530 ⇒ 00:45:03.109 Emily Giant: It stops at DIM, the new line item union, and never makes it.

442 00:45:06.840 ⇒ 00:45:08.640 Demilade Agboola: But it should show, though.

443 00:45:09.020 ⇒ 00:45:12.190 Emily Giant: Oh, it sure should. It’s something with a join.

444 00:45:12.190 ⇒ 00:45:19.519 Demilade Agboola: Yeah, that’s what I said, I think we just need to flip it around. Like, it should not be… the base of the model should not be components, because not all models have components, but all.

445 00:45:19.520 ⇒ 00:45:20.120 Emily Giant: Ian.

446 00:45:20.120 ⇒ 00:45:22.520 Demilade Agboola: Well, no, sorry, not all orders have components.

447 00:45:22.520 ⇒ 00:45:23.230 Emily Giant: Correct.

448 00:45:23.840 ⇒ 00:45:27.550 Demilade Agboola: Orders should have line items which could have components.

449 00:45:29.790 ⇒ 00:45:30.700 Emily Giant: Yeah.

450 00:45:30.870 ⇒ 00:45:31.850 Emily Giant: Okay.

451 00:45:33.730 ⇒ 00:45:37.560 Emily Giant: I’m just seeing if there’s… there’s nothing here that…

452 00:45:38.510 ⇒ 00:45:45.730 Emily Giant: where line item not in, select line item ID from split base. I do not think I have this.

453 00:45:50.030 ⇒ 00:45:51.960 Emily Giant: In the new version.

454 00:45:55.870 ⇒ 00:45:57.620 Demilade Agboola: Okay…

455 00:45:57.930 ⇒ 00:46:01.090 Emily Giant: I don’t know if that would matter all that much, but…

456 00:46:03.950 ⇒ 00:46:05.120 Demilade Agboola: See, union.

457 00:46:05.120 ⇒ 00:46:11.339 Emily Giant: Like, some of these, but… It’s called int Component… int OMS.

458 00:46:12.150 ⇒ 00:46:13.530 Emily Giant: Component union.

459 00:46:14.360 ⇒ 00:46:17.009 Emily Giant: Okay, so this is the same logic.

460 00:46:18.230 ⇒ 00:46:21.399 Emily Giant: as… this top half.

461 00:46:22.220 ⇒ 00:46:28.260 Emily Giant: Line item base, this is just the stuff from the new union table, where we know it comes through correctly.

462 00:46:30.310 ⇒ 00:46:43.669 Emily Giant: And then it uses… this… For filling in… the second CTE, Of the split line items.

463 00:46:46.570 ⇒ 00:46:54.180 Emily Giant: So, in staging components, just doing a… Senior Components… Old staging components.

464 00:46:56.690 ⇒ 00:47:01.140 Emily Giant: it should use dim light at Immunion, and then we need staging.

465 00:47:02.000 ⇒ 00:47:03.859 Emily Giant: component line items.

466 00:47:04.320 ⇒ 00:47:06.620 Emily Giant: Or staging line item components.

467 00:47:07.020 ⇒ 00:47:08.589 Emily Giant: It should use strength.

468 00:47:10.640 ⇒ 00:47:13.849 Emily Giant: Well, oh, that’s the new one, I’m sorry, we need the old one.

469 00:47:21.920 ⇒ 00:47:26.840 Emily Giant: It should use the source, that’s correct, and then the split line items, yep.

470 00:47:27.080 ⇒ 00:47:28.709 Emily Giant: And then it does all this junk.

471 00:47:29.140 ⇒ 00:47:30.900 Emily Giant: Okay.

472 00:47:32.880 ⇒ 00:47:35.090 Emily Giant: Yeah, I think this is it.

473 00:47:36.340 ⇒ 00:47:38.650 Emily Giant: Is that it’s using the line item base.

474 00:47:38.910 ⇒ 00:47:40.050 Emily Giant: Here.

475 00:47:40.840 ⇒ 00:47:42.790 Emily Giant: Let me see if it does that in ours.

476 00:47:47.670 ⇒ 00:47:50.180 Emily Giant: So on this one…

477 00:47:55.390 ⇒ 00:47:56.470 Demilade Agboola: I think it’s…

478 00:47:56.470 ⇒ 00:47:56.860 Emily Giant: Yeah.

479 00:47:57.320 ⇒ 00:47:58.820 Demilade Agboola: The strikethrough.

480 00:47:59.110 ⇒ 00:48:04.280 Emily Giant: It should be the strikethrough. Let me just double… Check.

481 00:48:06.330 ⇒ 00:48:08.389 Emily Giant: staging component, the…

482 00:48:12.330 ⇒ 00:48:13.919 Emily Giant: Oh, that’s still the new one.

483 00:48:15.260 ⇒ 00:48:21.460 Emily Giant: I have a lot of tabs open. I just need staging, line item components. Where are you?

484 00:48:25.280 ⇒ 00:48:27.530 Emily Giant: Here. I’ll pull that over here.

485 00:48:29.880 ⇒ 00:48:31.550 Emily Giant: So, old one…

486 00:48:33.850 ⇒ 00:48:35.659 Demilade Agboola: It pulls in both.

487 00:48:35.840 ⇒ 00:48:40.620 Emily Giant: models doing nothing, and then in the third CTE, it joins on

488 00:48:41.750 ⇒ 00:48:46.400 Emily Giant: line item base. Okay, that’s gotta be the problem, right? That it’s not doing that in the new one.

489 00:48:47.510 ⇒ 00:48:53.030 Emily Giant: It needs to be… From line item base. Not.

490 00:48:53.180 ⇒ 00:48:55.139 Emily Giant: from staging components.

491 00:48:55.370 ⇒ 00:48:56.410 Demilade Agboola: That’s what I’m saying.

492 00:48:56.410 ⇒ 00:48:57.460 Emily Giant: Yeah.

493 00:49:11.760 ⇒ 00:49:13.330 Emily Giant: Wait, was that the right one?

494 00:49:13.660 ⇒ 00:49:16.950 Emily Giant: Yes, it was. And then this one, it might be the same thing.

495 00:49:17.070 ⇒ 00:49:20.230 Emily Giant: Because that would make sense that nothing was coming through again.

496 00:49:21.340 ⇒ 00:49:23.160 Emily Giant: So, staging components…

497 00:49:23.990 ⇒ 00:49:32.920 Emily Giant: We’ve got the source components, we’ve got the line item base again, this time from the union, and we join on… bam, line item base, okay.

498 00:49:35.290 ⇒ 00:49:37.980 Emily Giant: That makes perfect sense.

499 00:49:53.460 ⇒ 00:49:54.230 Emily Giant: Alright.

500 00:50:04.830 ⇒ 00:50:06.680 Emily Giant: So, conflast Record.

501 00:50:08.640 ⇒ 00:50:11.760 Emily Giant: This is the partition, but component rank

502 00:50:12.070 ⇒ 00:50:14.120 Emily Giant: Is the pieces of the order.

503 00:50:17.980 ⇒ 00:50:19.240 Emily Giant: If that makes sense.

504 00:50:19.450 ⇒ 00:50:24.200 Demilade Agboola: Like, not every… not every order has… components, though.

505 00:50:24.880 ⇒ 00:50:28.200 Emily Giant: Right. So, their comp last rec… you… yeah.

506 00:50:28.880 ⇒ 00:50:35.370 Emily Giant: Not every order has components, correct. So it would just be Hivo Array Index 0, HEVO array index 1, 0.

507 00:50:35.840 ⇒ 00:50:43.650 Emily Giant: But what the partition in this does for the component rank, Ugh.

508 00:50:45.730 ⇒ 00:50:48.650 Emily Giant: Alright, first of all, let’s test our…

509 00:51:21.650 ⇒ 00:51:22.510 Emily Giant: No.

510 00:51:26.260 ⇒ 00:51:26.970 Emily Giant: How…

511 00:51:27.740 ⇒ 00:51:29.059 Demilade Agboola: Have you rerun it?

512 00:51:30.090 ⇒ 00:51:32.130 Emily Giant: I built it, but I didn’t run it.

513 00:51:32.580 ⇒ 00:51:34.350 Demilade Agboola: I mean, building should…

514 00:51:34.800 ⇒ 00:51:36.620 Emily Giant: do it. Yeah.

515 00:51:37.370 ⇒ 00:51:47.019 Emily Giant: I’m gonna… compile it. It might be because of the, eva ingested at.

516 00:51:49.050 ⇒ 00:51:55.679 Emily Giant: like, or the incrementality. Sometimes in staging, it will be like, no, this order’s too old.

517 00:51:55.880 ⇒ 00:51:57.819 Emily Giant: And it won’t pull it up for me.

518 00:51:59.770 ⇒ 00:52:00.630 Emily Giant: Some of these…

519 00:52:27.210 ⇒ 00:52:29.230 Emily Giant: Boo. Alright, let’s try compiling.

520 00:52:29.690 ⇒ 00:52:35.630 Emily Giant: We can at least break it apart and see, like, let’s… Happening.

521 00:52:35.800 ⇒ 00:52:39.000 Emily Giant: Oh, good, okay. Just the work component.

522 00:52:42.320 ⇒ 00:52:43.809 Demilade Agboola: I actually know it’s there.

523 00:52:45.580 ⇒ 00:52:46.205 Emily Giant: Mmm…

524 00:53:03.340 ⇒ 00:53:08.880 Emily Giant: oh, this is not the right CTE. What is… this is the… Not the right thing.

525 00:53:10.050 ⇒ 00:53:10.980 Emily Giant: There we go.

526 00:53:12.560 ⇒ 00:53:14.480 Emily Giant: Was I running the wrong one?

527 00:53:15.130 ⇒ 00:53:17.760 Demilade Agboola: Can we look at the history?

528 00:53:18.420 ⇒ 00:53:19.110 Emily Giant: Yeah.

529 00:53:21.050 ⇒ 00:53:24.700 Emily Giant: No, I was running the right… It definitely ran the wrong one.

530 00:53:25.410 ⇒ 00:53:26.740 Emily Giant: Last time.

531 00:53:27.240 ⇒ 00:53:28.940 Emily Giant: Okay, let me get this.

532 00:53:44.710 ⇒ 00:53:47.310 Emily Giant: We erased all of the this…

533 00:53:55.640 ⇒ 00:53:56.310 Emily Giant: Okay.

534 00:54:13.870 ⇒ 00:54:19.510 Emily Giant: Oh, this is, like… Not… sorry.

535 00:54:24.330 ⇒ 00:54:27.480 Emily Giant: I don’t know why it’s got so much junk in it. Hold on.

536 00:54:34.090 ⇒ 00:54:34.950 Emily Giant: Okay.

537 00:54:40.230 ⇒ 00:54:41.939 Demilade Agboola: Did you switch it to the analytics?

538 00:54:42.380 ⇒ 00:54:44.260 Demilade Agboola: Okay, the sixth version?

539 00:54:45.460 ⇒ 00:54:49.119 Emily Giant: No. This doesn’t exist in analytics.

540 00:54:50.750 ⇒ 00:54:56.150 Emily Giant: I also… is this even incremental? No, it’s a table, so it shouldn’t… it should not have…

541 00:54:56.340 ⇒ 00:54:58.980 Emily Giant: Obscured it in the first place, if it was there.

542 00:55:22.030 ⇒ 00:55:25.820 Emily Giant: It also doesn’t have the condition if you have split line items in this one.

543 00:55:28.090 ⇒ 00:55:29.790 Emily Giant: What the fuck?

544 00:55:44.690 ⇒ 00:55:46.050 Emily Giant: Wait, where’s the tops?

545 00:55:46.680 ⇒ 00:55:47.750 Emily Giant: Top, tap.

546 00:55:49.550 ⇒ 00:55:51.520 Emily Giant: No, that’s not where that goes.

547 00:55:53.910 ⇒ 00:55:54.740 Emily Giant: Yeah.

548 00:55:55.280 ⇒ 00:55:59.190 Emily Giant: So if I… comment this out.

549 00:55:59.840 ⇒ 00:56:01.189 Emily Giant: And run it.

550 00:56:10.310 ⇒ 00:56:11.659 Emily Giant: Fair enough.

551 00:56:32.930 ⇒ 00:56:36.779 Emily Giant: Because we know line item base pulls it. We’ve tested that.

552 00:56:37.430 ⇒ 00:56:38.180 Emily Giant: Okay.

553 00:56:38.350 ⇒ 00:56:41.040 Emily Giant: Voila. -Oh.

554 00:56:42.300 ⇒ 00:56:43.660 Demilade Agboola: So it’s no…

555 00:56:46.380 ⇒ 00:56:47.210 Emily Giant: That’s…

556 00:56:48.310 ⇒ 00:56:50.459 Demilade Agboola: Not what we’re partitioning on.

557 00:56:53.830 ⇒ 00:56:54.680 Demilade Agboola: Right?

558 00:56:54.900 ⇒ 00:57:00.550 Emily Giant: there’s… there’s no partition yet here, right? It’s a… oh, yeah, you’re right!

559 00:57:01.350 ⇒ 00:57:04.820 Emily Giant: Okay. Yup, yup, yup, yup, yup, yup, yup.

560 00:57:05.420 ⇒ 00:57:08.929 Emily Giant: So we gotta switch these. This can stay…

561 00:57:12.400 ⇒ 00:57:15.400 Emily Giant: C line item ID, C component ID.

562 00:57:16.130 ⇒ 00:57:17.679 Demilade Agboola: So I think we can add…

563 00:57:18.250 ⇒ 00:57:21.910 Demilade Agboola: One of that, or potentially be…

564 00:57:23.380 ⇒ 00:57:26.919 Demilade Agboola: Let me see, we have the suborder ID, order ID…

565 00:57:32.420 ⇒ 00:57:42.670 Demilade Agboola: But do we… so, like, this is line item based to this, and then… so we have heroef ID. Alright, can we add the, maybe line item ID, or…

566 00:57:45.670 ⇒ 00:57:47.979 Emily Giant: And I’m adding a coalesce there, too.

567 00:57:51.730 ⇒ 00:57:53.470 Emily Giant: Okay…

568 00:57:58.830 ⇒ 00:58:02.780 Emily Giant: So, add line item ID into this partition.

569 00:58:03.720 ⇒ 00:58:04.650 Demilade Agboola: Yeah.

570 00:58:16.750 ⇒ 00:58:21.809 Demilade Agboola: But is it not… but is this deleted, though? No, I think… wait, sorry, can you…

571 00:58:21.810 ⇒ 00:58:23.600 Emily Giant: Oh, oh, oh, -oh, yeah.

572 00:58:24.410 ⇒ 00:58:27.729 Emily Giant: I still think we want… don’t we still want that?

573 00:58:28.130 ⇒ 00:58:30.280 Demilade Agboola: No, no, yeah, so it’s still fine, because…

574 00:58:31.470 ⇒ 00:58:34.289 Emily Giant: Because it’s not… because there are deleted orders.

575 00:58:34.670 ⇒ 00:58:38.010 Emily Giant: But then, okay, there is no partition yet.

576 00:58:38.190 ⇒ 00:58:42.799 Emily Giant: Right? Do you… are you able to stay on for a little? Because I’ll tell…

577 00:58:43.020 ⇒ 00:58:47.879 Emily Giant: the team, I can’t make it to stand up, if you are, because I would love to figure this out.

578 00:58:49.100 ⇒ 00:58:56.130 Demilade Agboola: I will have to hop at… Half past.

579 00:58:56.620 ⇒ 00:59:03.420 Emily Giant: Okay. Let me just tell the team real quick that I… I’m not showing up today.

580 00:59:40.730 ⇒ 00:59:41.470 Emily Giant: Okay.

581 00:59:44.090 ⇒ 00:59:45.160 Emily Giant: So…

582 00:59:49.870 ⇒ 00:59:54.579 Emily Giant: Okay, also, this is a problem, because there won’t be a HEVO Ref ID if it’s not…

583 00:59:59.490 ⇒ 01:00:05.590 Demilade Agboola: Right, so can we go… so did… how many cities are there? There’s the… Strikethrough.

584 01:00:06.110 ⇒ 01:00:09.529 Demilade Agboola: There’s the strikethrough.

585 01:00:11.040 ⇒ 01:00:15.079 Emily Giant: There are 4 different… are you asking, like, which models are involved in this?

586 01:00:16.000 ⇒ 01:00:19.830 Demilade Agboola: Yeah, not the models per se, but more of the cities. I want to see where…

587 01:00:22.080 ⇒ 01:00:25.689 Demilade Agboola: Can we see… can I go to the book? Can we scroll down?

588 01:00:26.230 ⇒ 01:00:29.469 Demilade Agboola: Then the component from spilled and items.

589 01:00:29.990 ⇒ 01:00:35.940 Demilade Agboola: And then… And then we have the union.

590 01:00:35.940 ⇒ 01:00:37.919 Emily Giant: Yep, and then just the list.

591 01:00:38.840 ⇒ 01:00:47.679 Emily Giant: So, the biggest problem that I’m seeing at the current moment is that there is no coalesce on these, so if they’re blank.

592 01:00:47.860 ⇒ 01:00:53.270 Emily Giant: without a coalesced to Hero Ref ID, it’s… there’s nothing…

593 01:00:53.460 ⇒ 01:00:55.449 Emily Giant: To join it to in the model.

594 01:00:56.200 ⇒ 01:01:02.980 Emily Giant: And then these are blank, so they need to coalesce with zero, because they should… Never be blank.

595 01:01:06.930 ⇒ 01:01:07.760 Emily Giant: Yeah.

596 01:01:07.760 ⇒ 01:01:10.659 Demilade Agboola: Is this… is this a component suborder?

597 01:01:11.560 ⇒ 01:01:15.780 Emily Giant: It’s not. And that’s why L.LineItem ID does not exist.

598 01:01:16.950 ⇒ 01:01:19.109 Emily Giant: Okay. So many problems.

599 01:01:19.340 ⇒ 01:01:24.020 Emily Giant: So… I need 2…

600 01:01:24.440 ⇒ 01:01:33.199 Emily Giant: from the line item base, or the union, I don’t remember what line item ID is called. I feel like it’s called ID in that.

601 01:01:46.180 ⇒ 01:01:48.019 Emily Giant: Okay, ID, yeah.

602 01:02:00.190 ⇒ 01:02:03.510 Emily Giant: Mmm… Hold on.

603 01:02:07.290 ⇒ 01:02:11.169 Emily Giant: So, line item ID should be…

604 01:02:11.880 ⇒ 01:02:15.069 Emily Giant: Okay, there are just, like, essential things missing.

605 01:02:15.190 ⇒ 01:02:20.930 Emily Giant: From the union at this point, from the upstream models, and that is creating issues.

606 01:02:21.190 ⇒ 01:02:23.910 Emily Giant: Because this doesn’t have HEVO RefID.

607 01:02:24.410 ⇒ 01:02:30.860 Emily Giant: Or it has… yeah, it doesn’t have, the index arrays.

608 01:02:32.140 ⇒ 01:02:40.869 Emily Giant: which will be needed, and it doesn’t have the line item ID, which we can create very easily in this model, so that you don’t have to do it

609 01:02:41.680 ⇒ 01:02:49.340 Emily Giant: Well… essentially, we just need the HEVO array index, and we can fix the problem.

610 01:02:51.010 ⇒ 01:02:54.200 Demilade Agboola: So, what model is that in…

611 01:02:54.200 ⇒ 01:02:59.390 Emily Giant: It’s gonna be in… So this…

612 01:02:59.390 ⇒ 01:03:02.720 Demilade Agboola: Feeds only to this, this feeds to this.

613 01:03:03.310 ⇒ 01:03:06.200 Demilade Agboola: There’s also the line items.

614 01:03:07.030 ⇒ 01:03:12.490 Emily Giant: Yeah, so Ole Miss Line Items doesn’t go directly to it, I don’t think, does it? Yeah, it does.

615 01:03:12.920 ⇒ 01:03:20.340 Emily Giant: Okay. Wow! Sorry. So, order line items… HivoRay Index.

616 01:03:27.700 ⇒ 01:03:30.820 Emily Giant: That’s not even in the final CTE.

617 01:03:36.910 ⇒ 01:03:40.530 Emily Giant: Oh, why would… why? That’s a cursor.

618 01:03:43.500 ⇒ 01:03:46.470 Emily Giant: Okay, so it is in the final CTE, it’s just…

619 01:03:46.580 ⇒ 01:03:49.179 Emily Giant: They take away the two spaces before it. Great.

620 01:03:50.090 ⇒ 01:03:51.719 Emily Giant: That’s real fun.

621 01:03:54.040 ⇒ 01:03:57.280 Emily Giant: And then is it? Okay, so it is in that model.

622 01:03:59.670 ⇒ 01:04:00.780 Emily Giant: And then…

623 01:04:22.340 ⇒ 01:04:24.140 Emily Giant: It is in this one.

624 01:04:27.080 ⇒ 01:04:29.990 Emily Giant: So I should be able to just plunk it in.

625 01:04:59.400 ⇒ 01:05:00.470 Emily Giant: Oh…

626 01:05:43.280 ⇒ 01:05:45.230 Emily Giant: Ugh, it’s probably gonna tell me I can’t.

627 01:05:45.570 ⇒ 01:05:50.149 Emily Giant: do a union of different character types, because I didn’t cast this as an int.

628 01:05:51.220 ⇒ 01:05:52.120 Emily Giant: But…

629 01:06:17.050 ⇒ 01:06:20.830 Emily Giant: Okay, well, it didn’t tell me that, so… huzzah.

630 01:06:21.380 ⇒ 01:06:25.519 Emily Giant: Now we need to go to the one we were just in, and add it.

631 01:06:33.320 ⇒ 01:06:39.069 Emily Giant: And then it… It… line item ID is suborder ID…

632 01:07:05.910 ⇒ 01:07:10.950 Emily Giant: we don’t need this anymore, because we just carried it through, right? So…

633 01:08:49.819 ⇒ 01:08:53.670 Emily Giant: I probably have to… no, no, it’ll be fine if I just come… add it to mode.

634 01:09:05.310 ⇒ 01:09:10.219 Emily Giant: That’s why I always put the period there, it’s so easy to comment out when they’re all on the same line.

635 01:09:11.670 ⇒ 01:09:17.020 Emily Giant: Okay… But I commented out the wrong one, that being said.

636 01:09:18.260 ⇒ 01:09:19.000 Emily Giant: Okay.

637 01:09:22.990 ⇒ 01:09:26.340 Emily Giant: Oh, this is… Left joint… okay, no, it’s correct.

638 01:09:41.479 ⇒ 01:09:42.709 Emily Giant: But it does.

639 01:09:43.120 ⇒ 01:09:44.450 Emily Giant: It does exist.

640 01:09:53.250 ⇒ 01:09:54.440 Emily Giant: Where is it?

641 01:10:10.990 ⇒ 01:10:16.760 Emily Giant: Ugh, it’s incremental. So it’s… Ugh, I have to do a full refresh.

642 01:10:21.260 ⇒ 01:10:22.000 Emily Giant: Yeah.

643 01:10:22.960 ⇒ 01:10:23.750 Demilade Agboola: Yeah.

644 01:10:25.520 ⇒ 01:10:26.510 Demilade Agboola: We’ll refresh.

645 01:10:32.950 ⇒ 01:10:34.930 Demilade Agboola: What about the table it’s feeding from?

646 01:10:36.600 ⇒ 01:10:39.390 Demilade Agboola: So, by the way, I did the DVT exam last week.

647 01:10:39.780 ⇒ 01:10:41.379 Emily Giant: Oh, you did? How’d it go?

648 01:10:41.380 ⇒ 01:10:42.500 Demilade Agboola: Fantastic.

649 01:10:42.500 ⇒ 01:10:45.749 Emily Giant: Well, I figured, but was it hard?

650 01:10:47.030 ⇒ 01:10:50.640 Demilade Agboola: So, DPT exam is more tricky than hard.

651 01:10:51.500 ⇒ 01:11:00.309 Demilade Agboola: I mean, you do need to learn some of the commands and stuff that they would ask you questions about, but it’s more tricky than hard. It’s usually about, like, best-case scenarios and…

652 01:11:00.810 ⇒ 01:11:02.969 Demilade Agboola: Like, trying to figure out…

653 01:11:03.090 ⇒ 01:11:07.960 Demilade Agboola: what happens in this situation? If you use a, for instance, if you use a fail-fast command.

654 01:11:09.520 ⇒ 01:11:10.649 Demilade Agboola: if you,

655 01:11:10.800 ⇒ 01:11:19.830 Demilade Agboola: if this fails, which model? So if there’s a lineage and something fails, what will run. DBT retry does this,

656 01:11:22.080 ⇒ 01:11:26.559 Demilade Agboola: If you wanted to only run a model one layer upstream.

657 01:11:26.860 ⇒ 01:11:33.690 Demilade Agboola: the current model, how do you do that? Things like that. Which is a part of why I remembered it was because you could do that for this, by the way.

658 01:11:34.110 ⇒ 01:11:35.779 Emily Giant: How do you do it?

659 01:11:36.050 ⇒ 01:11:42.929 Demilade Agboola: So you… you just basically put… so you know how normally if you want to run something upstream, you put the plus sign in front of the name of the model?

660 01:11:43.800 ⇒ 01:11:51.359 Demilade Agboola: Just put the number right in front of that, so if you want only one layer upstream of that model, you put one plus the model.

661 01:11:51.360 ⇒ 01:11:51.980 Emily Giant: Nice.

662 01:11:51.980 ⇒ 01:11:53.810 Demilade Agboola: All together. Smushed together.

663 01:11:54.880 ⇒ 01:11:55.640 Demilade Agboola: Oh, no.

664 01:11:55.640 ⇒ 01:11:56.320 Emily Giant: Okay?

665 01:11:56.320 ⇒ 01:11:57.050 Demilade Agboola: Yeah.

666 01:11:57.830 ⇒ 01:12:05.860 Demilade Agboola: You could also do the reverse downstream, so if you don’t want to run, like, you know, one layer downstream of that model, it’s just plus one smushed together.

667 01:12:06.160 ⇒ 01:12:08.950 Demilade Agboola: Yeah.

668 01:12:09.160 ⇒ 01:12:11.590 Demilade Agboola: It’s just, like, it’s those sort of things, it’s…

669 01:12:11.590 ⇒ 01:12:13.290 Emily Giant: Yeah, that’s smart.

670 01:12:13.290 ⇒ 01:12:14.970 Demilade Agboola: 65 questions.

671 01:12:15.550 ⇒ 01:12:24.109 Demilade Agboola: And then stuff about, like, debugging, so if, XYZ, you got this XYZ failure, what would you do to fix the model?

672 01:12:26.960 ⇒ 01:12:32.299 Demilade Agboola: how would your YAML file look like in… if you’re trying to build out XYZ, XYZ? Like, it’s… it’s very…

673 01:12:34.280 ⇒ 01:12:36.190 Demilade Agboola: antibiotic details, that’s the best one.

674 01:12:36.190 ⇒ 01:12:36.910 Emily Giant: Hmm.

675 01:12:36.910 ⇒ 01:12:37.960 Demilade Agboola: For the details.

676 01:12:40.720 ⇒ 01:12:43.919 Emily Giant: Man, that’s… so it was only 65 questions?

677 01:12:43.920 ⇒ 01:12:44.440 Demilade Agboola: Yes, it’s…

678 01:12:44.440 ⇒ 01:12:47.259 Emily Giant: How long does it take to… to finish?

679 01:12:48.600 ⇒ 01:12:50.210 Demilade Agboola: So it’s a toy exam.

680 01:12:51.270 ⇒ 01:12:56.810 Demilade Agboola: I finished in… actually be fair, I was probably done in, like.

681 01:12:57.170 ⇒ 01:13:03.649 Demilade Agboola: So, the way I write my exams, especially for, like, multiple-choice questions, is I… Yeah.

682 01:13:04.730 ⇒ 01:13:07.610 Demilade Agboola: I’m a very, like, skip person, like, if I read.

683 01:13:07.610 ⇒ 01:13:08.080 Emily Giant: Me too.

684 01:13:08.080 ⇒ 01:13:12.450 Demilade Agboola: and I don’t get it, or, like, I don’t know the answer right off the bat, I skip, or flag it.

685 01:13:13.150 ⇒ 01:13:14.140 Demilade Agboola: Okay, Visa?

686 01:13:15.220 ⇒ 01:13:18.679 Demilade Agboola: So I usually do my first take of an exam really quickly.

687 01:13:19.270 ⇒ 01:13:27.299 Demilade Agboola: And then I spent my time, like, going through and trying to solve it better. I learned that when I was doing SATs.

688 01:13:28.100 ⇒ 01:13:36.660 Demilade Agboola: So, effectively, yeah, I think I finished the first round in, like, maybe… 30, 40 minutes?

689 01:13:37.850 ⇒ 01:13:41.830 Emily Giant: So all the ones you knew, you were like, bam-bam-bam-bam-bam-bam-bam, then went back and…

690 01:13:42.020 ⇒ 01:13:50.100 Demilade Agboola: Yeah, so the one… when I was finally done, I think I had, like, maybe… 20, 25 minutes left.

691 01:13:50.320 ⇒ 01:13:53.399 Demilade Agboola: So I took my time, I really took my time with the other ones I didn’t know.

692 01:13:53.400 ⇒ 01:13:54.020 Emily Giant: Yeah.

693 01:13:54.020 ⇒ 01:13:55.299 Demilade Agboola: Ultimately, like, okay.

694 01:13:57.050 ⇒ 01:14:11.669 Demilade Agboola: what, like, I would break down the question, try to remember stuff, and then finally pick my answer. That was one where, like, one question, the DAG wasn’t loading for me, so I, like, because sometimes they’ll ask you to show you a DAG and ask you if you were going to run this.

695 01:14:11.670 ⇒ 01:14:12.280 Emily Giant: Oof.

696 01:14:12.480 ⇒ 01:14:18.290 Demilade Agboola: Like, things like that. Like, again, like I said, it’s really about… The details, you know.

697 01:14:19.350 ⇒ 01:14:19.920 Demilade Agboola: Yeah.

698 01:14:20.330 ⇒ 01:14:28.860 Emily Giant: I really… I do want to take that test, but it would take some serious studying up for me, because I’m such a, like, self-taught, and have never gone through any kind of, like.

699 01:14:29.390 ⇒ 01:14:36.610 Emily Giant: I mean, you’ve been my teacher, but, like, you’re… The only one.

700 01:14:37.030 ⇒ 01:14:43.560 Emily Giant: Steven showed me 3 hours of DBT and was like, good luck, before he quit. I was like, okay.

701 01:14:43.680 ⇒ 01:14:50.209 Emily Giant: so most of it I’ve just figured out from, like, reading online, but I would love to have a more formal understanding.

702 01:14:51.240 ⇒ 01:14:54.650 Emily Giant: Yeah, there’s a… there’s a syllabus for the… for the exam.

703 01:14:56.020 ⇒ 01:14:57.050 Emily Giant: Is it online?

704 01:14:57.230 ⇒ 01:15:01.020 Demilade Agboola: This is still the story. Let me see if I can quickly find it.

705 01:15:03.400 ⇒ 01:15:09.840 Demilade Agboola: So, boss, I’m like a study guide, releasing analytics, engineering, certification, Study.

706 01:15:10.080 ⇒ 01:15:10.949 Demilade Agboola: Got it.

707 01:15:12.680 ⇒ 01:15:18.539 Demilade Agboola: To be fair, she… I actually started, like, reading, like, the day before.

708 01:15:18.540 ⇒ 01:15:30.499 Emily Giant: Oh my god. Well, you do do this, like, for hours a day, so… if anyone could kind of, like, just walk into it, you’re gonna be alright.

709 01:15:30.920 ⇒ 01:15:32.260 Demilade Agboola: Yeah, I think…

710 01:15:32.260 ⇒ 01:15:33.000 Emily Giant: No.

711 01:15:38.060 ⇒ 01:15:42.390 Demilade Agboola: First time I actually wrote the exam, I mean, it’s a kind of a funny story.

712 01:15:42.870 ⇒ 01:15:47.880 Demilade Agboola: So this is when I… so I moved to Malta in 2023.

713 01:15:48.700 ⇒ 01:15:49.330 Emily Giant: Huh?

714 01:15:49.770 ⇒ 01:15:53.300 Demilade Agboola: After I got my…

715 01:15:56.020 ⇒ 01:16:00.969 Demilade Agboola: Okay, so I found it and shared it with you. So after I got my…

716 01:16:01.620 ⇒ 01:16:07.820 Demilade Agboola: I got here, like, 15 days after I moved here, I got, like, laid off, because I was working in another consulting company.

717 01:16:08.090 ⇒ 01:16:08.790 Emily Giant: Hmm.

718 01:16:08.790 ⇒ 01:16:09.850 Demilade Agboola: were really bad.

719 01:16:11.380 ⇒ 01:16:17.200 Demilade Agboola: And because the thing with consulting is all of our clients coming in, and if they don’t have clients coming in, like, it’s… you know, people get, like…

720 01:16:18.050 ⇒ 01:16:20.659 Demilade Agboola: Okay. Talk about that, and so…

721 01:16:21.320 ⇒ 01:16:24.020 Demilade Agboola: I’m applying for jobs, because I’m like, alright, cool.

722 01:16:24.490 ⇒ 01:16:25.830 Demilade Agboola: And then…

723 01:16:26.220 ⇒ 01:16:32.020 Demilade Agboola: One job gave me the feedback of, like, it was an analytics engineering role or something, and was like.

724 01:16:32.750 ⇒ 01:16:36.790 Demilade Agboola: good experience, but not sure about, like, your DBT.

725 01:16:37.130 ⇒ 01:16:37.910 Emily Giant: Yeah.

726 01:16:37.910 ⇒ 01:16:44.349 Demilade Agboola: Something like that, and I’m like, I beg your pardon? And I literally, like, signed up for the nearest exam, like, it was probably, like…

727 01:16:44.350 ⇒ 01:16:45.010 Emily Giant: Good.

728 01:16:45.010 ⇒ 01:16:48.140 Demilade Agboola: After, and then I just received the next Thursday.

729 01:16:48.140 ⇒ 01:16:52.800 Emily Giant: Yeah, true Demade style. Like, don’t you dare.

730 01:16:53.990 ⇒ 01:16:56.100 Emily Giant: Don’t you tell me how I’d be.

731 01:16:56.310 ⇒ 01:16:59.289 Demilade Agboola: So that’s kind of how I wrote it for the very first time in 2023.

732 01:16:59.290 ⇒ 01:17:00.649 Emily Giant: Oh my gosh.

733 01:17:01.440 ⇒ 01:17:10.759 Emily Giant: Yeah, somebody telling me that they’re not sure about something is the most motivating thing that… Could possibly happen.

734 01:17:10.760 ⇒ 01:17:11.870 Demilade Agboola: Bear, let me…

735 01:17:12.120 ⇒ 01:17:13.749 Emily Giant: Compile this again.

736 01:17:14.500 ⇒ 01:17:16.120 Emily Giant: Wait, hold up.

737 01:17:17.490 ⇒ 01:17:25.729 Emily Giant: Kivo FID… oh, that’s funny. Look at this. There was no Kivo array index happening at all.

738 01:17:25.730 ⇒ 01:17:27.230 Demilade Agboola: Always drain off its rain.

739 01:17:27.230 ⇒ 01:17:27.889 Emily Giant: Yeah, yep.

740 01:17:28.150 ⇒ 01:17:29.010 Emily Giant: Okay.

741 01:17:31.040 ⇒ 01:17:36.970 Demilade Agboola: Are they both the same, minus two strings and, like, the two…

742 01:17:37.890 ⇒ 01:17:39.869 Demilade Agboola: Or just one of them?

743 01:17:43.880 ⇒ 01:17:47.600 Demilade Agboola: Because if you go back to the join, you’ll see that one has the double…

744 01:17:47.600 ⇒ 01:17:52.690 Emily Giant: Yeah, that’s why it was failing. It’s because this one doesn’t have it, and this one does.

745 01:17:53.310 ⇒ 01:18:03.309 Emily Giant: That was Cursor’s little treat for me, was changing the name of the Hivo Array Index and me not noticing. It does shit like that, it drives me crazy.

746 01:18:03.900 ⇒ 01:18:08.339 Emily Giant: I’m like, don’t take liberties. How can I program that into the rules?

747 01:18:08.460 ⇒ 01:18:18.199 Emily Giant: I added a couple rules, because it did the same things wrong, like, over and over. Like, it would be using timestamps, or, like.

748 01:18:18.350 ⇒ 01:18:36.650 Emily Giant: current date timestamp, or some kind of command that Redshift is not compatible with, and it would be, like, spinning its wheels on why a model wasn’t running, and I’m like, it’s… it’s the timestamp thing again. My god, it’s the timestamp thing. And so finally, I added it to the cursor rules of, like, use getDate instead of current timestamp.

749 01:18:36.700 ⇒ 01:18:39.289 Emily Giant: And it has saved me so much time.

750 01:18:39.810 ⇒ 01:18:40.590 Demilade Agboola: Yeah.

751 01:18:42.710 ⇒ 01:18:47.099 Emily Giant: Alright, big money, big money, big money. Come on! Pull a row!

752 01:18:47.950 ⇒ 01:18:51.370 Emily Giant: Although I’m not sure this is the model that would pull the row, so…

753 01:18:51.800 ⇒ 01:18:54.110 Emily Giant: I think it’s the CTE below.

754 01:19:01.240 ⇒ 01:19:04.400 Emily Giant: Oh my gosh! Yahtzee!

755 01:19:05.340 ⇒ 01:19:06.350 Emily Giant: I mean…

756 01:19:06.830 ⇒ 01:19:09.869 Demilade Agboola: It should have, like, 50 lines, but…

757 01:19:10.100 ⇒ 01:19:13.400 Emily Giant: That’s okay. Alright, that’s blank, and that’s okay.

758 01:19:13.780 ⇒ 01:19:17.250 Emily Giant: Because… It doesn’t have components.

759 01:19:18.040 ⇒ 01:19:19.800 Emily Giant: Although…

760 01:19:19.800 ⇒ 01:19:20.380 Demilade Agboola: How’s, like.

761 01:19:20.380 ⇒ 01:19:23.719 Emily Giant: I have, like, 12 lines to it, so…

762 01:19:24.430 ⇒ 01:19:31.950 Emily Giant: Let me erase this and fix… This one now… So, component source…

763 01:19:36.540 ⇒ 01:19:39.020 Emily Giant: I can just copy this.

764 01:19:39.330 ⇒ 01:19:41.690 Emily Giant: Instead of rewriting all of it…

765 01:19:44.710 ⇒ 01:19:49.570 Emily Giant: Although it’s the split line items now, instead of… L.

766 01:20:09.940 ⇒ 01:20:10.690 Emily Giant: Okay.

767 01:20:33.030 ⇒ 01:20:35.710 Emily Giant: That’s filled in, that’s filled in, that’s filled in.

768 01:20:36.120 ⇒ 01:20:38.670 Emily Giant: That’s… Filled in…

769 01:20:42.790 ⇒ 01:20:44.819 Emily Giant: This is not…

770 01:20:55.100 ⇒ 01:20:56.450 Emily Giant: ID?

771 01:21:01.950 ⇒ 01:21:05.579 Emily Giant: Oh, it’s from this one, sorry, I wasn’t understanding what I was looking at.

772 01:21:07.730 ⇒ 01:21:08.719 Demilade Agboola: They should have…

773 01:21:12.110 ⇒ 01:21:14.040 Demilade Agboola: Obviously, it’s 30…

774 01:21:26.210 ⇒ 01:21:32.109 Demilade Agboola: So is it… the reason why it’s only 1 is because of the final, like, complex record is equal to 1?

775 01:21:34.240 ⇒ 01:21:35.120 Demilade Agboola: Right?

776 01:21:37.510 ⇒ 01:21:39.619 Emily Giant: Let me run the entire thing.

777 01:21:39.750 ⇒ 01:21:42.260 Emily Giant: And see if… wait, what is going on here?

778 01:21:43.120 ⇒ 01:21:44.960 Demilade Agboola: Line 53.

779 01:21:49.590 ⇒ 01:21:51.240 Emily Giant: 153!

780 01:21:54.190 ⇒ 01:22:00.180 Emily Giant: Oh, 53! I was like… there… Oh…

781 01:22:04.830 ⇒ 01:22:07.369 Demilade Agboola: Oh, there’s a where called after…

782 01:22:11.090 ⇒ 01:22:15.600 Emily Giant: I mean… Okay.

783 01:22:18.590 ⇒ 01:22:22.309 Emily Giant: And then this doesn’t have the hu… and… anyway.

784 01:22:22.490 ⇒ 01:22:25.760 Emily Giant: I would think that this needs, like, HEVO split line items.

785 01:22:28.520 ⇒ 01:22:30.090 Emily Giant: Still the same error?

786 01:22:30.940 ⇒ 01:22:32.370 Demilade Agboola: Mister.

787 01:22:32.670 ⇒ 01:22:33.959 Demilade Agboola: Put a left drawing in.

788 01:22:33.960 ⇒ 01:22:35.260 Emily Giant: Oh, I see.

789 01:22:46.500 ⇒ 01:22:48.449 Emily Giant: I. Will. Scream.

790 01:22:48.940 ⇒ 01:22:51.290 Demilade Agboola: Where’s the… Thanks.

791 01:22:56.460 ⇒ 01:23:01.560 Emily Giant: dot tablebase, and L.TableBase… Oh.

792 01:23:02.570 ⇒ 01:23:03.619 Demilade Agboola: Yeah, you…

793 01:23:03.620 ⇒ 01:23:05.120 Emily Giant: I gotcha.

794 01:23:06.320 ⇒ 01:23:08.959 Emily Giant: I thought that that was a condition.

795 01:23:10.230 ⇒ 01:23:12.259 Emily Giant: Did it not say this before, though?

796 01:23:13.560 ⇒ 01:23:15.210 Demilade Agboola: I don’t see.

797 01:23:33.280 ⇒ 01:23:36.340 Emily Giant: I mean, I’m fully confident I’ll get that error again, but…

798 01:23:36.960 ⇒ 01:23:41.110 Demilade Agboola: My guess is… so can we see… What city is it?

799 01:23:41.280 ⇒ 01:23:41.890 Emily Giant: Oh.

800 01:23:42.180 ⇒ 01:23:42.840 Demilade Agboola: Yeah, because.

801 01:23:42.840 ⇒ 01:23:43.200 Emily Giant: Right here.

802 01:23:43.770 ⇒ 01:23:45.430 Demilade Agboola: I forgot what it’s gonna be.

803 01:24:01.120 ⇒ 01:24:07.280 Emily Giant: At least it’s a new error. Wait, okay, it does, though, split my HivoRef ID. Does not… oh.

804 01:24:08.390 ⇒ 01:24:09.450 Emily Giant: Hold up.

805 01:24:11.990 ⇒ 01:24:14.039 Emily Giant: Where’s that split line item?

806 01:24:17.740 ⇒ 01:24:19.359 Emily Giant: Oh, PKref.

807 01:24:19.830 ⇒ 01:24:21.150 Emily Giant: That’s what it’s called.

808 01:24:25.850 ⇒ 01:24:28.930 Emily Giant: Gosh, no wonder this didn’t work.

809 01:24:33.250 ⇒ 01:24:35.659 Emily Giant: Okay, I see what’s going on here.

810 01:24:36.990 ⇒ 01:24:43.170 Emily Giant: It’s… this, strikethrough base doesn’t have all of the… Things it needs.

811 01:24:43.440 ⇒ 01:24:46.200 Emily Giant: Is that open right now?

812 01:24:51.440 ⇒ 01:24:55.370 Emily Giant: This is what I’m telling you, like, I had Cursor do this model, and…

813 01:24:55.530 ⇒ 01:24:57.749 Emily Giant: It just didn’t add everything that…

814 01:24:58.030 ⇒ 01:24:59.400 Demilade Agboola: We heated.

815 01:24:59.480 ⇒ 01:25:05.959 Emily Giant: And then it’s screwing it up. So, I just need to create line item ID here. Order ID.

816 01:25:06.070 ⇒ 01:25:07.160 Emily Giant: Honey.

817 01:25:08.480 ⇒ 01:25:09.600 Emily Giant: Mmm…

818 01:25:39.690 ⇒ 01:25:43.720 Emily Giant: Oh, I have a meeting with Zach in 3 minutes, okay, fun.

819 01:25:44.850 ⇒ 01:25:46.940 Emily Giant: Didn’t realize.

820 01:26:25.330 ⇒ 01:26:27.980 Emily Giant: That is gonna work, it just needs to finish running.

821 01:26:50.210 ⇒ 01:26:52.389 Emily Giant: Alright, I do think that this is gonna fix…

822 01:26:52.970 ⇒ 01:26:57.300 Emily Giant: those errors. So, what I can do is, like, once the…

823 01:26:57.930 ⇒ 01:27:00.430 Emily Giant: new models running, I’ll go through and, like.

824 01:27:00.570 ⇒ 01:27:02.590 Emily Giant: Start working on all of these.

825 01:27:03.680 ⇒ 01:27:10.239 Emily Giant: the problems that we’re seeing, and even if I can’t solve them, I can at least, like, investigate why they’re happening.

826 01:27:11.080 ⇒ 01:27:12.109 Emily Giant: And… Okay.

827 01:27:12.790 ⇒ 01:27:18.999 Emily Giant: pose some answers, and I’ll just, like, huddle you later today, and… Give you updates.

828 01:27:20.840 ⇒ 01:27:29.790 Emily Giant: But that way. Question before we go. Were you able to add shipping costs to revenue in the new model yet?

829 01:27:30.820 ⇒ 01:27:32.559 Demilade Agboola: For the legacy part.

830 01:27:32.560 ⇒ 01:27:37.429 Emily Giant: No, for the… this will have shipping in it already, for the big part.

831 01:27:38.130 ⇒ 01:27:46.349 Demilade Agboola: Yeah, for the Shopify part, yeah, it’s there, so back to orders, though. So that’s where the… where all the revenue is.

832 01:27:46.730 ⇒ 01:27:53.099 Emily Giant: Gotcha, okay. And then, delivery date. That’s the one last thing.

833 01:27:55.140 ⇒ 01:27:57.510 Demilade Agboola: Okay, I’ll have to look into the…

834 01:27:58.140 ⇒ 01:28:01.510 Demilade Agboola: Shopify. There’s not, like, an obvious delivery date, but I’ll figure it out.

835 01:28:01.870 ⇒ 01:28:05.770 Emily Giant: Okay, I think you can extract it from…

836 01:28:05.770 ⇒ 01:28:06.750 Demilade Agboola: performance.

837 01:28:06.870 ⇒ 01:28:19.590 Emily Giant: one of the models, but if not, it is in the suborder, HEVO suborder. If we just use that, and, like, continue running that model for fewer columns, then…

838 01:28:19.760 ⇒ 01:28:23.390 Emily Giant: Hopefully that’ll…

839 01:28:23.750 ⇒ 01:28:28.180 Emily Giant: if we’re not able to find it in Shopify, we can just use that. It’s usually correct.

840 01:28:28.770 ⇒ 01:28:30.089 Demilade Agboola: Okay, sounds good.

841 01:28:30.490 ⇒ 01:28:36.320 Emily Giant: Alright, cool. Well, thank you, I’ll send you updates. This is what I’m working on today, so…

842 01:28:36.640 ⇒ 01:28:38.570 Emily Giant: Yeah, we’ll get this over the finish line.

843 01:28:39.860 ⇒ 01:28:41.519 Emily Giant: In some fashion.

844 01:28:42.480 ⇒ 01:28:43.600 Demilade Agboola: Sounds good.

845 01:28:43.600 ⇒ 01:28:45.080 Emily Giant: Alright, I’ll talk to you later.

846 01:28:45.290 ⇒ 01:28:45.910 Demilade Agboola: Weather.

847 01:28:46.130 ⇒ 01:28:46.810 Emily Giant: Bye.