Meeting Title: Zoom-Meeting Date: 2024-05-03 Meeting participants: Agustin, Uttam Kumaran


WEBVTT

1 00:03:04.090 00:03:05.020 Something.

2 00:07:36.710 00:07:39.050 Agustin: Hey? What’s up? Sorry for the delay?

3 00:07:42.060 00:07:42.740 Uttam Kumaran: Hey!

4 00:07:43.460 00:07:44.120 Agustin: Hey!

5 00:07:44.120 00:07:46.589 Uttam Kumaran: I was just turned listening to me. Hey! How’s it going.

6 00:07:47.390 00:07:48.800 Agustin: I’m doing good. Yeah.

7 00:07:49.570 00:07:51.820 Agustin: I just had a quick class.

8 00:07:51.930 00:07:56.019 Agustin: I enroll in a project management course. I don’t even know why.

9 00:07:58.005 00:07:59.440 Uttam Kumaran: Nice.

10 00:08:00.940 00:08:01.540 Agustin: And Daniel.

11 00:08:01.540 00:08:07.158 Uttam Kumaran: It’s it’s a lot. It’s a. It’s a lot more boring than engineering for me.

12 00:08:08.270 00:08:12.430 Agustin: Yeah, it is. But I want to cover all the possible aspects

13 00:08:13.300 00:08:14.330 Agustin: of the

14 00:08:15.090 00:08:16.130 Agustin: job. You know.

15 00:08:16.440 00:08:18.329 Uttam Kumaran: Yeah, yeah, yeah. Makes sense.

16 00:08:19.060 00:08:20.419 Uttam Kumaran: How’s everything going.

17 00:08:21.870 00:08:24.200 Agustin: Yeah. It’s you mean the course or.

18 00:08:24.470 00:08:27.133 Uttam Kumaran: No, just everything. But yeah, how’s the course, too?

19 00:08:27.800 00:08:29.290 Agustin: Yeah, I mean, I’m doing good.

20 00:08:30.815 00:08:32.394 Agustin: I try to be honest.

21 00:08:32.820 00:08:35.189 Agustin: you know that they have another job. Right? So.

22 00:08:35.190 00:08:35.690 Uttam Kumaran: Yeah.

23 00:08:35.690 00:08:39.659 Agustin: Sometime. It’s kind of hard to get a lot of things out

24 00:08:40.020 00:08:41.809 Agustin: depending on the day. Right?

25 00:08:42.080 00:08:43.299 Agustin: But yeah, yeah.

26 00:08:43.460 00:08:44.660 Agustin: I think I,

27 00:08:45.100 00:08:47.040 Agustin: and finding a balance. Now.

28 00:08:47.930 00:08:51.357 Agustin: there’s some I do. I’m doing a lot of infrastructure.

29 00:08:51.720 00:08:53.599 Agustin: Nice. What’s gonna be awesome?

30 00:08:54.490 00:08:57.000 Agustin: Yeah, it’s mostly like

31 00:08:57.220 00:08:59.599 Agustin: step functions. Lambdas.

32 00:09:00.710 00:09:01.070 Uttam Kumaran: Per se.

33 00:09:01.070 00:09:02.459 Agustin: That the base is

34 00:09:02.520 00:09:05.389 Agustin: now touch touching a bit of air flow

35 00:09:05.650 00:09:06.350 Agustin: to yeah.

36 00:09:06.350 00:09:07.450 Uttam Kumaran: Oh, nice!

37 00:09:07.450 00:09:11.770 Agustin: I created like a static website hosting the Dbt. Docs

38 00:09:13.260 00:09:14.690 Agustin: for the company.

39 00:09:15.110 00:09:15.783 Uttam Kumaran: Nice. Okay.

40 00:09:16.370 00:09:17.770 Agustin: Which is, yeah.

41 00:09:18.570 00:09:23.641 Uttam Kumaran: Oh, I mean, we’re gonna need the same thing here for the elementary file.

42 00:09:24.740 00:09:26.462 Agustin: Yeah, I can help with that.

43 00:09:30.520 00:09:34.639 Agustin: Yeah, okay, let me show you what I I found, what I did.

44 00:09:36.320 00:09:38.869 Agustin: So let me share my screen.

45 00:09:45.960 00:09:49.259 Agustin: Okay, so first, here are the models

46 00:09:49.300 00:09:51.510 Agustin: that open. AI has right.

47 00:09:52.480 00:10:00.450 Agustin: And now, Ryan suggested to use Cbd for Turbo. But this is the most expensive model. So this is something

48 00:10:00.800 00:10:02.409 Agustin: we should keep in mind right.

49 00:10:03.630 00:10:04.459 Uttam Kumaran: Yeah, that makes sense.

50 00:10:04.460 00:10:05.140 Agustin: Owners

51 00:10:05.540 00:10:07.410 Agustin: for 1 million buckets, and I think

52 00:10:07.720 00:10:08.989 Agustin: one token is

53 00:10:09.190 00:10:11.860 Agustin: equal to 4 characters. Right?

54 00:10:12.524 00:10:16.249 Agustin: So I think we we could go by this.

55 00:10:16.860 00:10:21.419 Agustin: but it may be a limitation. I I will explain. Okay, so let’s go back

56 00:10:21.760 00:10:23.669 Agustin: to the application I build.

57 00:10:23.710 00:10:27.700 Agustin: I join the ticket and ticket command tables. Right?

58 00:10:28.320 00:10:29.150 Uttam Kumaran: Nice.

59 00:10:30.010 00:10:30.760 Agustin: And

60 00:10:32.315 00:10:40.579 Agustin: I I took 3 columns which are subject, body and description. Description is the mess, the the comment. Right?

61 00:10:41.940 00:10:43.500 Agustin: Okay. So

62 00:10:44.280 00:10:46.840 Agustin: I found out a few things.

63 00:10:48.080 00:10:50.039 Agustin: and one of them is that

64 00:10:50.470 00:10:51.460 Agustin: and

65 00:10:51.970 00:10:57.450 Agustin: the model is not good at like relating data from different columns.

66 00:10:57.920 00:10:58.850 Agustin: So.

67 00:10:59.040 00:11:02.560 Agustin: according to all the used cases I saw on the Internet

68 00:11:02.800 00:11:07.329 Agustin: at the best usage is to have only one volume.

