Meeting Title: Zoom-Meeting Date: 2024-04-29 Meeting participants: Agustin, Uttam Kumaran


WEBVTT

1 00:00:19.680 00:00:20.600 Agustin: Hello!

2 00:00:22.750 00:00:24.600 Uttam Kumaran: Hey? Good morning! How’s it going.

3 00:00:25.200 00:00:28.857 Agustin: I’m doing good. I’m a bit sick today, but I’m doing.

4 00:00:30.310 00:00:31.659 Uttam Kumaran: Sorry. How do you feel?

5 00:00:32.759 00:00:37.170 Agustin: I feel good. I have a lot of like bit of calf and

6 00:00:37.799 00:00:41.489 Agustin: a bit of I don’t know how to say it in English, like

7 00:00:41.969 00:00:43.169 Agustin: conned.

8 00:00:43.170 00:00:44.320 Uttam Kumaran: Okay. Okay.

9 00:00:44.710 00:00:45.620 Agustin: Yeah, I am

10 00:00:46.230 00:00:47.690 Agustin: so. But I’m good.

11 00:00:49.577 00:00:52.350 Uttam Kumaran: Cool. So maybe we can just hop right into stuff.

12 00:00:53.120 00:00:54.759 Agustin: Sure. Yeah. Yeah. Yeah.

13 00:00:56.885 00:00:59.469 Uttam Kumaran: So I think the big thing that we wanted to talk about

14 00:01:00.515 00:01:01.430 Uttam Kumaran: today

15 00:01:01.820 00:01:02.915 Uttam Kumaran: was

16 00:01:04.370 00:01:06.070 Uttam Kumaran: related to

17 00:01:06.260 00:01:10.680 Uttam Kumaran: how do we do the adv like data share process.

18 00:01:11.070 00:01:12.070 Agustin: That’s right.

19 00:01:12.977 00:01:20.750 Uttam Kumaran: So in particular, one thing that we wanted to do is we have right now, the 13 F data is being shared

20 00:01:20.850 00:01:24.480 Uttam Kumaran: from our internal instance to the client.

21 00:01:25.011 00:01:27.820 Uttam Kumaran: We basically want to replicate that same

22 00:01:28.020 00:01:29.220 Uttam Kumaran: process.

23 00:01:29.512 00:01:32.769 Uttam Kumaran: So one thing is, if you want to drive, you can actually pull up.

24 00:01:34.760 00:01:39.630 Uttam Kumaran: you can actually pull up our internal snowflake. And I can show you where the private share stuff is.

25 00:01:40.320 00:01:42.979 Agustin: Yeah, I will share my screen. Now.

26 00:01:43.200 00:01:44.530 Agustin: Adam, yeah.

27 00:01:51.350 00:01:52.900 Agustin: can you see my screen.

28 00:01:53.851 00:01:56.170 Uttam Kumaran: I can. But yeah, I can see it now. Yeah.

29 00:01:56.900 00:02:00.549 Uttam Kumaran: And if you go yeah, if you go to private sharing.

30 00:02:01.710 00:02:03.829 Agustin: Yeah, 1 min.

31 00:02:14.743 00:02:21.320 Uttam Kumaran: Yeah. So you should see. So this is shared with us. But if you go to, shared by your account.

32 00:02:22.870 00:02:24.430 Uttam Kumaran: you should see?

33 00:02:24.540 00:02:30.019 Uttam Kumaran: Exactly. So you should see both the sec secure share, which is the second one

34 00:02:30.941 00:02:34.310 Uttam Kumaran: and the fema share. So this includes both

35 00:02:34.420 00:02:38.230 Uttam Kumaran: what we’re sharing externally, and what we’re sharing privately.

36 00:02:38.240 00:02:41.609 Uttam Kumaran: so externally means what we’re sharing on the marketplace

37 00:02:41.970 00:02:46.740 Uttam Kumaran: and and privately means what we’re sharing direct to another snowflake account.

