Meeting Title: ABC Standup Date: 2025-07-23 Meeting participants: Mustafa Raja, luke, Amber Lin, Annie Yu
WEBVTT
1 00:01:44.210 ⇒ 00:01:45.380 Amber Lin: Hello!
2 00:01:45.540 ⇒ 00:01:46.240 Mustafa Raja: Hey!
3 00:01:47.470 ⇒ 00:01:49.380 Amber Lin: Like, are you back for a vacation.
4 00:01:51.128 ⇒ 00:01:54.240 luke: Hi, no, I’m quitting.
5 00:01:54.360 ⇒ 00:01:58.140 luke: I’ll be here for 3 weeks. Actually. So yeah.
6 00:01:58.140 ⇒ 00:02:00.010 Amber Lin: Oh, wow! Okay.
7 00:02:00.532 ⇒ 00:02:02.099 luke: Can be online.
8 00:02:02.810 ⇒ 00:02:04.130 Amber Lin: I see. Okay.
9 00:02:05.650 ⇒ 00:02:08.500 Amber Lin: Alright, let’s start.
10 00:02:09.269 ⇒ 00:02:12.429 luke: Here we go. How’s everything? So far as a station.
11 00:02:13.030 ⇒ 00:02:17.829 Amber Lin: I think it went really well a way stepped in to help, and
12 00:02:18.230 ⇒ 00:02:28.999 Amber Lin: like we’re finishing off the cycle. So we don’t have much left, and Mosava has been great. Casey’s also out. But we’re we were able to cover for him. So
13 00:02:29.240 ⇒ 00:02:30.539 Amber Lin: we’re doing pretty well.
14 00:02:32.080 ⇒ 00:02:33.550 luke: Let’s see the other side.
15 00:02:34.120 ⇒ 00:02:39.199 Amber Lin: Yeah, Annie’s not here yet. Let’s see.
16 00:02:39.530 ⇒ 00:02:47.359 Amber Lin: Yeah, I think because the wishes task is done, I think. Mostly hi, Annie
17 00:02:47.910 ⇒ 00:02:51.139 Amber Lin: Lucas back online. Very exciting.
18 00:02:52.860 ⇒ 00:02:54.460 Annie Yu: Nice hi.
19 00:02:56.010 ⇒ 00:02:58.119 Amber Lin: Yeah. And so I think
20 00:02:58.260 ⇒ 00:03:06.049 Amber Lin: I think for a wish to send all the transformations are done. So I think what we need.
21 00:03:06.260 ⇒ 00:03:12.580 Amber Lin: Luke on the data side is to set up Dvt, and then we’ll work on.
22 00:03:12.960 ⇒ 00:03:18.779 Amber Lin: maybe transferring the models to Dbt, though I do think this is a bit
23 00:03:19.060 ⇒ 00:03:23.100 Amber Lin: of a lower priority. But I’m just worried that things would break
24 00:03:23.290 ⇒ 00:03:25.450 Amber Lin: like, do you think it’s necessary.
25 00:03:27.298 ⇒ 00:03:34.980 luke: Yeah, I would agree. It’s a bit of a lower priority. I think you don’t even mentioned that last week as well.
26 00:03:35.610 ⇒ 00:03:43.010 luke: Just yeah. But we can definitely work on that. I did start working on that, although it’s still in progress.
27 00:03:43.855 ⇒ 00:03:44.210 Amber Lin: Okay.
28 00:03:44.210 ⇒ 00:03:55.120 luke: Yeah, I can. Yeah. For now, I think.
29 00:03:55.640 ⇒ 00:03:58.340 Amber Lin: We’re not using them.
30 00:03:58.340 ⇒ 00:04:14.760 Amber Lin: Okay? Sounds good. I think it’s just if we set up Dvt. If any needs any modeling help, it’ll be easier probably easier for you to help her instead of going into real and looking at the models. But I I’m not sure if that’s true.
31 00:04:15.630 ⇒ 00:04:17.050 luke: Yeah, that makes sense.
32 00:04:17.050 ⇒ 00:04:18.660 Annie Yu: Oh, okay.
33 00:04:19.062 ⇒ 00:04:29.919 Annie Yu: one update. I know that already did the transformation. But right now, when I open the source file in real, it’s giving me an error code.
34 00:04:31.556 ⇒ 00:04:36.189 Annie Yu: And not nothing has changed in terms of code on my end
35 00:04:36.530 ⇒ 00:04:41.549 Annie Yu: since like yesterday. So I’m not sure if there’s something.
36 00:04:42.830 ⇒ 00:04:47.419 luke: Is it just for a specific model, or is it for everything?
37 00:04:49.040 ⇒ 00:04:57.479 Annie Yu: It’s a model. Let me, yeah, I just can you see this?
38 00:04:57.740 ⇒ 00:05:00.500 Annie Yu: Yeah, yeah, yeah, I can share my screen, too.
39 00:05:00.500 ⇒ 00:05:01.050 Amber Lin: Hmm.
40 00:05:07.700 ⇒ 00:05:13.110 Annie Yu: Okay, so this is it.
41 00:05:14.740 ⇒ 00:05:18.550 Annie Yu: So this is the the new source that we switch to.
42 00:05:18.850 ⇒ 00:05:25.370 Annie Yu: But right right now I can’t read this, for I think this reason
43 00:05:36.270 ⇒ 00:05:37.349 Annie Yu: I believe this is.
44 00:05:37.350 ⇒ 00:05:41.480 luke: Failed to create table hold on a minute
45 00:05:44.680 ⇒ 00:05:46.700 luke: struct can only be renowned.
46 00:05:47.250 ⇒ 00:05:48.370 luke: No, don’t.
47 00:05:49.410 ⇒ 00:05:50.620 luke: Yeah. Some.
48 00:05:51.830 ⇒ 00:05:58.840 luke: I think we might need to create a staging model for that. Maybe there’s a field that’s not
49 00:05:59.360 ⇒ 00:06:03.920 luke: are getting the correct schema or something like.
50 00:06:04.660 ⇒ 00:06:07.579 luke: yeah. And it doesn’t even say which field it is.
51 00:06:08.740 ⇒ 00:06:13.390 luke: But yeah, we can. I can take a look at that once I get from.
52 00:06:14.430 ⇒ 00:06:19.850 Annie Yu: Yeah. Yeah. Because if I can’t use this, then we can’t do the join.
53 00:06:23.570 ⇒ 00:06:29.009 luke: Must make it voicious available to fix it as soon as possible.
54 00:06:29.310 ⇒ 00:06:32.220 luke: This is a list getting sleepy now.
55 00:06:33.290 ⇒ 00:06:35.569 luke: Okay, I can take a look at that as soon as I can.
56 00:06:36.470 ⇒ 00:06:42.139 Annie Yu: Okay, yeah, yeah. Cause before the transformation, we we can read this file here with no problem. So I think it’s
57 00:06:42.290 ⇒ 00:06:44.619 Annie Yu: after the transformation.
58 00:06:44.970 ⇒ 00:06:47.750 Annie Yu: And then something with the the value.
59 00:06:56.420 ⇒ 00:06:57.340 Annie Yu: Okay?
60 00:06:57.700 ⇒ 00:07:00.379 Annie Yu: So that’s yeah, there’s that. But
61 00:07:01.488 ⇒ 00:07:08.449 Annie Yu: yeah, I have to get that working before I can do for further things.
62 00:07:09.070 ⇒ 00:07:11.799 Amber Lin: I see. So I can.
63 00:07:13.092 ⇒ 00:07:14.449 Amber Lin: Sorry what? What?
64 00:07:14.660 ⇒ 00:07:17.859 Amber Lin: I’m gonna make a ticket. What would that be called.
65 00:07:22.340 ⇒ 00:07:24.589 Annie Yu: And is that for Luke, or or.
66 00:07:24.590 ⇒ 00:07:26.660 Amber Lin: Yeah, that’ll be sorry. That’ll be for Luke.
67 00:07:28.170 ⇒ 00:07:28.570 Annie Yu: Okay.
68 00:07:28.570 ⇒ 00:07:34.800 luke: Yeah, I might be able to work on that later this afternoon. Or maybe meeting shows.
69 00:07:35.390 ⇒ 00:07:41.079 luke: Yeah, if if it’s needed as soon as possible. Then maybe you can have always take a look at it.
70 00:07:42.840 ⇒ 00:07:47.780 luke: but if it can wait until tomorrow, then I can work on it later.
71 00:07:47.780 ⇒ 00:07:48.340 Amber Lin: I.
72 00:07:49.170 ⇒ 00:07:56.130 Amber Lin: We probably need as soon as possible, because I need Annie’s dashboard for Thursday.
73 00:07:57.530 ⇒ 00:08:00.720 Amber Lin: So let me go ask away
74 00:08:02.150 ⇒ 00:08:06.050 Amber Lin: What was the issue again, Annie. I just wanted to write it down.
75 00:08:06.270 ⇒ 00:08:09.880 Annie Yu: So it’s it’s for detail.
76 00:08:13.130 ⇒ 00:08:13.620 Annie Yu: It’s the.
77 00:08:13.620 ⇒ 00:08:17.939 luke: There’s also a screenshot in the chat. Maybe you can add that to the ticket as well.
78 00:08:18.930 ⇒ 00:08:19.770 Amber Lin: Okay.
79 00:08:20.310 ⇒ 00:08:21.980 Amber Lin: Yeah. Sounds good.
80 00:08:23.346 ⇒ 00:08:26.039 Annie Yu: It’s not. It’s not loading yet, and it’s
81 00:08:26.450 ⇒ 00:08:32.070 Annie Yu: I’ve only got this error code after the transformation. So before that.
82 00:08:32.070 ⇒ 00:08:34.396 Amber Lin: I see I see
83 00:08:36.460 ⇒ 00:08:41.229 Amber Lin: Would you mind tagging a wish and asking about this one.
84 00:08:41.860 ⇒ 00:08:42.280 Annie Yu: I.
85 00:08:42.289 ⇒ 00:08:43.079 Amber Lin: Made a ticket for.
86 00:08:43.645 ⇒ 00:08:45.905 Annie Yu: Just 8 min ago.
87 00:08:47.600 ⇒ 00:08:51.459 Annie Yu: but yeah, I I did share the screenshot, and then.
88 00:08:52.610 ⇒ 00:08:53.310 Amber Lin: Okay.
89 00:08:56.860 ⇒ 00:08:57.800 Annie Yu: Yeah.
90 00:08:58.330 ⇒ 00:08:59.600 Amber Lin: Sounds good.
91 00:09:00.280 ⇒ 00:09:04.270 Amber Lin: Okay.
92 00:09:10.310 ⇒ 00:09:11.990 Amber Lin: alright. Okay.
93 00:09:12.140 ⇒ 00:09:24.170 Amber Lin: I think that’s it for the data side. Let’s get this error done. And, Annie, I really want the dashboard for tomorrow, because the stakeholders been asking me.
94 00:09:25.080 ⇒ 00:09:40.929 Annie Yu: Yeah, we’ll we’ll see when I can get that field, though. I tried to join yesterday, but I realized with the participants. So the original format. In this report the participant was not was in the list, so I couldn’t use that to join either
95 00:09:42.590 ⇒ 00:09:43.340 Annie Yu: participant.
96 00:09:43.340 ⇒ 00:09:45.050 Amber Lin: Where it’s not on the.
97 00:09:45.050 ⇒ 00:09:45.500 Annie Yu: No, it.
98 00:09:45.500 ⇒ 00:09:45.880 Amber Lin: What is.
99 00:09:45.880 ⇒ 00:09:58.340 Annie Yu: It was in a list format. So the transformation. So now it should be joinable. But then I can’t read that table, so there’s like nothing I can do.
100 00:09:58.630 ⇒ 00:09:59.590 Amber Lin: -
101 00:10:03.290 ⇒ 00:10:05.260 Amber Lin: yeah, okay. Sounds good.
102 00:10:07.710 ⇒ 00:10:09.720 Amber Lin: Me go check there.
103 00:10:11.320 ⇒ 00:10:14.390 Amber Lin: Sorry you sent a message.
104 00:10:14.840 ⇒ 00:10:16.810 Amber Lin: Where did you send the message?
105 00:10:17.718 ⇒ 00:10:20.411 Annie Yu: I tag you in the thread.
106 00:10:21.440 ⇒ 00:10:26.310 Amber Lin: Oh, hmm!
107 00:10:28.420 ⇒ 00:10:29.930 Amber Lin: I don’t see it.
108 00:10:34.000 ⇒ 00:10:35.360 Amber Lin: Oh, I see!
109 00:10:36.780 ⇒ 00:10:37.560 Amber Lin: See.
110 00:10:50.791 ⇒ 00:10:55.970 Annie Yu: Yeah, so that one will be urgent. But I’m gonna let you.
111 00:11:02.020 ⇒ 00:11:06.560 Annie Yu: No, no, no, yeah, I’ll let you. I’ll let you do your thing.
112 00:11:08.245 ⇒ 00:11:14.080 Amber Lin: Okay, because I I will have to rely on you guys to
113 00:11:14.607 ⇒ 00:11:20.722 Amber Lin: push this past because I have like, I have no breathing room between meetings today.
114 00:11:21.130 ⇒ 00:11:23.979 Annie Yu: Yeah. Can you let him know if this is urgent?
115 00:11:24.510 ⇒ 00:11:28.440 Amber Lin: Yes, yes, I I will do that.
116 00:11:28.840 ⇒ 00:11:31.330 Amber Lin: I’m doing that right now.
117 00:11:34.560 ⇒ 00:11:38.070 Amber Lin: Urgent requests.
118 00:11:38.290 ⇒ 00:11:39.889 Amber Lin: Exclamation, mark.
119 00:11:43.340 ⇒ 00:11:45.040 Amber Lin: okay. Sent.
120 00:11:47.620 ⇒ 00:11:48.620 Amber Lin: Okay.
121 00:11:49.540 ⇒ 00:11:57.900 Amber Lin: Alright. Update me on this, if you can. By the at the end of day, if anything happens.
122 00:11:58.110 ⇒ 00:12:03.050 Amber Lin: we’ll probably see it in the chat. But if there’s any updates, just add me in the channel.
123 00:12:03.050 ⇒ 00:12:03.640 Annie Yu: Okay.
124 00:12:03.740 ⇒ 00:12:04.280 Annie Yu: Yeah.
125 00:12:04.280 ⇒ 00:12:05.160 Amber Lin: All right.
126 00:12:05.370 ⇒ 00:12:07.600 Amber Lin: Okay.
127 00:12:08.180 ⇒ 00:12:17.209 Amber Lin: yeah, Luca, I think if you have, if you just have time, you can look at the Dbt stuff. I I do think it’s less of a higher priority.
128 00:12:18.460 ⇒ 00:12:23.836 Amber Lin: It’s probably medium and then low. Yeah, okay, okay.
129 00:12:26.030 ⇒ 00:12:32.450 Amber Lin: Luke and Annie feel free to hop off. I have 5 min left. I’ll talk with Mustafa about the other stuff.
130 00:12:33.170 ⇒ 00:12:34.619 Annie Yu: Okay. Thank you guys.
131 00:12:34.620 ⇒ 00:12:36.000 Amber Lin: Alright. Thank you.
132 00:12:39.106 ⇒ 00:12:41.880 Amber Lin: Can I? Can we close this one out.
133 00:12:42.370 ⇒ 00:12:43.540 Mustafa Raja: Hmm, yeah.
134 00:12:44.300 ⇒ 00:12:45.020 Amber Lin: Okay.
135 00:12:45.480 ⇒ 00:12:54.279 Amber Lin: sounds good. I haven’t tested it yet, but I trust you manual trigger. Oh, that’s also in review.
136 00:12:54.480 ⇒ 00:12:54.980 Mustafa Raja: Yeah.
137 00:12:54.980 ⇒ 00:12:56.380 Amber Lin: I test that one.
138 00:12:56.380 ⇒ 00:13:00.010 Mustafa Raja: Yeah, yeah, so I created a sheet for this.
139 00:13:00.010 ⇒ 00:13:00.400 Amber Lin: Hmm.
140 00:13:01.530 ⇒ 00:13:04.419 Mustafa Raja: I forgot. What’s the name of the sheet? Let me see. Actually.
141 00:13:13.080 ⇒ 00:13:17.960 Mustafa Raja: yeah, it’s named Trigger ag update. The sheet is named Trigger ag update
142 00:13:18.387 ⇒ 00:13:24.419 Mustafa Raja: and then there would be only one check box which we can turn on and off and that would trigger.
143 00:13:24.420 ⇒ 00:13:24.980 Amber Lin: Hmm.
144 00:13:24.980 ⇒ 00:13:32.540 Mustafa Raja: That and I and I’ve also worked on the what’s it called the features.
145 00:13:32.540 ⇒ 00:13:33.030 Amber Lin: The.
146 00:13:33.030 ⇒ 00:13:37.934 Mustafa Raja: Feature alert in slack when Google drive is listening is complete.
147 00:13:38.380 ⇒ 00:13:39.620 Amber Lin: What? Okay?
148 00:13:39.620 ⇒ 00:13:44.310 Mustafa Raja: Yeah, but that I realized it later that that was for the next cycle.
149 00:13:44.934 ⇒ 00:13:52.209 Amber Lin: It’s okay. It’s okay. This cycle is ending soon. So that would just means less work. Next cycle.
150 00:13:52.490 ⇒ 00:14:04.880 Mustafa Raja: Yeah, yeah, and hopefully, I’ll have the this. When’s your meeting with the stakeholders? When when are we going to present this mechanical test routing, test.
151 00:14:05.496 ⇒ 00:14:08.580 Amber Lin: That’s for next next Monday.
152 00:14:08.580 ⇒ 00:14:11.529 Mustafa Raja: Next Monday. Yeah, then I’ll have it done by Friday.
153 00:14:12.050 ⇒ 00:14:13.990 Amber Lin: Yeah, okay, sounds good.
154 00:14:15.195 ⇒ 00:14:18.480 Amber Lin: I don’t know when Casey’s back. I think if
155 00:14:18.750 ⇒ 00:14:26.340 Amber Lin: we’ll see how it goes, if he’s not back, we probably I might ask you to help connect one more spreadsheet to Nan.
156 00:14:26.881 ⇒ 00:14:33.879 Amber Lin: but I know you’re working on some stuff right now, so I’ll this is for internal testing.
157 00:14:36.640 ⇒ 00:14:40.549 Amber Lin: Let’s see, we have this one.
158 00:14:48.130 ⇒ 00:14:53.100 Amber Lin: Yeah, I’ll I’ll I’ll try to update that
159 00:14:54.991 ⇒ 00:14:57.880 Mustafa Raja: Did Casey tell us when when he’ll be back.
160 00:14:58.500 ⇒ 00:15:07.239 Amber Lin: I think, he said. He’ll be back by Wednesday or Thursday, but I am not sure when he will be back.
161 00:15:08.060 ⇒ 00:15:08.753 Mustafa Raja: On the
162 00:15:09.320 ⇒ 00:15:14.549 Amber Lin: Yeah, if he’s not back, I think by tomorrow I might ask you to help with.
163 00:15:15.210 ⇒ 00:15:15.570 Mustafa Raja: Yeah.
164 00:15:15.570 ⇒ 00:15:17.850 Amber Lin: What are you currently working on today.
165 00:15:19.060 ⇒ 00:15:32.019 Mustafa Raja: So I a few requests from few requests, from utam. Yeah, there’s 2 things. And then one more thing in internally.
166 00:15:33.020 ⇒ 00:15:34.040 Amber Lin: Hmm, okay.
167 00:15:34.260 ⇒ 00:15:35.080 Mustafa Raja: Oh!
168 00:15:35.930 ⇒ 00:15:38.550 Amber Lin: Can you help? Look at.
169 00:15:38.940 ⇒ 00:15:41.119 Mustafa Raja: Yeah. Yeah. If the switch.
170 00:15:42.670 ⇒ 00:15:43.140 Amber Lin: Okay.
171 00:15:43.930 ⇒ 00:15:54.489 Amber Lin: So if you’re in na, and you’ll see that we already connected to spreadsheets. So we already connected the inspector sheet. And then the technicians like the skills and zips
172 00:15:54.620 ⇒ 00:16:00.990 Amber Lin: sheet and then so let me share my whole screen.
173 00:16:02.110 ⇒ 00:16:06.869 Amber Lin: So here is, oh, I have to jump very soon.
174 00:16:07.530 ⇒ 00:16:14.780 Amber Lin: So there’s these 2 spreadsheets. So this is essentially, oh, ignore that one. So there’s ABC service areas.
175 00:16:15.510 ⇒ 00:16:41.770 Amber Lin: And this one. So that’s essentially does ABC service in this this zip code, for, say commercial pest, it says, no, this do they service for residential pests and termite? It says, no. So it’s essentially all the zip codes are the same from our inspector Sheet, because I copied it over from this. But this is what the yes and no means.
176 00:16:42.090 ⇒ 00:16:42.780 Mustafa Raja: Okay.
177 00:16:43.060 ⇒ 00:16:45.982 Amber Lin: Yeah, so essentially, just to connect that
178 00:16:46.400 ⇒ 00:16:48.610 Mustafa Raja: So we want to connect this with Andy, or something.
179 00:16:49.080 ⇒ 00:16:50.210 Amber Lin: Yeah, with. Andy.
180 00:16:50.950 ⇒ 00:16:55.219 Mustafa Raja: Okay, I’ll see. I’ll see the previous connection, how it’s done with Andy.
181 00:16:55.798 ⇒ 00:17:00.420 Mustafa Raja: When I’ll update this, I’ll I’ll also have to. I guess. Update the system prompt
182 00:17:00.580 ⇒ 00:17:02.230 Mustafa Raja: to have a user street.
183 00:17:02.850 ⇒ 00:17:04.470 Amber Lin: Yeah, sounds good. It’s.
184 00:17:04.893 ⇒ 00:17:05.740 Mustafa Raja: Any? Yeah.
185 00:17:06.220 ⇒ 00:17:07.089 Mustafa Raja: Yeah. Good evening.
186 00:17:07.099 ⇒ 00:17:13.419 Amber Lin: Service and zip code.
187 00:17:14.229 ⇒ 00:17:15.299 Amber Lin: Alright.
188 00:17:15.469 ⇒ 00:17:19.639 Amber Lin: Yeah, yeah, I guess that’s okay.
189 00:17:19.859 ⇒ 00:17:25.869 Amber Lin: Alright, thank you so much. I must run. Thank you so much for helping this team.
190 00:17:26.609 ⇒ 00:17:27.429 Mustafa Raja: Yeah.
191 00:17:28.069 ⇒ 00:17:28.729 Amber Lin: Yay. Okay.
192 00:17:28.730 ⇒ 00:17:29.780 Mustafa Raja: Yeah, thank you so much.
193 00:17:30.280 ⇒ 00:17:31.190 Amber Lin: Course. Talk to you soon.
194 00:17:31.190 ⇒ 00:17:32.129 Mustafa Raja: Am I? Yeah.
195 00:17:32.130 ⇒ 00:17:32.910 Amber Lin: Bye.