69 00:11:07.570 00:11:13.973 Agustin: and if that’s not sufficient, you you can concatenate all columns into one, if that makes sense.

70 00:11:15.250 00:11:17.039 Agustin: So that’s something to keep in mind

71 00:11:17.600 00:11:21.579 Agustin: also, since we are using Cbd for Turbo.

72 00:11:21.920 00:11:24.759 Agustin: these questions are really expensive.

73 00:11:24.890 00:11:28.630 Agustin: So I would say. Not sure about ho! How much?

74 00:11:29.100 00:11:32.770 Agustin: But I would say maybe half a cent.

75 00:11:33.300 00:11:34.980 Agustin: No sorry half a dollar

76 00:11:35.610 00:11:37.969 Agustin: per answer.

77 00:11:38.140 00:11:39.310 Uttam Kumaran: Oh, wow! Okay.

78 00:11:39.660 00:11:45.389 Agustin: Yeah, so yeah, it’s expensive. So the only way to reduce it will be to

79 00:11:45.410 00:11:47.829 Agustin: do. I be the feature engineering and

80 00:11:48.060 00:11:50.209 Agustin: putting all the volumes into one. Right?

81 00:11:50.660 00:11:52.740 Agustin: So that’s what I found out.

82 00:11:53.280 00:11:55.320 Uttam Kumaran: Okay, but also snowflake cortex.

83 00:11:55.320 00:11:55.680 Agustin: So.

84 00:11:55.680 00:12:00.009 Uttam Kumaran: They’re gonna they have like they’re gonna come out with llama and stuff like that right.

85 00:12:01.840 00:12:03.509 Agustin: I’m not sure I don’t know.

86 00:12:03.510 00:12:10.859 Uttam Kumaran: Yeah, I’m pretty sure Snowflake cortex allows you to use in build models like they have llama and mistral and things in built.

87 00:12:11.920 00:12:14.549 Agustin: I think you’re right. Yeah, I didn’t.

88 00:12:15.150 00:12:18.040 Agustin: I? I did that done a lot of research

89 00:12:19.620 00:12:22.020 Agustin: about that. Yes, but yeah.

90 00:12:22.550 00:12:23.180 Uttam Kumaran: Okay.

91 00:12:24.520 00:12:27.710 Agustin: So here’s the data set. Let me

92 00:12:29.640 00:12:30.730 Agustin: show you.

93 00:12:34.535 00:12:34.870 Agustin: Oh.

94 00:12:38.090 00:12:38.930 Agustin: sorry. Yeah.

95 00:12:48.070 00:12:54.259 Agustin: So, as I say, as I said before, it cannot connect data from different columns.

96 00:12:54.780 00:12:57.810 Agustin: So it’s feather to ask question of a single column.

97 00:13:00.069 00:13:00.540 Agustin: Can’t.

98 00:13:00.730 00:13:03.070 Agustin: So let me ask

99 00:13:04.940 00:13:05.740 Agustin: what

100 00:13:06.390 00:13:08.750 Agustin: a question I have one in mind.

101 00:13:13.130 00:13:16.809 Agustin: and re. No, it’s Aranda, I think.

102 00:13:18.510 00:13:20.150 Uttam Kumaran: But can you share screen? By the way.

103 00:13:21.090 00:13:22.999 Agustin: Oh, I’m I’m sharing now.

104 00:13:23.110 00:13:24.849 Agustin: What am I not?

105 00:13:25.170 00:13:29.899 Uttam Kumaran: Oh, oh, I see it. Sorry it was not popping up on my zoom. Okay, I see enough.

106 00:13:31.160 00:13:33.620 Agustin: Oh, so e, okay.

107 00:13:34.930 00:13:39.002 Uttam Kumaran: So I was just listening to you. And I was like, Okay, it would be nice to see it. But okay,

108 00:13:39.390 00:13:42.299 Agustin: Yeah, I mean, I’ve been sharing for 5 min, but not.

109 00:13:42.770 00:13:46.060 Uttam Kumaran: Can you show me where you

110 00:13:46.120 00:13:48.620 Uttam Kumaran: what, what the tables you actually pulled from.

111 00:13:50.180 00:13:50.670 Agustin: Sure.

112 00:13:50.670 00:13:52.569 Uttam Kumaran: Okay. Okay. Great.

113 00:13:52.570 00:13:54.590 Agustin: Ticket and ticket comments. Yeah.

114 00:13:55.490 00:13:56.190 Uttam Kumaran: Okay. Cool.

115 00:13:57.080 00:13:57.830 Uttam Kumaran: Yep.

116 00:13:58.370 00:14:01.900 Agustin: So let’s see if we can ask this question.

117 00:14:02.270 00:14:04.719 Uttam Kumaran: So this asks on the entire data set.

118 00:14:08.550 00:14:09.560 Uttam Kumaran: Is that right?

119 00:14:12.990 00:14:13.690 Agustin: Yeah.

120 00:14:14.770 00:14:15.869 Agustin: yeah, yeah.

121 00:14:16.000 00:14:17.610 Agustin: Well, actually.

122 00:14:18.280 00:14:19.075 Agustin: it’s

123 00:14:19.930 00:14:23.710 Agustin: only not the entire one. I put like a limit, because

124 00:14:23.890 00:14:29.170 Agustin: otherwise the context window would be very big. So that’s something

125 00:14:29.350 00:14:32.559 Agustin: we should keep in mind. Maybe we could separate by chunks

126 00:14:33.450 00:14:37.090 Agustin: and see how much it can take right.

127 00:14:39.700 00:14:41.160 Uttam Kumaran: Hmm, interesting.

128 00:14:42.730 00:14:43.450 Agustin: Yeah.

129 00:14:46.630 00:14:50.850 Uttam Kumaran: So can you go to the can you go to the table for this ticket?

130 00:14:52.990 00:14:54.820 Agustin: Yeah. You mean, like the road

131 00:14:54.900 00:14:57.080 Agustin: where this person bought.

132 00:14:57.400 00:14:58.110 Uttam Kumaran: Yeah.

133 00:15:02.190 00:15:03.819 Agustin: Let me see.

134 00:15:07.650 00:15:10.700 Agustin: Yeah. Here the voicemail transcript version, yeah.