38 00:02:47.070 00:02:54.329 Uttam Kumaran: And so that that is without any cost. But you can. Just you just have to basically specify the account, URL,

39 00:02:54.580 00:02:58.180 Uttam Kumaran: and the database will just show up in their account.

40 00:02:58.781 00:03:02.319 Uttam Kumaran: So one thing, if you click on the one right above.

41 00:03:03.209 00:03:03.789 Agustin: He said

42 00:03:06.190 00:03:07.619 Agustin: this one. Sorry.

43 00:03:07.760 00:03:08.950 Uttam Kumaran: Yeah. The second one.

44 00:03:09.460 00:03:10.540 Agustin: Sorry I

45 00:03:22.660 00:03:28.659 Uttam Kumaran: So what you’re gonna see here is you’re gonna see what that we’re sharing it to. Dfd, which is the client.

46 00:03:29.070 00:03:32.749 Uttam Kumaran: And there’s the account. And then you can see the data that we’re actually sharing below.

47 00:03:34.120 00:03:34.490 Agustin: Yeah.

48 00:03:36.460 00:03:39.910 Uttam Kumaran: So it’s actually not that much more complicated process than that.

49 00:03:40.623 00:03:46.270 Uttam Kumaran: And so what what like my proposal would be is that for the for

50 00:03:46.720 00:03:57.970 Uttam Kumaran: the Adv data. It would be great if we can also have that accessible in our instance, so that we can both send that we could also send that to the marketplace.

51 00:03:59.320 00:04:03.740 Agustin: Yeah, I mean, if we’re talking about the actual data.

52 00:04:04.880 00:04:07.620 Agustin: let me show you right here 1 min.

53 00:04:09.870 00:04:13.149 Agustin: We already have it here in our instance.

54 00:04:13.590 00:04:14.750 Uttam Kumaran: Okay. Great.

55 00:04:15.250 00:04:17.369 Agustin: Yeah, that’s what I mean. On Friday.

56 00:04:17.370 00:04:21.210 Uttam Kumaran: I thought it was on the other. I thought it was on the client, instance or no.

57 00:04:22.089 00:04:24.059 Agustin: Yeah, but I migrated it.

58 00:04:24.230 00:04:25.660 Uttam Kumaran: Oh, nice. Okay, okay.

59 00:04:26.470 00:04:29.569 Uttam Kumaran: okay, great. So then, I mean, one thing that we could do.

60 00:04:29.570 00:04:30.590 Agustin: So no!

61 00:04:31.070 00:04:31.940 Uttam Kumaran: Yeah. Go ahead.

62 00:04:34.190 00:04:37.940 Agustin: Sorry I I was saying that after this I

63 00:04:38.310 00:04:41.760 Agustin: and I didn’t create it so far. But we I

64 00:04:42.310 00:04:44.440 Agustin: sorry I created these

65 00:04:44.580 00:04:47.050 Agustin: script. I didn’t run it yet.

66 00:04:47.280 00:04:50.019 Agustin: but I was trying to create

67 00:04:50.110 00:04:53.440 Agustin: other database, and these secure views

68 00:04:53.720 00:04:56.219 Agustin: so that we can share these tables.

69 00:04:56.950 00:05:14.021 Uttam Kumaran: Yeah. So what? Let me send you now, some of the scripts that I ran for for creating the for creating the 13 S data. And that way, you can have those. And we can start to use those. Basically, how do you do the trial?

70 00:05:14.840 00:05:16.540 Uttam Kumaran: let me show you 1 s.

71 00:05:16.810 00:05:23.610 Agustin: Yeah, I, okay. I think I already saw them. But it’s okay. If they send them again, it can be useful.

72 00:05:26.400 00:05:28.380 Agustin: Yeah, I had 2 concerns.

73 00:05:28.990 00:05:32.819 Agustin: The first one is that we don’t really know about the schema

74 00:05:33.340 00:05:34.120 Agustin: or what

75 00:05:35.090 00:05:37.389 Agustin: the columns? Some colors mean. Right?

76 00:05:37.902 00:05:39.289 Agustin: What is 5

