Meeting Title: US x BF | Sprint Kickoff Date: 2025-07-08 Meeting participants: Amber Lin, Emily Giant, Caio Velasco, Demilade Agboola
WEBVTT
1 00:00:57.050 ⇒ 00:00:57.980 Emily Giant: Hi.
2 00:00:58.580 ⇒ 00:01:00.579 Amber Lin: Hi, Emily! Sorry!
3 00:01:00.580 ⇒ 00:01:01.205 Emily Giant: Us.
4 00:01:02.623 ⇒ 00:01:05.673 Amber Lin: I was just awake.
5 00:01:06.700 ⇒ 00:01:11.149 Emily Giant: I feel so bad. I it’s just so early there. It’s absurd.
6 00:01:11.730 ⇒ 00:01:20.099 Amber Lin: It’s 7 30. It’s not that bad, I I think. When I 1st started working in Brain fridge, one of my meetings was at
7 00:01:20.810 ⇒ 00:01:21.910 Amber Lin: 6,
8 00:01:22.440 ⇒ 00:01:29.422 Amber Lin: and sometimes at 5 30. I don’t know why I booked it that early, because my some of my clients are in
9 00:01:30.210 ⇒ 00:01:39.096 Amber Lin: in CST so booked it so that it’s when they start. And now I’m like No. 7, 30 is very early.
10 00:01:39.520 ⇒ 00:01:54.890 Emily Giant: Like that was when Demo Ladi and I started working together like on a daily basis. We would do like in the afternoon, and then I was like, wait a minute. Is it like 11 o’clock at night there? And he was like, Yeah, and he’d been like playing football working out like it
11 00:01:55.460 ⇒ 00:02:02.680 Emily Giant: done. He was tired, I was like, why don’t we do the warning so that but sometimes it takes a minute to like
12 00:02:02.970 ⇒ 00:02:12.470 Emily Giant: get that familiarity and be like, we’re. We’re not doing this. We’re not ruining my life and your life to to like have convenient schedules. 6 too early.
13 00:02:13.840 ⇒ 00:02:18.400 Emily Giant: 7, 30 is crazy early. But does your day end early because you.
14 00:02:18.400 ⇒ 00:02:26.769 Amber Lin: Relatively, but because I work remote. I’m trying to end it early, but sometimes is a little bit hard.
15 00:02:27.540 ⇒ 00:02:34.450 Emily Giant: Yeah, especially in the field that you work in never ends.
16 00:02:39.750 ⇒ 00:02:45.619 Amber Lin: And sorry, Kyle Donald, I slept over. I thought it was 7 30.
17 00:02:47.230 ⇒ 00:02:48.389 Caio Velasco: No worries, no worries. See you.
18 00:02:48.390 ⇒ 00:02:50.450 Demilade Agboola: No worries. I forgot that happened.
19 00:02:51.252 ⇒ 00:02:57.908 Amber Lin: Can some. Can we update these? Take 2 min close out any tickets?
20 00:02:59.220 ⇒ 00:03:01.809 Amber Lin: so we can look at the new schedule.
21 00:03:27.240 ⇒ 00:03:35.459 Amber Lin: Okay, does all of the stuff here in inventory need to be pushed to the next cycle.
22 00:03:41.004 ⇒ 00:03:47.929 Demilade Agboola: Yes, but most of them are not heavy apart from like 1, 3, 5.
23 00:03:49.190 ⇒ 00:03:53.351 Demilade Agboola: 1, 6, 7 is kind of like continuous low priority, continuous.
24 00:04:03.310 ⇒ 00:04:05.500 Demilade Agboola: and then 1, 6, 9 is best done.
25 00:04:05.650 ⇒ 00:04:11.629 Demilade Agboola: You put, and 1, 6 9 is best done like once everything else is done.
26 00:04:11.630 ⇒ 00:04:13.620 Amber Lin: Okay.
27 00:04:16.730 ⇒ 00:04:23.489 Amber Lin: okay, can you look here in inventory and tell me, what we should put into this cycle.
28 00:04:29.550 ⇒ 00:04:31.950 Demilade Agboola: What we should put into
29 00:04:37.220 ⇒ 00:04:41.150 Demilade Agboola: 1, 6, 6, we should definitely put 1, 6, 6 into this icon.
30 00:04:43.511 ⇒ 00:04:48.470 Demilade Agboola: And 1, 8, 6, 1, 8, 6, and 1, 8, 7 kind of go hand in hand.
31 00:04:56.620 ⇒ 00:05:01.910 Demilade Agboola: So the idea is we need to get people using the dashboard and show them what’s happening.
32 00:05:02.650 ⇒ 00:05:12.040 Demilade Agboola: And then 1, 6, 6 is, there are some supporters without lot assignments. So we want to be able to aggregate those like from an inventory perspective. But yeah.
33 00:05:14.460 ⇒ 00:05:19.890 Amber Lin: Okay, are we going to do any code cleanups, any of these.
34 00:05:20.560 ⇒ 00:05:21.260 Demilade Agboola: Okay?
35 00:05:22.542 ⇒ 00:05:26.349 Demilade Agboola: Yeah, we’re doing 1, 3, 5, 1, 3, 5 is the non floral part.
36 00:05:27.087 ⇒ 00:05:37.409 Demilade Agboola: So that’s that 1, 6, 9 begins like kind of once we’re done.
37 00:05:38.201 ⇒ 00:05:46.068 Demilade Agboola: I I don’t think they’re really dupes right now, but I think it’s more of like there’s some tests that failing like available for sale. That fail.
38 00:05:46.470 ⇒ 00:05:50.780 Demilade Agboola: but yeah, it’s just cleaning up the final table and just ensuring that
39 00:05:51.360 ⇒ 00:05:53.319 Demilade Agboola: the numbers are as they should be.
40 00:05:55.350 ⇒ 00:06:00.709 Demilade Agboola: Which kind of wipes it up that would probably come after once everything is done when we’re like, okay. So.
41 00:06:01.650 ⇒ 00:06:06.410 Demilade Agboola: Of our numbers. Just want to be sure that the numbers like the test for the numbers work properly.
42 00:06:06.770 ⇒ 00:06:07.729 Amber Lin: I see it.
43 00:06:09.690 ⇒ 00:06:13.260 Amber Lin: So cool edit.
44 00:06:17.390 ⇒ 00:06:19.410 Amber Lin: Oh, oops!
45 00:06:26.360 ⇒ 00:06:35.539 Amber Lin: How are we going to complete these? Then it’s just a lot. It’s just a lot left? When are we gonna complete them?
46 00:06:40.770 ⇒ 00:06:48.009 Demilade Agboola: So some of these are one slash, 2 points that can be done quickly.
47 00:06:49.480 ⇒ 00:06:56.619 Demilade Agboola: So like, for instance, Meta, plane 98 is blocked because we’re still not. We’re still figuring out the Meta plane aspect of it.
48 00:06:57.080 ⇒ 00:07:02.980 Demilade Agboola: 98, 75 is currently
49 00:07:03.480 ⇒ 00:07:07.619 Demilade Agboola: ongoing. It’s part of what we’re working on
50 00:07:07.940 ⇒ 00:07:15.080 Demilade Agboola: in the sense of, like the way the models are being built. Some of the logic is being moved from higher level back into intermediate models
51 00:07:15.240 ⇒ 00:07:21.509 Demilade Agboola: so that might not stream its own standalone task per se. It’s just kind of happening with the other tasks.
52 00:07:24.310 ⇒ 00:07:25.500 Demilade Agboola: Yeah, we’ll.
53 00:07:32.690 ⇒ 00:07:33.500 Demilade Agboola: I’m
54 00:07:39.980 ⇒ 00:07:44.289 Demilade Agboola: and then, yeah, so we do need to set aside time for documentation.
55 00:07:45.159 ⇒ 00:07:46.319 Demilade Agboola: And grocery.
56 00:07:47.725 ⇒ 00:07:56.190 Demilade Agboola: I think I’ll take a 1st stop at that, like it’s even. It’s on the street like the time for it. But for the presentation on
57 00:07:56.310 ⇒ 00:07:58.930 Demilade Agboola: Thursday I will be putting together
58 00:07:59.080 ⇒ 00:08:05.640 Demilade Agboola: some documentation about it. But it’s not yet like the final final handover sort of documentation.
59 00:08:05.640 ⇒ 00:08:13.180 Amber Lin: I see cause. I was wondering, because we want to close out inventory this sprint cause. I don’t want
60 00:08:13.460 ⇒ 00:08:22.920 Amber Lin: inventory to go on forever. I was wondering if we only do these, how, if we are we going to need another sprint to close that inventory.
61 00:08:24.000 ⇒ 00:08:24.960 Demilade Agboola: I think
62 00:08:27.020 ⇒ 00:08:40.819 Demilade Agboola: the inventory will be a thing, but I don’t think it will be the main thing outside this sprint, in the sense of there might still be. Hey? We noticed that this is an edge case that we need to account for
63 00:08:40.929 ⇒ 00:08:53.199 Demilade Agboola: or Hey, you know, some of the data seems to be confusing some people, or Hey, we might need to like add a test here or something, but it wouldn’t be the main focus for the sprint I kind of, I think, like, after this sprint
64 00:08:53.850 ⇒ 00:09:02.470 Demilade Agboola: of all things being equal, the focus will be easily on revenue and then.
65 00:09:03.450 ⇒ 00:09:22.179 Demilade Agboola: like, yeah, so like it will be smaller things like, Hey, we can we standardize like for this? Can we do this? Can we add comments to this? But it wouldn’t necessarily be like a full on, like we’re trying to get inventory numbers out there, which is kind of what we’re doing and we’re testing and ensuring that, like the numbers, work for everybody.
66 00:09:22.950 ⇒ 00:09:32.559 Amber Lin: Okay? Let’s come back to inventory because I I just want to have some documentation ready so that
67 00:09:32.830 ⇒ 00:09:38.409 Amber Lin: you’re when we’re when you’re working on revenue. You don’t have to come back to think about inventory again.
68 00:09:38.530 ⇒ 00:09:44.529 Amber Lin: But let’s go look at revenue and see what see what we can do.
69 00:09:45.890 ⇒ 00:09:46.600 Demilade Agboola: Okay.
70 00:09:48.850 ⇒ 00:09:54.130 Amber Lin: Can you guys also tell me what we should do this cycle for revenue?
71 00:09:58.020 ⇒ 00:10:02.240 Demilade Agboola: I think the important thing is the scaffold. 1, 5, 6
72 00:10:02.762 ⇒ 00:10:09.410 Demilade Agboola: and I think that would trickle down into every every other thing like the 1, 4, 0, 1, 3, 3.
73 00:10:13.190 ⇒ 00:10:16.839 Amber Lin: Are we doing? 1, 3, 3, when we’re still auditing? Should that be later?
74 00:10:23.200 ⇒ 00:10:26.949 Emily Giant: So for part of the scaffold. I wanna
75 00:10:27.791 ⇒ 00:10:39.740 Emily Giant: I know I’ve like piped in with the like. Are we replacing tables with shopify as the source of truth. I feel like there does need to be like a definitive step about like what tables
76 00:10:40.120 ⇒ 00:10:53.469 Emily Giant: in redshift we’re going to change to. If we change to them, there are some source issues that you’re going to run into that logic cannot account for in the component level data.
77 00:10:54.630 ⇒ 00:11:00.680 Emily Giant: So we’re also gonna need to like, if shopify can’t
78 00:11:01.500 ⇒ 00:11:05.450 Emily Giant: make up the difference with what isn’t provided in the source
79 00:11:05.610 ⇒ 00:11:10.470 Emily Giant: tables that we’re using right now. We’re gonna have to collaborate with Dev to like.
80 00:11:11.700 ⇒ 00:11:15.740 Emily Giant: or or maybe that’s within the scope of what y’all can do.
81 00:11:16.344 ⇒ 00:11:20.189 Emily Giant: But we’re gonna have to like alter the source entirely.
82 00:11:20.630 ⇒ 00:11:27.249 Emily Giant: But that feels like it would come before scaffold like deciding whether or not we’re going to switch out the source table.
83 00:11:32.302 ⇒ 00:11:40.159 Amber Lin: Is there a ticket for that? How how would that look like in for this cycle?
84 00:11:42.380 ⇒ 00:11:43.470 Emily Giant: I would.
85 00:11:45.160 ⇒ 00:11:52.530 Demilade Agboola: But what about form part of the scaffold? Though, if we’re like, Hey, these are the sources. This is what fits this. This is what fits that this is the current.
86 00:11:52.530 ⇒ 00:11:52.940 Emily Giant: Hmm.
87 00:11:53.990 ⇒ 00:11:58.280 Demilade Agboola: And then we’re like, Okay, but these tables are
88 00:11:58.540 ⇒ 00:12:03.790 Demilade Agboola: unreliable and need to be changed and replaced like that’s still part of the scaffold.
89 00:12:03.790 ⇒ 00:12:10.920 Emily Giant: Yeah, that is just such like a monstrously huge ticket. And it only has 2 points.
90 00:12:11.020 ⇒ 00:12:13.800 Emily Giant: What’s what is the criteria for that?
91 00:12:14.630 ⇒ 00:12:18.940 Emily Giant: No, maybe that’s the pointing. That’s the something else.
92 00:12:19.910 ⇒ 00:12:24.390 Amber Lin: No, this is when the other, the other tickets, informs this one.
93 00:12:24.390 ⇒ 00:12:28.110 Emily Giant: Okay, that’s right. That’s right. Okay. I remember that now. Sorry.
94 00:12:30.870 ⇒ 00:12:34.330 Caio Velasco: So maybe what would help be in this part is that?
95 00:12:34.820 ⇒ 00:12:38.389 Caio Velasco: Well, yesterday, when I started looking at the
96 00:12:38.580 ⇒ 00:12:43.160 Caio Velasco: at a table tableau items, except and I
97 00:12:43.780 ⇒ 00:12:50.070 Caio Velasco: well, I was looking at it a lot of things looking at the lineage and then at the end. What I was trying to do
98 00:12:50.440 ⇒ 00:13:00.559 Caio Velasco: is go all the linears until the last one, which I think was the hevo Oms orders, which is in a schema yamu file.
99 00:13:00.720 ⇒ 00:13:05.399 Caio Velasco: And then I was like, okay. Now that I know more or less where orders is coming from.
100 00:13:05.520 ⇒ 00:13:31.090 Caio Velasco: like 6, 7, 8. Then I would try to understand, like, what is an order. Exactly. And how does that work so for me? Is this a scaffolding, or is this like a discovery? Maybe a ticket could cover this discovery part, and then the scaffold could be something more related to what we want to change, or what are we providing as a service in this? So this is something I’m still confused.
101 00:13:32.480 ⇒ 00:13:42.499 Demilade Agboola: So I I personally think of scaffolding as like this is what the current infrastructure is. This is what we need in terms of a revenue focus. So this is
102 00:13:42.952 ⇒ 00:13:54.250 Demilade Agboola: if we want to calculate order, total discount, total refund, total all that. This is how we’re going to calculate it from all the different tables, sources, all that stuff. So we have that flow.
103 00:13:54.650 ⇒ 00:14:08.379 Demilade Agboola: And then, obviously, once we bring that scaffold here, we can now say, Oh, but then, you know, going forward as we’re going to replace or create this flow like this like lineage, and how things should look.
104 00:14:08.500 ⇒ 00:14:11.709 Demilade Agboola: we can then say, but we’re going to change the source.
105 00:14:12.138 ⇒ 00:14:16.169 Demilade Agboola: This source is not the same source that’s going to be in the new infrastructure.
106 00:14:16.490 ⇒ 00:14:30.849 Demilade Agboola: but I don’t want us to get too caught up in like we’re changing things. I want us to know how things are now and then, when we look at things that will change that allows us to know where that label fits in and how that would work, and that allows us to build
107 00:14:31.878 ⇒ 00:14:34.880 Demilade Agboola: with a direction or sense of purpose.
108 00:14:39.740 ⇒ 00:14:48.589 Caio Velasco: Okay. So so part of what I’m doing is part of the beginning of what you’ve mentioned. So okay, so I’m I’m in the right direction. I think it’s still in the very beginning.
109 00:14:52.902 ⇒ 00:14:57.879 Amber Lin: Can. Can someone tell me what we’re putting into this cycle?
110 00:14:59.630 ⇒ 00:15:03.539 Amber Lin: Will we be able to get the auditing done in these 2 weeks?
111 00:15:05.391 ⇒ 00:15:10.850 Demilade Agboola: The scaffold. Yes, we should be able to, unless we run into any complications that aren’t unforeseen.
112 00:15:11.610 ⇒ 00:15:12.310 Amber Lin: Okay.
113 00:15:12.850 ⇒ 00:15:13.220 Caio Velasco: Yeah.
114 00:15:13.220 ⇒ 00:15:14.839 Amber Lin: Else will go in there.
115 00:15:18.860 ⇒ 00:15:25.669 Demilade Agboola: So think, think of like the scaffold as the parents of these other ones, the orders
116 00:15:26.110 ⇒ 00:15:29.800 Demilade Agboola: of the other audits. Trans. Yeah. So they kind of will.
117 00:15:32.560 ⇒ 00:15:36.410 Demilade Agboola: or at least at the very idea. We should have a good understanding of what’s going on.
118 00:15:36.900 ⇒ 00:15:47.547 Amber Lin: Okay? I guess we should also define what the outcomes of of these audits should be.
119 00:15:51.770 ⇒ 00:15:53.680 Caio Velasco: Yeah, freedom for the orders. One.
120 00:15:54.200 ⇒ 00:16:00.740 Caio Velasco: If what I’m doing is correct, then I would have the complete lineage of how would that order happen.
121 00:16:01.310 ⇒ 00:16:09.009 Caio Velasco: and then this would be true for everything else. So, for example, subscription will will be a part of the whole project where subscriptions are.
122 00:16:10.330 ⇒ 00:16:11.220 Caio Velasco: Puppy.
123 00:16:11.360 ⇒ 00:16:17.679 Caio Velasco: I wouldn’t be able also see the whole lineage of how is that affecting revenue, for example?
124 00:16:17.930 ⇒ 00:16:22.150 Caio Velasco: But I think, like a concrete deliverable?
125 00:16:23.650 ⇒ 00:16:33.900 Caio Velasco: I don’t even know it would be like sometime writing notion. There could be something on even Google Sheet like where each column would be part of the lineage.
126 00:16:34.250 ⇒ 00:16:42.850 Caio Velasco: something I would have to think I mean something concrete. But at the end of the day it’s understanding the lineage, how and how everything affects revenue.
127 00:16:44.860 ⇒ 00:16:45.600 Amber Lin: Okay.
128 00:16:46.958 ⇒ 00:16:52.929 Amber Lin: Let me put these into this current cycle.
129 00:16:55.780 ⇒ 00:17:02.252 Amber Lin: Team. Do we want to do anything here, or let’s look at Redshift.
130 00:17:03.110 ⇒ 00:17:07.910 Amber Lin: I know the I can do. The cost estimate is the
131 00:17:08.230 ⇒ 00:17:12.889 Amber Lin: is everything archived for now can we close this ticket?
132 00:17:14.270 ⇒ 00:17:22.829 Caio Velasco: Oh, I wish I was trying, and today I also send another message to them. And I did, because now one of the errors is gone. Finally.
133 00:17:23.681 ⇒ 00:17:26.090 Caio Velasco: and I had to rebuild everything.
134 00:17:26.300 ⇒ 00:17:33.969 Caio Velasco: I’m using a lot of store procedures in redshift, and I never use redshift before. So there are a lot of crazy errors that I don’t get it.
135 00:17:34.470 ⇒ 00:17:35.480 Caio Velasco: And
136 00:17:36.010 ⇒ 00:17:50.769 Caio Velasco: but then but now I think the United already tested for a few, I increased the limit to a hundred tables, and I think he will test again. And then, if he continues working, then I would increase to 2,000. See how long that takes, and hopefully
137 00:17:50.880 ⇒ 00:17:59.490 Caio Velasco: it. It can be done, because every time we increase there is like a different error that appears. Maybe the name of the table is too large, or I don’t even know.
138 00:17:59.600 ⇒ 00:18:01.240 Caio Velasco: So that’s why it stayed too long.
139 00:18:02.690 ⇒ 00:18:10.140 Amber Lin: Okay, I I don’t think we’re dropping any of the turned off tables this cycle right? We’re waiting for a bit.
140 00:18:11.280 ⇒ 00:18:15.820 Caio Velasco: Yeah, I think, for now the moving redshift is actually not moving.
141 00:18:15.950 ⇒ 00:18:21.389 Caio Velasco: It’s a copy from the same table. So then, after that, if we are.
142 00:18:22.810 ⇒ 00:18:23.630 Caio Velasco: If we
143 00:18:23.750 ⇒ 00:18:28.989 Caio Velasco: are sure that everything was moved correctly, then we could drop them as well would be the next step.
144 00:18:30.034 ⇒ 00:18:30.449 Caio Velasco: But.
145 00:18:30.450 ⇒ 00:18:34.750 Amber Lin: So will we do that this cycle, or next cycle.
146 00:18:36.260 ⇒ 00:18:40.170 Amber Lin: How soon after we move them are we dropping them.
147 00:18:41.445 ⇒ 00:18:46.670 Caio Velasco: It could be instantly dropping is easy. It’s just making like a script that will drop one by one.
148 00:18:47.040 ⇒ 00:18:49.630 Caio Velasco: That’s it. That I don’t think will be errors in that.
149 00:18:50.660 ⇒ 00:18:56.380 Amber Lin: Oh, sorry! I meant, as in how long are we waiting? Do we have to wait before we drop them?
150 00:18:56.970 ⇒ 00:18:59.710 Amber Lin: Are we waiting a week, 2 weeks.
151 00:19:00.230 ⇒ 00:19:02.869 Caio Velasco: After we drop them. I think we would wait.
152 00:19:03.080 ⇒ 00:19:05.789 Caio Velasco: I don’t know 2 weeks, or something like that, right
153 00:19:06.140 ⇒ 00:19:08.890 Caio Velasco: to see if someone is complaining or something happening.
154 00:19:09.210 ⇒ 00:19:18.915 Demilade Agboola: Yeah, I think we should just give about 2 weeks or a month, just enough time to see if the the there’s any impact on what currently is happening.
155 00:19:19.480 ⇒ 00:19:20.960 Amber Lin: And then.
156 00:19:23.980 ⇒ 00:19:28.310 Amber Lin: is there anything here that’s that we could
157 00:19:28.580 ⇒ 00:19:32.300 Amber Lin: that we want to add, say, one ticket, this cycle.
158 00:19:41.889 ⇒ 00:19:47.489 Demilade Agboola: Nothing that I don’t think anything that will
159 00:19:50.270 ⇒ 00:19:56.130 Demilade Agboola: cause. I think the current cycle will probably like this current cycle still has quite a bit of things. I’m not sure if we want to.
160 00:19:56.350 ⇒ 00:20:00.760 Amber Lin: Okay plus.
161 00:20:00.870 ⇒ 00:20:11.330 Amber Lin: Look at Looker Luger is more done than than the other ones, or reviewing that.
162 00:20:11.550 ⇒ 00:20:15.610 Amber Lin: do we still need to review it with stakeholders. I don’t think so.
163 00:20:16.580 ⇒ 00:20:18.199 Amber Lin: We’ve deprecated it.
164 00:20:18.840 ⇒ 00:20:27.310 Caio Velasco: Yeah. The only thing left are a few tables with check comments that I mentioned. It’s already filtered in the sheet. If you go there like just
165 00:20:27.770 ⇒ 00:20:28.450 Caio Velasco: 5.
166 00:20:28.660 ⇒ 00:20:30.300 Caio Velasco: That’s the wrong thing missing.
167 00:20:30.790 ⇒ 00:20:33.230 Amber Lin: Okay, so I’ll move this.
168 00:20:33.360 ⇒ 00:20:36.780 Amber Lin: I’ll just say it was previous cycle.
169 00:20:37.390 ⇒ 00:20:38.410 Amber Lin: Oh.
170 00:20:45.540 ⇒ 00:20:46.570 Amber Lin: okay.
171 00:20:49.250 ⇒ 00:20:59.229 Amber Lin: this I assume there’s not not anything here. We want to do this cycle? Are we going to do this? 1? 1, 60?
172 00:21:01.180 ⇒ 00:21:02.690 Amber Lin: Is that urgent.
173 00:21:04.615 ⇒ 00:21:10.019 Demilade Agboola: I don’t think it is. I would also have to look into that. I’m not sure about what the details of that ticket.
174 00:21:11.300 ⇒ 00:21:13.010 Emily Giant: No, that’s not urgent.
175 00:21:15.260 ⇒ 00:21:15.930 Amber Lin: Okay.
176 00:21:16.410 ⇒ 00:21:17.750 Demilade Agboola: So we’ll just.
177 00:21:17.970 ⇒ 00:21:19.630 Amber Lin: We’ll just finish up this.
178 00:21:25.400 ⇒ 00:21:31.339 Amber Lin: Kyle, is this close to finishing? I don’t want it to when I don’t want it to take up too much of your time.
179 00:21:33.960 ⇒ 00:21:35.329 Caio Velasco: So I think that well.
180 00:21:37.100 ⇒ 00:21:41.799 Caio Velasco: this would be after we that we move the the redshift tape. We will be like a
181 00:21:41.980 ⇒ 00:21:43.790 Caio Velasco: cherry on top. Let’s say
182 00:21:44.713 ⇒ 00:21:51.750 Caio Velasco: I don’t see that being super important, I mean after we, it’s good to keep it there, so that we don’t forget that we
183 00:21:52.210 ⇒ 00:22:01.320 Caio Velasco: deprecated some exports, there were not much, and maybe there’s a table, but that is not used, and that’s not been deprecated in the set of 2 thousands.
184 00:22:02.670 ⇒ 00:22:09.810 Caio Velasco: so yeah, it’s not affecting anything. It would be like, you know, you have 2,000, and this would be 2,010 or something like that.
185 00:22:09.810 ⇒ 00:22:27.470 Amber Lin: Should that be this cycle? Should we move into the cycle after? Are we like? I guess my question is, can we wrap up deprecation and call it done for now, like are we at that point where we can tell Zack and tell stakeholders say, Hey, deprecation is done for. Now
186 00:22:29.156 ⇒ 00:22:31.989 Amber Lin: looker. Wise, 95%.
187 00:22:32.824 ⇒ 00:22:41.520 Caio Velasco: This one would be the last 5% I would need to put hours in that in terms of taking hours off the other things.
188 00:22:42.850 ⇒ 00:22:48.290 Caio Velasco: or or minutes, I mean just trying to make a point alright, and
189 00:22:49.790 ⇒ 00:22:53.989 Caio Velasco: for deprecation in terms of redshift. Then we’re still running that script.
190 00:22:54.490 ⇒ 00:22:56.680 Caio Velasco: but that script is just for
191 00:22:57.020 ⇒ 00:23:04.020 Caio Velasco: tables that were not queried in redshift, so there would be just like a layer of deprecation. We would have the next one.
192 00:23:04.350 ⇒ 00:23:08.159 Caio Velasco: so I can red ship things. We’re still in the process.
193 00:23:08.660 ⇒ 00:23:09.190 Caio Velasco: I’m sorry.
194 00:23:09.190 ⇒ 00:23:10.350 Amber Lin: How far.
195 00:23:10.350 ⇒ 00:23:11.570 Caio Velasco: But in the in the cycle.
196 00:23:11.790 ⇒ 00:23:22.639 Amber Lin: I see. Okay. So for redshift, after we complete the say, 2,000 2,000 tables, how far are we percentage wise from being done?
197 00:23:25.040 ⇒ 00:23:28.129 Caio Velasco: Let’s say 50, because it’s 50% of the tables.
198 00:23:28.850 ⇒ 00:23:37.688 Amber Lin: Oh, dear, okay, I, I think I want to move this to redshift because it it’s also redshift tables.
199 00:23:38.260 ⇒ 00:23:50.857 Amber Lin: I think in terms of looker dashboard views and explores. We can call it done for deprecation. So I’m not gonna put anything in cycle there for now I want to give you space to work on revenue.
200 00:23:51.380 ⇒ 00:23:53.010 Amber Lin: I think redshift.
201 00:23:54.275 ⇒ 00:23:55.190 Amber Lin: Hmm!
202 00:23:56.060 ⇒ 00:24:10.909 Amber Lin: Let’s just finish the bulk of it, for now the other ones, we can do another round to come back to it, because redship doesn’t really have any direct revenue impact is more of indirect development time. So
203 00:24:11.150 ⇒ 00:24:17.371 Amber Lin: 2,000 tables is already gonna have a big impact, and then we’ll we’ll look at
204 00:24:18.110 ⇒ 00:24:22.260 Amber Lin: like, are, we say, use it? It was 50%.
205 00:24:22.440 ⇒ 00:24:28.020 Amber Lin: Do we have to also deprecate 2 2,000 more like, how do you think.
206 00:24:29.120 ⇒ 00:24:40.739 Caio Velasco: So not necessarily, I think, the only thing that was missing. We, this one, are the ones that are not present in the manifest dot Json, meaning it’s not being, let’s say, used by DVD.
207 00:24:41.559 ⇒ 00:24:47.010 Caio Velasco: And also was not used or queried or scanned by redshift at all.
208 00:24:47.260 ⇒ 00:24:52.870 Caio Velasco: So this is a bulk. It’s a good amount of tables, then the next would be
209 00:24:53.330 ⇒ 00:25:03.600 Caio Velasco: trying to get that accuracy into this, and see if there are very inaccurate tables point pointing through what? Through the work that Emily did.
210 00:25:04.320 ⇒ 00:25:09.490 Caio Velasco: That would be something could be, I don’t know. Like 500 more, I have no idea, but
211 00:25:09.910 ⇒ 00:25:13.059 Caio Velasco: of course it won’t be 2,000 more, because otherwise it would be everything.
212 00:25:13.500 ⇒ 00:25:22.760 Amber Lin: Okay, okay, sounds good. Let’s get the 2,000 out of the way. And then like.
213 00:25:23.970 ⇒ 00:25:28.340 Amber Lin: I think that 500 will be enough. I I think this one can be
214 00:25:29.740 ⇒ 00:25:31.969 Amber Lin: really later to do.
215 00:25:32.855 ⇒ 00:25:44.589 Amber Lin: I just wanna get the bulk done. I wanted to get it done last cycle, but I don’t think but I mean it’s in the current cycle now, so we’ll we’ll have to adjust around it.
216 00:25:44.840 ⇒ 00:25:47.700 Amber Lin: I’ll say status.
217 00:25:48.470 ⇒ 00:25:56.800 Amber Lin: I’ll move at remove. Oh, whoops, cycle.
218 00:26:00.960 ⇒ 00:26:07.560 Amber Lin: Okay, we have 5 min. Let’s go. I’m gonna check. If I put everything in cycle.
219 00:26:08.340 ⇒ 00:26:14.690 Amber Lin: Okay, current cycle.
220 00:26:15.650 ⇒ 00:26:16.660 Amber Lin: All right.
221 00:26:17.560 ⇒ 00:26:21.010 Amber Lin: Move. This was.
222 00:26:22.350 ⇒ 00:26:25.299 Amber Lin: So this was done.
223 00:26:29.780 ⇒ 00:26:35.380 Amber Lin: Redshift Dvt revenue. Okay?
224 00:26:36.220 ⇒ 00:26:43.109 Amber Lin: Oh, okay. Kyle has 21 points inventory.
225 00:26:43.560 ⇒ 00:26:47.020 Amber Lin: I’m gonna put these on.
226 00:26:47.530 ⇒ 00:26:48.740 Amber Lin: Come on day.
227 00:27:03.510 ⇒ 00:27:07.760 Amber Lin: And oh, okay.
228 00:27:11.590 ⇒ 00:27:13.369 Amber Lin: that’s a review.
229 00:27:14.023 ⇒ 00:27:20.800 Amber Lin: Is anyone, since it says, here it’s in review. Is anyone reviewing these 2.
230 00:27:21.240 ⇒ 00:27:21.940 Emily Giant: Yes.
231 00:27:27.815 ⇒ 00:27:38.049 Emily Giant: Okay, half. Yes, yes. I’m doing review with Felipe and Herman of the Afs scenarios.
232 00:27:38.220 ⇒ 00:27:38.835 Emily Giant: Currently.
233 00:27:40.046 ⇒ 00:27:47.443 Emily Giant: I also reviewed it with them a lot of today. And I just need to make a couple tweaks so that it makes more sense and is more useful. But
234 00:27:48.800 ⇒ 00:27:52.347 Emily Giant: that should be all but done.
235 00:27:53.840 ⇒ 00:28:00.015 Emily Giant: Also I reviewed it with the Dev team to make sure that so yes, that one but the polytomic Cron job.
236 00:28:00.820 ⇒ 00:28:05.420 Emily Giant: that’s when Utam says it’s done. I think it’s just done
237 00:28:08.170 ⇒ 00:28:09.260 Amber Lin: Oh, okay.
238 00:28:09.260 ⇒ 00:28:09.880 Emily Giant: Yeah.
239 00:28:10.210 ⇒ 00:28:17.569 Emily Giant: so I can follow up on that ticket and have him just mark it as as complete once he’s able to do it.
240 00:28:17.970 ⇒ 00:28:18.690 Amber Lin: Okay.
241 00:28:19.380 ⇒ 00:28:20.390 Emily Giant: Yeah, I’ll do that.
242 00:28:21.060 ⇒ 00:28:26.270 Amber Lin: I think he probably it’s in here. Okay?
243 00:28:26.540 ⇒ 00:28:32.629 Amber Lin: I mean, I think you guys would review it, that’s all. Would you have to do anything.
244 00:28:32.800 ⇒ 00:28:34.530 Emily Giant: I I’m gonna have.
245 00:28:35.100 ⇒ 00:28:36.400 Amber Lin: Whereas live already.
246 00:28:36.400 ⇒ 00:28:36.920 Emily Giant: Okay.
247 00:28:38.600 ⇒ 00:28:39.170 Amber Lin: Hmm.
248 00:28:39.702 ⇒ 00:28:45.500 Emily Giant: I’ll have Zack review it because it’s more of like a cost savings
249 00:28:45.820 ⇒ 00:28:50.447 Emily Giant: attempt that it is a like execution of schedule being.
250 00:28:52.940 ⇒ 00:28:56.280 Amber Lin: Okay, let me go.
251 00:28:57.050 ⇒ 00:28:59.790 Amber Lin: Let me go find it back. Let’s let’s.
252 00:28:59.790 ⇒ 00:29:00.190 Emily Giant: You guys.
253 00:29:00.190 ⇒ 00:29:01.700 Amber Lin: That group use it.
254 00:29:04.050 ⇒ 00:29:06.380 Amber Lin: Okay, projects
255 00:29:13.100 ⇒ 00:29:14.460 Amber Lin: go. 8.
256 00:29:15.726 ⇒ 00:29:18.260 Amber Lin: Emily, I’ll put it on.
257 00:29:18.920 ⇒ 00:29:21.507 Amber Lin: You say that sorry.
258 00:29:22.760 ⇒ 00:29:23.310 Emily Giant: Sounds good.
259 00:29:23.640 ⇒ 00:29:25.150 Amber Lin: Current cycle.
260 00:29:26.070 ⇒ 00:29:35.060 Amber Lin: Oh, I’ll say that review. But oh, whiz!
261 00:29:35.370 ⇒ 00:29:37.260 Amber Lin: Okay. Wednesday is tomorrow.
262 00:29:39.240 ⇒ 00:29:47.659 Amber Lin: so how should I give you due dates on these. What will be due this week, and what will be due next week?
263 00:29:52.060 ⇒ 00:29:54.310 Demilade Agboola: The stuff I’m currently working on.
264 00:29:54.550 ⇒ 00:29:59.240 Demilade Agboola: Let’s see. So we have
265 00:30:02.830 ⇒ 00:30:08.690 Demilade Agboola: on board eventually, stakeholders and inventory usage. Let’s start to date like this week.
266 00:30:08.890 ⇒ 00:30:09.365 Amber Lin: Okay.
267 00:30:11.640 ⇒ 00:30:16.524 Demilade Agboola: At least that that’s kind of ties to the call that we have on Thursday
268 00:30:17.000 ⇒ 00:30:18.990 Amber Lin: This was done last cycle. No.
269 00:30:20.260 ⇒ 00:30:23.839 Amber Lin: or these don’t I don’t. Did we get what we need.
270 00:30:26.240 ⇒ 00:30:29.200 Demilade Agboola: I think we haven’t still gotten the list.
271 00:30:29.200 ⇒ 00:30:31.152 Amber Lin: Okay, okay, that’s okay.
272 00:30:35.760 ⇒ 00:30:41.410 Amber Lin: So we probably need another meeting with inventory stakeholders. Specifically.
273 00:30:43.960 ⇒ 00:30:46.370 Demilade Agboola: No, no, I think Emily can help us gather the list.
274 00:30:46.370 ⇒ 00:30:52.549 Emily Giant: Yeah, okay, that yeah. Assign that to me. That’s no problem. I could.
275 00:30:53.590 ⇒ 00:30:55.480 Emily Giant: That’s a 1 pointer.
276 00:30:55.810 ⇒ 00:30:59.610 Amber Lin: Okay, yeah. As as long as Philippine knows what.
277 00:30:59.780 ⇒ 00:31:04.990 Amber Lin: no agrees with the list that we get. That’s like, that’s okay.
278 00:31:04.990 ⇒ 00:31:06.020 Emily Giant: Okay. Cool.
279 00:31:06.020 ⇒ 00:31:11.719 Amber Lin: Yeah, so I guess these are due out of this week.
280 00:31:12.620 ⇒ 00:31:15.560 Amber Lin: Anyone any of the these here.
281 00:31:19.790 ⇒ 00:31:22.499 Amber Lin: This is stomach and a cycle.
282 00:31:22.890 ⇒ 00:31:26.389 Amber Lin: Is it these ongoing ones.
283 00:31:26.730 ⇒ 00:31:28.270 Demilade Agboola: Yeah, yeah. And it’s like, one.
284 00:31:28.550 ⇒ 00:31:28.940 Amber Lin: Yeah.
285 00:31:28.940 ⇒ 00:31:35.090 Emily Giant: Do we need to add, like updating looker to for me as part of this cycle?
286 00:31:36.247 ⇒ 00:31:39.940 Demilade Agboola: Yeah, that would be helpful. Just so that we have something that.
287 00:31:41.040 ⇒ 00:31:47.970 Emily Giant: Because that’s how the stakeholders interact with it. Like, I think that will expedite. Qa.
288 00:31:48.540 ⇒ 00:31:51.730 Emily Giant: so yeah, update looker view for inventory mart.
289 00:31:52.330 ⇒ 00:31:59.889 Amber Lin: View? Or why should that be inventory under inventory or under looker.
290 00:32:02.460 ⇒ 00:32:03.250 Emily Giant: But.
291 00:32:03.250 ⇒ 00:32:11.800 Demilade Agboola: Technically both. Yeah, it’s an intersection. But it’s not just put on that inventory. Yeah, because we like our broad understanding of looker is the
292 00:32:13.443 ⇒ 00:32:17.750 Demilade Agboola: just like restructuring that.
293 00:32:18.340 ⇒ 00:32:21.270 Amber Lin: Okay, is this 1 point.
294 00:32:22.970 ⇒ 00:32:24.919 Emily Giant: Yeah. Oh, no, looker.
295 00:32:27.850 ⇒ 00:32:29.549 Emily Giant: I’ll 2 or 3.
296 00:32:31.280 ⇒ 00:32:32.580 Amber Lin: Sounds good.
297 00:32:34.630 ⇒ 00:32:39.319 Amber Lin: Is that this end of Oh, gosh! We have! We got to hop.
298 00:32:40.440 ⇒ 00:32:42.190 Amber Lin: Which one is end of this week.
299 00:32:43.340 ⇒ 00:32:45.610 Emily Giant: Both of those are fine for the end of this week.
300 00:32:45.610 ⇒ 00:32:46.480 Amber Lin: This one.
301 00:32:46.480 ⇒ 00:32:47.000 Emily Giant: Yeah.
302 00:32:47.350 ⇒ 00:32:52.589 Amber Lin: And that, or that there are 8, which one.
303 00:32:56.180 ⇒ 00:32:58.140 Amber Lin: this one, these 2.
304 00:32:59.160 ⇒ 00:33:00.370 Demilade Agboola: Yeah, yeah, that’s fine.
305 00:33:00.370 ⇒ 00:33:03.330 Amber Lin: Okay, I’ll I’ll say that.
306 00:33:06.430 ⇒ 00:33:08.130 Demilade Agboola: And those can be end of next week.
307 00:33:08.740 ⇒ 00:33:15.670 Amber Lin: Okay, sounds good. And I think for Kyle, this is already in progress.
308 00:33:17.720 ⇒ 00:33:20.670 Caio Velasco: Yes, know that. Yeah.
309 00:33:20.990 ⇒ 00:33:23.789 Amber Lin: Yeah, I’ll say this is end of oh.
310 00:33:24.010 ⇒ 00:33:26.559 Amber Lin: end of this week. Think scaffolding.
311 00:33:26.560 ⇒ 00:33:27.089 Caio Velasco: Feel free.
312 00:33:27.090 ⇒ 00:33:29.960 Amber Lin: Ideally and and the cycle
313 00:33:31.740 ⇒ 00:33:36.900 Caio Velasco: Which one or question before end of 25.
314 00:33:38.402 ⇒ 00:33:39.850 Amber Lin: That’s true. That’s true.
315 00:33:41.700 ⇒ 00:33:43.149 Amber Lin: And this is so cool.
316 00:33:45.000 ⇒ 00:33:51.980 Amber Lin: Oh, okay, so cost estimate.
317 00:33:52.140 ⇒ 00:33:53.090 Amber Lin: Okay.
318 00:33:53.310 ⇒ 00:34:00.650 Amber Lin: we will. I think I’ll just roughly put this at the end of this week. Transactions. I’ll put the other ones
319 00:34:02.000 ⇒ 00:34:04.380 Amber Lin: At the end of the cycle.
320 00:34:04.920 ⇒ 00:34:05.840 Amber Lin: Great.
321 00:34:06.130 ⇒ 00:34:06.490 Emily Giant: Cool.
322 00:34:07.450 ⇒ 00:34:12.000 Amber Lin: Awesome, finished in 30 min. Possible.
323 00:34:12.659 ⇒ 00:34:13.044 Caio Velasco: Bye.
324 00:34:15.949 ⇒ 00:34:16.919 Caio Velasco: Thank you. Thank you.
325 00:34:16.920 ⇒ 00:34:18.460 Demilade Agboola: Thanks everyone, bye.
326 00:34:18.469 ⇒ 00:34:18.829 Emily Giant: Okay.
327 00:34:18.830 ⇒ 00:34:19.230 Amber Lin: Bye.