Meeting Title: ABC Data Integration Working Session Date: 2025-12-18 Meeting participants: Casie Aviles, Mustafa Raja
WEBVTT
1 00:00:00.140 ⇒ 00:00:03.390 Mustafa Raja: They also have a concept of sales lead.
2 00:00:04.500 ⇒ 00:00:05.420 Casie Aviles: Yeah…
3 00:00:07.410 ⇒ 00:00:16.369 Mustafa Raja: But Amber just said, for sales, and you just, give any, any of the available, what’s it called, inspectors.
4 00:00:34.850 ⇒ 00:00:38.769 Mustafa Raja: Sorry, a comfort advisor is just an inspector, right?
5 00:00:40.250 ⇒ 00:00:45.959 Casie Aviles: Yes, I believe so. That should just be… I think I added that in the prompt as well.
6 00:00:46.950 ⇒ 00:00:52.879 Mustafa Raja: Okay, okay, yeah, for Comfort Advisor, it works, but this is for no assignments, you know?
7 00:00:53.290 ⇒ 00:00:59.380 Mustafa Raja: No sign on the table, so I’ll just verify if we are servicing… At all, or not?
8 00:01:02.460 ⇒ 00:01:03.570 Mustafa Raja: H1.
9 00:01:11.780 ⇒ 00:01:15.080 Mustafa Raja: Yep, looks like we are servicing Austin.
10 00:01:16.120 ⇒ 00:01:19.140 Mustafa Raja: But they have no assignments.
11 00:01:23.770 ⇒ 00:01:27.740 Mustafa Raja: Why didn’t we link, services with service here?
12 00:01:30.490 ⇒ 00:01:36.709 Casie Aviles: Let’s see… yeah, yeah, I think that’s, like, something I missed, probably.
13 00:01:36.710 ⇒ 00:01:38.390 Mustafa Raja: Okay, no touching.
14 00:01:38.880 ⇒ 00:01:40.329 Casie Aviles: That was… a lot of that was.
15 00:01:40.330 ⇒ 00:01:44.190 Mustafa Raja: It made me think that these might be two different things, you know?
16 00:01:45.660 ⇒ 00:01:46.540 Casie Aviles: Yeah, I think…
17 00:01:46.970 ⇒ 00:01:48.160 Mustafa Raja: Aren’t they?
18 00:01:49.610 ⇒ 00:01:51.379 Casie Aviles: No, no, I mean…
19 00:01:51.380 ⇒ 00:01:52.870 Mustafa Raja: Oh, it’s the same thing then, right?
20 00:01:53.180 ⇒ 00:01:53.760 Casie Aviles: Yeah.
21 00:01:53.760 ⇒ 00:02:00.839 Mustafa Raja: Are you confirming, because this is something that came into my mind yesterday, that it might just be two different things.
22 00:02:01.260 ⇒ 00:02:03.100 Mustafa Raja: And I’m gonna be looking at wrong.
23 00:02:04.390 ⇒ 00:02:05.530 Casie Aviles: That’s true.
24 00:02:06.010 ⇒ 00:02:09.289 Casie Aviles: Yeah, it’s the same one, it’s just…
25 00:02:12.120 ⇒ 00:02:19.960 Casie Aviles: I think the reason why I separated it is because there’s… for the service… services table.
26 00:02:21.060 ⇒ 00:02:28.320 Casie Aviles: it shows, like, the residential and commercial, but for service areas, it doesn’t show it, I think.
27 00:02:29.660 ⇒ 00:02:30.360 Mustafa Raja: Hmm.
28 00:02:35.280 ⇒ 00:02:36.589 Mustafa Raja: Yeah, it does not.
29 00:02:37.320 ⇒ 00:02:41.499 Mustafa Raja: I noticed that also that, the naming convention was a little different also.
30 00:03:10.860 ⇒ 00:03:13.080 Mustafa Raja: Yeah, same case here.
31 00:03:15.110 ⇒ 00:03:16.450 Mustafa Raja: We service…
32 00:03:34.560 ⇒ 00:03:40.090 Mustafa Raja: Now aeration, so let’s just quickly go through…
33 00:03:43.330 ⇒ 00:03:45.080 Mustafa Raja: Nation…
34 00:03:54.560 ⇒ 00:03:55.460 Mustafa Raja: Hmm.
35 00:03:55.670 ⇒ 00:03:56.780 Mustafa Raja: Mmm…
36 00:04:01.270 ⇒ 00:04:02.460 Mustafa Raja: Aviation?
37 00:04:04.990 ⇒ 00:04:05.930 Mustafa Raja: Okay.
38 00:04:10.610 ⇒ 00:04:15.970 Mustafa Raja: Would you know what aeration is called in service areas? Because this isn’t giving me anything.
39 00:04:18.089 ⇒ 00:04:20.929 Casie Aviles: Oh, I don’t think we have aeration in…
40 00:04:22.260 ⇒ 00:04:24.010 Mustafa Raja: But we have it in services.
41 00:04:26.150 ⇒ 00:04:29.329 Casie Aviles: Yeah, that’s true. That’s their data.
42 00:04:29.590 ⇒ 00:04:30.800 Casie Aviles: I don’t think that’s…
43 00:04:32.120 ⇒ 00:04:41.090 Casie Aviles: Yeah, it’s their data. I mean, they don’t have the same data there, right? It’s inconsistent, so I think that’s how they set it up.
44 00:04:41.620 ⇒ 00:04:45.099 Casie Aviles: We don’t really have much control over that.
45 00:04:46.920 ⇒ 00:04:48.579 Mustafa Raja: What should I know to do?
46 00:04:49.430 ⇒ 00:04:57.200 Casie Aviles: Yeah, let’s think. Yeah, they don’t have aeration in the service areas, but they have… they have it as a service.
47 00:04:58.320 ⇒ 00:05:00.969 Casie Aviles: In another spreadsheet.
48 00:05:01.150 ⇒ 00:05:04.440 Mustafa Raja: Okay, yeah, I understood that, okay.
49 00:05:05.290 ⇒ 00:05:08.619 Mustafa Raja: Yeah, I was confused for a bit, because…
50 00:05:09.090 ⇒ 00:05:12.330 Mustafa Raja: I thought this is slightly coupled or something.
51 00:05:14.640 ⇒ 00:05:19.179 Mustafa Raja: Shining service areas, and no assignments.
52 00:05:19.640 ⇒ 00:05:22.560 Mustafa Raja: Need… Nope.
53 00:05:30.140 ⇒ 00:05:35.089 Mustafa Raja: Yeah, and I think that me and Andy is hallucinating also, because, you know.
54 00:05:38.030 ⇒ 00:05:38.800 Casie Aviles: Hmm.
55 00:05:39.660 ⇒ 00:05:43.450 Mustafa Raja: For estimate, it’ll… Okay.
56 00:05:43.450 ⇒ 00:05:45.489 Casie Aviles: Oh, it returned technicians?
57 00:05:48.130 ⇒ 00:05:53.840 Mustafa Raja: Oh, yeah, yeah, for SMH, it returned inspected. Oh, sorry, no, the technicians, yeah.
58 00:05:56.150 ⇒ 00:05:56.679 Casie Aviles: I see.
59 00:05:56.680 ⇒ 00:06:01.349 Mustafa Raja: So, that is just a prompt update.
60 00:06:01.520 ⇒ 00:06:07.289 Mustafa Raja: I’ll also check if it does the same thing right now…
61 00:06:08.510 ⇒ 00:06:12.019 Mustafa Raja: Also, we added, execution ID.
62 00:06:12.140 ⇒ 00:06:18.849 Mustafa Raja: In… in Snowflake, so we should be able to, you know, pull up the execution.
63 00:06:19.150 ⇒ 00:06:20.970 Mustafa Raja: quite easily.
64 00:06:23.550 ⇒ 00:06:26.820 Casie Aviles: Oh, okay. Also, you mean in the logs?
65 00:06:27.380 ⇒ 00:06:29.730 Mustafa Raja: Yeah, I’m just going to add that in the…
66 00:06:32.140 ⇒ 00:06:34.479 Mustafa Raja: in the ABC Logs channel also.
67 00:06:45.570 ⇒ 00:06:46.290 Casie Aviles: Okay.
68 00:07:10.170 ⇒ 00:07:13.950 Mustafa Raja: Again, doesn’t do that anymore… What?
69 00:07:16.150 ⇒ 00:07:17.880 Mustafa Raja: Gave me an answer, though.
70 00:07:47.690 ⇒ 00:07:50.429 Mustafa Raja: Yeah, so now it works good.
71 00:08:25.480 ⇒ 00:08:27.680 Mustafa Raja: Yeah, it looks fun now.
72 00:08:30.900 ⇒ 00:08:33.189 Mustafa Raja: What kind of distinct…
73 00:08:44.890 ⇒ 00:08:47.049 Mustafa Raja: Log time and distance.
74 00:08:59.980 ⇒ 00:09:04.659 Mustafa Raja: Okay, I’m done with my P0s. So my takeaway is…
75 00:09:08.880 ⇒ 00:09:16.879 Mustafa Raja: Potential prompt update. So, when it finds nothing, it also looks into service areas to check if we serviced that.
76 00:09:19.390 ⇒ 00:09:33.080 Mustafa Raja: Or not, and then… we do have some missing assignments that we need to fill in. This is my takeaway, but we do need them to, you know, come back to us with proper assignments, so we could add that.
77 00:09:37.580 ⇒ 00:09:39.130 Casie Aviles: Yes, yes, exactly.
78 00:09:39.740 ⇒ 00:09:46.089 Mustafa Raja: I’m going to work on the prompt, so we do see that if we service it or not.
79 00:09:46.290 ⇒ 00:09:47.859 Mustafa Raja: It returns nothing.
80 00:09:57.450 ⇒ 00:10:01.399 Mustafa Raja: I’m going to work on it locally, so I do not mess that up.
81 00:10:42.900 ⇒ 00:10:44.860 Casie Aviles: Oh, so the prompt is in…
82 00:10:45.860 ⇒ 00:10:49.350 Casie Aviles: In the repository, right? It’s not… we’re not getting from Langfuse?
83 00:10:49.720 ⇒ 00:10:55.219 Mustafa Raja: We are getting it from Langfruit, I’m going to import it for… from there, for my testing only.
84 00:10:55.840 ⇒ 00:10:56.950 Casie Aviles: Oh, okay.
85 00:11:02.420 ⇒ 00:11:08.720 Mustafa Raja: Because I’ll have to push it every time, no? So I don’t want to… I don’t want to push it until it’s, you know…
86 00:11:10.300 ⇒ 00:11:11.719 Mustafa Raja: The best thing, you know?
87 00:11:15.640 ⇒ 00:11:25.449 Mustafa Raja: Because, weird thing is, we push it, and it’s the live one, and then they’re also using it, yeah?
88 00:11:26.560 ⇒ 00:11:29.500 Casie Aviles: Oh, I see, yeah, yeah, that makes sense.
89 00:11:42.040 ⇒ 00:11:45.160 Mustafa Raja: So, are you going to then, you know…
90 00:11:45.780 ⇒ 00:11:49.589 Mustafa Raja: Communicate with them, that we need assignments or something.
91 00:11:52.320 ⇒ 00:11:58.340 Casie Aviles: Yeah, I mean, we can… we can just… we… I think we can also… I can also send,
92 00:11:59.100 ⇒ 00:12:03.569 Casie Aviles: our… what do you call this? Our notes into the channel. So just…
93 00:12:04.830 ⇒ 00:12:06.930 Casie Aviles: I’m not sure if… who’s been…
94 00:12:08.120 ⇒ 00:12:10.939 Casie Aviles: Handling, like, the emails to the client.
95 00:12:10.940 ⇒ 00:12:12.340 Mustafa Raja: handling the mute.
96 00:12:13.450 ⇒ 00:12:17.240 Casie Aviles: Yeah, so that might be something Otong will ask, but…
97 00:12:18.160 ⇒ 00:12:20.250 Casie Aviles: Or, like, include in his update.
98 00:12:20.690 ⇒ 00:12:24.350 Casie Aviles: But I can also ask them, in Google Chat.
99 00:12:24.900 ⇒ 00:12:26.320 Casie Aviles: If they respond.
100 00:12:26.540 ⇒ 00:12:28.530 Casie Aviles: Yeah, that is if they respond.
101 00:12:28.830 ⇒ 00:12:29.740 Mustafa Raja: Okay.
102 00:12:29.740 ⇒ 00:12:30.980 Casie Aviles: But at least we ask.
103 00:16:03.010 ⇒ 00:16:06.369 Mustafa Raja: Have you… have you used the browser and cursor? It’s for good.
104 00:16:08.130 ⇒ 00:16:16.119 Casie Aviles: Oh, I think… I’ve tried it. You mean, like, being able to open links inside Corsa, right?
105 00:16:17.370 ⇒ 00:16:18.180 Mustafa Raja: Your dish.
106 00:16:19.700 ⇒ 00:16:24.769 Casie Aviles: Oh, yeah, yeah, yeah, I haven’t tried it a lot, but I’ve seen it, yeah.
107 00:16:25.630 ⇒ 00:16:27.680 Casie Aviles: It makes it easier, I guess.
108 00:16:29.720 ⇒ 00:16:34.319 Mustafa Raja: I mean, for platform, we cannot do it, because we’ll have to log in also, you know?
109 00:16:34.320 ⇒ 00:16:38.559 Casie Aviles: That’s true. So we still have to use the browser, a separate browser.
110 00:16:39.500 ⇒ 00:16:42.590 Mustafa Raja: But for stuff like this, it works very well.
111 00:16:44.450 ⇒ 00:16:45.140 Casie Aviles: Nice.
112 00:16:45.480 ⇒ 00:16:47.269 Mustafa Raja: I mean, we could,
113 00:16:47.980 ⇒ 00:16:53.450 Mustafa Raja: do a separate environment for dev to be able to use this, but that’s a long stretch.
114 00:16:53.620 ⇒ 00:16:54.600 Casie Aviles: That’s true.
115 00:44:44.740 ⇒ 00:44:51.019 Casie Aviles: Hey, Mustafa, I might have to jump, since I have another call around in 10 minutes.
116 00:44:51.740 ⇒ 00:44:52.930 Mustafa Raja: Yeah, okay, that’s fine.
117 00:44:53.780 ⇒ 00:45:00.099 Casie Aviles: Alright, let me know if you, if you want to hop on another call later, if still needed, but…
118 00:45:00.370 ⇒ 00:45:05.479 Casie Aviles: Yeah, I’ll hop off right now. Yeah, thank you very much for the time.
119 00:45:07.050 ⇒ 00:45:11.180 Mustafa Raja: I don’t know, nobody’s… Thank you for assisting, yeah.
120 00:45:11.540 ⇒ 00:45:18.890 Casie Aviles: Yep, thanks. I still have a couple… yeah, I still have a couple of fixes to do, but at least we’ve documented what
121 00:45:20.260 ⇒ 00:45:22.830 Casie Aviles: Some stuff in the notes already, so…
122 00:45:22.950 ⇒ 00:45:26.269 Casie Aviles: Yeah, I’ll send updates in the channel.
123 00:45:29.070 ⇒ 00:45:29.790 Mustafa Raja: Okay.
124 00:45:30.400 ⇒ 00:45:31.470 Casie Aviles: Alright, bye-bye.