77 00:05:39.480 00:05:42.899 Agustin: 5 page. I mean we don’t really know. So we.

78 00:05:42.900 00:05:43.300 Uttam Kumaran: Yeah.

79 00:05:43.645 00:05:43.990 Agustin: Then

80 00:05:44.180 00:05:45.380 Agustin: documentation.

81 00:05:48.100 00:05:54.979 Uttam Kumaran: Yeah, I see what you mean. No. So we definitely need that. I mean, that’s the thing. I don’t have time to to go through and look at that.

82 00:05:55.458 00:06:05.629 Uttam Kumaran: But I don’t know. Maybe we can keep it in a backlog ticket. I just wanna make sure we have all the scripts to create the share. And then that way we can just add any of these tasks to backlog.

83 00:06:07.770 00:06:11.549 Agustin: Yeah, I agree, we have to consider we have lots of tables.

84 00:06:11.550 00:06:13.640 Uttam Kumaran: Yeah, yeah, no. I agree.

85 00:06:14.000 00:06:14.640 Agustin: Yeah.

86 00:06:16.670 00:06:22.570 Uttam Kumaran: So that’s the thing I wanna make sure every we have understanding of what all the columns are and how to do joins and things like that. But

87 00:06:23.167 00:06:26.379 Uttam Kumaran: you know, I think we can definitely get there.

88 00:06:28.150 00:06:30.030 Uttam Kumaran: Let me just share

89 00:06:31.380 00:06:32.990 Uttam Kumaran: on one thing.

90 00:07:00.160 00:07:01.420 Uttam Kumaran: Okay.

91 00:07:07.440 00:07:13.010 Uttam Kumaran: yeah. So do you see the you see the sec. 13 F. Worksheet.

92 00:07:14.400 00:07:17.210 Uttam Kumaran: If you go to all, you go to all worksheets.

93 00:07:18.860 00:07:21.179 Agustin: Oh, that’s a good question. Let me.

94 00:07:23.690 00:07:26.240 Uttam Kumaran: I don’t even know. Can I even share this with you?

95 00:07:27.270 00:07:28.570 Agustin: I’m not sure.

96 00:07:29.850 00:07:31.820 Agustin: Maybe probably you could.

97 00:07:32.790 00:07:34.830 Uttam Kumaran: Let me see how I can do that.

98 00:07:46.005 00:07:47.425 Uttam Kumaran: Oh, yes, share. Okay.

99 00:07:56.220 00:07:58.409 Uttam Kumaran: okay, wait take a look. Now.

100 00:07:59.520 00:08:00.155 Agustin: Sure.

101 00:08:01.320 00:08:04.390 Uttam Kumaran: You should see a 13 half sc. 13 half at the bottom. Yeah.

102 00:08:04.390 00:08:05.589 Agustin: It’s working. Yeah.

103 00:08:07.670 00:08:08.490 Agustin: great.

104 00:08:10.730 00:08:18.539 Uttam Kumaran: So you should. Yeah, you basically have all this. So I’ll let me just walk you through what this worksheet is. Basically so

105 00:08:18.946 00:08:23.210 Uttam Kumaran: sorry. It’s kind of like a little bit all over the place. But one thing I did was

106 00:08:23.270 00:08:28.270 Uttam Kumaran: I was creating I was creating the actual schema.

107 00:08:28.280 00:08:29.786 Uttam Kumaran: creating the

108 00:08:32.177 00:08:36.079 Uttam Kumaran: so creating the schema creating the tables.

109 00:08:36.230 00:08:38.599 Uttam Kumaran: Sec. Prod info table.

110 00:08:38.679 00:08:40.049 Uttam Kumaran: and then

111 00:08:41.940 00:08:46.590 Uttam Kumaran: then I’m renaming them to to. I’m creating the secure views from them.

112 00:08:48.720 00:08:50.719 Uttam Kumaran: and so the secure view

113 00:08:52.600 00:08:54.204 Uttam Kumaran: are what gets