135 00:15:10.700 00:15:13.889 Uttam Kumaran: But so this isn’t. This isn’t like the entire

136 00:15:13.920 00:15:18.620 Uttam Kumaran: back and forth between the person and the customer service team. This is just like the.

137 00:15:18.890 00:15:19.290 Agustin: That’s.

138 00:15:19.290 00:15:20.690 Uttam Kumaran: The message.

139 00:15:21.570 00:15:22.550 Uttam Kumaran: Can you hear me.

140 00:15:24.070 00:15:24.750 Agustin: Yes.

141 00:15:24.970 00:15:26.080 Agustin: yeah, yeah. Yeah.

142 00:15:26.930 00:15:28.700 Agustin: Yeah. I can hear you now. Sorry. Yeah.

143 00:15:28.730 00:15:32.015 Agustin: not sure. Why, when I share my screen some

144 00:15:32.530 00:15:33.759 Agustin: that’s not work.

145 00:15:33.880 00:15:36.540 Agustin: Yeah, we’d like, Eva, yeah, I can hear you. Can you see.

146 00:15:36.813 00:15:42.559 Uttam Kumaran: I was asked, yeah, I was asking, so this is just the initial message. This isn’t the entire back and forth.

147 00:15:44.480 00:15:49.129 Agustin: Yeah, I I mean to be honest, I I haven’t gone through all the tables, so

148 00:15:49.450 00:15:51.279 Agustin: there may be some way to

149 00:15:51.510 00:15:52.700 Agustin: with everything.

150 00:15:53.620 00:15:58.740 Uttam Kumaran: Can you? Can you walk me through? How to do this on my end? Like, how do I access this.

151 00:16:00.260 00:16:04.129 Agustin: Oh, okay, yeah. I mean, if you follow the tutorial.

152 00:16:04.960 00:16:09.640 Agustin: the one on that you share with me, it should be pretty straightforward.

153 00:16:10.080 00:16:16.739 Agustin: You have to find an Api key by resist by registering in open AI right

154 00:16:18.871 00:16:21.280 Agustin: just copy and paste these directly.

155 00:16:21.950 00:16:25.039 Uttam Kumaran: And are you just logging into? Is this our open AI or.

156 00:16:25.040 00:16:26.860 Agustin: White insane.

157 00:16:29.880 00:16:30.970 Agustin: Yeah, yeah. Yeah.

158 00:16:31.190 00:16:34.930 Agustin: And then you create embeddings for all the rows

159 00:16:35.520 00:16:38.409 Agustin: you are interested in

160 00:16:38.490 00:16:40.670 Agustin: for all the columns. I mean, sorry. Yeah.

161 00:16:41.460 00:16:43.010 Agustin: and create a table

162 00:16:43.230 00:16:44.829 Agustin: or view, or whatever.

163 00:16:45.390 00:16:49.169 Agustin: And then you literally use the same logic.

164 00:16:50.310 00:16:52.689 Agustin: I put in the columns embeddings

165 00:16:53.280 00:16:55.080 Agustin: this similarity, which.

166 00:16:55.440 00:17:01.840 Agustin: to be honest. I not understand fully understand how it works. I mean, I do understand how it works, but no.

167 00:17:02.360 00:17:04.150 Agustin: how it’s being used here.

168 00:17:04.359 00:17:07.140 Agustin: Why needs to filter out this.

169 00:17:07.560 00:17:09.530 Agustin: So my question will be.

170 00:17:09.900 00:17:11.099 Agustin: if I,

171 00:17:12.069 00:17:15.919 Agustin: if if I remove this, will this work the same?

172 00:17:16.280 00:17:19.330 Agustin: So that’s something I would like to try out.

173 00:17:20.770 00:17:23.649 Uttam Kumaran: So can you share with me that initial worksheet.

174 00:17:24.359 00:17:26.319 Agustin: Yeah, I will do that. Yeah, yeah, yeah.

175 00:17:27.520 00:17:29.311 Uttam Kumaran: Cause. I can see the streamlined app right now.

176 00:17:33.320 00:17:37.079 Uttam Kumaran: And so this is hitting our. This is hitting our azure right.

177 00:17:41.230 00:17:42.779 Agustin: Sorry again. You say that again.

178 00:17:43.360 00:17:44.500 Uttam Kumaran: Like, how is this.

179 00:17:44.500 00:17:46.730 Agustin: I was sorry I was touch screen.

180 00:17:47.630 00:17:48.440 Agustin: It’s not getting.

181 00:17:48.440 00:17:49.660 Uttam Kumaran: And using pressure.

182 00:17:50.480 00:17:53.077 Agustin: No, it’s only using open AI.

183 00:17:53.510 00:17:57.840 Uttam Kumaran: So are you. This is your Api key, or is it like? Is it your personal one?

184 00:17:58.290 00:18:04.979 Agustin: Yeah, it’s a personal one with the account I created where I put $5 with your credit card. Yeah.

185 00:18:05.220 00:18:09.749 Uttam Kumaran: Okay, cool. Okay? So I can use. I’ll make sure to use the company one.

186 00:18:10.310 00:18:11.054 Uttam Kumaran: And then

187 00:18:11.890 00:18:15.019 Uttam Kumaran: so can you share with me that worksheet that you’re working on.

188 00:18:15.040 00:18:16.699 Uttam Kumaran: Yeah, I have the streamlit app.

189 00:18:19.380 00:18:20.670 Agustin: Okay, let me

190 00:18:21.090 00:18:22.480 Agustin: rename it.

191 00:18:26.540 00:18:29.349 Agustin: Do you think this can be useful for the business.

192 00:18:29.350 00:18:32.079 Uttam Kumaran: Yeah, I mean, I’m gonna work on it tonight. Actually.

193 00:18:32.416 00:18:36.939 Uttam Kumaran: what I’m gonna do is I’m gonna actually figure out how to embed all of the entire

194 00:18:37.410 00:18:41.740 Uttam Kumaran: back and forth. And then what I’m gonna do is I’m gonna ask questions like, tell me, like what the

195 00:18:41.960 00:18:45.060 Uttam Kumaran: what the most common issue is, tell me like

196 00:18:45.180 00:18:48.939 Uttam Kumaran: a little bit about how we typically respond things like that.

197 00:18:50.242 00:18:53.900 Uttam Kumaran: And then I’m gonna record a little bit of a zoom of a loom, Demo, and I’ll send it.

