Meeting Title: Setting up DBT locally Date: 2026-05-11 Meeting participants: Awaish Kumar, Advait Nandakumar Menon, Jasmin Multani, Jasmin Multani
WEBVTT
1 00:03:52.360 ⇒ 00:03:53.630 Advait Nandakumar Menon: damage.
2 00:03:56.820 ⇒ 00:03:57.660 Awaish Kumar: Hello.
3 00:03:59.690 ⇒ 00:04:00.870 Advait Nandakumar Menon: How’s it going?
4 00:04:02.420 ⇒ 00:04:03.080 Awaish Kumar: Sorry?
5 00:04:04.200 ⇒ 00:04:05.979 Advait Nandakumar Menon: How are you doing? How was the weekend?
6 00:04:34.980 ⇒ 00:04:38.410 Advait Nandakumar Menon: Not sure where Jasmine is. He’s the one who created this.
7 00:04:39.290 ⇒ 00:04:43.040 Advait Nandakumar Menon: meeting, I’m not able to see her on Slack.
8 00:04:45.220 ⇒ 00:04:46.959 Advait Nandakumar Menon: Let me just try pinging up.
9 00:06:34.490 ⇒ 00:06:38.230 Advait Nandakumar Menon: You just… Message me, she’s joining soon.
10 00:06:47.700 ⇒ 00:06:49.080 Advait Nandakumar Menon: Are you able to hear me.
11 00:06:50.530 ⇒ 00:06:51.679 Awaish Kumar: Yeah, yeah, I can hear you.
12 00:06:52.190 ⇒ 00:06:52.960 Advait Nandakumar Menon: Ok, oak.
13 00:06:58.300 ⇒ 00:07:00.279 Jasmin Multani: Hi, team, sorry for being late.
14 00:07:01.120 ⇒ 00:07:02.050 Jasmin Multani: Here, those.
15 00:07:05.290 ⇒ 00:07:06.630 Awaish Kumar: Hi.
16 00:07:07.640 ⇒ 00:07:10.830 Jasmin Multani: Hey, yeah, thank you so much, Awish.
17 00:07:10.830 ⇒ 00:07:11.310 Awaish Kumar: Nobody’s.
18 00:07:11.310 ⇒ 00:07:12.770 Jasmin Multani: Do you guys how to go through this?
19 00:07:13.040 ⇒ 00:07:22.059 Awaish Kumar: Yeah, so… no problem, I hope you both have cursor installed, and… GitHub repo for Element, right?
20 00:07:23.850 ⇒ 00:07:27.570 Jasmin Multani: Yeah, we have Cruiser. What was the second part you said?
21 00:07:28.330 ⇒ 00:07:35.310 Awaish Kumar: GitHub repo, Element repo, that you got access to. Okay, so is it available… you have a
22 00:07:36.110 ⇒ 00:07:39.299 Awaish Kumar: You clone it locally, you have it in Cursor.
23 00:07:40.790 ⇒ 00:07:44.960 Jasmin Multani: Yeah… Yeah, I mean, that way…
24 00:07:45.360 ⇒ 00:07:48.199 Jasmin Multani: That’s the only way for us to see the skills, right?
25 00:07:48.740 ⇒ 00:07:50.699 Awaish Kumar: Yeah, can we open up the…
26 00:07:50.810 ⇒ 00:07:52.970 Awaish Kumar: Can you show… share the screen?
27 00:07:52.970 ⇒ 00:07:56.240 Jasmin Multani: Okay, yeah, let me… Sorry.
28 00:07:59.490 ⇒ 00:08:04.850 Jasmin Multani: Give me a couple minutes, I’m talking through my phone right now, and I’m just waiting for my laptop to load.
29 00:08:06.550 ⇒ 00:08:07.580 Awaish Kumar: Okay, in the meantime…
30 00:08:07.580 ⇒ 00:08:10.280 Advait Nandakumar Menon: easier I can… Sure.
31 00:08:10.860 ⇒ 00:08:12.330 Jasmin Multani: Okay, great, thanks.
32 00:08:12.930 ⇒ 00:08:21.749 Awaish Kumar: No, no, but let’s go through it, like, so we have to set up at the end. You can also share it away, and then we can also look at Jasmine’s.
33 00:08:22.050 ⇒ 00:08:23.090 Awaish Kumar: undeliver.
34 00:08:23.090 ⇒ 00:08:23.770 Advait Nandakumar Menon: Okay.
35 00:08:36.039 ⇒ 00:08:42.329 Awaish Kumar: Okay, so, Pia opened the repository, and
36 00:08:42.609 ⇒ 00:08:45.169 Awaish Kumar: Can… maybe you can ask,
37 00:08:50.279 ⇒ 00:08:53.819 Awaish Kumar: Oh, here is a… Protection name.
38 00:08:59.830 ⇒ 00:09:02.480 Advait Nandakumar Menon: Did you say something? Your voice was cutting off.
39 00:09:03.220 ⇒ 00:09:07.309 Awaish Kumar: Yeah, I… I have shared in the Slack, I have shared a…
40 00:09:07.900 ⇒ 00:09:10.520 Awaish Kumar: a message. Can you copy-paste that here?
41 00:09:12.230 ⇒ 00:09:12.940 Advait Nandakumar Menon: Okay.
42 00:09:14.380 ⇒ 00:09:16.619 Awaish Kumar: in the Slack channel.
43 00:09:17.210 ⇒ 00:09:18.279 Advait Nandakumar Menon: Yeah, yeah, yeah, yeah.
44 00:09:18.460 ⇒ 00:09:23.400 Awaish Kumar: Yeah, just copy that part, paste here, and ask Kasir to…
45 00:09:23.720 ⇒ 00:09:27.720 Awaish Kumar: set up, Snowflake, Slo CLI connection for you.
46 00:09:35.270 ⇒ 00:09:36.480 Awaish Kumar: Yeah, that’s…
47 00:09:39.900 ⇒ 00:09:41.549 Awaish Kumar: Oh, sorry, Andrew, I have to…
48 00:09:41.760 ⇒ 00:09:48.980 Awaish Kumar: fix the path, basically, for the file. That is showing, yeah, my path. I’m sending you the file.
49 00:09:50.310 ⇒ 00:09:52.219 Awaish Kumar: Slack to you both.
50 00:09:54.520 ⇒ 00:09:56.620 Awaish Kumar: Download it, and then you can use it.
51 00:10:03.900 ⇒ 00:10:06.660 Awaish Kumar: painful assessment, and then…
52 00:10:16.860 ⇒ 00:10:17.770 Awaish Kumar: Okay.
53 00:10:21.140 ⇒ 00:10:22.450 Advait Nandakumar Menon: Just give me a sec.
54 00:11:02.000 ⇒ 00:11:02.690 Awaish Kumar: Okay.
55 00:11:03.940 ⇒ 00:11:06.320 Advait Nandakumar Menon: I have to place that file on this path, right?
56 00:11:08.790 ⇒ 00:11:14.710 Awaish Kumar: No, no, you can… Just wherever you place this file, just give the path… correct your path.
57 00:11:14.850 ⇒ 00:11:15.689 Awaish Kumar: For the fire.
58 00:11:15.690 ⇒ 00:11:17.669 Advait Nandakumar Menon: Oh, okay, okay, okay, okay.
59 00:11:27.620 ⇒ 00:11:28.700 Awaish Kumar: What is happening?
60 00:11:30.700 ⇒ 00:11:32.470 Awaish Kumar: you’re using VS Code?
61 00:11:34.530 ⇒ 00:11:35.909 Advait Nandakumar Menon: No, this is Gresso.
62 00:11:36.960 ⇒ 00:11:39.790 Advait Nandakumar Menon: The theme is… the theme looks like VS Code.
63 00:11:41.550 ⇒ 00:11:48.480 Awaish Kumar: Okay, so… And you are logged in with the Brainforge account.
64 00:11:49.930 ⇒ 00:11:50.630 Advait Nandakumar Menon: Yeah.
65 00:11:52.230 ⇒ 00:11:55.490 Awaish Kumar: Okay, then why is… why is it so slow?
66 00:11:56.640 ⇒ 00:11:59.620 Advait Nandakumar Menon: I didn’t hit the query, I stopped the con…
67 00:11:59.890 ⇒ 00:12:06.240 Advait Nandakumar Menon: This thing, I’m placing the file in my element project folder, so… and I’m here to correct the path.
68 00:12:06.760 ⇒ 00:12:08.220 Advait Nandakumar Menon: I’m doing it right.
69 00:12:08.860 ⇒ 00:12:09.620 Awaish Kumar: Okay.
70 00:12:17.820 ⇒ 00:12:19.230 Awaish Kumar: Okay, true.
71 00:13:23.670 ⇒ 00:13:25.039 Awaish Kumar: Also, you can.
72 00:13:30.500 ⇒ 00:13:31.360 Advait Nandakumar Menon: Yeah, sorry?
73 00:13:31.880 ⇒ 00:13:36.460 Awaish Kumar: Yeah, also, I’ve shared some environment variables, you can set it up additionally.
74 00:13:37.260 ⇒ 00:13:41.630 Awaish Kumar: So basically, we are setting… setting up two things. One, you can run through dbt.
75 00:13:41.980 ⇒ 00:13:44.530 Awaish Kumar: Second thing is, you can also directly query
76 00:13:44.970 ⇒ 00:13:47.619 Awaish Kumar: Snowflake from here, using Sinu CNI.
77 00:13:47.790 ⇒ 00:13:48.880 Awaish Kumar: So it will…
78 00:13:48.880 ⇒ 00:13:49.220 Advait Nandakumar Menon: Okay.
79 00:13:49.220 ⇒ 00:13:51.079 Awaish Kumar: Like, you can do both, right?
80 00:13:51.280 ⇒ 00:13:52.010 Awaish Kumar: So…
81 00:13:52.010 ⇒ 00:13:52.940 Advait Nandakumar Menon: Right, right.
82 00:13:53.210 ⇒ 00:13:56.389 Awaish Kumar: I’ve sent you the environment variables, just in a dbt project.
83 00:13:56.610 ⇒ 00:14:02.260 Awaish Kumar: Folder, create a .env file, and place these variables there.
84 00:14:04.580 ⇒ 00:14:05.260 Advait Nandakumar Menon: Okay.
85 00:14:05.820 ⇒ 00:14:07.029 Awaish Kumar: I’ve sent you in Slack.
86 00:14:08.360 ⇒ 00:14:08.960 Advait Nandakumar Menon: Yep.
87 00:14:09.760 ⇒ 00:14:16.169 Advait Nandakumar Menon: Can I place it in the same, folder wherein the… I have kept the RSA key?
88 00:14:16.170 ⇒ 00:14:17.860 Awaish Kumar: No, no, you have to place it in…
89 00:14:18.380 ⇒ 00:14:21.029 Awaish Kumar: in a .env file in the dbt project.
90 00:14:21.720 ⇒ 00:14:22.270 Awaish Kumar: Oh, the…
91 00:14:22.270 ⇒ 00:14:24.599 Advait Nandakumar Menon: Cloned, repository.
92 00:14:24.600 ⇒ 00:14:26.130 Awaish Kumar: BBT project.
93 00:14:28.080 ⇒ 00:14:32.200 Awaish Kumar: The dbt project is a Bradford Assessment, you have a dbt project folder.
94 00:14:33.080 ⇒ 00:14:34.290 Advait Nandakumar Menon: Yeah, yeah.
95 00:14:37.430 ⇒ 00:14:38.390 Advait Nandakumar Menon: Understood.
96 00:14:39.990 ⇒ 00:14:41.240 Awaish Kumar: From this one here.
97 00:14:43.480 ⇒ 00:14:44.230 Advait Nandakumar Menon: Yeah, yeah.
98 00:14:44.480 ⇒ 00:14:48.649 Advait Nandakumar Menon: I’m doing it within my finder, so that’s why it’s not visible for you.
99 00:14:49.560 ⇒ 00:14:55.720 Awaish Kumar: Yeah, just create .edv file, and play… copy-paste this, variables.
100 00:14:57.710 ⇒ 00:14:58.929 Awaish Kumar: That’s it.
101 00:14:59.050 ⇒ 00:15:03.740 Awaish Kumar: And, yeah, change the path to your RSA key file.
102 00:15:04.840 ⇒ 00:15:05.860 Awaish Kumar: Yes, yep.
103 00:15:12.600 ⇒ 00:15:15.200 Awaish Kumar: That’s it, and it should be done.
104 00:15:15.770 ⇒ 00:15:16.580 Awaish Kumar: Okay.
105 00:15:19.250 ⇒ 00:15:23.679 Awaish Kumar: Now you can ask… try in cursor, and you can ask it to run.
106 00:15:25.480 ⇒ 00:15:28.789 Awaish Kumar: DBT… Command for you.
107 00:15:32.570 ⇒ 00:15:35.880 Awaish Kumar: And yeah, hit enter, it will set up this one as well.
108 00:15:46.930 ⇒ 00:15:50.279 Awaish Kumar: And then you have one mode.
109 00:15:50.850 ⇒ 00:15:52.220 Awaish Kumar: Example here…
110 00:16:10.920 ⇒ 00:16:12.159 Awaish Kumar: Jasmine, is it…
111 00:16:12.550 ⇒ 00:16:14.110 Awaish Kumar: Do you have a setup?
112 00:16:14.820 ⇒ 00:16:21.740 Jasmin Multani: Well, I have cursor set up. I’m tracking to see if I have… the same DBT project, and…
113 00:16:22.210 ⇒ 00:16:27.490 Awaish Kumar: Yeah, just, you can just clone from GitHub. I can share the link if you want.
114 00:16:28.550 ⇒ 00:16:30.430 Jasmin Multani: Oh, from GitHub, okay.
115 00:16:33.250 ⇒ 00:16:34.959 Awaish Kumar: Let me share the link.
116 00:16:47.590 ⇒ 00:16:51.959 Awaish Kumar: This repository, you can just clone it on your local machine.
117 00:16:52.830 ⇒ 00:16:58.749 Jasmin Multani: Okay, so… Let me exit out of cursor once more.
118 00:17:19.099 ⇒ 00:17:22.009 Awaish Kumar: Yeah, you can say the hello list, so…
119 00:17:22.989 ⇒ 00:17:25.839 Awaish Kumar: Either way, next time, it will just automatically execute.
120 00:17:27.420 ⇒ 00:17:28.609 Advait Nandakumar Menon: Okay, okay.
121 00:17:29.440 ⇒ 00:17:31.810 Awaish Kumar: We’ll put all these commands in the auto list.
122 00:17:33.690 ⇒ 00:17:34.360 Advait Nandakumar Menon: Oh, good.
123 00:18:01.090 ⇒ 00:18:03.019 Jasmin Multani: I’m just reloading my cursor.
124 00:18:40.970 ⇒ 00:18:42.769 Awaish Kumar: And also, you can click on this…
125 00:18:43.660 ⇒ 00:18:50.890 Awaish Kumar: By the way on this command, which is running, and you can see the logs, actually, what’s happening on the screen, yeah, on this one. If you click…
126 00:18:51.060 ⇒ 00:18:53.389 Awaish Kumar: It’ll show you exactly what it is doing.
127 00:18:57.400 ⇒ 00:18:58.060 Awaish Kumar: Okay.
128 00:19:03.000 ⇒ 00:19:05.730 Awaish Kumar: Okay, so both are set up.
129 00:19:07.380 ⇒ 00:19:12.960 Jasmin Multani: Wait, I have a quick question, sorry. That link you sent, where do I paste it in the cursor?
130 00:19:14.640 ⇒ 00:19:19.720 Awaish Kumar: Okay, you don’t… you just open it in browser?
131 00:19:20.610 ⇒ 00:19:21.780 Awaish Kumar: Okay.
132 00:19:21.930 ⇒ 00:19:22.740 Awaish Kumar: get a…
133 00:19:22.740 ⇒ 00:19:23.240 Jasmin Multani: Okay.
134 00:19:24.700 ⇒ 00:19:27.570 Awaish Kumar: And for this repository, do you have to copy another link?
135 00:19:30.480 ⇒ 00:19:32.619 Jasmin Multani: I just clicked in the…
136 00:19:32.620 ⇒ 00:19:35.719 Awaish Kumar: Can I… can you share the screen so I… we can follow together?
137 00:19:35.940 ⇒ 00:19:38.820 Jasmin Multani: Yeah, sorry, I’m gonna start sharing.
138 00:19:39.630 ⇒ 00:19:46.210 Advait Nandakumar Menon: Do you have GitHub desktop installed, Jasmine? That’s also another easy way to just clone the repository.
139 00:19:46.580 ⇒ 00:19:48.920 Jasmin Multani: Yeah, I should have that.
140 00:19:50.050 ⇒ 00:19:53.220 Awaish Kumar: But for now, we can just… Okay.
141 00:19:53.220 ⇒ 00:19:54.800 Advait Nandakumar Menon: Yeah, whichever is easier for now.
142 00:19:56.990 ⇒ 00:20:01.500 Awaish Kumar: Yeah, just… I think if you can paste the URL here, it can work. Just copy-paste on the top.
143 00:20:02.010 ⇒ 00:20:02.580 Jasmin Multani: Yep.
144 00:20:04.360 ⇒ 00:20:05.880 Jasmin Multani: This is it, right?
145 00:20:07.190 ⇒ 00:20:11.359 Awaish Kumar: I hope so. Otherwise, we can also… You can click on code.
146 00:20:11.360 ⇒ 00:20:12.000 Advait Nandakumar Menon: And this…
147 00:20:14.340 ⇒ 00:20:19.029 Awaish Kumar: You can click on the code, this green button here.
148 00:20:19.370 ⇒ 00:20:20.070 Jasmin Multani: Okay.
149 00:20:21.580 ⇒ 00:20:22.400 Jasmin Multani: mode.
150 00:20:22.400 ⇒ 00:20:25.280 Awaish Kumar: You can copy this one, yeah.
151 00:20:26.170 ⇒ 00:20:30.379 Jasmin Multani: Copy this, and then where do I… Just… and the URL.
152 00:20:30.510 ⇒ 00:20:34.670 Awaish Kumar: interested in the GitHub, duh.
153 00:20:34.910 ⇒ 00:20:37.240 Awaish Kumar: The, yeah, here, in the cursor.
154 00:20:37.940 ⇒ 00:20:40.510 Jasmin Multani: Oh, you can join the cursor, so where do I…
155 00:20:40.820 ⇒ 00:20:45.329 Awaish Kumar: On the top, where it’s asking you to provide depository URL, yeah, just hit add to…
156 00:20:48.710 ⇒ 00:20:51.629 Awaish Kumar: No, it’s… okay, we can cancel it.
157 00:20:53.850 ⇒ 00:20:55.380 Awaish Kumar: Okay, yeah, I don’t know.
158 00:20:56.080 ⇒ 00:20:59.860 Awaish Kumar: It was asking for a folder to place the repository, right, Edwie?
159 00:21:00.310 ⇒ 00:21:00.840 Awaish Kumar: Hmm.
160 00:21:00.840 ⇒ 00:21:01.920 Advait Nandakumar Menon: Yeah, yeah.
161 00:21:01.920 ⇒ 00:21:02.569 Awaish Kumar: Okay, good.
162 00:21:05.040 ⇒ 00:21:06.390 Awaish Kumar: You can…
163 00:21:07.340 ⇒ 00:21:10.080 Advait Nandakumar Menon: Can I click on Clone Reaper in the middle?
164 00:21:10.550 ⇒ 00:21:11.200 Jasmin Multani: Yeah.
165 00:21:12.200 ⇒ 00:21:15.720 Awaish Kumar: Yeah, it’s the same. You have to provide URL now, on the top.
166 00:21:16.560 ⇒ 00:21:17.400 Jasmin Multani: Provide…
167 00:21:17.400 ⇒ 00:21:18.420 Advait Nandakumar Menon: neighbors!
168 00:21:18.420 ⇒ 00:21:20.820 Awaish Kumar: Just copy-paste… Enter.
169 00:21:20.820 ⇒ 00:21:22.790 Advait Nandakumar Menon: Yeah, it was… yeah, yeah.
170 00:21:25.690 ⇒ 00:21:28.580 Awaish Kumar: And provide where we want to place this folder.
171 00:21:29.030 ⇒ 00:21:30.940 Awaish Kumar: Maybe on desktop or wherever.
172 00:21:30.940 ⇒ 00:21:33.109 Jasmin Multani: Yeah, I’ll just shoot it on desktop.
173 00:21:33.820 ⇒ 00:21:36.919 Awaish Kumar: Select as representative destination, yeah, and then…
174 00:21:37.120 ⇒ 00:21:41.880 Awaish Kumar: It will clone it, places… place the folder there, and then it will open it,
175 00:21:42.530 ⇒ 00:21:44.919 Awaish Kumar: open it in cursor, and then…
176 00:21:45.160 ⇒ 00:21:49.940 Awaish Kumar: What you can do is, I’ll send you some,
177 00:21:50.500 ⇒ 00:21:55.179 Awaish Kumar: messages on Slack, if you can download those files.
178 00:21:57.400 ⇒ 00:22:00.380 Awaish Kumar: Yeah. You can download this file, and…
179 00:22:00.560 ⇒ 00:22:02.680 Awaish Kumar: Keep it… keep it wherever you want to.
180 00:22:03.990 ⇒ 00:22:06.360 Awaish Kumar: And you have to copy this…
181 00:22:07.480 ⇒ 00:22:11.089 Awaish Kumar: config, which is right below that, in the Slack.
182 00:22:13.080 ⇒ 00:22:18.220 Jasmin Multani: Yeah, and then right over the… RSA.
183 00:22:20.060 ⇒ 00:22:21.510 Awaish Kumar: Yeah, copy this.
184 00:22:22.610 ⇒ 00:22:23.650 Jasmin Multani: Copy this.
185 00:22:24.240 ⇒ 00:22:26.250 Awaish Kumar: And we can move to Karsal now.
186 00:22:27.660 ⇒ 00:22:29.960 Jasmin Multani: Would you like to open the code?
187 00:22:38.640 ⇒ 00:22:44.890 Awaish Kumar: Okay, we have… Now, I think we have the repository here.
188 00:22:45.140 ⇒ 00:22:51.610 Awaish Kumar: So, now in the dbt project folder, if you click on that, just create a new file.env.
189 00:22:53.610 ⇒ 00:22:54.340 Awaish Kumar: Yeah.
190 00:22:55.460 ⇒ 00:22:57.189 Jasmin Multani: dot E-N-V. Cool.
191 00:22:57.190 ⇒ 00:23:01.210 Awaish Kumar: Yeah, enter, and then copy-paste, paste the… Music.
192 00:23:03.910 ⇒ 00:23:04.720 Jasmin Multani: This whole thing.
193 00:23:04.720 ⇒ 00:23:11.440 Awaish Kumar: whatever we copied from Slack message, and then you… you have to fix the path to the RSA key file.
194 00:23:11.820 ⇒ 00:23:14.769 Awaish Kumar: So, wherever it is now, we just have to fix that.
195 00:23:17.930 ⇒ 00:23:21.480 Awaish Kumar: Or, one other thing you can do is just copy that file.
196 00:23:21.710 ⇒ 00:23:25.160 Awaish Kumar: And also put it in this folder, dbt project.
197 00:23:27.470 ⇒ 00:23:29.250 Jasmin Multani: The RSA, copy the RSA.
198 00:23:29.850 ⇒ 00:23:30.670 Awaish Kumar: Yeah, yeah.
199 00:23:31.830 ⇒ 00:23:36.709 Awaish Kumar: this one, RSKey.ph8, copy that, and move it to the same folder in there.
200 00:23:37.140 ⇒ 00:23:38.510 Awaish Kumar: NDT project.
201 00:23:40.550 ⇒ 00:23:46.029 Jasmin Multani: I think I’ll just… But… okay.
202 00:23:46.030 ⇒ 00:23:48.010 Awaish Kumar: Just copy that, you can just move it to…
203 00:23:48.010 ⇒ 00:23:48.620 Jasmin Multani: be it?
204 00:23:49.780 ⇒ 00:23:55.320 Awaish Kumar: I copy this, and go to the brain forge assessment folder, which is at the top.
205 00:23:57.180 ⇒ 00:23:57.820 Jasmin Multani: Here?
206 00:23:58.010 ⇒ 00:23:59.900 Awaish Kumar: No, no, no, no, just go back to the…
207 00:24:01.910 ⇒ 00:24:03.849 Awaish Kumar: On the top, you see the folder?
208 00:24:03.850 ⇒ 00:24:05.230 Jasmin Multani: Oh, okay, yeah, sorry.
209 00:24:05.580 ⇒ 00:24:06.760 Jasmin Multani: Sorry, guys.
210 00:24:07.350 ⇒ 00:24:09.370 Awaish Kumar: No, no, we have to move further.
211 00:24:10.620 ⇒ 00:24:14.429 Awaish Kumar: In this, yeah, and move it to dbt project folder.
212 00:24:15.030 ⇒ 00:24:15.840 Jasmin Multani: There.
213 00:24:15.840 ⇒ 00:24:17.579 Awaish Kumar: Okay, now it’s fine.
214 00:24:18.720 ⇒ 00:24:19.500 Jasmin Multani: And then…
215 00:24:19.500 ⇒ 00:24:20.419 Awaish Kumar: Back to Carson.
216 00:24:22.160 ⇒ 00:24:23.389 Jasmin Multani: Back to cursor, okay.
217 00:24:24.740 ⇒ 00:24:27.899 Awaish Kumar: And let’s save… save this file, Ctrl-S.
218 00:24:28.690 ⇒ 00:24:29.350 Jasmin Multani: Who…
219 00:24:29.920 ⇒ 00:24:36.689 Awaish Kumar: Okay, in the chat, you can… and one more thing. In the Slack, in the channel, I also sent some configuration.
220 00:24:37.190 ⇒ 00:24:38.339 Awaish Kumar: Copy that.
221 00:24:39.560 ⇒ 00:24:42.570 Awaish Kumar: It’s in the… in the client element channel.
222 00:24:44.690 ⇒ 00:24:45.810 Jasmin Multani: I’m MLM.
223 00:24:50.470 ⇒ 00:24:55.780 Awaish Kumar: Yeah, in this channel, I send you… Instead…
224 00:24:59.640 ⇒ 00:25:00.850 Awaish Kumar: Copy that.
225 00:25:01.790 ⇒ 00:25:02.900 Jasmin Multani: Just this bottom?
226 00:25:02.900 ⇒ 00:25:05.169 Awaish Kumar: No, no, no, full configuration.
227 00:25:05.790 ⇒ 00:25:06.380 Jasmin Multani: Hmm.
228 00:25:06.490 ⇒ 00:25:07.429 Jasmin Multani: This full thing.
229 00:25:07.430 ⇒ 00:25:08.280 Awaish Kumar: From the top.
230 00:25:11.480 ⇒ 00:25:12.120 Awaish Kumar: Okay.
231 00:25:13.290 ⇒ 00:25:17.319 Awaish Kumar: And the cursor, if you can just go to the cursor and,
232 00:25:18.820 ⇒ 00:25:21.120 Awaish Kumar: Paste it in the… in the chat.
233 00:25:22.960 ⇒ 00:25:32.490 Awaish Kumar: And fix the path, now our RC key file exists in… dbt project from…
234 00:25:33.510 ⇒ 00:25:34.539 Jasmin Multani: to change this.
235 00:25:34.540 ⇒ 00:25:37.710 Awaish Kumar: You have to go give the full path. You can go to the file.
236 00:25:38.340 ⇒ 00:25:41.009 Awaish Kumar: RSA key, in the, in the cursor itself.
237 00:25:42.420 ⇒ 00:25:43.850 Jasmin Multani: Oh, I can go…
238 00:25:43.850 ⇒ 00:25:47.320 Awaish Kumar: RSaq.ph file, right-click, and you can copy the path.
239 00:25:48.830 ⇒ 00:25:51.359 Jasmin Multani: Where is RSA?
240 00:25:52.260 ⇒ 00:25:53.339 Jasmin Multani: Not right here.
241 00:25:53.730 ⇒ 00:25:56.479 Awaish Kumar: Yeah, yeah, right-click, you can copy path.
242 00:25:57.630 ⇒ 00:25:58.600 Jasmin Multani: Copy of that.
243 00:25:58.600 ⇒ 00:26:02.089 Awaish Kumar: Yeah, and then you just avoid that exact path here.
244 00:26:02.370 ⇒ 00:26:03.260 Jasmin Multani: Great, thanks.
245 00:26:04.050 ⇒ 00:26:06.509 Awaish Kumar: Now you can ask cursor in the bottom.
246 00:26:08.310 ⇒ 00:26:14.690 Awaish Kumar: Hit enter, and we go to the bottom, and just ask to set up this connection.
247 00:26:15.010 ⇒ 00:26:17.030 Awaish Kumar: For Sluice Lai.
248 00:26:18.450 ⇒ 00:26:21.739 Awaish Kumar: Yeah, setups, no CLI connection.
249 00:26:22.760 ⇒ 00:26:24.170 Jasmin Multani: No CLI.
250 00:26:24.170 ⇒ 00:26:24.730 Awaish Kumar: Yeah.
251 00:26:25.630 ⇒ 00:26:27.429 Awaish Kumar: And hit enter.
252 00:26:33.560 ⇒ 00:26:34.870 Awaish Kumar: You can continue.
253 00:26:46.250 ⇒ 00:26:46.980 Jasmin Multani: Run.
254 00:26:46.980 ⇒ 00:26:47.600 Awaish Kumar: Yep.
255 00:26:58.350 ⇒ 00:27:00.530 Awaish Kumar: And we… have you tried running the commands?
256 00:27:00.650 ⇒ 00:27:04.209 Awaish Kumar: You can try running it, like, you can ask to carry…
257 00:27:04.400 ⇒ 00:27:09.760 Awaish Kumar: From any table from Snowflake for Element, and see if it is returning the data.
258 00:27:11.110 ⇒ 00:27:15.320 Advait Nandakumar Menon: Okay, maybe I’ll try the same weekly summary table,
259 00:27:15.320 ⇒ 00:27:16.690 Awaish Kumar: table.
260 00:27:16.690 ⇒ 00:27:18.070 Advait Nandakumar Menon: Yeah, yeah.
261 00:27:35.140 ⇒ 00:27:35.740 Awaish Kumar: Hello?
262 00:27:36.990 ⇒ 00:27:38.700 Awaish Kumar: Click on About, Jasmine.
263 00:27:39.650 ⇒ 00:27:40.850 Jasmin Multani: about.
264 00:27:41.650 ⇒ 00:27:42.839 Awaish Kumar: Yeah, click on run.
265 00:27:43.430 ⇒ 00:27:44.710 Jasmin Multani: Okay.
266 00:27:44.710 ⇒ 00:27:55.209 Awaish Kumar: But, like, normally you can… there are options to click, like, continue or the allow list. If you normally click on allow list, it will… it won’t ask you, like, again and again.
267 00:27:55.210 ⇒ 00:27:56.880 Jasmin Multani: Oh. Okay.
268 00:27:56.880 ⇒ 00:27:57.520 Awaish Kumar: loaded up.
269 00:27:58.240 ⇒ 00:27:59.010 Jasmin Multani: Thanks.
270 00:27:59.580 ⇒ 00:28:02.269 Awaish Kumar: Okay, now you can also ask here…
271 00:28:02.920 ⇒ 00:28:08.280 Awaish Kumar: And, yeah, us to carry, like, For example, you can say.
272 00:28:08.600 ⇒ 00:28:12.350 Awaish Kumar: Get me a sample of any table from raw.
273 00:28:12.890 ⇒ 00:28:15.300 Awaish Kumar: Shopify, schema.
274 00:28:19.830 ⇒ 00:28:22.390 Awaish Kumar: From raw database, like, you can just…
275 00:28:24.810 ⇒ 00:28:26.959 Awaish Kumar: Or element. Okay. Yeah.
276 00:28:28.680 ⇒ 00:28:34.100 Awaish Kumar: It can figure out still, but, like, if you give him more path, it will just be exactly…
277 00:28:34.340 ⇒ 00:28:35.510 Awaish Kumar: We’ll follow that.
278 00:28:45.660 ⇒ 00:28:48.069 Jasmin Multani: So if we wanted to, like, run…
279 00:28:48.290 ⇒ 00:28:49.550 Awaish Kumar: Cause, like…
280 00:28:49.550 ⇒ 00:28:56.400 Jasmin Multani: Yeah, cause, like, last week, we just, like, Shivani had asked…
281 00:28:57.080 ⇒ 00:29:05.959 Jasmin Multani: she… she was getting to… she felt like she wanted to see how the first, second, and third order were being calculated in the SQL backend.
282 00:29:06.080 ⇒ 00:29:14.640 Jasmin Multani: And there was just a lot of flipping between the snowflake and the dbt and changing parts, but I don’t…
283 00:29:15.010 ⇒ 00:29:15.670 Jasmin Multani: Because we…
284 00:29:15.670 ⇒ 00:29:16.220 Awaish Kumar: Legally.
285 00:29:16.930 ⇒ 00:29:23.049 Jasmin Multani: Yeah, because we were changing parts, I don’t want her to think that we were changing parts of your original sequel.
286 00:29:23.450 ⇒ 00:29:27.519 Jasmin Multani: in order to make it quote-unquote, better. We were just…
287 00:29:27.660 ⇒ 00:29:30.500 Jasmin Multani: Changing parts of it so that we could actually run it.
288 00:29:30.810 ⇒ 00:29:37.769 Jasmin Multani: So that’s why I want it to be, like, an apples-to-apples experience, in case she asks next time again.
289 00:29:38.130 ⇒ 00:29:41.849 Awaish Kumar: Okay, but what you were… I don’t know… where you were changing.
290 00:29:42.590 ⇒ 00:29:48.570 Jasmin Multani: We were playing around in Snowflake, so we pulled up the Snowflake environment, we opened up, like, a…
291 00:29:49.210 ⇒ 00:29:55.999 Jasmin Multani: raw file. We never changed anything in dbt. We just, like, copied the code, and then pasted in Snowflake, and just…
292 00:29:56.730 ⇒ 00:30:00.559 Jasmin Multani: ran things CTE by CTE, so she can understand the flow.
293 00:30:01.640 ⇒ 00:30:06.930 Awaish Kumar: Okay, so what… okay, you can do it in Karsali, exactly, I’m just setting up that for you.
294 00:30:09.330 ⇒ 00:30:11.589 Awaish Kumar: Yep, but is your connection working?
295 00:30:11.700 ⇒ 00:30:12.769 Awaish Kumar: What was that?
296 00:30:13.660 ⇒ 00:30:18.060 Awaish Kumar: Yeah, what the cursor is saying, is it… does it work? Is it showing some data, or not?
297 00:30:18.330 ⇒ 00:30:23.650 Jasmin Multani: Yeah, I’m seeing that it’s… Oh, it’s actually, if you mean… Okay.
298 00:30:23.650 ⇒ 00:30:25.359 Awaish Kumar: Give, give him, maybe, yeah.
299 00:30:25.940 ⇒ 00:30:27.110 Jasmin Multani: We’ll just do those.
300 00:30:28.750 ⇒ 00:30:33.050 Awaish Kumar: Just ask to, like, ask, to give, like, sample.
301 00:30:33.850 ⇒ 00:30:35.140 Awaish Kumar: Later for this.
302 00:30:38.990 ⇒ 00:30:41.230 Awaish Kumar: Yeah, now it should work.
303 00:30:42.010 ⇒ 00:30:43.880 Awaish Kumar: You can click on Analyst.
304 00:30:44.360 ⇒ 00:30:46.629 Awaish Kumar: Oh, yeah. It won’t ask you again.
305 00:30:47.060 ⇒ 00:30:48.440 Jasmin Multani: Yeah, next time I’ll do that.
306 00:30:58.830 ⇒ 00:31:05.739 Jasmin Multani: This machine still does not have the snow CLI on path, so the query was not executed here. To run it locally after Snow CLI.
307 00:31:06.300 ⇒ 00:31:09.939 Awaish Kumar: Can you ask Cursor to install SinoCLI for you?
308 00:31:11.140 ⇒ 00:31:12.060 Jasmin Multani: You don’t believe him?
309 00:31:14.200 ⇒ 00:31:14.910 Jasmin Multani: That’s stupid.
310 00:31:18.160 ⇒ 00:31:21.720 Awaish Kumar: Because it did for Advoc, like, automatically.
311 00:31:22.190 ⇒ 00:31:23.530 Jasmin Multani: Yeah, and I…
312 00:31:24.750 ⇒ 00:31:26.839 Awaish Kumar: Here, let’s click on one.
313 00:31:27.830 ⇒ 00:31:29.120 Awaish Kumar: And continue.
314 00:31:29.220 ⇒ 00:31:30.020 Awaish Kumar: On the top.
315 00:31:44.090 ⇒ 00:31:45.640 Awaish Kumar: Click and click on all list.
316 00:31:46.080 ⇒ 00:31:48.219 Jasmin Multani: Oh, shoot, sorry, I missed it again, sorry.
317 00:31:49.670 ⇒ 00:31:54.750 Jasmin Multani: It’s just the blue button, and then I’m like, I love hitting the highlighted button.
318 00:32:08.920 ⇒ 00:32:10.639 Awaish Kumar: Is it working for you, Edwin?
319 00:32:15.870 ⇒ 00:32:16.530 Awaish Kumar: Sorry?
320 00:32:17.940 ⇒ 00:32:23.079 Advait Nandakumar Menon: It is running the dev mod and not the prod mat for me, I’m not sure why.
321 00:32:24.290 ⇒ 00:32:30.519 Awaish Kumar: Yeah, it… it… Oh, my… Why? You can ask?
322 00:32:31.520 ⇒ 00:32:32.580 Awaish Kumar: Hmm…
323 00:32:32.580 ⇒ 00:32:33.180 Advait Nandakumar Menon: Yep.
324 00:32:34.570 ⇒ 00:32:36.570 Advait Nandakumar Menon: Yeah, just a second, unsec…
325 00:33:16.010 ⇒ 00:33:18.659 Awaish Kumar: Also, Jasmine, you can click on…
326 00:33:19.050 ⇒ 00:33:23.930 Awaish Kumar: These exact commands, then it will, like, show you the logs, like, what is happening.
327 00:33:24.090 ⇒ 00:33:25.550 Awaish Kumar: While we’re waiting, like…
328 00:33:26.520 ⇒ 00:33:28.579 Jasmin Multani: The commands you sent in…
329 00:33:28.580 ⇒ 00:33:32.890 Awaish Kumar: No, no, in this… in the… in the chat, this is a command, like, refresh path.
330 00:33:33.160 ⇒ 00:33:35.380 Awaish Kumar: Kind of verifies an OC Live version.
331 00:33:35.610 ⇒ 00:33:36.800 Jasmin Multani: Yeah, okay.
332 00:33:36.800 ⇒ 00:33:40.730 Awaish Kumar: running a command in behind. If you click on the latest one.
333 00:33:40.970 ⇒ 00:33:42.940 Awaish Kumar: That’s the first, yeah, least one.
334 00:33:43.460 ⇒ 00:33:46.149 Awaish Kumar: So you can see what is running and what it is waiting for.
335 00:33:54.060 ⇒ 00:33:54.780 Awaish Kumar: Come on.
336 00:33:55.260 ⇒ 00:33:56.340 Jasmin Multani: Allow list.
337 00:33:56.590 ⇒ 00:33:57.200 Awaish Kumar: Nope.
338 00:34:05.460 ⇒ 00:34:11.399 Advait Nandakumar Menon: So, for me, it’s saying insufficient privileges to operate On the table.
339 00:34:11.639 ⇒ 00:34:12.469 Awaish Kumar: Okay.
340 00:34:12.699 ⇒ 00:34:16.769 Advait Nandakumar Menon: In Shopify wholesale DIN customer.
341 00:34:19.370 ⇒ 00:34:22.529 Awaish Kumar: Yeah, you can change the role to maybe CICD role.
342 00:34:24.679 ⇒ 00:34:26.769 Advait Nandakumar Menon: Okay. The snowflake roll, right?
343 00:34:27.480 ⇒ 00:34:29.150 Awaish Kumar: Yeah, so fake rules.
344 00:34:30.949 ⇒ 00:34:31.559 Advait Nandakumar Menon: Okay.
345 00:34:43.699 ⇒ 00:34:47.899 Jasmin Multani: Okay, cool. You should see snowflakes, yellow, the first one can take several seconds.
346 00:34:52.340 ⇒ 00:34:56.800 Awaish Kumar: Okay, let’s scroll down. Now you can ask it to run the…
347 00:34:57.550 ⇒ 00:34:59.969 Awaish Kumar: It’s no CLI and Kiri, the kill here.
348 00:35:04.070 ⇒ 00:35:07.440 Awaish Kumar: Oh, no, no, no, the DevDB is not anything, like…
349 00:35:07.710 ⇒ 00:35:10.099 Awaish Kumar: So you have to give the exact, like…
350 00:35:10.100 ⇒ 00:35:11.380 Jasmin Multani: Nope.
351 00:35:12.290 ⇒ 00:35:15.450 Awaish Kumar: DevDB is nothing, like, yeah, copy this, maybe.
352 00:35:19.460 ⇒ 00:35:22.129 Jasmin Multani: I’m curious to see what this entails.
353 00:35:22.790 ⇒ 00:35:24.210 Jasmin Multani: Okay, just because…
354 00:35:25.450 ⇒ 00:35:26.740 Awaish Kumar: Let’s… let’s…
355 00:35:28.180 ⇒ 00:35:34.759 Awaish Kumar: Yeah, you can ask it to do anything, so… we just sent a carry, but we didn’t actually ask anything from AI.
356 00:35:34.760 ⇒ 00:35:35.550 Jasmin Multani: Oh.
357 00:35:35.940 ⇒ 00:35:43.510 Awaish Kumar: Right now, we don’t know what it will do. It’s actually trying to run. You can click… allow list, you can click on allow list, because…
358 00:35:43.850 ⇒ 00:35:46.090 Awaish Kumar: I did pick up the context.
359 00:35:46.310 ⇒ 00:35:47.419 Awaish Kumar: Trying to run.
360 00:35:49.110 ⇒ 00:35:53.370 Awaish Kumar: Sometimes it can do anything because we didn’t clarify what to do.
361 00:35:54.220 ⇒ 00:35:54.830 Jasmin Multani: Hmm.
362 00:35:55.790 ⇒ 00:35:58.020 Jasmin Multani: Yeah, yeah, it’s a good troubleshoot.
363 00:35:58.020 ⇒ 00:36:01.970 Awaish Kumar: But now you can click on the… Terminal…
364 00:36:02.340 ⇒ 00:36:05.320 Awaish Kumar: And it, yeah, now it’s showing you some data.
365 00:36:06.140 ⇒ 00:36:13.830 Awaish Kumar: So now you don’t have to go into the snowflake from cursor, you can ask it to… like,
366 00:36:13.960 ⇒ 00:36:19.490 Awaish Kumar: Get data from any table, any intermediate table, any… Anywhere, anywhere.
367 00:36:20.370 ⇒ 00:36:21.330 Jasmin Multani: Okay, great.
368 00:36:22.040 ⇒ 00:36:25.820 Jasmin Multani: Okay, so if we wanted to run, like, a PR, something that was
369 00:36:26.460 ⇒ 00:36:28.790 Jasmin Multani: listed in a PR, hopefully we can do that.
370 00:36:29.630 ⇒ 00:36:35.499 Awaish Kumar: Like, you… from here, what you can do is, you can actually just create, carry the tables.
371 00:36:35.780 ⇒ 00:36:37.149 Awaish Kumar: Now the second part.
372 00:36:37.460 ⇒ 00:36:44.540 Awaish Kumar: Second part is setting up dbt. For that, you have to also follow the Similar path, ask cursor.
373 00:36:44.790 ⇒ 00:36:50.470 Awaish Kumar: To use your .env file, And… Set up dbt.
374 00:36:51.110 ⇒ 00:36:56.850 Awaish Kumar: And then you can actually run DBD projects through that. So, if you want to create any model.
375 00:36:57.140 ⇒ 00:37:06.069 Awaish Kumar: it will create, like, run that and create a table for you, but that you, through dbt, we can’t curate, like, we can’t curate to see the data.
376 00:37:06.440 ⇒ 00:37:19.129 Awaish Kumar: DVT only will help you create the models, or tables, if you don’t see it in Snowflake, if you’ve updated the SQL, if you’ve changed the logic or anything, and if you want to rerun it.
377 00:37:19.280 ⇒ 00:37:21.340 Awaish Kumar: Then you use DVD, you will ask.
378 00:37:21.670 ⇒ 00:37:28.290 Awaish Kumar: cursor to use dbt to run this model, so it will recreate the table with your updated logic.
379 00:37:28.460 ⇒ 00:37:34.250 Awaish Kumar: But if you want to just see the data and carry the data, then you have to use this CINO CLI.
380 00:37:36.380 ⇒ 00:37:37.450 Awaish Kumar: That we just did.
381 00:37:37.640 ⇒ 00:37:41.829 Jasmin Multani: Okay, okay, okay. Sounds good. I’ll test around with it again.
382 00:37:42.720 ⇒ 00:37:49.889 Awaish Kumar: So, Seno CLI is working for you, like, now, if you… if you want to set up dbt, we can do that, if you want to do it recently.
383 00:37:51.000 ⇒ 00:37:53.590 Jasmin Multani: I’m down to do that. I’ll go throw you down.
384 00:37:54.250 ⇒ 00:37:54.680 Awaish Kumar: Yeah.
385 00:37:54.680 ⇒ 00:37:59.380 Advait Nandakumar Menon: Yeah. Do we have access to DBT Cloud, or only DBT Cloud.
386 00:37:59.380 ⇒ 00:38:00.990 Awaish Kumar: No, no, we don’t have DB Cloud.
387 00:38:01.960 ⇒ 00:38:03.870 Advait Nandakumar Menon: Okay, okay, okay.
388 00:38:03.870 ⇒ 00:38:08.190 Awaish Kumar: That’s the reason why I’m showing you all this, because we have to run.
389 00:38:08.190 ⇒ 00:38:08.900 Advait Nandakumar Menon: Beautiful.
390 00:38:08.900 ⇒ 00:38:13.880 Awaish Kumar: If you have to… Try it out… try out anything, you have to run it from your local machine.
391 00:38:14.840 ⇒ 00:38:16.619 Advait Nandakumar Menon: From the CLI, okay.
392 00:38:17.000 ⇒ 00:38:17.590 Awaish Kumar: Yeah.
393 00:38:19.540 ⇒ 00:38:20.720 Jasmin Multani: Okay.
394 00:38:20.720 ⇒ 00:38:24.630 Awaish Kumar: No CLI, or two things, so no CLI is just for accessing data.
395 00:38:25.760 ⇒ 00:38:31.790 Awaish Kumar: for creating tables, you have to use dbt. So now in the chat, Jasmine, you can ask.
396 00:38:33.630 ⇒ 00:38:36.610 Awaish Kumar: Like, use.env file.
397 00:38:39.230 ⇒ 00:38:44.249 Awaish Kumar: You can link this file, like, with the atrate.thenv.
398 00:38:45.450 ⇒ 00:38:47.780 Awaish Kumar: In the chat, if you… if you do it.
399 00:38:48.580 ⇒ 00:38:49.310 Jasmin Multani: Oh.
400 00:38:52.020 ⇒ 00:38:54.030 Awaish Kumar: Yeah, you can, yeah, you can do that.
401 00:38:55.010 ⇒ 00:38:57.169 Awaish Kumar: and help set up TBT.
402 00:38:58.690 ⇒ 00:39:02.610 Jasmin Multani: 2… And all of a sudden…
403 00:39:02.970 ⇒ 00:39:05.540 Awaish Kumar: DB. Yeah, that’s it.
404 00:39:07.740 ⇒ 00:39:11.410 Advait Nandakumar Menon: Where can I see the list of roles, Avesh, for the Snowflake?
405 00:39:12.070 ⇒ 00:39:15.170 Awaish Kumar: Or who can use SynoCLI to get a review on Google?
406 00:39:16.760 ⇒ 00:39:17.420 Advait Nandakumar Menon: Okay.
407 00:39:18.250 ⇒ 00:39:23.939 Awaish Kumar: You can ask Kirsten to… You can ask her, sir, to use UnoCli.
408 00:39:24.100 ⇒ 00:39:33.850 Awaish Kumar: and get you all the rules. If you have privileges, you will be able to see that. If you don’t have privileges, then you have to log in to a single site.
409 00:39:34.250 ⇒ 00:39:36.009 Awaish Kumar: And then see it there.
410 00:39:38.640 ⇒ 00:39:42.879 Advait Nandakumar Menon: Okay, so on the SNOS side, that is on the web UI, I…
411 00:39:42.880 ⇒ 00:39:43.440 Awaish Kumar: Yes.
412 00:39:43.570 ⇒ 00:39:49.910 Advait Nandakumar Menon: Logging in through… I’m not sure if it’s the right account, but it’s…
413 00:39:50.730 ⇒ 00:39:54.649 Awaish Kumar: Yeah, you have to log in using your own credentials.
414 00:39:56.600 ⇒ 00:40:04.229 Advait Nandakumar Menon: Oh, I don’t… I’m using the one from… I think it’s Utam’s account, or 1Password.
415 00:40:04.750 ⇒ 00:40:05.460 Jasmin Multani: Yeah.
416 00:40:05.460 ⇒ 00:40:07.569 Awaish Kumar: Okay, if you’re using that, then,
417 00:40:07.770 ⇒ 00:40:11.169 Awaish Kumar: you have all the access, right? Utame is everything.
418 00:40:11.790 ⇒ 00:40:13.990 Awaish Kumar: Access to everything, foreign.
419 00:40:14.300 ⇒ 00:40:19.049 Awaish Kumar: For elements, you know, like… So you have… you are, like, kind of a… have…
420 00:40:19.540 ⇒ 00:40:28.189 Awaish Kumar: account admin there. So, basically, you can see everything. All the roles. If you click on users and roles, on the left-hand side.
421 00:40:29.920 ⇒ 00:40:34.949 Awaish Kumar: there will be a section for your roles, right? If you click on that, you will see all the roles available.
422 00:40:35.890 ⇒ 00:40:46.959 Advait Nandakumar Menon: Yeah, I already saw all of that, I’m aware of that. My thing is, like, what we have set up in the environment file right now, and that login, it’s all the same account, right?
423 00:40:49.580 ⇒ 00:40:52.659 Awaish Kumar: It’s for that account for that account, right? Yes.
424 00:40:54.040 ⇒ 00:40:54.810 Advait Nandakumar Menon: Oka.
425 00:40:55.220 ⇒ 00:41:04.060 Awaish Kumar: That’s why we are able to carry the snowflake, elements data, because… this Snowflake account identifier.
426 00:41:04.350 ⇒ 00:41:07.149 Awaish Kumar: is identifying the exact same account for Elevate.
427 00:41:08.860 ⇒ 00:41:09.620 Advait Nandakumar Menon: Okay.
428 00:41:22.460 ⇒ 00:41:24.630 Awaish Kumar: But then you have to, like…
429 00:41:26.000 ⇒ 00:41:29.820 Awaish Kumar: Maybe now, when it says you don’t have privileges, you can…
430 00:41:29.980 ⇒ 00:41:33.440 Awaish Kumar: change the role to CICD role, for example, and try it out.
431 00:41:33.900 ⇒ 00:41:34.830 Awaish Kumar: punishment.
432 00:41:35.370 ⇒ 00:41:36.510 Awaish Kumar: Work, that’s it.
433 00:41:39.710 ⇒ 00:41:44.300 Awaish Kumar: But now that you have… It is, you might…
434 00:41:45.090 ⇒ 00:41:48.850 Awaish Kumar: Be able to do a lot more than…
435 00:41:51.880 ⇒ 00:41:55.999 Awaish Kumar: than what you, like, what you can do with less probability, so…
436 00:41:56.130 ⇒ 00:42:02.569 Awaish Kumar: So ask Cursor to, like, create tables, query data, everything, and yeah, don’t ask it to drop anything.
437 00:42:05.690 ⇒ 00:42:06.420 Advait Nandakumar Menon: Okay.
438 00:42:06.420 ⇒ 00:42:12.109 Awaish Kumar: And yeah, never touch raw, I think. That’s… that’s my suggestion. Normally in the raw.
439 00:42:12.420 ⇒ 00:42:15.640 Awaish Kumar: Data, we… we can use it to debug things.
440 00:42:15.910 ⇒ 00:42:17.179 Awaish Kumar: But that is the most…
441 00:42:17.180 ⇒ 00:42:18.330 Advait Nandakumar Menon: Yeah, that’s what I do.
442 00:42:18.510 ⇒ 00:42:22.039 Awaish Kumar: That is the most problematic thing. If you drop anything anywhere else.
443 00:42:22.180 ⇒ 00:42:25.199 Awaish Kumar: We can recreate it using dbt.
444 00:42:26.600 ⇒ 00:42:28.899 Awaish Kumar: If you drop anything in raw.
445 00:42:29.210 ⇒ 00:42:31.140 Awaish Kumar: And then it’s a problem, so…
446 00:42:31.820 ⇒ 00:42:34.379 Awaish Kumar: Be careful whether you’re using raw database.
447 00:42:35.900 ⇒ 00:42:36.640 Advait Nandakumar Menon: Okay.
448 00:42:37.160 ⇒ 00:42:39.240 Advait Nandakumar Menon: Yeah, I’ve been…
449 00:42:39.780 ⇒ 00:42:44.549 Advait Nandakumar Menon: Yeah, I’ve been using raw, just looking at the raw data. Sometimes if something is not present in the fat.
450 00:42:44.710 ⇒ 00:42:45.179 Awaish Kumar: You know?
451 00:42:45.180 ⇒ 00:42:50.230 Advait Nandakumar Menon: table of water when I work my way backwards.
452 00:42:50.740 ⇒ 00:42:54.220 Advait Nandakumar Menon: sometimes I don’t see a table listed
453 00:42:54.340 ⇒ 00:43:01.150 Advait Nandakumar Menon: within the SQL code of a dbt model or whatever, like, the raw table, I’m not able to see it as a drop-down within the,
454 00:43:01.290 ⇒ 00:43:02.700 Advait Nandakumar Menon: Snowflake UI.
455 00:43:03.500 ⇒ 00:43:07.269 Advait Nandakumar Menon: So is it because of a permission issue, or something else?
456 00:43:08.030 ⇒ 00:43:11.569 Awaish Kumar: Like, what do you mean, you won’t… you are not able to see the table?
457 00:43:12.870 ⇒ 00:43:16.090 Advait Nandakumar Menon: Let me give you an example.
458 00:43:18.260 ⇒ 00:43:22.769 Awaish Kumar: Like, with Uttum’s account, you have access to everything, you should be able to see all the tables.
459 00:43:23.320 ⇒ 00:43:26.720 Advait Nandakumar Menon: Yeah, but I’m not sure… so there are two accounts…
460 00:43:26.920 ⇒ 00:43:35.060 Advait Nandakumar Menon: within 1Pass for Uttam, the one username is Utam K, and the other is Utam Kumaran, so…
461 00:43:35.550 ⇒ 00:43:39.430 Advait Nandakumar Menon: The one we are using, me and Jasmine are using, is Uttam Kumaran.
462 00:43:40.960 ⇒ 00:43:42.160 Awaish Kumar: Yep.
463 00:43:42.160 ⇒ 00:43:45.000 Advait Nandakumar Menon: I’m not sure if that has all the access you’re talking about.
464 00:43:45.370 ⇒ 00:43:46.240 Awaish Kumar: Yeah, yeah.
465 00:43:46.830 ⇒ 00:43:47.610 Awaish Kumar: liked.
466 00:43:49.480 ⇒ 00:43:52.779 Awaish Kumar: Yeah, Utam Kumaran, right? That is the…
467 00:43:53.190 ⇒ 00:43:55.369 Awaish Kumar: That username has all the access.
468 00:43:56.940 ⇒ 00:43:57.900 Advait Nandakumar Menon: Oh, okay.
469 00:44:01.610 ⇒ 00:44:03.389 Awaish Kumar: Okay, Jasmine, is it working?
470 00:44:05.540 ⇒ 00:44:07.320 Jasmin Multani: It’s still loading.
471 00:44:07.910 ⇒ 00:44:09.360 Jasmin Multani: Still running things.
472 00:44:14.300 ⇒ 00:44:21.489 Awaish Kumar: It’s just installing, like, Python, everything you didn’t… maybe you didn’t add before, that’s why. But it’s done right.
473 00:44:21.630 ⇒ 00:44:23.210 Awaish Kumar: If you click on this one.
474 00:44:24.040 ⇒ 00:44:25.180 Jasmin Multani: Go on DVD.
475 00:44:25.180 ⇒ 00:44:27.669 Awaish Kumar: Here, just click on, and we can see the logs.
476 00:44:28.340 ⇒ 00:44:35.200 Awaish Kumar: Yeah, so it’s basically just installing, like, dbt for you, dbt Snowflake…
477 00:44:35.400 ⇒ 00:44:38.239 Awaish Kumar: Python, so it’s just spreading up everything.
478 00:44:42.450 ⇒ 00:44:48.780 Jasmin Multani: Yeah, I think I had anaconda, but it was an old… Older version or something.
479 00:44:50.300 ⇒ 00:44:57.149 Awaish Kumar: Yeah, maybe… But after that is done, you would be able to run dbt.
480 00:44:58.050 ⇒ 00:44:58.670 Jasmin Multani: Okay.
481 00:44:59.530 ⇒ 00:45:02.450 Awaish Kumar: But you have to just learn a few things about dbt, like…
482 00:45:02.450 ⇒ 00:45:03.560 Jasmin Multani: Yeah, yeah.
483 00:45:03.970 ⇒ 00:45:04.750 Jasmin Multani: I think there’s…
484 00:45:05.490 ⇒ 00:45:13.430 Awaish Kumar: Right? We have 3 different targets for dbt. One is… if you open the profiles.yme file.
485 00:45:13.670 ⇒ 00:45:15.070 Awaish Kumar: I can just show you.
486 00:45:15.720 ⇒ 00:45:17.210 Jasmin Multani: This one? Do we two projects?
487 00:45:17.210 ⇒ 00:45:19.280 Awaish Kumar: No, no, profiles, not viable.
488 00:45:20.790 ⇒ 00:45:24.060 Awaish Kumar: It’s, it’s in there, like, under dbt project.
489 00:45:24.860 ⇒ 00:45:26.990 Jasmin Multani: Oh.
490 00:45:27.220 ⇒ 00:45:32.069 Awaish Kumar: No, no, under dbtproject.yml, you can see the profiles.yml.
491 00:45:32.440 ⇒ 00:45:33.760 Awaish Kumar: Scroll down a little bit.
492 00:45:33.760 ⇒ 00:45:34.979 Jasmin Multani: Okay, sorry.
493 00:45:35.750 ⇒ 00:45:36.350 Awaish Kumar: Okay.
494 00:45:36.680 ⇒ 00:45:42.009 Awaish Kumar: Here, we… you can see… You can see the dev.
495 00:45:42.960 ⇒ 00:45:46.300 Awaish Kumar: section, right? DEV, on the line number 7.
496 00:45:46.300 ⇒ 00:45:46.849 Jasmin Multani: I mean?
497 00:45:48.560 ⇒ 00:45:52.120 Awaish Kumar: And then on the line number 27, you can see CICD.
498 00:45:52.330 ⇒ 00:45:57.019 Awaish Kumar: And then, if you scroll down, you can see prod, line number 47.
499 00:45:57.500 ⇒ 00:46:06.679 Awaish Kumar: So… These are 3 different environments, like development environment, staging environment, and production environment.
500 00:46:06.990 ⇒ 00:46:09.759 Awaish Kumar: Right? If you run using…
501 00:46:10.520 ⇒ 00:46:15.890 Awaish Kumar: development environment, it will create tables in the development databases in Smoothlake.
502 00:46:16.220 ⇒ 00:46:17.210 Jasmin Multani: So…
503 00:46:17.210 ⇒ 00:46:18.660 Awaish Kumar: Very uni.
504 00:46:19.210 ⇒ 00:46:23.630 Awaish Kumar: So when you run dbt commands, you have to set up a flag called target.
505 00:46:23.760 ⇒ 00:46:27.649 Awaish Kumar: And if you set the target as a dev, then it will create data.
506 00:46:27.760 ⇒ 00:46:31.689 Awaish Kumar: It will create the tables in our dev databases in Snowflake.
507 00:46:31.800 ⇒ 00:46:38.749 Awaish Kumar: if you set up the target as CICD, it will create tables in a staining environment, and then
508 00:46:39.420 ⇒ 00:46:52.169 Awaish Kumar: create the flag as prod, it will create the tables in production environment. So normally, when we are trying to run something for testing purpose from our local machine, we only
509 00:46:52.320 ⇒ 00:46:54.150 Awaish Kumar: Use the dev flag.
510 00:46:54.650 ⇒ 00:46:55.789 Jasmin Multani: Oh, okay, this one.
511 00:46:55.790 ⇒ 00:46:59.040 Awaish Kumar: Which is, yeah, which is by default also set up as dev.
512 00:46:59.220 ⇒ 00:47:00.550 Awaish Kumar: Line number 4.
513 00:47:00.710 ⇒ 00:47:01.249 Awaish Kumar: I feel like…
514 00:47:01.250 ⇒ 00:47:01.840 Jasmin Multani: Bye.
515 00:47:02.930 ⇒ 00:47:03.760 Jasmin Multani: Yeah, okay.
516 00:47:03.860 ⇒ 00:47:18.549 Awaish Kumar: target dev. So, by default, it’s dev. So, whenever you run the command using it, using cursor chat, if we ask it to run, like, use dbt to run this model for me.
517 00:47:18.710 ⇒ 00:47:30.299 Awaish Kumar: It will create the model, but we just have to be careful that it uses… either it don’t use any flag for target, or it uses the flag, with a value with dev.
518 00:47:30.480 ⇒ 00:47:31.090 Awaish Kumar: So…
519 00:47:32.990 ⇒ 00:47:42.780 Awaish Kumar: once it is done, you can see the tables in Snowflake, and then you can use, you know, CLI to query inside the customer. So you don’t have to actually go into the Snowflake.
520 00:47:43.080 ⇒ 00:47:52.080 Awaish Kumar: Okay. The table here from chat, and then you can ask it to use UnSQLI to carry the table, so everything will be done inside of this.
521 00:47:52.410 ⇒ 00:47:53.850 Awaish Kumar: Okay, platform.
522 00:47:54.400 ⇒ 00:48:01.400 Jasmin Multani: That’s good. Yeah, I want to take the DBT certification before I start really playing around with
523 00:48:01.770 ⇒ 00:48:06.240 Jasmin Multani: modeling and stuff. I think Amber has that… is going through that right now.
524 00:48:21.480 ⇒ 00:48:23.870 Jasmin Multani: It should be, like, a few more minutes, I believe, right?
525 00:48:24.740 ⇒ 00:48:25.910 Jasmin Multani: None.
526 00:48:27.130 ⇒ 00:48:37.900 Jasmin Multani: Other than I have attending, like, another meeting in 15 minutes with them, but I’m hoping this will be done. You can feel free to skip, or sorry, drop if you have other things to do.
527 00:48:39.720 ⇒ 00:48:40.370 Awaish Kumar: Okay, literally.
528 00:48:40.370 ⇒ 00:48:40.920 Advait Nandakumar Menon: I’m just…
529 00:48:42.200 ⇒ 00:48:42.710 Awaish Kumar: Unless…
530 00:48:42.710 ⇒ 00:48:44.290 Jasmin Multani: You’re also downloading those.
531 00:48:46.170 ⇒ 00:48:48.449 Advait Nandakumar Menon: No, I’m actually trying to execute the…
532 00:48:48.750 ⇒ 00:48:51.060 Advait Nandakumar Menon: query, so that’s where I’m at.
533 00:48:55.320 ⇒ 00:48:59.549 Awaish Kumar: Okay, Jasmine, I will just drop then, and…
534 00:48:59.810 ⇒ 00:49:04.510 Awaish Kumar: You could ask now it to run… for example, let’s look at a…
535 00:49:04.640 ⇒ 00:49:08.500 Awaish Kumar: One of the models, in the models, Folder.
536 00:49:09.150 ⇒ 00:49:10.095 Jasmin Multani: Hmm…
537 00:49:11.040 ⇒ 00:49:12.989 Awaish Kumar: Let’s go to the intermediate.
538 00:49:14.330 ⇒ 00:49:19.320 Awaish Kumar: Yeah, and then maybe to… Maybe Shopify.
539 00:49:20.390 ⇒ 00:49:27.830 Awaish Kumar: Just go to Shopify, like… And copy any, like, into GS wholesale, for example.
540 00:49:28.370 ⇒ 00:49:28.910 Awaish Kumar: Copy the.
541 00:49:28.910 ⇒ 00:49:32.310 Jasmin Multani: So I just… Copy the path, okay.
542 00:49:32.690 ⇒ 00:49:34.720 Awaish Kumar: Yeah, we can copy path, or we can just…
543 00:49:35.420 ⇒ 00:49:39.170 Awaish Kumar: like, mention in the chat, like, with Ed, you can see.
544 00:49:41.640 ⇒ 00:49:45.889 Awaish Kumar: Use… yeah, like, use dbt to build this model.
545 00:49:48.370 ⇒ 00:49:49.270 Jasmin Multani: confused.
546 00:49:49.270 ⇒ 00:49:53.500 Awaish Kumar: ABT to build this model, for elements.
547 00:49:53.660 ⇒ 00:49:59.629 Awaish Kumar: For element, and in the… Using Target as dev.
548 00:50:01.200 ⇒ 00:50:01.800 Awaish Kumar: equals…
549 00:50:01.800 ⇒ 00:50:07.219 Advait Nandakumar Menon: So, Amesh, even for running a dbt SQL model code.
550 00:50:07.360 ⇒ 00:50:12.169 Advait Nandakumar Menon: A table has to always be created, like, right? That’s what you’re saying, right?
551 00:50:13.370 ⇒ 00:50:15.519 Advait Nandakumar Menon: Using the target command?
552 00:50:16.600 ⇒ 00:50:23.089 Awaish Kumar: No, no, for the dbt, we can… we always use the dbt to create tables, or update tables.
553 00:50:23.610 ⇒ 00:50:25.359 Advait Nandakumar Menon: Yeah, that I understand, yeah, but…
554 00:50:25.360 ⇒ 00:50:26.579 Awaish Kumar: So this is where…
555 00:50:29.340 ⇒ 00:50:41.999 Advait Nandakumar Menon: Yeah, just to execute or run a query, like the… for example, the weekly summary table code you have in the dbt model, to run something like that, just to look at the data.
556 00:50:42.310 ⇒ 00:50:43.929 Advait Nandakumar Menon: What should we do?
557 00:50:44.980 ⇒ 00:50:52.839 Awaish Kumar: just… if you want to just access the data, you just want to read the data, you can just use NoCLI. We just did before, like, Jasmine just.
558 00:50:52.840 ⇒ 00:50:53.370 Jasmin Multani: Thank you.
559 00:50:53.650 ⇒ 00:50:59.330 Awaish Kumar: Did it, like, a few minutes before, she asked, to get the sample data for a products table.
560 00:50:59.700 ⇒ 00:51:00.670 Awaish Kumar: And it actually works.
561 00:51:00.670 ⇒ 00:51:01.250 Advait Nandakumar Menon: Yep.
562 00:51:01.250 ⇒ 00:51:12.559 Awaish Kumar: Jasmine, it showed you the… all the sample data. So, for accessing data, you will just ask it to, okay, read data from this database for this table.
563 00:51:13.690 ⇒ 00:51:24.210 Advait Nandakumar Menon: Yeah, for that, only Snow CLI is enough. Okay, I got that. How about I want to manipulate or change the dbt code a little? In that instance, what should I do?
564 00:51:25.120 ⇒ 00:51:30.499 Awaish Kumar: Yeah, you can change the dbt code, right, in the files, right?
565 00:51:31.270 ⇒ 00:51:40.780 Awaish Kumar: in the cursor, like, you have all the model files, SQL file, you can change your code, and then you can just ask it to run in a dev.
566 00:51:40.920 ⇒ 00:51:42.900 Awaish Kumar: Like, as we just lost.
567 00:51:43.230 ⇒ 00:51:51.199 Awaish Kumar: We asked it to create this model using dbt with the target dev. So what it will do, it will create the table.
568 00:51:51.310 ⇒ 00:51:56.589 Awaish Kumar: using your logic, your updated logic, in a dev development environment. And then.
569 00:51:57.340 ⇒ 00:52:02.319 Awaish Kumar: You can verify your logic. Once table is created, you can run… do your validation.
570 00:52:02.490 ⇒ 00:52:03.379 Awaish Kumar: On top of it.
571 00:52:03.870 ⇒ 00:52:07.210 Awaish Kumar: And if it looks fine to you, then you can just…
572 00:52:07.950 ⇒ 00:52:09.930 Awaish Kumar: like, push it and create a PR.
573 00:52:11.120 ⇒ 00:52:12.700 Advait Nandakumar Menon: Okay. Okay.
574 00:52:14.980 ⇒ 00:52:15.770 Advait Nandakumar Menon: Water.
575 00:52:15.770 ⇒ 00:52:19.179 Awaish Kumar: So it worked, Jasmine. So it created a table in dev.
576 00:52:19.430 ⇒ 00:52:20.290 Awaish Kumar: No, it doesn’t.
577 00:52:20.290 ⇒ 00:52:20.860 Jasmin Multani: I created the.
578 00:52:20.860 ⇒ 00:52:26.720 Awaish Kumar: table. It is saying that it worked, and you have this table. If you click on this,
579 00:52:26.870 ⇒ 00:52:29.620 Awaish Kumar: build into GS terminal?
580 00:52:30.220 ⇒ 00:52:31.070 Awaish Kumar: Hmm.
581 00:52:31.450 ⇒ 00:52:33.509 Awaish Kumar: You can actually see, scroll down.
582 00:52:34.200 ⇒ 00:52:39.549 Awaish Kumar: In the logs, you can see it ran the dbt command, and it actually created this table.
583 00:52:39.550 ⇒ 00:52:39.870 Jasmin Multani: Mmm.
584 00:52:40.070 ⇒ 00:52:47.540 Awaish Kumar: Like, the… I should just read the line number… 4, 5, from… from below.
585 00:52:48.000 ⇒ 00:52:50.120 Awaish Kumar: So it is just saying you…
586 00:52:50.120 ⇒ 00:52:50.750 Jasmin Multani: Good.
587 00:52:50.750 ⇒ 00:52:52.860 Awaish Kumar: We created this table, yeah.
588 00:52:52.860 ⇒ 00:52:56.279 Jasmin Multani: so does this mean that, like.
589 00:52:56.480 ⇒ 00:52:59.459 Jasmin Multani: Only I have access to this new table.
590 00:52:59.460 ⇒ 00:53:14.930 Awaish Kumar: No, no, everybody who has access to Dev Intermediate database will have access to this table. But this dev environment is not a production environment. Whatever we… whatever, for example, going to Omni is going from production environment.
591 00:53:15.090 ⇒ 00:53:15.480 Jasmin Multani: Okay.
592 00:53:15.490 ⇒ 00:53:27.419 Awaish Kumar: You are… you can… you can update anything, you can create any table here, and you can verify. It won’t affect our Omni or any reporting, because our reporting depends on production environment only.
593 00:53:27.810 ⇒ 00:53:31.499 Jasmin Multani: Perfect, okay, just wanna, yeah, wanna make sure I’m not breaking anything.
594 00:53:32.160 ⇒ 00:53:48.069 Awaish Kumar: So, same here for Advait, like, you can do that, and change the code, you can ask it to run in dev environment, it will create a table in dev environment, you can validate it. Once you are sure that your changes are correct, you can push a PR,
595 00:53:49.090 ⇒ 00:53:59.090 Awaish Kumar: like, on GitHub, you can create a new branch, push your changes, create OPR, and assign a reviewer. After that, maybe I will review it, and then I merge it.
596 00:53:59.690 ⇒ 00:54:03.040 Awaish Kumar: When I merge it, you can see in production.
597 00:54:04.700 ⇒ 00:54:10.479 Advait Nandakumar Menon: Okay, and so that is Dev and Prod, and where does CICD fit into this?
598 00:54:10.760 ⇒ 00:54:13.459 Awaish Kumar: So, when you create the PR, then…
599 00:54:13.570 ⇒ 00:54:22.810 Awaish Kumar: before I merge it, I will check if it is running properly, like, because I don’t know… I don’t have access to your development environment, so what I will do is, for me to verify.
600 00:54:22.920 ⇒ 00:54:27.500 Awaish Kumar: The only environment I have is…
601 00:54:27.710 ⇒ 00:54:32.640 Awaish Kumar: at the PR, right? So, while there’s a PR, we run a few checks.
602 00:54:32.760 ⇒ 00:54:33.780 Awaish Kumar: Automatically.
603 00:54:34.450 ⇒ 00:54:36.719 Awaish Kumar: Whenever you create a plan, it will run some checks.
604 00:54:36.820 ⇒ 00:54:41.369 Awaish Kumar: So, during those checks, it will create the tables in the staging environment.
605 00:54:42.740 ⇒ 00:54:43.410 Awaish Kumar: So if…
606 00:54:43.410 ⇒ 00:54:44.599 Advait Nandakumar Menon: Yeah, okay, okay.
607 00:54:44.600 ⇒ 00:54:46.359 Awaish Kumar: Tables in the staging environment.
608 00:54:46.590 ⇒ 00:54:52.799 Awaish Kumar: And then we will merge it. And then it will create… once it is merged, it will create the same table in production.
609 00:54:54.080 ⇒ 00:54:56.490 Advait Nandakumar Menon: Okay, okay, understood.
610 00:54:57.400 ⇒ 00:54:58.620 Advait Nandakumar Menon: That was helpful.
611 00:55:00.490 ⇒ 00:55:04.110 Awaish Kumar: Okay, thanks. If you need anything, let me know.
612 00:55:05.610 ⇒ 00:55:08.250 Awaish Kumar: Otherwise, yeah, that’s all. Thank you.
613 00:55:08.720 ⇒ 00:55:09.280 Jasmin Multani: Thank you!
614 00:55:09.280 ⇒ 00:55:09.839 Advait Nandakumar Menon: Thank you, guys.
615 00:55:10.190 ⇒ 00:55:11.570 Jasmin Multani: Take care, bye.
616 00:55:11.570 ⇒ 00:55:12.230 Awaish Kumar: What?