114 00:08:56.023 00:08:58.940 Uttam Kumaran: shared via the sec share.

115 00:08:59.777 00:09:02.169 Uttam Kumaran: And then that’s fine.

116 00:09:02.590 00:09:04.809 Uttam Kumaran: These are the grants.

117 00:09:05.330 00:09:13.939 Uttam Kumaran: So granting usage on the schema and the table to the share, and then finally, at the bottom, is adding all the columns.

118 00:09:16.210 00:09:19.040 Agustin: Okay, that makes sense.

119 00:09:20.440 00:09:24.199 Uttam Kumaran: Yeah, so these are actually not necessary.

120 00:09:24.200 00:09:24.850 Agustin: A.

121 00:09:25.870 00:09:28.200 Agustin: You mean these comments, or.

122 00:09:28.200 00:09:32.410 Uttam Kumaran: No, no, yeah, exactly. So those are. Those are the actual columns on the table.

123 00:09:33.260 00:09:33.900 Agustin: Yeah.

124 00:09:34.730 00:09:36.650 Uttam Kumaran: And the view just sits on top of the table.

125 00:09:39.570 00:09:40.879 Agustin: Yeah, I think we got

126 00:09:40.950 00:09:43.830 Agustin: to this like this directly, right?

127 00:09:45.520 00:09:46.210 Uttam Kumaran: Yep.

128 00:09:47.390 00:09:50.590 Uttam Kumaran: So, yeah, I actually just adjust the room. Yeah.

129 00:09:50.590 00:09:51.460 Agustin: Have another.

130 00:09:52.140 00:09:52.790 Uttam Kumaran: Yeah.

131 00:09:55.070 00:09:58.990 Agustin: Yeah, yeah, yeah, I have another kind of concern, which is.

132 00:09:59.340 00:10:03.069 Agustin: and we we don’t really process the data.

133 00:10:03.360 00:10:08.659 Agustin: And one of the reasons where I didn’t want to spend too much time working on this.

134 00:10:09.260 00:10:16.569 Agustin: So to make things simpler, I just read the data as is since it was cleaned. So.

135 00:10:16.570 00:10:16.910 Uttam Kumaran: Okay.

136 00:10:16.910 00:10:19.439 Agustin: That’d be. We don’t have any

137 00:10:19.710 00:10:27.780 Agustin: additional columns like year this case. So I’m not sure if will we able to filter data if that makes sense.

138 00:10:27.780 00:10:32.648 Uttam Kumaran: That makes sense. So one thing I’m just gonna I’m gonna create a ticket in the backlog. And then we can.

139 00:10:33.250 00:10:36.000 Uttam Kumaran: I just wanna come back and take a look at this.

140 00:10:36.060 00:10:38.539 Uttam Kumaran: So one is adv data share

141 00:10:41.920 00:10:45.739 Uttam Kumaran: and all the all the kind of scripts for this are they in the internal tools.

142 00:10:47.804 00:10:51.265 Agustin: That’s a good question. No, I think I use.

143 00:10:51.650 00:10:52.900 Uttam Kumaran: Data provider. They come.

144 00:10:52.900 00:10:54.740 Agustin: Provider rico. Let me check.

145 00:10:55.220 00:10:56.300 Uttam Kumaran: Yeah, yeah.

146 00:10:56.710 00:10:59.370 Agustin: Yeah, yeah, yeah, I created, yeah.

147 00:11:00.540 00:11:07.369 Uttam Kumaran: Okay? So the big things is, we want to do documentation on all columns and tables.

148 00:11:07.630 00:11:11.980 Uttam Kumaran: We want to add ancillary want to add

149 00:11:12.170 00:11:16.660 Uttam Kumaran: extra fields like year and month.

150 00:11:30.040 00:11:33.750 Uttam Kumaran: Okay? So I’m just gonna create this. Wait that way. It’s here.

151 00:11:40.280 00:11:42.510 Agustin: Yeah, that looks good. Yeah.

152 00:11:53.280 00:11:55.349 Uttam Kumaran: Why is it showing up.