198 00:18:55.260 00:18:57.090 Agustin: Yeah, that’s that’s good. Yeah.

199 00:18:57.463 00:19:00.579 Agustin: No. How do I share? I’ll share. Yeah, I see them.

200 00:19:01.670 00:19:02.920 Uttam Kumaran: You see the share worksheet.

201 00:19:03.220 00:19:04.172 Agustin: Yeah. Yeah. Yeah. Yeah.

202 00:19:06.240 00:19:07.500 Agustin: Owner.

203 00:19:08.860 00:19:09.910 Agustin: Oh, shit my desktop.

204 00:19:09.910 00:19:10.590 Uttam Kumaran: Swag.

205 00:19:12.670 00:19:13.300 Agustin: Yeah.

206 00:19:14.980 00:19:16.330 Agustin: can you see it?

207 00:19:16.330 00:19:17.470 Uttam Kumaran: I can see it. Yeah.

208 00:19:20.880 00:19:25.509 Agustin: Yeah, I would suggest trying to concatenate all the columns into one.

209 00:19:25.640 00:19:30.629 Agustin: separate them by a coma, or something like that, or a semicolon.

210 00:19:31.620 00:19:32.732 Uttam Kumaran: So let me just

211 00:19:33.030 00:19:37.220 Uttam Kumaran: Let me just walk through this one time with you. So you’re creating this

212 00:19:38.170 00:19:40.819 Uttam Kumaran: this database test rag.

213 00:19:45.670 00:19:50.719 Uttam Kumaran: okay, creating database. Create in place table. Zendesk. Okay, so this is just to hold the data.

214 00:19:50.730 00:19:53.000 Uttam Kumaran: Oh, can you share with me? Edit access.

215 00:19:57.130 00:19:58.670 Agustin: What access, sorry.

216 00:19:59.160 00:20:01.600 Uttam Kumaran: Access to edit this.

217 00:20:01.840 00:20:04.370 Uttam Kumaran: Oh, never mind, I got it now. Okay, I got it

218 00:20:08.880 00:20:09.830 Uttam Kumaran: so.

219 00:20:40.350 00:20:41.310 Agustin: Fall.

220 00:20:45.750 00:20:47.302 Uttam Kumaran: Okay? And then

221 00:20:54.380 00:20:56.020 Uttam Kumaran: this handler.

222 00:20:56.060 00:20:57.800 Uttam Kumaran: where do you get this handler from?

223 00:21:08.440 00:21:09.130 Uttam Kumaran: Hub?

224 00:21:10.140 00:21:11.570 Agustin: Yeah, I’m here. Yeah.

225 00:21:11.570 00:21:13.779 Uttam Kumaran: Hey? Where do you get this handler from.

226 00:21:15.970 00:21:20.480 Agustin: It’s the one below, I mean should be the function.

227 00:21:20.860 00:21:21.490 Agustin: Let me see.

228 00:21:21.490 00:21:25.110 Uttam Kumaran: Oh, okay, okay, okay, never mind. Never mind. Sorry.

229 00:22:02.020 00:22:03.166 Uttam Kumaran: So then

230 00:22:04.360 00:22:08.570 Agustin: So when I research a bit, and when you do this.

231 00:22:09.380 00:22:12.209 Agustin: this vector represents a string only.

232 00:22:12.300 00:22:15.109 Agustin: So it’s that vector contains

233 00:22:15.700 00:22:18.800 Agustin: information about each cell.

234 00:22:18.820 00:22:20.080 Agustin: If that makes sense.

235 00:22:24.400 00:22:27.400 Uttam Kumaran: Okay, so that’s this. And then if you go to the app.

236 00:22:29.150 00:22:32.609 Agustin: Yeah, I’m not sure if you, if you will be able to see it.

237 00:22:33.840 00:22:36.489 Agustin: No, you should go right

238 00:22:36.640 00:22:38.980 Agustin: sorry. Yeah, right there.

239 00:23:15.110 00:23:16.541 Uttam Kumaran: And then this is

240 00:23:22.920 00:23:24.859 Uttam Kumaran: Oh, and this code they gave.

241 00:23:29.610 00:23:31.170 Uttam Kumaran: Is that right? Okay.

242 00:23:33.270 00:23:35.907 Uttam Kumaran: this part? I don’t. I don’t understand at all.

243 00:23:38.660 00:23:45.739 Agustin: The only part I don’t understand is, though, that wing clearer. Whatever similarity.

244 00:23:45.740 00:23:46.830 Uttam Kumaran: Okay, yeah.

245 00:23:47.890 00:23:48.740 Uttam Kumaran: Cool. By the way.

246 00:23:48.740 00:23:51.949 Agustin: What we are doing here is putting these embeddings

247 00:23:52.820 00:23:53.600 Agustin: right?

248 00:23:55.450 00:23:57.680 Agustin: And we’re giving it to a context.

249 00:23:59.380 00:24:03.739 Agustin: I mean, the context is this, the subscription, body and description right?

250 00:24:04.130 00:24:07.079 Agustin: Those similarity is just for filtering.

251 00:24:07.380 00:24:08.689 Agustin: So we are giving

252 00:24:09.090 00:24:13.770 Agustin: the charge should be the context of the data which is just putting, like all the.

253 00:24:13.770 00:24:15.430 Uttam Kumaran: I think what is free.

254 00:24:17.150 00:24:19.469 Uttam Kumaran: So you’re saying you should just make one contact. But.

255 00:24:19.470 00:24:21.199 Agustin: Utilizing when I’m freeing.

256 00:24:21.980 00:24:23.710 Agustin: And here’s all the data.

257 00:24:24.330 00:24:26.359 Uttam Kumaran: So you should make one contact list.

258 00:24:29.610 00:24:31.549 Agustin: Yeah, it’s one at the end.

259 00:24:32.300 00:24:34.650 Agustin: It’s feeling like concatenated somehow.

260 00:24:34.650 00:24:36.190 Uttam Kumaran: Oh, okay.

261 00:24:38.230 00:24:39.240 Uttam Kumaran: Okay.

262 00:24:40.980 00:24:42.080 Uttam Kumaran: I see.

263 00:24:46.180 00:24:49.649 Agustin: I tried using Cbd 3.5,

