Meeting Title: ABC Snowflake Data Access Sync Date: 2026-02-10 Meeting participants: Pranav Narahari, Casie Aviles, Mustafa Raja
WEBVTT
1 00:01:02.200 ⇒ 00:01:03.230 Casie Aviles: Hey, guys.
2 00:01:05.430 ⇒ 00:01:06.110 Mustafa Raja: Hey.
3 00:01:10.330 ⇒ 00:01:11.200 Mustafa Raja: Hey?
4 00:01:13.210 ⇒ 00:01:23.800 Pranav Narahari: Whoops, sorry, I was muted. Hey guys, I just had a couple questions with navigating Snowflake, and for this task, just, getting in the weekly data.
5 00:01:23.850 ⇒ 00:01:33.930 Pranav Narahari: the categorization stuff and everything seems pretty straightforward. I was already able to do that with, like, some previous data, but… yeah, just pulling it in from Snowflake would be helpful.
6 00:01:37.350 ⇒ 00:01:39.629 Pranav Narahari: Yeah, so, let me…
7 00:01:40.970 ⇒ 00:01:42.840 Mustafa Raja: Yes, sir, do you want to share screen?
8 00:01:43.070 ⇒ 00:01:47.110 Pranav Narahari: Yeah, I’ll share my screen real quick. I’m just signing in once.
9 00:01:47.110 ⇒ 00:01:47.460 Mustafa Raja: Yeah, yeah.
10 00:02:29.610 ⇒ 00:02:30.410 Pranav Narahari: Okay.
11 00:02:39.010 ⇒ 00:02:39.720 Casie Aviles: Yeah.
12 00:02:40.770 ⇒ 00:02:42.529 Pranav Narahari: You guys can see smoother? That’s phenomenal.
13 00:02:42.530 ⇒ 00:02:43.949 Casie Aviles: Yeah, we can, we can see it, you know.
14 00:02:43.950 ⇒ 00:02:47.039 Mustafa Raja: Yeah, let’s go into… I feel let’s go into projects.
15 00:02:48.350 ⇒ 00:02:49.080 Pranav Narahari: jokes.
16 00:02:53.580 ⇒ 00:02:55.039 Mustafa Raja: And then, at the bottom, I think.
17 00:02:55.040 ⇒ 00:02:57.970 Pranav Narahari: I see another workspace here. Oh, is it one of these?
18 00:02:59.050 ⇒ 00:03:03.329 Mustafa Raja: Wait, let me also, let me also log in and see what it is on my site.
19 00:03:05.590 ⇒ 00:03:10.379 Pranav Narahari: I wasn’t sure if Rico actually added me to the workspace, because I wasn’t able to see it here, but I wasn’t also…
20 00:03:10.770 ⇒ 00:03:13.630 Pranav Narahari: I didn’t spend a ton of time digging into this.
21 00:03:16.010 ⇒ 00:03:16.840 Mustafa Raja: Let me see…
22 00:03:17.290 ⇒ 00:03:17.830 Pranav Narahari: Okay.
23 00:03:34.620 ⇒ 00:03:37.699 Mustafa Raja: Yeah… you don’t have all of the tables.
24 00:03:42.660 ⇒ 00:03:46.690 Mustafa Raja: Casey, would you know how we would get him all the tables, though?
25 00:03:50.580 ⇒ 00:03:53.159 Casie Aviles: Hmm, let’s see… I remember, like, I…
26 00:03:53.430 ⇒ 00:03:56.069 Casie Aviles: Someone, like, has to, like, provide, like.
27 00:03:56.750 ⇒ 00:03:57.990 Mustafa Raja: Oh, yeah…
28 00:03:57.990 ⇒ 00:03:58.380 Casie Aviles: someone…
29 00:03:58.380 ⇒ 00:04:02.090 Mustafa Raja: The rules, right? An access or something, yeah, there’s rules thing.
30 00:04:03.750 ⇒ 00:04:10.040 Mustafa Raja: Yeah… Pranav, could you expand the sidebar here?
31 00:04:11.380 ⇒ 00:04:11.820 Pranav Narahari: Oh.
32 00:04:11.820 ⇒ 00:04:12.880 Casie Aviles: informational.
33 00:04:13.180 ⇒ 00:04:13.860 Pranav Narahari: This one?
34 00:04:14.380 ⇒ 00:04:17.220 Mustafa Raja: Yeah, okay, your role is public.
35 00:04:20.240 ⇒ 00:04:23.230 Mustafa Raja: And my role is transform.
36 00:04:24.020 ⇒ 00:04:26.559 Mustafa Raja: So maybe that would help.
37 00:04:27.220 ⇒ 00:04:28.960 Mustafa Raja: Casey, what’s your role?
38 00:04:32.010 ⇒ 00:04:34.180 Casie Aviles: It looks like mine’s sysadmin.
39 00:04:35.730 ⇒ 00:04:42.200 Mustafa Raja: Okay… I’m wondering if you would be able to, you know… Update.
40 00:04:42.200 ⇒ 00:04:42.860 Casie Aviles: Yeah.
41 00:04:42.860 ⇒ 00:04:43.460 Mustafa Raja: road.
42 00:04:44.940 ⇒ 00:04:51.199 Casie Aviles: But let me check, but I remember, like, before, I wasn’t able to do it, even when I was sysadmin.
43 00:04:52.240 ⇒ 00:04:58.450 Mustafa Raja: Okay, I think Utam… I think it’s, I think we have to do it with SQL, also.
44 00:04:59.190 ⇒ 00:05:02.930 Mustafa Raja: We have to write SQL to do that. I’m not sure, though.
45 00:05:03.440 ⇒ 00:05:04.130 Casie Aviles: Nope.
46 00:05:04.310 ⇒ 00:05:06.909 Casie Aviles: I’m seeing these, let me, let me…
47 00:05:07.920 ⇒ 00:05:11.069 Casie Aviles: Also send just a screenshot to you.
48 00:05:16.300 ⇒ 00:05:22.430 Casie Aviles: These are the… I don’t see Brandon off here yet, I think, yeah. Or wait, no, he’s here.
49 00:05:24.730 ⇒ 00:05:25.610 Casie Aviles: Okay.
50 00:05:26.280 ⇒ 00:05:29.159 Casie Aviles: Why do I give you access to ABC, though?
51 00:05:30.610 ⇒ 00:05:32.719 Pranav Narahari: It looks like I can change my role here in my…
52 00:05:32.970 ⇒ 00:05:35.360 Pranav Narahari: No, but I don’t have other options.
53 00:05:41.990 ⇒ 00:05:43.970 Casie Aviles: I’ll just give you admin.
54 00:05:44.460 ⇒ 00:05:46.549 Casie Aviles: Let’s see… Oh, I can’t…
55 00:05:50.680 ⇒ 00:05:56.880 Casie Aviles: I do believe we have an ABC service account, so I think we may be able to use that.
56 00:05:57.310 ⇒ 00:06:03.409 Casie Aviles: To pull data from… ABC, but yeah, let me, let me see if I can add you.
57 00:06:04.450 ⇒ 00:06:07.090 Casie Aviles: Because I can share my screen as well.
58 00:06:07.240 ⇒ 00:06:08.809 Mustafa Raja: Okay. Very dry skin.
59 00:06:09.110 ⇒ 00:06:10.280 Casie Aviles: I have an idea.
60 00:06:12.630 ⇒ 00:06:15.870 Casie Aviles: So this is what I can see right now.
61 00:06:19.260 ⇒ 00:06:20.200 Pranav Narahari: Gotcha.
62 00:06:24.110 ⇒ 00:06:24.870 Casie Aviles: grant…
63 00:06:29.630 ⇒ 00:06:33.839 Casie Aviles: Let me see if I can… no, I don’t think I can grab the rules.
64 00:06:37.220 ⇒ 00:06:41.760 Casie Aviles: Because I also tried Sysad, and it doesn’t let me.
65 00:06:44.040 ⇒ 00:06:49.199 Casie Aviles: I can access, like… For me, it looks like this, where…
66 00:06:49.790 ⇒ 00:06:50.820 Pranav Narahari: It’s actually allowing me to.
67 00:06:50.820 ⇒ 00:06:51.220 Casie Aviles: Jesus.
68 00:06:51.490 ⇒ 00:06:56.639 Pranav Narahari: Or at least am able to see the drop-down for role to grant.
69 00:06:57.310 ⇒ 00:07:01.960 Pranav Narahari: Were you able to click on that? I didn’t… I might have missed that on your screen share.
70 00:07:04.780 ⇒ 00:07:08.170 Casie Aviles: Yeah, let’s… The one right above.
71 00:07:08.420 ⇒ 00:07:11.670 Pranav Narahari: Yeah, that one. The shield.
72 00:07:12.570 ⇒ 00:07:13.520 Casie Aviles: Oh, yeah.
73 00:07:13.630 ⇒ 00:07:14.930 Casie Aviles: He’s doing his…
74 00:07:15.230 ⇒ 00:07:20.519 Pranav Narahari: Yeah, and then if you go into the three dots, Grant award. This one? Yeah.
75 00:07:22.140 ⇒ 00:07:26.500 Pranav Narahari: Okay, yeah, I see the same thing, but when you click on one, It doesn’t allow…
76 00:07:26.500 ⇒ 00:07:27.540 Casie Aviles: Doesn’t let me.
77 00:07:27.690 ⇒ 00:07:29.329 Pranav Narahari: Oh, I see, okay.
78 00:07:34.760 ⇒ 00:07:35.580 Pranav Narahari: Yeah.
79 00:07:35.580 ⇒ 00:07:41.290 Casie Aviles: What you should be seeing are these tables, ABC logs.
80 00:07:42.090 ⇒ 00:07:43.620 Pranav Narahari: Gotcha. Okay.
81 00:07:44.990 ⇒ 00:07:47.510 Casie Aviles: And ABC Ski and Life, yeah.
82 00:07:50.090 ⇒ 00:07:55.260 Casie Aviles: Yeah, the snowflake’s a bit confusing when… Adding…
83 00:07:57.800 ⇒ 00:08:05.029 Casie Aviles: I’m not sure who to, because last time I… Awish was asking the same thing for me, but I couldn’t grant him.
84 00:08:06.540 ⇒ 00:08:09.130 Pranav Narahari: Gotcha. So, who set y’all up? Was it with them?
85 00:08:09.790 ⇒ 00:08:13.469 Casie Aviles: Yeah, for me, like, it was UTAM when we first started.
86 00:08:13.640 ⇒ 00:08:15.439 Casie Aviles: Okay. With, snowflake.
87 00:08:15.440 ⇒ 00:08:16.249 Mustafa Raja: Yeah, me too.
88 00:08:17.350 ⇒ 00:08:18.480 Pranav Narahari: Gotcha.
89 00:08:21.300 ⇒ 00:08:22.040 Casie Aviles: Let’s see…
90 00:08:22.040 ⇒ 00:08:29.329 Pranav Narahari: So, is the issue that I’m not added to the right workspace? Because I don’t know if you got… for you guys, it says my workspace at the top.
91 00:08:29.330 ⇒ 00:08:31.569 Mustafa Raja: It’s just my workspace on my side also.
92 00:08:31.930 ⇒ 00:08:33.049 Pranav Narahari: It does, okay.
93 00:08:33.539 ⇒ 00:08:42.609 Mustafa Raja: And then, I have, a lot more tables than you, so it’s just… it’s just that you might not be… you might not have access to, you know…
94 00:08:42.819 ⇒ 00:08:45.499 Mustafa Raja: these databases that I have, you know?
95 00:08:45.950 ⇒ 00:08:46.690 Pranav Narahari: Yeah, that makes.
96 00:08:46.690 ⇒ 00:08:47.480 Casie Aviles: Yeah.
97 00:08:54.550 ⇒ 00:09:01.190 Casie Aviles: You should, I think you should at least, yeah, have access to… you should be given access to those tables, at least.
98 00:09:02.720 ⇒ 00:09:06.160 Casie Aviles: Yeah.
99 00:09:18.910 ⇒ 00:09:24.139 Pranav Narahari: Okay, is that something I can ask Rico for, or do you guys think that’s not really…
100 00:09:25.260 ⇒ 00:09:28.499 Mustafa Raja: I think… so it might be…
101 00:09:30.880 ⇒ 00:09:32.719 Mustafa Raja: Able to add you here now.
102 00:09:34.700 ⇒ 00:09:35.430 Pranav Narahari: Okay.
103 00:09:35.670 ⇒ 00:09:38.189 Pranav Narahari: Let me just give him a quick message right now.
104 00:09:42.370 ⇒ 00:09:49.990 Casie Aviles: Yeah… I remember I was also just using a service account for pulling data.
105 00:09:50.370 ⇒ 00:09:56.969 Casie Aviles: In case you… You won’t… you… you can… yeah, you can also use that for now while you…
106 00:09:57.540 ⇒ 00:09:58.380 Mustafa Raja: Yeah.
107 00:09:58.620 ⇒ 00:10:01.469 Mustafa Raja: Yeah, meanwhile, we figured out the permissions.
108 00:10:01.730 ⇒ 00:10:05.150 Mustafa Raja: You can ask Ursu to, you know, give you the data and stuff.
109 00:10:07.230 ⇒ 00:10:16.940 Mustafa Raja: And I think for weekly, for getting the data weekly, you’ll be using the… CLI, right? So…
110 00:10:19.030 ⇒ 00:10:21.059 Pranav Narahari: The CLI, yeah. Yeah, so I mean…
111 00:10:21.500 ⇒ 00:10:24.180 Pranav Narahari: What’s important to me is just that I can access this data.
112 00:10:24.290 ⇒ 00:10:25.320 Pranav Narahari: Yeah, so…
113 00:10:25.660 ⇒ 00:10:32.529 Mustafa Raja: I think, the, Casey, can we share the credits for… yeah, yeah, Casey’s sharing the credits for that.
114 00:10:33.340 ⇒ 00:10:33.660 Pranav Narahari: Okay.
115 00:10:33.660 ⇒ 00:10:37.150 Casie Aviles: this I’m just gonna copy that, and…
116 00:10:37.440 ⇒ 00:10:42.930 Pranav Narahari: Perfect. I think I have… the creds, actually. I’m already added to that one pass.
117 00:10:44.910 ⇒ 00:10:46.830 Mustafa Raja: Yeah, he’s just thinking.
118 00:10:47.040 ⇒ 00:10:48.310 Pranav Narahari: Okay, that works too.
119 00:10:48.560 ⇒ 00:10:56.199 Pranav Narahari: Okay. So yeah, then I can just set up the… the CLI, so I can.
120 00:10:56.200 ⇒ 00:10:57.030 Mustafa Raja: Oh, yeah.
121 00:10:58.110 ⇒ 00:11:08.760 Casie Aviles: I haven’t tried the CLI yet. When I was working on pulling data from Snowflake, I was just using their SDK, I think, yeah. And I use pretty much this same.
122 00:11:09.950 ⇒ 00:11:15.319 Casie Aviles: But yeah, if… you can also try CLI. Were you able to try it, Mustafa?
123 00:11:16.290 ⇒ 00:11:24.629 Mustafa Raja: Not yet, I haven’t had the use case for that right now, so… once I do have it, I will definitely try it out.
124 00:11:25.100 ⇒ 00:11:27.799 Casie Aviles: Oh, okay, yeah, I was just curious, like, how different…
125 00:11:27.920 ⇒ 00:11:34.339 Casie Aviles: But yeah, when I was pulling data, like, programmatically, I used Snowflake SDK, and I just used
126 00:11:34.620 ⇒ 00:11:36.699 Casie Aviles: this, I think, yeah, I believe it’s this service.
127 00:11:36.700 ⇒ 00:11:46.270 Mustafa Raja: I think the… I think the benefit of, having the CLI is, Cursor would be able to directly, query, right?
128 00:11:47.280 ⇒ 00:11:51.149 Mustafa Raja: Yeah. So you’re supposed to be able to understand, data, right?
129 00:11:52.760 ⇒ 00:11:53.770 Casie Aviles: Yeah, yeah, yeah.
130 00:11:54.470 ⇒ 00:12:02.929 Mustafa Raja: So that… I think that… that is the only difference with SDK, because with SDK, you have to code it, and with CLI, you can just run commands.
131 00:12:04.810 ⇒ 00:12:09.719 Casie Aviles: Yeah, the use case for me was just different, but yeah, I understand, yeah.
132 00:12:10.080 ⇒ 00:12:17.489 Mustafa Raja: Yeah, I haven’t had a use case for that too, so I’m just waiting… waiting on a good use case. I think Pranav has a good use case.
133 00:12:17.610 ⇒ 00:12:18.480 Mustafa Raja: Here?
134 00:12:21.310 ⇒ 00:12:24.540 Casie Aviles: Yeah, if you need to schedule something, you know.
135 00:12:25.720 ⇒ 00:12:32.140 Pranav Narahari: Yeah, I’m happy to do this, and then, I can just create a Zoom clip and get you guys ready on it as well.
136 00:12:32.730 ⇒ 00:12:33.420 Mustafa Raja: Yep.
137 00:12:34.030 ⇒ 00:12:34.790 Casie Aviles: Sure, sure.
138 00:12:34.790 ⇒ 00:12:39.919 Mustafa Raja: Then… and then, Casey, do you think Pranav should, ping Utam regarding this permission?
139 00:12:43.720 ⇒ 00:12:48.669 Pranav Narahari: Will I also need this permission for setting up the CLI? I guess, yeah, you guys wouldn’t know yet.
140 00:12:48.820 ⇒ 00:12:50.689 Pranav Narahari: Because you guys haven’t set it up either.
141 00:12:50.920 ⇒ 00:12:59.220 Pranav Narahari: For the SDK, though, Casey, like, I’m thinking for tonight, I’ll probably just, like, use the SDK using that API key.
142 00:13:00.910 ⇒ 00:13:02.579 Pranav Narahari: Since Casey, that worked for you, right?
143 00:13:03.880 ⇒ 00:13:08.240 Casie Aviles: Yeah, I used that for a script I had before.
144 00:13:09.300 ⇒ 00:13:10.130 Pranav Narahari: Gotcha.
145 00:13:11.330 ⇒ 00:13:16.500 Casie Aviles: I can also link you… Show you the file.
146 00:13:18.840 ⇒ 00:13:19.770 Pranav Narahari: The file?
147 00:13:21.100 ⇒ 00:13:22.240 Casie Aviles: Yeah, yeah,
148 00:13:23.640 ⇒ 00:13:33.099 Casie Aviles: just to… just, you know, as a reference of how… for how I did it in the past. It’s… I’m not using it anymore, but I was able to, like, use
149 00:13:33.360 ⇒ 00:13:36.790 Casie Aviles: it to access, Snowflake.
150 00:13:37.690 ⇒ 00:13:38.490 Pranav Narahari: Okay.
151 00:13:39.540 ⇒ 00:13:41.780 Casie Aviles: I’m just looking for it right now.
152 00:13:46.810 ⇒ 00:13:48.970 Casie Aviles: Oh, yeah, yeah, something like this.
153 00:13:49.730 ⇒ 00:13:55.490 Casie Aviles: Hmm, this might be… updated, but yeah, I’ll take a look, I’ll send.
154 00:13:56.210 ⇒ 00:13:57.820 Casie Aviles: Whichever works.
155 00:13:58.230 ⇒ 00:14:01.299 Casie Aviles: But yeah, this is how I basically did it in Python.
156 00:14:03.550 ⇒ 00:14:04.759 Pranav Narahari: Gotcha. This was…
157 00:14:04.990 ⇒ 00:14:06.810 Casie Aviles: I used my personal account.
158 00:14:07.000 ⇒ 00:14:11.189 Casie Aviles: before, so I think we need to use… they updated the…
159 00:14:13.240 ⇒ 00:14:17.009 Casie Aviles: The authentication, so we need to use, like, the service account now.
160 00:14:20.060 ⇒ 00:14:22.950 Pranav Narahari: Okay, yeah, that’s pretty much all, yeah.
161 00:14:25.700 ⇒ 00:14:27.280 Pranav Narahari: Gotcha. Okay.
162 00:14:28.330 ⇒ 00:14:34.849 Pranav Narahari: Yeah, I mean, two things I need to do is just that we’ve got the weekly report just, like, format now, so…
163 00:14:34.960 ⇒ 00:14:45.560 Pranav Narahari: The… the input that I’m expecting is still that CSV, but it’ll just have different questions, so I’ll just still use that as a sample. If there is, like, a more…
164 00:14:45.870 ⇒ 00:14:50.650 Pranav Narahari: Like, a latest sample, the…
165 00:14:50.950 ⇒ 00:14:54.990 Mustafa Raja: I could just query and download a sample.
166 00:14:55.250 ⇒ 00:14:55.630 Pranav Narahari: If you don’t mind.
167 00:14:55.630 ⇒ 00:14:56.320 Mustafa Raja: Meaning…
168 00:14:56.320 ⇒ 00:14:58.329 Pranav Narahari: For today, yeah, that would be great.
169 00:14:58.510 ⇒ 00:15:06.000 Mustafa Raja: Yeah, yeah, let me know how much rows would be good enough. I could… I could do latest 200 or something, you know? Let me know, just let me know.
170 00:15:06.000 ⇒ 00:15:10.480 Pranav Narahari: Yeah, if we could actually do for the… let’s say, let me find the…
171 00:15:10.480 ⇒ 00:15:11.250 Mustafa Raja: fund?
172 00:15:11.250 ⇒ 00:15:14.340 Pranav Narahari: Yeah, just, I think just last week?
173 00:15:14.630 ⇒ 00:15:15.370 Pranav Narahari: We’ll be fine.
174 00:15:15.370 ⇒ 00:15:19.720 Mustafa Raja: Yeah, so far. Let me grab that for you…
175 00:15:19.890 ⇒ 00:15:21.900 Pranav Narahari: Yeah, Feb 1st to Feb 7th.
176 00:15:22.160 ⇒ 00:15:23.450 Pranav Narahari: I think that would be great.
177 00:15:24.510 ⇒ 00:15:25.120 Mustafa Raja: Yep.
178 00:15:25.770 ⇒ 00:15:26.659 Pranav Narahari: Appreciate that.
179 00:15:42.240 ⇒ 00:15:45.329 Mustafa Raja: Yeah, I’ll unquery that, and then I’ll send you that.
180 00:15:45.570 ⇒ 00:15:47.019 Pranav Narahari: Appreciate that, thank you.
181 00:15:47.850 ⇒ 00:15:49.060 Mustafa Raja: Okay, thank you.
182 00:15:49.330 ⇒ 00:16:07.510 Pranav Narahari: Cool. Yeah, thanks guys. I think I’m all set, probably tomorrow, or tonight I’ll just, yeah, ping with Tom about, how I can get those tables, but other than that, I don’t think there’s anything blocking, and yeah, I don’t think this is, like, high priority to get finished by tomorrow, so… not in… not in too much of a rush.
183 00:16:08.380 ⇒ 00:16:08.890 Casie Aviles: Okay.
184 00:16:08.890 ⇒ 00:16:09.710 Mustafa Raja: Thank you.
185 00:16:10.030 ⇒ 00:16:11.080 Pranav Narahari: Cool. Thanks, guys.
186 00:16:11.530 ⇒ 00:16:12.980 Mustafa Raja: Thank you, have a good day. Bye.
187 00:16:13.210 ⇒ 00:16:13.940 Pranav Narahari: See ya.