153 00:12:00.320 00:12:01.170 Agustin: Where.

154 00:12:01.921 00:12:04.799 Uttam Kumaran: I’m just trying to see why it’s not showing up in the project.

155 00:12:09.270 00:12:10.030 Uttam Kumaran: Oh.

156 00:12:11.090 00:12:15.849 Uttam Kumaran: theater provider issues AV data share

157 00:12:17.100 00:12:19.070 Uttam Kumaran: project tracker

158 00:12:21.120 00:12:22.380 Uttam Kumaran: labels.

159 00:12:25.670 00:12:26.870 Uttam Kumaran: Hmm!

160 00:12:55.570 00:12:57.389 Uttam Kumaran: Where is it? I don’t know

161 00:13:01.485 00:13:02.850 Uttam Kumaran: what the heck.

162 00:13:03.200 00:13:04.767 Agustin: Let me check

163 00:13:05.290 00:13:07.260 Uttam Kumaran: I don’t know why it’s not showing up in there.

164 00:13:18.890 00:13:20.580 Agustin: Isn’t it here, or.

165 00:13:20.580 00:13:21.850 Uttam Kumaran: Oh, it is here.

166 00:13:22.470 00:13:24.179 Uttam Kumaran: but maybe I have to do

167 00:13:35.310 00:13:37.860 Uttam Kumaran: oh, I see it, I say, never mind, never mind. Sorry.

168 00:13:38.210 00:13:39.190 Uttam Kumaran: Okay.

169 00:13:39.860 00:13:40.590 Agustin: Great.

170 00:13:41.080 00:13:43.929 Uttam Kumaran: Okay, cool. I know we’re about to talk about.

171 00:13:43.930 00:13:45.560 Agustin: The native apps to.

172 00:13:45.560 00:13:47.996 Uttam Kumaran: But I wanted to talk also a little bit about

173 00:13:49.334 00:13:54.150 Uttam Kumaran: I wanted to talk a little about probably the plan for the week.

174 00:13:55.670 00:13:56.130 Agustin: Sure.

175 00:13:56.980 00:14:01.300 Uttam Kumaran: So the big thing is, I wanted to just make sure that

176 00:14:02.910 00:14:08.540 Uttam Kumaran: they had everything they needed for this Adv. The other thing I wanted to start looking at is

177 00:14:08.570 00:14:10.720 Uttam Kumaran: Rag and snowflake.

178 00:14:13.160 00:14:16.179 Uttam Kumaran: So doing, some of the AI features in Snowflake.

179 00:14:17.210 00:14:21.640 Uttam Kumaran: The one thing that would be great, and I’m just gonna send you some links, and then

180 00:14:22.060 00:14:25.350 Uttam Kumaran: I think it would be great if me, you and Surf can meet tomorrow.

181 00:14:28.430 00:14:30.690 Uttam Kumaran: is, we want to do something like

182 00:14:33.040 00:14:34.065 Uttam Kumaran: This

183 00:14:38.850 00:14:42.981 Uttam Kumaran: Hello! Hang 1 s sorry minutes.

184 00:14:44.010 00:14:45.599 Uttam Kumaran: Can you hear your bedroom?

185 00:14:47.820 00:14:50.637 Agustin: Hello, yeah, kind of I can hear you.

186 00:14:52.210 00:14:54.010 Uttam Kumaran: Yeah, I can hear. Have a good one.

187 00:14:59.420 00:15:00.690 Agustin: Sorry. What do you mean?

188 00:15:07.020 00:15:10.109 Uttam Kumaran: Sorry. There’s like a fire alarm going out in my building.

189 00:15:11.020 00:15:14.770 Agustin: Yeah, I couldn’t wait. Scare like what’s going on.

190 00:15:15.940 00:15:18.150 Uttam Kumaran: I’m I’m I’m moving out of this

191 00:15:18.280 00:15:20.090 Uttam Kumaran: dumb buildings and.