264 00:24:50.160 00:24:55.070 Agustin: and the the context window was very small for this, even for.

265 00:24:55.070 00:24:55.980 Uttam Kumaran: Oh, okay.

266 00:24:55.980 00:24:57.079 Agustin: Heather and rose.

267 00:24:57.670 00:25:01.860 Agustin: So yeah, we have to keep that in mind. Yeah, what I have to

268 00:25:02.270 00:25:05.130 Agustin: research of it. There may be some way.

269 00:25:05.720 00:25:08.450 Agustin: so that we can keep this into

270 00:25:08.810 00:25:10.559 Agustin: the memory right?

271 00:25:11.240 00:25:12.210 Agustin: Another.

272 00:25:13.120 00:25:16.790 Agustin: Send all the tokens every time right.

273 00:25:17.650 00:25:18.689 Uttam Kumaran: Doesn’t make sense.

274 00:25:18.880 00:25:20.640 Uttam Kumaran: Yeah, yeah, yeah. Yeah.

275 00:25:21.150 00:25:28.769 Uttam Kumaran: So I’ve done a lot of this stuff in in python locally like with lane chain and stuff. But I never did in Snowflake. So it’s interesting to see it.

276 00:25:35.230 00:25:40.499 Uttam Kumaran: Okay, great. Let me I’m gonna play around. This is this is great. I’m gonna play around tonight a little bit.

277 00:25:41.070 00:25:46.740 Agustin: Yeah, try. Yeah. Just try to keep in mind about the cost. Yeah, try to create an account.

278 00:25:47.600 00:25:49.392 Uttam Kumaran: Create an account? Yeah.

279 00:25:49.840 00:25:53.329 Agustin: Not sure. Yeah, if what’s expensive for you. But I think that.

280 00:25:53.730 00:25:57.082 Uttam Kumaran: No, no, no, I’m not gonna run like crazy. But I’m going to

281 00:25:57.470 00:26:04.179 Uttam Kumaran: I’m gonna see how much one of these costs. And I’m also, gonna I’m gonna very simplify how much context gets put in.

282 00:26:04.740 00:26:09.165 Uttam Kumaran: Cause the reason, yeah, yeah, I’m gonna just see how much it totally costs. And

283 00:26:10.870 00:26:12.250 Uttam Kumaran: yeah, play around.

284 00:26:13.310 00:26:15.443 Agustin: Yeah. Try to use that

285 00:26:15.950 00:26:19.319 Agustin: function in itself, like I sent you concaten

286 00:26:19.660 00:26:21.990 Agustin: under Dash W. Us.

287 00:26:22.270 00:26:23.440 Agustin: To concatenate

288 00:26:25.060 00:26:26.970 Agustin: all the columns.

289 00:26:27.330 00:26:28.386 Uttam Kumaran: Where’d you send us.

290 00:26:29.420 00:26:30.549 Agustin: In this some

291 00:26:30.640 00:26:31.650 Agustin: tabs up.

292 00:26:31.650 00:26:31.990 Uttam Kumaran: Okay.

293 00:26:41.540 00:26:44.290 Uttam Kumaran: And this is this is to concatenate. But aren’t we already.

294 00:26:44.540 00:26:45.370 Agustin: Think that.

295 00:26:49.280 00:26:54.340 Agustin: No, I mean what they say is that we don’t really want to give

296 00:26:54.840 00:27:00.439 Agustin: the A. Llm. All the volumes, but only one that contains

297 00:27:01.560 00:27:04.648 Agustin: all the data. If that makes sense.

298 00:27:05.090 00:27:06.180 Uttam Kumaran: Find it here.

299 00:27:07.070 00:27:08.010 Agustin: Yeah.

300 00:27:08.730 00:27:12.480 Agustin: but I think it will understand better if we just

301 00:27:12.730 00:27:15.279 Agustin: so. I mean, as I said before.

302 00:27:15.290 00:27:18.769 Agustin: we are telling the the it.

303 00:27:20.360 00:27:26.480 Agustin: Here’s the first column. Here’s the second one, and here’s the third one, so it will not connect the data

304 00:27:26.680 00:27:28.010 Agustin: from all the columns

305 00:27:29.060 00:27:33.070 Agustin: at the so sorry. Let me try to explain it in another way.

306 00:27:33.210 00:27:34.520 Agustin: So let’s say

307 00:27:34.720 00:27:35.750 Agustin: we have

308 00:27:35.800 00:27:39.150 Agustin: a table with name and age. Right?

309 00:27:39.690 00:27:40.570 Agustin: So

310 00:27:41.140 00:27:42.510 Agustin: in this way

311 00:27:42.630 00:27:44.640 Agustin: we are telling it.

312 00:27:44.730 00:27:48.279 Agustin: Here are all the names, and here are all the ages.

313 00:27:48.580 00:27:50.959 Agustin: but we won’t be able to ask.

314 00:27:51.280 00:27:53.300 Agustin: What is the name.

315 00:27:54.220 00:27:55.830 Agustin: or what is the age of

316 00:27:55.860 00:27:57.100 Agustin: this person.

317 00:27:57.400 00:27:59.870 Agustin: So in a better way to

318 00:28:00.430 00:28:02.640 Agustin: handle this would be to

319 00:28:02.930 00:28:04.590 Agustin: put only one row.

320 00:28:04.670 00:28:07.249 Agustin: What one calling called data, which is

321 00:28:07.520 00:28:12.949 Agustin: like John Com semicolon? 14. Right

322 00:28:13.720 00:28:15.670 Agustin: does that make sense? Now.

323 00:28:16.740 00:28:21.000 Uttam Kumaran: Kind of, but I just don’t get. So we have these contacts, lists.

324 00:28:24.500 00:28:26.008 Agustin: Yeah, but they’re just like

325 00:28:26.370 00:28:28.029 Agustin: lists, like.

326 00:28:28.752 00:28:33.380 Agustin: let’s say we have ages. It’s like 14 coma 15

327 00:28:33.590 00:28:34.390 Agustin: dates.

328 00:28:34.390 00:28:35.090 Uttam Kumaran: Yeah.

329 00:28:36.250 00:28:36.960 Agustin: So.

330 00:28:36.960 00:28:38.470 Uttam Kumaran: Oh, you’re saying to

