Meeting Title: ABC Standup Date: 2025-09-10 Meeting participants: Casie Aviles, Mustafa Raja, Amber Lin, Samuel Roberts
WEBVTT
1 00:00:17.360 ⇒ 00:00:18.659 Mustafa Raja: Okay, Casey…
2 00:00:22.030 ⇒ 00:00:23.090 Casie Aviles: Hey, hey.
3 00:00:23.290 ⇒ 00:00:24.000 Mustafa Raja: How are you?
4 00:00:25.330 ⇒ 00:00:27.670 Casie Aviles: Yeah, doing good. Is it,
5 00:00:27.800 ⇒ 00:00:30.619 Casie Aviles: Is the weather finder in Pakistan?
6 00:00:30.860 ⇒ 00:00:38.959 Mustafa Raja: It’s okay, shit’s sometimes really bad. My internet has gone really bad because of the weather.
7 00:00:38.960 ⇒ 00:00:41.250 Casie Aviles: Oh, that sucks. Is it… is it rainy?
8 00:00:41.430 ⇒ 00:00:42.200 Mustafa Raja: Yeah.
9 00:00:42.660 ⇒ 00:00:44.370 Casie Aviles: Too much. Yeah.
10 00:00:46.100 ⇒ 00:00:49.560 Casie Aviles: And that… I think it’s around these times where
11 00:00:50.200 ⇒ 00:00:55.000 Casie Aviles: around this time of the year where it becomes rainy. Kind of same here, too.
12 00:00:55.640 ⇒ 00:01:04.480 Mustafa Raja: For us, it’s, it wasn’t like… it wasn’t this bad. It’s because of the climate change that it’s…
13 00:01:04.529 ⇒ 00:01:05.199 Casie Aviles: Yeah.
14 00:01:05.200 ⇒ 00:01:12.450 Mustafa Raja: It’s been… it’s been bad, pretty bad. Definitely. This year, yeah, it’s really bad.
15 00:01:13.850 ⇒ 00:01:14.830 Casie Aviles: But past…
16 00:01:14.830 ⇒ 00:01:15.600 Mustafa Raja: This wasn’.
17 00:01:15.600 ⇒ 00:01:16.879 Casie Aviles: Like this, yeah.
18 00:01:19.410 ⇒ 00:01:22.869 Casie Aviles: Alright, do you guys have, like, flood problems, too?
19 00:01:23.100 ⇒ 00:01:35.340 Mustafa Raja: Yeah, it’s so… it’s really only this year that it’s been this bad. And this is because of the climate change and the rains, they’re really not stopping.
20 00:01:36.280 ⇒ 00:01:43.149 Casie Aviles: That’s true. I mean, same here, like, we’ve had our floods get worse this year, too.
21 00:01:44.180 ⇒ 00:01:52.450 Casie Aviles: The problem is, it’s not just climate change, but it’s also, like, people are mad at the government, you know, for the corruption.
22 00:01:52.980 ⇒ 00:01:58.769 Mustafa Raja: Yeah, that’s… that’s one thing, too. That… that’s a problem over here, too.
23 00:01:58.770 ⇒ 00:02:02.170 Casie Aviles: Yeah, I think it’s a problem for a lot of countries.
24 00:02:02.180 ⇒ 00:02:02.990 Mustafa Raja: Yeah.
25 00:02:03.200 ⇒ 00:02:04.590 Mustafa Raja: Yeah, we have.
26 00:02:04.590 ⇒ 00:02:05.400 Amber Lin: Hello.
27 00:02:05.400 ⇒ 00:02:05.990 Mustafa Raja: Yeah.
28 00:02:06.610 ⇒ 00:02:08.500 Casie Aviles: Are we talking about the rain?
29 00:02:08.509 ⇒ 00:02:12.679 Mustafa Raja: Yeah… Really bad dreams.
30 00:02:13.490 ⇒ 00:02:19.850 Amber Lin: Yeah, I saw him. I saw… I was one… I was like, where’s the wave? And then I saw his icon, it was raining, I was like, oh…
31 00:02:20.320 ⇒ 00:02:22.440 Amber Lin: Nevermind.
32 00:02:22.810 ⇒ 00:02:23.620 Mustafa Raja: Yeah.
33 00:02:26.370 ⇒ 00:02:31.440 Amber Lin: It has not rained here in California for a very long time, so…
34 00:02:31.440 ⇒ 00:02:35.820 Casie Aviles: I have… typical Weathered there.
35 00:02:36.290 ⇒ 00:02:45.399 Amber Lin: It’s… it’s dry, and I think it’s about… let me see in Celsius, it’s about, like, 20 degrees…
36 00:02:45.540 ⇒ 00:02:51.219 Amber Lin: So, from 17 to 25, and it’s… it’s dry. It’s very dry.
37 00:02:51.370 ⇒ 00:02:52.510 Casie Aviles: Oh.
38 00:02:52.510 ⇒ 00:02:54.589 Mustafa Raja: It’s cold, though, right? 20…
39 00:02:54.590 ⇒ 00:02:55.230 Amber Lin: Thank you for me.
40 00:02:55.230 ⇒ 00:02:55.920 Mustafa Raja: Cool.
41 00:02:56.450 ⇒ 00:03:14.389 Amber Lin: Celsius, so I think it’s okay. It’s not cold, it’s just… it can’t get hot in the midday, but then it gets okay later at night. Because I’m used to the cold, because I was in Canada for a long time, so I’m okay with cold, but I can’t deal with the heat.
42 00:03:14.600 ⇒ 00:03:15.580 Mustafa Raja: Oh.
43 00:03:15.960 ⇒ 00:03:16.820 Amber Lin: Yeah.
44 00:03:17.730 ⇒ 00:03:21.649 Mustafa Raja: 20 is, like, a little on the colder side for me.
45 00:03:21.950 ⇒ 00:03:29.229 Mustafa Raja: Oh, really? What’s the usual, what’s the usual temperature? It’s about, 30 to 40.
46 00:03:30.410 ⇒ 00:03:33.239 Amber Lin: Oh, dear.
47 00:03:34.840 ⇒ 00:03:46.590 Mustafa Raja: As we go in the north, it drops. Yeah, as we go in the north of Pakistan, it drops. But, where I am from, it’s going to be about 30… from 30 to 40.
48 00:03:47.120 ⇒ 00:03:49.370 Amber Lin: Wow. Impressive.
49 00:03:50.940 ⇒ 00:03:54.759 Amber Lin: Anyways, questions here.
50 00:03:55.100 ⇒ 00:03:58.770 Amber Lin: On insomnia, are we close?
51 00:03:59.170 ⇒ 00:04:01.870 Amber Lin: with the bugs.
52 00:04:03.780 ⇒ 00:04:11.840 Casie Aviles: Oh, for… For Braze, there’s just, I’ll have to reach out to support. There’s just one…
53 00:04:12.900 ⇒ 00:04:15.880 Casie Aviles: thing that I have to work on there, because…
54 00:04:16.790 ⇒ 00:04:29.980 Casie Aviles: Yeah, that one, that particular comment, so I’ll reach out to Braze support, and then I’ll add the response here, but if there’s really no way, then I’ll close it out, because…
55 00:04:29.980 ⇒ 00:04:30.540 Amber Lin: Hmm.
56 00:04:30.540 ⇒ 00:04:31.500 Casie Aviles: Yeah. Okay.
57 00:04:31.840 ⇒ 00:04:35.440 Casie Aviles: That’s, I guess, the last resort, and then for DoorDash…
58 00:04:35.680 ⇒ 00:04:38.519 Casie Aviles: Yeah, that’s… that’s what I’ll have to work on today.
59 00:04:38.800 ⇒ 00:04:39.820 Amber Lin: Yeah, okay.
60 00:04:40.200 ⇒ 00:04:51.550 Amber Lin: And then, assemble in Google Sheets… We have that, so… Put that in review.
61 00:04:53.110 ⇒ 00:04:58.490 Amber Lin: Oh, I don’t think I pulled that… Ticket in.
62 00:05:01.490 ⇒ 00:05:09.439 Amber Lin: So… I think this… by the end of this week, we can do the spike from Google Sheets to SharePoint.
63 00:05:11.180 ⇒ 00:05:18.079 Casie Aviles: Yeah, I think this should be… yeah, this shouldn’t be too… too long. This shouldn’t take too long.
64 00:05:18.650 ⇒ 00:05:19.290 Amber Lin: Okay.
65 00:05:19.640 ⇒ 00:05:22.279 Amber Lin: So I’ll say 1 point, or 2 points?
66 00:05:22.770 ⇒ 00:05:24.440 Casie Aviles: Yeah, let’s do 1.4 now.
67 00:05:25.010 ⇒ 00:05:25.640 Amber Lin: Okay.
68 00:05:26.170 ⇒ 00:05:26.900 Samuel Roberts: Hey, sorry.
69 00:05:26.900 ⇒ 00:05:27.420 Amber Lin: Good.
70 00:05:27.650 ⇒ 00:05:28.630 Amber Lin: Hello!
71 00:05:29.300 ⇒ 00:05:32.289 Amber Lin: It’s mostly…
72 00:05:32.510 ⇒ 00:05:43.309 Amber Lin: We’re talking about installing our cookies, we’re fixing some bugs, and mostly, will spike on, how to take our Google Sheets to Shreveport this week.
73 00:05:43.410 ⇒ 00:05:47.490 Amber Lin: Because ultimately, the client looks at SharePoint and not Google Sheets.
74 00:05:47.950 ⇒ 00:05:52.400 Samuel Roberts: Cool. Also sent them an email yesterday…
75 00:05:52.710 ⇒ 00:05:57.099 Amber Lin: They have not replied, so that’s okay.
76 00:05:58.200 ⇒ 00:06:02.760 Amber Lin: Okay, on the So, just one more question about…
77 00:06:02.780 ⇒ 00:06:08.770 Casie Aviles: them about this client. If I have, like, any questions on the… Unlike the process…
78 00:06:09.300 ⇒ 00:06:13.970 Casie Aviles: Do we have, like, a contact with them already, like…
79 00:06:15.110 ⇒ 00:06:17.320 Casie Aviles: Just message someone directly from their team.
80 00:06:17.710 ⇒ 00:06:28.479 Amber Lin: I don’t think so, we probably still have to go through Robert. They gave us the email, so I have their email, so if it’s something that’s urgent, we’ll…
81 00:06:28.810 ⇒ 00:06:37.700 Amber Lin: We can email them, but… We’re still not added to Slack yet, I think Robert’s working on that.
82 00:06:38.320 ⇒ 00:06:40.989 Casie Aviles: Okay, okay, I’ll just send it in the channel, then.
83 00:06:40.990 ⇒ 00:06:42.460 Amber Lin: Yeah, yeah, sounds good.
84 00:06:43.650 ⇒ 00:06:46.990 Amber Lin: Alright, for ABC…
85 00:06:47.680 ⇒ 00:06:55.969 Amber Lin: I wrote down a few thoughts I had for ABC. So, trans… on transcripts, how did that go, Sam?
86 00:06:59.990 ⇒ 00:07:05.520 Samuel Roberts: Started talking, I was on mute. Good thing it popped up. It went, it went pretty well. I was able to…
87 00:07:05.760 ⇒ 00:07:14.170 Samuel Roberts: I found the API key in 1Password, was able to just kind of throw some scripts together to hit some endpoints, and I’m able to get transcripts.
88 00:07:14.170 ⇒ 00:07:14.960 Amber Lin: Oh, awesome.
89 00:07:14.960 ⇒ 00:07:22.900 Samuel Roberts: Sure. Yeah. So, I think, it’s not, it’s not… I wouldn’t… it’s not… done. What…
90 00:07:23.600 ⇒ 00:07:28.949 Samuel Roberts: I was just… I just chatted with Utom, because I was like, where do you want me to go from here? Like, it’s not… that pipeline is still not…
91 00:07:29.070 ⇒ 00:07:30.390 Samuel Roberts: Good.
92 00:07:30.390 ⇒ 00:07:31.020 Amber Lin: Oh.
93 00:07:31.890 ⇒ 00:07:33.870 Samuel Roberts: But,
94 00:07:34.550 ⇒ 00:07:40.849 Samuel Roberts: what he was saying was to throw together, because basically, we’re trying to, like, tie this 8x8 stuff to… Yeah.
95 00:07:42.240 ⇒ 00:07:48.120 Samuel Roberts: like, Andy usage, potentially, which I’m trying to… I need to figure out…
96 00:07:48.410 ⇒ 00:07:55.060 Samuel Roberts: I can see the transcripts, so I have the timestamps, and I have the user, I want to be able to, like.
97 00:07:55.390 ⇒ 00:08:00.129 Samuel Roberts: side-by-side show, like, here’s the call transcript, and here’s what they chatted with Andy about.
98 00:08:00.180 ⇒ 00:08:04.299 Amber Lin: Yeah, is there a call ID that we can use?
99 00:08:05.750 ⇒ 00:08:07.549 Samuel Roberts: From which side?
100 00:08:07.830 ⇒ 00:08:14.369 Amber Lin: For the transcripts, because if they have a call ID, then probably they have it for the transcripts, and…
101 00:08:14.650 ⇒ 00:08:20.690 Amber Lin: the call. So, I think when we made this dashboard for ABC, we…
102 00:08:20.800 ⇒ 00:08:24.749 Amber Lin: We didn’t use the call transcripts, we used…
103 00:08:24.860 ⇒ 00:08:35.220 Amber Lin: the username and the timestamp of when that happened, to join it to the potential anti-usages to happen during that call period.
104 00:08:35.220 ⇒ 00:08:37.620 Samuel Roberts: That’s exactly what the kind of stuff I’m wondering about here, so…
105 00:08:37.620 ⇒ 00:08:38.710 Amber Lin: Yeah.
106 00:08:39.049 ⇒ 00:08:57.580 Amber Lin: So, I think if we have the call ID, we can join it to the… we can get the, say, this call took 5 minutes, and then it was answered by this person. But if we want to tie it to Andy Usage, we probably have to do the same, same type of logic that we had here.
107 00:08:58.230 ⇒ 00:09:02.539 Samuel Roberts: And that’s all on that real dashboard. Is that coming from 8x8, or where is that stuff coming from?
108 00:09:03.360 ⇒ 00:09:10.900 Amber Lin: Yes, this is coming from another endpoint from 8x8. We got another API about the call metrics.
109 00:09:11.560 ⇒ 00:09:14.459 Samuel Roberts: Okay, I think I found that one as I was exploring today, so that makes sense.
110 00:09:15.470 ⇒ 00:09:16.470 Amber Lin: Okay.
111 00:09:16.770 ⇒ 00:09:21.650 Samuel Roberts: Cool. I will try to explore a good way to join that,
112 00:09:23.770 ⇒ 00:09:28.020 Samuel Roberts: Because what I was trying to figure out… what I was just thinking about and kind of spitballing was…
113 00:09:28.270 ⇒ 00:09:34.040 Samuel Roberts: And it ends… won’t have, like, the whole chat, so I might want to…
114 00:09:34.770 ⇒ 00:09:38.249 Samuel Roberts: get access to the Google Chat itself at some point?
115 00:09:40.860 ⇒ 00:09:43.660 Samuel Roberts: Because… if we…
116 00:09:45.080 ⇒ 00:09:55.409 Samuel Roberts: if we just have the chat, it’s really all we need. We don’t necessarily need, like, every hit to Andy, we just want to see, like, what they chatted about, and be able to compare with the call. So I don’t know,
117 00:09:56.310 ⇒ 00:10:01.330 Samuel Roberts: Who that would have to be on their end to kind of figure that out, but…
118 00:10:01.800 ⇒ 00:10:07.989 Amber Lin: Well, would that be… I know they’re data people, but they’re not the fastest at responding.
119 00:10:08.010 ⇒ 00:10:09.080 Samuel Roberts: Okay. So we have…
120 00:10:09.080 ⇒ 00:10:10.560 Amber Lin: Ryan and Dave.
121 00:10:10.560 ⇒ 00:10:10.930 Samuel Roberts: Okay.
122 00:10:12.210 ⇒ 00:10:17.580 Samuel Roberts: Are they the ones that would have, like, got this working into, google Chat for them.
123 00:10:18.230 ⇒ 00:10:18.960 Casie Aviles: Tim…
124 00:10:18.960 ⇒ 00:10:22.079 Samuel Roberts: Tim would be, I guess, their…
125 00:10:22.080 ⇒ 00:10:24.210 Amber Lin: technology heads?
126 00:10:24.360 ⇒ 00:10:25.230 Samuel Roberts: Okay.
127 00:10:29.560 ⇒ 00:10:30.710 Amber Lin: And then…
128 00:10:33.790 ⇒ 00:10:35.840 Samuel Roberts: Okay, that’s good to know.
129 00:10:36.190 ⇒ 00:10:41.970 Samuel Roberts: Has… I’m gonna… I’m gonna do a little bit in 8N now, and maybe I’ll check out that real…
130 00:10:42.460 ⇒ 00:10:45.140 Samuel Roberts: Dashboard and how that’s pulling stuff, but…
131 00:10:47.260 ⇒ 00:10:47.590 Amber Lin: Okay.
132 00:10:47.590 ⇒ 00:10:53.409 Samuel Roberts: I wasn’t sure the best way to get access to the data that I’m gonna need to, like, match up, interactions.
133 00:10:53.630 ⇒ 00:11:00.490 Amber Lin: Yeah, I think all that data is in Snowflake, so all the, ANDI usage data.
134 00:11:01.880 ⇒ 00:11:08.420 Samuel Roberts: Oh, that’s… okay. So that’s gonna be, like, usage data, but not necessarily, like, what was discussed, or is, like, what was discussed all in there, too?
135 00:11:08.660 ⇒ 00:11:09.240 Amber Lin: Awesome.
136 00:11:09.240 ⇒ 00:11:09.970 Samuel Roberts: logs.
137 00:11:10.930 ⇒ 00:11:14.070 Amber Lin: Casey, what was discussed is in Superbase, right?
138 00:11:14.880 ⇒ 00:11:22.720 Casie Aviles: No, I mean, like, the input, right? The input of the CSR and then the AI output, they’re all… they’re in Snowflake.
139 00:11:23.210 ⇒ 00:11:27.629 Samuel Roberts: That’s the snowflake? That’s good to know. Okay, cool, because that might… and that’s got, like, timestamps and stuff.
140 00:11:28.290 ⇒ 00:11:35.449 Casie Aviles: Yes, although… When it was created, we didn’t have, like, a dedicated timestamp column. It was…
141 00:11:35.760 ⇒ 00:11:37.469 Casie Aviles: Stored as a text.
142 00:11:37.590 ⇒ 00:11:40.199 Casie Aviles: And appended to another string, which is…
143 00:11:40.730 ⇒ 00:11:46.060 Casie Aviles: But it’s there, there’s a timestamp there, and I think it’s a record ID, but you’ll have to.
144 00:11:46.060 ⇒ 00:11:46.440 Samuel Roberts: Okay.
145 00:11:46.440 ⇒ 00:11:46.980 Casie Aviles: hip.
146 00:11:47.770 ⇒ 00:11:53.110 Samuel Roberts: That’s fine, I can… I can play with that. I don’t know if I… I haven’t really dealt with Snowflake yet, so…
147 00:11:53.230 ⇒ 00:11:56.990 Samuel Roberts: I may need you to, like, walk me through that later, Casey, if that’s cool.
148 00:11:57.160 ⇒ 00:11:58.140 Casie Aviles: Sure.
149 00:11:58.480 ⇒ 00:12:01.240 Samuel Roberts: Yeah. Is Snowflake?
150 00:12:01.240 ⇒ 00:12:02.030 Amber Lin: Oh!
151 00:12:02.030 ⇒ 00:12:03.769 Samuel Roberts: Yeah, we’ll chat later. You’re good.
152 00:12:03.770 ⇒ 00:12:08.660 Amber Lin: Okay, how long should we… should we take for this initial spike?
153 00:12:09.640 ⇒ 00:12:11.590 Samuel Roberts: I mean, I’ve already spent…
154 00:12:11.960 ⇒ 00:12:14.869 Samuel Roberts: Better part of, like, an hour and a half, two hours.
155 00:12:15.760 ⇒ 00:12:22.280 Samuel Roberts: Just exploring the endpoints, trying to figure it out, because, like, what was in the pipeline was just totally hallucinated.
156 00:12:23.320 ⇒ 00:12:27.329 Samuel Roberts: But, yeah, I mean, maybe 2 or 3 would be good.
157 00:12:27.330 ⇒ 00:12:27.930 Amber Lin: Okay.
158 00:12:28.760 ⇒ 00:12:31.320 Samuel Roberts: I’ll… if I have to amend that, I’ll let you know.
159 00:12:31.440 ⇒ 00:12:35.810 Samuel Roberts: Okay. Yeah, I definitely would love to get it by, you know, End of…
160 00:12:36.200 ⇒ 00:12:40.729 Samuel Roberts: Or before we chat with them later tomorrow, right? Where’s today? Wednesday, yeah.
161 00:12:41.280 ⇒ 00:12:41.710 Amber Lin: Yeah, okay.
162 00:12:41.710 ⇒ 00:12:43.519 Samuel Roberts: I’m shooting for that, but at least something.
163 00:12:43.520 ⇒ 00:12:49.190 Amber Lin: something, as long as we have something, they will be happy. I just want them to know that we’re moving.
164 00:12:49.730 ⇒ 00:12:53.379 Samuel Roberts: Yeah, that’s exactly why I wanted to just, like, jump into it when Dominic…
165 00:12:53.620 ⇒ 00:12:55.519 Amber Lin: I’ve just sent a message.
166 00:12:57.450 ⇒ 00:12:58.010 Samuel Roberts: Heh, yeah.
167 00:12:58.010 ⇒ 00:12:58.399 Amber Lin: Oh, yeah.
168 00:12:58.400 ⇒ 00:12:59.220 Samuel Roberts: You and I were just on a.
169 00:12:59.220 ⇒ 00:13:06.199 Amber Lin: Yeah. On the database testing side, Casey, how did that go?
170 00:13:07.240 ⇒ 00:13:10.540 Casie Aviles: Yeah, so I did, perform some tests,
171 00:13:10.790 ⇒ 00:13:17.070 Casie Aviles: And then it should be in a doc, so I put the results that I have in that Notion doc, which I linked.
172 00:13:17.210 ⇒ 00:13:20.319 Casie Aviles: Also, to the ticket, and also to this message.
173 00:13:22.490 ⇒ 00:13:29.550 Casie Aviles: Yeah, so, I guess just a review would also be nice, and if some… if, like, a…
174 00:13:29.770 ⇒ 00:13:34.740 Casie Aviles: Another, like, fresh ice to… to also poke holes at the,
175 00:13:36.150 ⇒ 00:13:40.079 Casie Aviles: The DB would be great. I did tag Aish there.
176 00:13:41.760 ⇒ 00:13:42.599 Casie Aviles: If fair…
177 00:13:42.600 ⇒ 00:13:43.030 Amber Lin: Sounds good.
178 00:13:43.030 ⇒ 00:13:46.390 Casie Aviles: they could… Yeah, but I guess if, if…
179 00:13:46.950 ⇒ 00:13:55.290 Casie Aviles: if they can’t review it immediately, then I can still proceed with the other ticket, which is the testing with, the querying.
180 00:13:56.020 ⇒ 00:13:56.639 Casie Aviles: That’s… yeah.
181 00:13:56.640 ⇒ 00:14:08.529 Amber Lin: Okay. Yeah, I think that doesn’t inhibit how we do the query, because if we edit it, the database is still going to be a database, we’ll still have the rows, and the schema’s probably going to be the same, so…
182 00:14:09.040 ⇒ 00:14:09.900 Casie Aviles: Yeah, yeah.
183 00:14:10.030 ⇒ 00:14:12.360 Amber Lin: I think it’s not blocking the query.
184 00:14:12.780 ⇒ 00:14:19.489 Casie Aviles: Yes, because this will be, like, a separate thing, I have to figure out, like, what’s the best prompt, you know, and… yeah.
185 00:14:20.400 ⇒ 00:14:23.560 Casie Aviles: So this… I can work on that next, but yeah.
186 00:14:24.010 ⇒ 00:14:24.650 Amber Lin: Okay.
187 00:14:24.870 ⇒ 00:14:25.930 Amber Lin: Sounds good.
188 00:14:26.040 ⇒ 00:14:34.410 Amber Lin: And then… I’ll close out the triage tickets, and then I’ll talk to Lon about the spreadsheets.
189 00:14:34.870 ⇒ 00:14:38.489 Amber Lin: Okay, great. These are in progress and testing.
190 00:14:39.000 ⇒ 00:14:39.510 Mustafa Raja: Oh.
191 00:14:39.510 ⇒ 00:14:41.560 Amber Lin: I’ll check with Janiece on that.
192 00:14:41.830 ⇒ 00:14:45.590 Amber Lin: Okay, this is great. Any… any questions?
193 00:14:45.590 ⇒ 00:14:51.949 Mustafa Raja: Yeah, for the, for my triages, can we, can we go to the ones that I’ve put in escalation?
194 00:14:52.810 ⇒ 00:14:59.990 Mustafa Raja: Yeah, this one… So this is the, Yeah, this is a.
195 00:14:59.990 ⇒ 00:15:00.710 Amber Lin: See, when the.
196 00:15:00.710 ⇒ 00:15:07.649 Mustafa Raja: Depends on the… what’s it called, database, so let me know where should you put it, because I guess we’ll…
197 00:15:09.150 ⇒ 00:15:11.319 Amber Lin: How long would this take?
198 00:15:13.890 ⇒ 00:15:18.300 Amber Lin: We’re to change the prompt that says, okay, only look at the zip.
199 00:15:19.000 ⇒ 00:15:19.560 Amber Lin: That’s happening.
200 00:15:19.560 ⇒ 00:15:21.390 Mustafa Raja: asked for. Hmm.
201 00:15:22.000 ⇒ 00:15:29.200 Mustafa Raja: So, so what’s happening is we have a few sheets, and only one of those sheets has the zips.
202 00:15:29.440 ⇒ 00:15:36.699 Mustafa Raja: Yeah, it should take me, I guess, 30 to… 30 minutes to an hour, I guess.
203 00:15:38.870 ⇒ 00:15:41.989 Amber Lin: I see, but you have default work, right?
204 00:15:42.890 ⇒ 00:15:44.320 Mustafa Raja: Yeah, I can take it, though.
205 00:15:45.660 ⇒ 00:15:46.650 Amber Lin: I see.
206 00:15:47.150 ⇒ 00:15:47.530 Mustafa Raja: Yeah.
207 00:15:47.990 ⇒ 00:16:06.089 Mustafa Raja: And for this, what they were doing is irrigation technician, and if it’s the technician, then it looks for skeleton Zips 1, but the appropriate one would be irrigation inspector for it to look into the master inspector sheet.
208 00:16:06.090 ⇒ 00:16:15.270 Amber Lin: Mmm, okay, so this, I would… Tag… Janiece.
209 00:16:16.370 ⇒ 00:16:18.430 Amber Lin: This is… like, this is not…
210 00:16:21.630 ⇒ 00:16:26.169 Mustafa Raja: Yeah, they said that they accidentally hit the thumbs down, so I don’t know.
211 00:16:26.170 ⇒ 00:16:31.979 Amber Lin: Yeah, I think this is a… yeah, it’s okay, we… sorry, I should’ve… shoulda closed this.
212 00:16:32.530 ⇒ 00:16:34.389 Amber Lin: I’ll just close this one.
213 00:16:35.920 ⇒ 00:16:45.770 Amber Lin: Okay. I mean, this is not urgent. If you get time this week, we can… we can do it. If not, hopefully we roll it out
214 00:16:45.770 ⇒ 00:16:56.520 Amber Lin: we roll out the zip code database next week, so we don’t have to. I’ll just check in on that, I’ll… I have some time now, I can clean this, backlog up.
215 00:16:57.560 ⇒ 00:16:57.950 Mustafa Raja: Okay.
216 00:16:57.950 ⇒ 00:17:05.450 Amber Lin: Last thing, Sam, do you know if Utam’s talking to Matt, or do you know when you guys are talking to 8x8?
217 00:17:06.819 ⇒ 00:17:12.079 Samuel Roberts: I think they were saying… they were trying to set up a meeting for, like, next Wednesday to talk to 8x8.
218 00:17:13.130 ⇒ 00:17:13.780 Amber Lin: Okay.
219 00:17:13.780 ⇒ 00:17:16.159 Samuel Roberts: But Utam and I were just talking, I might just try to…
220 00:17:16.700 ⇒ 00:17:21.629 Samuel Roberts: Give him a little, like, a bunch of questions, and maybe we can just send that over, and hopefully…
221 00:17:22.040 ⇒ 00:17:26.860 Samuel Roberts: get some info before that even, but chatting with them will be helpful still. But that’s all I know right now.
222 00:17:27.530 ⇒ 00:17:28.590 Amber Lin: Sounds good.
223 00:17:29.110 ⇒ 00:17:35.030 Amber Lin: Alright, that’s… that’s all I had.
224 00:17:35.500 ⇒ 00:17:39.430 Amber Lin: don’t have much more questions. They’re… they’re in testing, so…
225 00:17:39.560 ⇒ 00:17:42.260 Amber Lin: And then our usage doing pretty well.
226 00:17:43.870 ⇒ 00:17:44.280 Samuel Roberts: Cool.
227 00:17:44.280 ⇒ 00:17:46.310 Amber Lin: Okay. Thanks, everyone.
228 00:17:46.660 ⇒ 00:17:50.660 Samuel Roberts: Thank you. Cool. Casey, can we just, like, hop on the huddle real quick to look at the Snowflake stuff?
229 00:17:50.740 ⇒ 00:17:51.600 Casie Aviles: Do you have any questions?
230 00:17:51.600 ⇒ 00:17:56.010 Amber Lin: I can also stay on this call, I think, I don’t… I have another, like…
231 00:17:56.800 ⇒ 00:17:58.550 Amber Lin: 40 minutes before I need to use.
232 00:17:58.550 ⇒ 00:17:59.180 Samuel Roberts: Oh, okay.
233 00:17:59.180 ⇒ 00:18:00.360 Amber Lin: room. Yeah.
234 00:18:00.360 ⇒ 00:18:02.769 Samuel Roberts: Perfect. Okay. Alright, great. Thanks, Amber.
235 00:18:03.620 ⇒ 00:18:04.830 Casie Aviles: Mike. Thank you.
236 00:18:09.310 ⇒ 00:18:10.250 Mustafa Raja: And also.
237 00:18:10.250 ⇒ 00:18:11.020 Samuel Roberts: Cool.
238 00:18:11.750 ⇒ 00:18:12.350 Casie Aviles: Let me go…
239 00:18:12.350 ⇒ 00:18:16.699 Samuel Roberts: Oh, cool. Yeah, I’m just wondering… I haven’t, like I said, I haven’t accessed it yet, so I don’t know exactly, yeah.
240 00:18:17.080 ⇒ 00:18:19.389 Samuel Roberts: I’ll best to go into it.
241 00:18:21.290 ⇒ 00:18:24.409 Casie Aviles: Oh, I don’t think I’m able to add people there.
242 00:18:25.170 ⇒ 00:18:26.300 Samuel Roberts: Okay.
243 00:18:45.630 ⇒ 00:18:49.560 Samuel Roberts: Yeah, I didn’t realize it was all being locked there. That’s actually very helpful, because I was just trying to…
244 00:18:51.010 ⇒ 00:18:53.829 Samuel Roberts: think how I was gonna merge that stuff together, but…
245 00:18:54.790 ⇒ 00:19:04.300 Casie Aviles: Yeah, that’s… I don’t think Google… I’m not sure if Google Chat natively supports, like, storing those.
246 00:19:04.840 ⇒ 00:19:05.770 Samuel Roberts: Yeah…
247 00:19:05.770 ⇒ 00:19:07.160 Casie Aviles: Conversations.
248 00:19:07.430 ⇒ 00:19:09.609 Casie Aviles: But this is what we have.
249 00:19:09.960 ⇒ 00:19:12.080 Samuel Roberts: No, this is perfect, so at least…
250 00:19:13.390 ⇒ 00:19:15.129 Samuel Roberts: At least get something stood up.
251 00:19:18.210 ⇒ 00:19:22.930 Casie Aviles: Yeah, here. Under Catalog, we have ABC Logs.
252 00:19:23.510 ⇒ 00:19:24.210 Samuel Roberts: Cool.
253 00:19:24.210 ⇒ 00:19:31.100 Casie Aviles: ABC schema, and then… yeah, this one, ABC Logs, backfilled March 26.
254 00:19:31.100 ⇒ 00:19:31.770 Samuel Roberts: Okay.
255 00:19:33.290 ⇒ 00:19:38.110 Casie Aviles: And then we… It has to run on the ABC warehouse.
256 00:19:39.520 ⇒ 00:19:47.839 Casie Aviles: And then we have… let’s just quickly take a look at the data. So, this is what I was talking about, the timestamps are…
257 00:19:48.080 ⇒ 00:19:50.360 Casie Aviles: part of this record ID string.
258 00:19:50.780 ⇒ 00:19:51.690 Casie Aviles: So you’ll…
259 00:19:51.800 ⇒ 00:19:57.360 Casie Aviles: So, what we did was to extract it from there, so, yeah, we don’t have, like, a…
260 00:19:58.810 ⇒ 00:20:07.360 Casie Aviles: Yeah, a timestamp column, and you can see here the input, so it’s, like, one input and then the output that the AI gave.
261 00:20:08.070 ⇒ 00:20:11.840 Casie Aviles: Okay. So we could probably get the conversations.
262 00:20:12.480 ⇒ 00:20:13.940 Samuel Roberts: Yeah.
263 00:20:14.860 ⇒ 00:20:17.600 Casie Aviles: Yeah, there’s also conversation ID here.
264 00:20:17.730 ⇒ 00:20:18.530 Casie Aviles: That we have.
265 00:20:18.530 ⇒ 00:20:19.100 Samuel Roberts: Okay.
266 00:20:19.360 ⇒ 00:20:26.810 Samuel Roberts: That’s helpful, too, yeah. I’m thinking at this point, I’m just gonna try to find, like, now that I have the access to the transcripts, like, 5 recent ones.
267 00:20:27.030 ⇒ 00:20:36.010 Samuel Roberts: And just try to, Match that to, like, a few conversations and try to get it to,
268 00:20:36.630 ⇒ 00:20:43.650 Samuel Roberts: just… just so I can show, like, okay, here’s it, here they are, side by side, this is what we could be able to do if they want to move forward with the other…
269 00:20:43.830 ⇒ 00:20:44.470 Samuel Roberts: Proposal.
270 00:20:44.470 ⇒ 00:20:45.200 Casie Aviles: Yes.
271 00:20:46.030 ⇒ 00:20:49.370 Samuel Roberts: So, okay, now the question is, how do I get in here and get this access?
272 00:20:49.750 ⇒ 00:20:58.270 Casie Aviles: Alright, yeah, I can’t add people here, I’ve tried before, I’m going to… Ask.
273 00:20:59.790 ⇒ 00:21:04.650 Casie Aviles: Because it was Awish who was adding people then, but he might be out.
274 00:21:05.220 ⇒ 00:21:06.190 Samuel Roberts: Mmm, okay.
275 00:21:08.640 ⇒ 00:21:10.240 Casie Aviles: I’ll ask,
276 00:21:21.460 ⇒ 00:21:28.550 Casie Aviles: Okay, I asked him… Okay, cool, thank you. I’ll also ask Rico if he’s able to…
277 00:21:28.860 ⇒ 00:21:30.620 Samuel Roberts: Yeah, that might be…
278 00:21:38.640 ⇒ 00:21:44.169 Casie Aviles: Yeah, I think that’s… That’s it. But if you’re not able to…
279 00:21:46.800 ⇒ 00:21:49.520 Casie Aviles: Not sure if I can just share my account.
280 00:21:50.570 ⇒ 00:21:54.640 Samuel Roberts: Oh, okay, yeah, I mean, let me see if they can get back to us first, and then maybe…
281 00:21:55.580 ⇒ 00:21:56.340 Casie Aviles: Okay.
282 00:21:57.160 ⇒ 00:22:01.920 Samuel Roberts: Actually, you know what, go ahead and share it, just in case, because it might be easier to do it now. If I don’t need it, I’ll try not to use it, but…
283 00:22:03.680 ⇒ 00:22:07.509 Casie Aviles: Yeah, I just don’t have the authenticator here, I’ll have to move it.
284 00:22:08.120 ⇒ 00:22:10.950 Samuel Roberts: Oh, then don’t worry about it, let’s hope that they can get me in there, then.
285 00:22:11.360 ⇒ 00:22:14.290 Casie Aviles: Alright, but yeah, if they don’t, I’ll just…
286 00:22:15.210 ⇒ 00:22:19.340 Casie Aviles: I’ll just give you some access then. But that’s about it. Anything else?
287 00:22:19.990 ⇒ 00:22:25.480 Samuel Roberts: I guess… So, this is the, like, the UI for Snowflake here.
288 00:22:25.650 ⇒ 00:22:31.330 Samuel Roberts: if I wanted to just, like… I guess I don’t know how… like, what is actually putting this in here? Is there…
289 00:22:31.650 ⇒ 00:22:34.649 Samuel Roberts: Is this a Daxter thing, or is this an 8NN thing?
290 00:22:34.650 ⇒ 00:22:39.409 Casie Aviles: So you’re asking how we’re populating these, how we’re getting the records here?
291 00:22:40.400 ⇒ 00:22:41.909 Samuel Roberts: Yeah, that’s one question I’m wondering.
292 00:22:42.110 ⇒ 00:22:47.299 Casie Aviles: Yeah, so it… we have a workflow, and that’s also…
293 00:22:47.600 ⇒ 00:22:50.510 Casie Aviles: Yeah, the ABC workflow that we have.
294 00:22:50.810 ⇒ 00:22:52.530 Samuel Roberts: Okay, it’s in that one.
295 00:22:53.620 ⇒ 00:23:00.210 Casie Aviles: Yes, but… we… so before, we were using the N8N node, but because…
296 00:23:00.610 ⇒ 00:23:03.909 Casie Aviles: We, we, we, and it then doesn’t support, like.
297 00:23:05.000 ⇒ 00:23:09.650 Casie Aviles: There’s, like, an issue that we have with the credentials, so we replaced Good.
298 00:23:10.100 ⇒ 00:23:14.669 Casie Aviles: with a custom… lager over here, it’s very…
299 00:23:15.160 ⇒ 00:23:19.109 Casie Aviles: Might be very flimsy, but this is how we did it right now.
300 00:23:19.110 ⇒ 00:23:22.630 Samuel Roberts: That’s fine, I just wanted to see, so I had a sense of it. Okay, cool.
301 00:23:23.850 ⇒ 00:23:25.339 Samuel Roberts: And then…
302 00:23:25.580 ⇒ 00:23:28.669 Casie Aviles: This is in Windmill, by the way. This.
303 00:23:28.710 ⇒ 00:23:31.209 Samuel Roberts: Oh, okay, cool.
304 00:23:31.460 ⇒ 00:23:34.410 Samuel Roberts: I am starting to get more of a… Visual.
305 00:23:35.040 ⇒ 00:23:36.720 Samuel Roberts: of everything here. Okay.
306 00:23:37.150 ⇒ 00:23:39.750 Samuel Roberts: That’s great. Alright, I’m just,
307 00:23:40.540 ⇒ 00:23:47.059 Samuel Roberts: That’s in Windmill. And then, for me to pull data out of Snowflake and try to match it up.
308 00:23:47.600 ⇒ 00:23:50.830 Samuel Roberts: Is there…
309 00:23:52.450 ⇒ 00:23:58.079 Samuel Roberts: I guess I don’t know what the normal process is for getting things in and out of here.
310 00:23:58.740 ⇒ 00:24:05.479 Samuel Roberts: Yeah, like, is there a good way to, like, access this table programmatically for me? Once I have access, obviously?
311 00:24:05.820 ⇒ 00:24:09.250 Casie Aviles: ye… yeah, what I did is…
312 00:24:09.570 ⇒ 00:24:14.619 Casie Aviles: Yeah, I did use Python and a Snowflake connector when I want to.
313 00:24:14.620 ⇒ 00:24:15.070 Samuel Roberts: Okay.
314 00:24:15.070 ⇒ 00:24:16.600 Casie Aviles: this programmatically.
315 00:24:16.970 ⇒ 00:24:19.599 Samuel Roberts: Okay, that’s great, I could probably figure that out then.
316 00:24:20.070 ⇒ 00:24:23.699 Samuel Roberts: And I probably can look in Windmill and see how it’s doing it, and just based it on that.
317 00:24:24.560 ⇒ 00:24:27.369 Casie Aviles: Yeah, there’s, like, something…
318 00:24:27.520 ⇒ 00:24:34.240 Casie Aviles: I think we added 2FA to Snowflake, so it’s a little different how we connect their.
319 00:24:34.240 ⇒ 00:24:35.960 Samuel Roberts: Oh, okay.
320 00:24:36.370 ⇒ 00:24:39.999 Samuel Roberts: Alright, well, I’ll do a little bit. Once I get access, I’ll figure that out.
321 00:24:40.410 ⇒ 00:24:42.750 Samuel Roberts: Hopefully one of them can grant it then.
322 00:24:43.140 ⇒ 00:24:46.759 Samuel Roberts: Is there anyone else, if you are in Snowflake, that…
323 00:24:47.350 ⇒ 00:24:51.669 Samuel Roberts: Like, do you know who the admin is besides Away Shariko? Is that it, you think?
324 00:24:53.060 ⇒ 00:24:55.070 Casie Aviles: Well, there’s Uten, but…
325 00:24:55.180 ⇒ 00:25:02.109 Casie Aviles: Yeah, we tried to message… I tried to message Awesha and Draco first, then if not, then I guess Otomi.
326 00:25:02.110 ⇒ 00:25:05.710 Samuel Roberts: I just wanted to make sure that there was a way to escalate it, that’s all. Alright, cool.
327 00:25:05.710 ⇒ 00:25:06.060 Casie Aviles: iron.
328 00:25:06.060 ⇒ 00:25:09.760 Samuel Roberts: get him to do it then. All right, cool. Thank you so much, that is very helpful.
329 00:25:09.960 ⇒ 00:25:10.670 Casie Aviles: Okay.
330 00:25:11.470 ⇒ 00:25:12.549 Samuel Roberts: Appreciate the time.
331 00:25:12.620 ⇒ 00:25:13.310 Casie Aviles: Alright.
332 00:25:14.040 ⇒ 00:25:15.719 Samuel Roberts: Alright. Yep, bye.