192 00:15:21.070 00:15:25.570 Agustin: Yeah, we don’t have fire alarms here. Yeah.

193 00:15:26.540 00:15:27.540 Agustin: Sylvia.

194 00:15:29.620 00:15:31.610 Agustin: yeah, we were discussing these

195 00:15:32.040 00:15:34.220 Agustin: Iraq and Snowflake.

196 00:15:34.520 00:15:38.400 Uttam Kumaran: Yeah. So let me let me. I’m gonna send it to you in that in the asset link channel.

197 00:15:39.000 00:15:39.870 Agustin: Sure.

198 00:15:47.870 00:15:49.230 Agustin: Okay, great.

199 00:15:51.630 00:15:53.670 Agustin: I will take a look today.

200 00:15:55.080 00:16:02.009 Uttam Kumaran: Yeah. So the basic goal is, we want to do rag over the Adv. Docs.

201 00:16:04.170 00:16:04.880 Agustin: Yes.

202 00:16:04.880 00:16:12.170 Uttam Kumaran: And and I don’t know if you’ve like taken a look at any of the AI stuff. But basically we wanna try to be able to ask questions over those documents.

203 00:16:12.440 00:16:17.289 Uttam Kumaran: And so this sort of rag process is like one of the main processes.

204 00:16:18.023 00:16:22.960 Uttam Kumaran: The other one that’s interesting is let me show you

205 00:16:32.120 00:16:32.540 Agustin: Act.

206 00:17:07.903 00:17:08.989 Uttam Kumaran: One sec.

207 00:17:56.569 00:17:58.869 Uttam Kumaran: And this one’s also

208 00:18:00.419 00:18:01.139 Uttam Kumaran: go.

209 00:18:10.070 00:18:10.900 Agustin: Great.

210 00:18:13.000 00:18:31.079 Uttam Kumaran: So, yeah, if you’d like, if you don’t mind taking a look at those, and I can create issues for those. And so that would be our goal for this week mainly is to try to get one of those up and running on the Adv. Docs. But let’s maybe we can. If you wanna take a look today, maybe mean you, you and sir can me tomorrow, just to get a sense of like

211 00:18:31.330 00:18:35.559 Uttam Kumaran: what you looked at and like what’s possible. So then we could probably let you run from there.

212 00:18:36.710 00:18:40.389 Agustin: Sure. Yeah, I I will do that. I will read it today.

213 00:18:40.640 00:18:41.090 Uttam Kumaran: Okay.

214 00:18:41.090 00:18:44.105 Agustin: Not sure why. It takes 1 h to read.

215 00:18:44.770 00:18:46.505 Uttam Kumaran: Yeah, I don’t know.

216 00:18:48.900 00:18:52.339 Uttam Kumaran: yeah, I know. I think it’s more like 1 h to actually do the thing.

217 00:18:52.950 00:18:55.338 Agustin: Oh, yeah, yeah, yeah. Makes sense. Yeah.

218 00:18:56.930 00:18:58.180 Agustin: yeah, you’re right.

219 00:18:59.855 00:19:00.730 Agustin: Yeah.

220 00:19:01.820 00:19:04.237 Agustin: I’m not sure if I have other questions.

221 00:19:04.870 00:19:05.199 Uttam Kumaran: Okay.

222 00:19:07.530 00:19:09.165 Uttam Kumaran: okay, yeah. Let’s

223 00:19:09.760 00:19:11.543 Uttam Kumaran: We could probably just

224 00:19:12.930 00:19:14.500 Uttam Kumaran: chat in the next meeting. Then.

225 00:19:15.410 00:19:16.830 Agustin: Sure. Yeah.

226 00:19:17.110 00:19:17.720 Uttam Kumaran: Okay.

227 00:19:17.960 00:19:18.500 Uttam Kumaran: okay, right?

228 00:19:18.500 00:19:18.880 Agustin: Thinking.

229 00:19:19.280 00:19:19.680 Uttam Kumaran: Sorry.

230 00:19:19.910 00:19:20.730 Uttam Kumaran: That’s fine.