331 00:28:38.590 00:28:40.142 Uttam Kumaran: you’re saying to

332 00:28:41.360 00:28:43.299 Uttam Kumaran: make it one row with

333 00:28:43.330 00:28:44.449 Uttam Kumaran: all 3.

334 00:28:46.440 00:28:48.579 Agustin: Yeah, one column with, yeah

335 00:28:49.090 00:28:50.119 Agustin: on the data.

336 00:28:51.100 00:28:54.319 Agustin: So one context list, with all the data.

337 00:28:55.416 00:28:56.410 Uttam Kumaran: I see.

338 00:28:57.710 00:28:58.240 Uttam Kumaran: Okay.

339 00:29:00.130 00:29:02.549 Agustin: I’m sure that will work better. Yeah.

340 00:29:06.130 00:29:08.690 Agustin: So you can do something like concat.

341 00:29:19.650 00:29:20.910 Agustin: something like that.

342 00:29:22.470 00:29:24.359 Uttam Kumaran: Hmm, okay, okay, yeah.

343 00:29:27.400 00:29:29.179 Uttam Kumaran: yeah. That makes sense. Okay, okay.

344 00:29:32.850 00:29:37.716 Uttam Kumaran: okay, I’m gonna try that. And then my other question was, Do you have any ideas of how we can.

345 00:29:38.200 00:29:39.760 Uttam Kumaran: try and host this

346 00:29:40.330 00:29:42.470 Uttam Kumaran: this this HTML page.

347 00:29:45.060 00:29:46.759 Agustin: Yeah, probably.

348 00:29:46.760 00:29:47.580 Uttam Kumaran: This one.

349 00:29:49.200 00:29:50.740 Agustin: Can you show it to me.

350 00:29:51.430 00:29:52.330 Uttam Kumaran: Yeah.

351 00:29:59.250 00:30:01.000 Uttam Kumaran: just an HTML file.

352 00:30:15.660 00:30:17.620 Uttam Kumaran: Just one HTML, but file.

353 00:30:19.720 00:30:21.100 Agustin: Oh, it’s that one.

354 00:30:23.570 00:30:29.142 Agustin: Yeah, I mean, we can host it on S. 3 should be literally a few minutes.

355 00:30:31.040 00:30:34.329 Uttam Kumaran: Can I? Can you tell me that? Can I do right now?

356 00:30:35.180 00:30:38.059 Agustin: Yeah, yeah, we can do it if you wish.

357 00:30:39.020 00:30:42.687 Uttam Kumaran: If you could show me that’d be amazing. So I can learn something today.

358 00:30:44.510 00:30:45.000 Uttam Kumaran: Okay.

359 00:30:45.000 00:30:45.569 Agustin: And me.

360 00:30:46.680 00:30:48.479 Uttam Kumaran: So I log in the console.

361 00:30:51.380 00:30:53.150 Agustin: Yeah, do you want? Yeah.

362 00:30:58.960 00:31:00.519 Uttam Kumaran: Just a static site, right?

363 00:31:01.790 00:31:02.659 Agustin: Yeah, yeah.

364 00:31:03.840 00:31:05.480 Agustin: there may be other

365 00:31:05.530 00:31:08.869 Agustin: things like authentication or trying to create

366 00:31:09.792 00:31:11.999 Agustin: like a Cdn or

367 00:31:12.820 00:31:16.420 Agustin: the website name, just. But yeah, the simplest way

368 00:31:16.510 00:31:19.040 Agustin: should be a Celtic website, public one

369 00:31:19.790 00:31:22.090 Agustin: for anyone to access. And that’s it.

370 00:31:22.630 00:31:24.920 Uttam Kumaran: Do we have a brain forge? Aws!

371 00:31:27.710 00:31:28.670 Agustin: The account.

372 00:31:29.270 00:31:29.980 Uttam Kumaran: Yeah.

373 00:31:31.410 00:31:31.740 Agustin: Yeah, I.

374 00:31:31.740 00:31:32.260 Uttam Kumaran: Have the best.

375 00:31:32.554 00:31:32.850 Agustin: Work.

376 00:31:34.820 00:31:35.150 Uttam Kumaran: Am, I.

377 00:31:35.150 00:31:35.980 Agustin: And that’s kind of

378 00:31:37.140 00:31:37.990 Agustin: Hello!

379 00:31:38.610 00:31:39.620 Uttam Kumaran: Love! Can you hear me?

380 00:31:40.180 00:31:42.319 Agustin: Yeah, yeah, I can hear you. What? What do you mean? Sorry?

381 00:31:42.540 00:31:45.630 Uttam Kumaran: No, I said, am I in there? Cause? I don’t know if I have

382 00:31:48.030 00:31:48.960 Uttam Kumaran: the account.

383 00:31:51.310 00:31:52.690 Agustin: Yeah, I think.

384 00:31:53.090 00:31:55.579 Agustin: Let me search for the password.

385 00:32:10.180 00:32:11.930 Agustin: I will send it to you

386 00:32:12.050 00:32:13.079 Agustin: in a slack.

387 00:32:24.260 00:32:25.440 Agustin: Oh, thank you.

388 00:32:52.370 00:32:55.600 Agustin: Something kind of random. But today I received like

389 00:32:56.060 00:32:59.119 Agustin: and an offer for a gig that is

390 00:32:59.220 00:33:00.395 Agustin: literally

391 00:33:02.100 00:33:06.709 Agustin: hosting interviews. Yeah, to hire people in data.

392 00:33:07.795 00:33:08.190 Uttam Kumaran: Really.

393 00:33:08.710 00:33:09.390 Agustin: Yeah.

394 00:33:10.720 00:33:11.760 Uttam Kumaran: What does that mean?

395 00:33:13.040 00:33:14.880 Uttam Kumaran: Literally like interviewing people?

396 00:33:15.310 00:33:19.249 Agustin: Yeah, I will see. My, I’m getting paid for

397 00:33:19.260 00:33:20.480 Agustin: each interview.

398 00:33:20.480 00:33:22.940 Uttam Kumaran: Let’s go, dude, get me! Get me and all that.

399 00:33:27.800 00:33:29.558 Uttam Kumaran: Get the whole team in on that.

400 00:33:31.540 00:33:36.770 Agustin: Yeah. But yeah, but the the thing is that the rate is kind of low.

401 00:33:36.870 00:33:39.670 Agustin: probably for people in the Us.

402 00:33:40.970 00:33:42.450 Agustin: It’s like, maybe

403 00:33:42.800 00:33:45.029 Agustin: $30 per interview

404 00:33:45.170 00:33:47.000 Agustin: for half an hour.

405 00:33:47.760 00:33:48.290 Uttam Kumaran: I’m glad.

406 00:33:48.290 00:33:48.890 Agustin: Row.

407 00:33:50.070 00:33:51.446 Agustin: Oh, it’s not bad.

408 00:33:52.200 00:33:55.360 Uttam Kumaran: I mean, like, that’s like $60 an hour. That’s pretty good.

409 00:33:55.970 00:33:58.330 Agustin: Yeah, if you think it that way. Yeah.

410 00:34:03.830 00:34:05.380 Agustin: But I think they’re going right

411 00:34:05.750 00:34:08.610 Agustin: for for that, maybe higher.

412 00:34:09.070 00:34:10.549 Agustin: I don’t know. I mean.

413 00:34:11.330 00:34:12.219 Agustin: I’m not.

414 00:34:12.650 00:34:18.195 Uttam Kumaran: I’ve interview. I’ve interviewed people for friends and but I just did it for free. I should have charged them.

415 00:34:20.380 00:34:21.210 Agustin: Yeah.

416 00:34:22.350 00:34:23.150 Agustin: bye.

417 00:34:23.159 00:34:23.619 Uttam Kumaran: Okay, and.

418 00:34:23.620 00:34:26.600 Agustin: Go to S. 3 right there. Let’s go backwards.

419 00:34:28.179 00:34:28.849 Uttam Kumaran: Oh, yeah.

420 00:34:36.429 00:34:37.519 Uttam Kumaran: Okay. Anyone.

421 00:34:38.880 00:34:39.520 Agustin: Yeah.

422 00:34:48.840 00:34:52.070 Agustin: you can call it something, website.

423 00:34:53.469 00:34:55.110 Agustin: elementary website.

424 00:34:56.530 00:34:58.030 Agustin: full part. Yeah.

425 00:35:00.300 00:35:00.880 Uttam Kumaran: Yeah.

426 00:35:01.300 00:35:02.040 Uttam Kumaran: Yep.

427 00:35:02.320 00:35:05.099 Agustin: Yeah, that’s it. You just create it like that.

428 00:35:11.080 00:35:12.490 Uttam Kumaran: I don’t have to do any of this.

429 00:35:12.850 00:35:15.230 Agustin: No, no, that’s okay.

430 00:35:18.000 00:35:19.080 Agustin: for now. Yeah.

431 00:35:19.530 00:35:24.259 Agustin: Now you just up go to the racket and upload the file.

432 00:35:43.720 00:35:44.390 Uttam Kumaran: Get it.

433 00:35:56.540 00:35:57.300 Uttam Kumaran: Okay.

434 00:35:57.860 00:35:58.540 Uttam Kumaran: Thank you.

435 00:35:59.610 00:36:01.100 Agustin: Yeah, he

436 00:36:01.300 00:36:02.780 Agustin: upload it. And

437 00:36:06.750 00:36:10.689 Agustin: and after that you should go to a bucket

438 00:36:11.850 00:36:13.140 Agustin: destination.

439 00:36:13.690 00:36:14.550 Agustin: Yeah.

440 00:36:14.780 00:36:17.399 Agustin: click, it go to properties.

441 00:36:19.500 00:36:23.229 Agustin: Yeah. A bit below to the bottom.

442 00:36:27.580 00:36:28.750 Agustin: That’s it.

443 00:36:33.250 00:36:36.650 Agustin: Wow, that’s weird. Can you go to

444 00:36:37.890 00:36:39.560 Agustin: permissions?

445 00:36:44.040 00:36:46.190 Agustin: Okay, let let me try to access

446 00:36:46.970 00:36:49.489 Agustin: the back end. Not yeah.

447 00:37:04.780 00:37:06.739 Agustin: Which region is it

448 00:37:08.650 00:37:09.490 Agustin: us? Where.

449 00:37:09.490 00:37:12.479 Uttam Kumaran: Region. I don’t think we even specified the region.

450 00:37:13.690 00:37:15.460 Uttam Kumaran: Oh, it’s it’s us East Swan.

451 00:37:23.490 00:37:24.270 Agustin: Okay.

452 00:37:29.620 00:37:33.653 Agustin: can you go again to the main bucket to the bucket?

453 00:37:35.430 00:37:39.919 Agustin: yeah. Go to quick, click on that, then properties

454 00:37:40.850 00:37:45.010 Agustin: and go to the bottom where it says, static website hosting

455 00:38:00.040 00:38:00.820 Uttam Kumaran: That’s it.

456 00:38:01.000 00:38:03.058 Agustin: Yeah, I think that’s it.

457 00:38:04.140 00:38:05.939 Agustin: Just a few minutes

458 00:38:06.420 00:38:06.910 Agustin: you go to.

459 00:38:06.910 00:38:09.650 Uttam Kumaran: And then how do I? How do we make this password protected.

460 00:38:10.450 00:38:16.309 Agustin: Oh, yeah, that’s a very good question. It’s not very straightforward.

461 00:38:16.310 00:38:16.980 Uttam Kumaran: Okay.

462 00:38:17.370 00:38:18.540 Agustin: A bad

463 00:38:18.820 00:38:21.059 Agustin: depends on how you want to handle it.

464 00:38:21.240 00:38:23.870 Agustin: You can use a cloud from distribution.

465 00:38:23.900 00:38:25.750 Agustin: I use lambda Edge

466 00:38:26.540 00:38:28.370 Agustin: to execute the function

467 00:38:29.020 00:38:31.350 Agustin: to validate the user and password.

468 00:38:31.710 00:38:32.055 Uttam Kumaran: Okay.

469 00:38:33.070 00:38:35.820 Agustin: Or you can use Octa authentication.

470 00:38:37.200 00:38:39.419 Agustin: You know, Octa, what Octa is.

471 00:38:39.570 00:38:40.190 Uttam Kumaran: Yeah.

472 00:38:41.080 00:38:47.304 Agustin: Yeah, you can. I just deploy a website this website using Octa in the company.

473 00:38:48.260 00:38:49.050 Agustin: Yeah.

474 00:38:50.260 00:38:51.990 Uttam Kumaran: Oh, octo office, free.

475 00:38:54.520 00:38:57.709 Agustin: I I mean, the company pays for it.

476 00:38:57.720 00:39:01.369 Agustin: But you can create the trial account for 30 days

477 00:39:02.338 00:39:04.080 Agustin: track. How much it costs

478 00:39:04.130 00:39:05.279 Agustin: per user.

479 00:39:07.900 00:39:12.199 Agustin: Yeah, I think that we can create a simple user and password.

480 00:39:13.010 00:39:13.670 Uttam Kumaran: Okay.

481 00:39:14.550 00:39:16.632 Agustin: Yeah, I I can do that.

482 00:39:17.640 00:39:20.403 Uttam Kumaran: So if I go here and I click on this

483 00:39:20.960 00:39:23.220 Uttam Kumaran: click on this and click on this.

484 00:39:25.100 00:39:27.760 Agustin: I don’t think that’s the way to go. Let me see.

485 00:39:28.820 00:39:29.880 Agustin: And what

486 00:39:31.290 00:39:34.139 Agustin: the link is for this website

487 00:39:34.990 00:39:36.280 Agustin: should be on the same.

488 00:39:37.105 00:39:37.360 Uttam Kumaran: Like.

489 00:39:37.360 00:39:37.890 Agustin: Reasonable.

490 00:39:38.050 00:39:38.810 Agustin: Yeah.

491 00:39:42.400 00:39:44.649 Agustin: And if we cannot access.

492 00:39:44.770 00:39:45.790 Agustin: that’s

493 00:39:46.790 00:39:48.929 Agustin: because we have to put

494 00:39:50.330 00:39:53.929 Agustin: the permissions to allow public access.

495 00:39:54.980 00:39:56.330 Agustin: So I will do that.

496 00:40:00.720 00:40:01.860 Agustin: if you agree.

497 00:40:03.530 00:40:04.160 Agustin: Yeah.

498 00:40:04.160 00:40:08.529 Uttam Kumaran: Can we make it so? Yeah, if we can have like simple sign on, that’d be great.

499 00:40:13.890 00:40:14.590 Uttam Kumaran: Paul.

500 00:40:26.700 00:40:29.159 Uttam Kumaran: So if these cloud front and lambda edge.

501 00:40:30.450 00:40:31.080 Agustin: Yeah.

502 00:40:35.670 00:40:39.239 Agustin: I’m not sure what’s going on. To be honest.

503 00:40:40.020 00:40:41.240 Agustin: it’s really weird.

504 00:40:48.990 00:40:51.220 Uttam Kumaran: You think we can also do it and get up pages.

505 00:40:53.240 00:40:56.649 Agustin: Yeah, I’m not familiar with it that much, but probably yes.

506 00:41:08.300 00:41:09.630 Uttam Kumaran: Okay.

507 00:41:34.490 00:41:36.493 Uttam Kumaran: okay. I’m gonna try to do the

508 00:41:37.210 00:41:43.620 Agustin: Yeah, I think that sorry. Yeah, yeah, we can do it. I I will add the bucket policy right here. I forgot about that.

509 00:41:44.060 00:41:44.540 Uttam Kumaran: Cool

510 00:41:47.000 00:41:49.660 Agustin: Let me see, what’s the name for this?

511 00:42:02.540 00:42:05.410 Agustin: Yeah, I think it’s working now. Yeah, it is.

512 00:42:07.109 00:42:07.429 Uttam Kumaran: But.

513 00:42:16.190 00:42:16.910 Agustin: Paul.

514 00:42:17.680 00:42:18.520 Agustin: yeah.

515 00:42:23.270 00:42:24.759 Agustin: is it working fine?

516 00:42:26.270 00:42:26.900 Uttam Kumaran: Yep.

517 00:42:27.710 00:42:29.780 Uttam Kumaran: So we probably follow like.

518 00:42:30.090 00:42:33.970 Uttam Kumaran: go to aws. Lambda, create function, use blueprint.

519 00:42:35.440 00:42:37.710 Uttam Kumaran: choose basic lambda edge.

520 00:42:41.150 00:42:41.860 Agustin: Yeah.

521 00:42:49.940 00:42:52.530 Uttam Kumaran: Basic user password deploy it.

522 00:42:55.800 00:42:56.250 Agustin: Sorry, what.

523 00:42:56.250 00:42:57.899 Uttam Kumaran: Front distribution.

524 00:42:59.100 00:42:59.960 Agustin: Yeah.

525 00:43:01.760 00:43:03.160 Agustin: Why are you asking?

526 00:43:03.630 00:43:06.700 Uttam Kumaran: No, no, no, I’m just reading. I’ll probably end up. I’ll try to do it later.

527 00:43:07.290 00:43:10.140 Agustin: Yeah, I mean, I can help if you need it tomorrow.

528 00:43:10.740 00:43:11.099 Uttam Kumaran: Nick.

529 00:43:11.770 00:43:12.245 Agustin: Yeah.

530 00:43:13.030 00:43:14.896 Uttam Kumaran: Let’s do it tomorrow sometime. This is great.

531 00:43:15.690 00:43:16.972 Agustin: Yeah, it is.

532 00:43:17.400 00:43:19.754 Uttam Kumaran: So what I’m gonna do, what I’m gonna do is

533 00:43:23.980 00:43:28.183 Uttam Kumaran: I’m going to actually have that Github action right

534 00:43:28.910 00:43:31.160 Uttam Kumaran: to this. Aws.

535 00:43:31.250 00:43:32.579 Uttam Kumaran: S 3 bucket.

536 00:43:41.340 00:43:43.130 Agustin: Okay, well, I have to go now.

537 00:43:43.665 00:43:46.219 Agustin: But yeah, thank you for this time.

538 00:43:46.480 00:43:47.500 Uttam Kumaran: Thank you for your help.

539 00:43:48.380 00:43:50.600 Agustin: Yeah. Well, see you tomorrow.

540 00:43:50.760 00:43:51.969 Agustin: Have a good night.

541 00:43:51.970 00:43:52.730 Uttam Kumaran: See tomorrow.

542 00:43:53.050 00:43:54.160 Uttam Kumaran: Thank you. Bye.