Meeting Title: Brainforge Snowflake Connection Debugging Date: 2025-07-15 Meeting participants: Vishnu, Awaish Kumar
WEBVTT
1 00:03:20.480 ⇒ 00:03:23.900 Awaish Kumar: Hello! Vishnut! How? How are you doing?
2 00:03:25.115 ⇒ 00:03:27.189 Vishnu: Hello! Hi avish! I’m doing good.
3 00:03:27.750 ⇒ 00:03:28.779 Awaish Kumar: Okay, can.
4 00:03:28.780 ⇒ 00:03:29.110 Vishnu: To you.
5 00:03:29.920 ⇒ 00:03:37.549 Awaish Kumar: Okay, I’m I’m I’m good as well. So let’s start off with the the some of the tickets we have, and then we can.
6 00:03:37.760 ⇒ 00:03:41.190 Awaish Kumar: I get pair of program here about snowflake connection.
7 00:03:41.330 ⇒ 00:03:42.080 Vishnu: Okay. Okay.
8 00:03:43.030 ⇒ 00:03:45.299 Awaish Kumar: And we can try to solve that.
9 00:03:45.849 ⇒ 00:03:49.529 Awaish Kumar: So this one and this one, I, yeah, I
10 00:03:49.640 ⇒ 00:03:59.800 Awaish Kumar: don’t have the other task, I can just add. So we have been work into operating to basically snowflake
11 00:04:02.890 ⇒ 00:04:06.339 Awaish Kumar: as well, and I can assign it to you. So I’ve talked
12 00:04:07.538 ⇒ 00:04:16.750 Awaish Kumar: talk to the team, and we are kind of try to.
13 00:04:20.500 ⇒ 00:04:26.000 Awaish Kumar: So we try. Yeah, I will try to get this dashboarding task out of your plate so
14 00:04:26.000 ⇒ 00:04:49.340 Awaish Kumar: you can focus more on the back end on it and the analytics engineering side. So we will be working on the the retail pipelines building, or or the and the like analytics work, which is part of engineering, like writing SQL and data transformation. So that’s what we would be doing. And the dashboards like building actually charts which you have been
15 00:04:49.490 ⇒ 00:04:51.879 Awaish Kumar: just like. They’re asking me to
16 00:04:52.320 ⇒ 00:04:55.119 Awaish Kumar: move out of your plate. So we we can just
17 00:04:55.460 ⇒ 00:05:00.579 Awaish Kumar: I can, unassigned and weekends, and I will figure out how to handle that.
18 00:05:01.000 ⇒ 00:05:03.859 Vishnu: Okay, okay, thank you. Avish, appreciate that.
19 00:05:05.713 ⇒ 00:05:13.959 Awaish Kumar: But like, I want to understand, what is your availability? Because like. Obviously, it has been a week and we are not able
20 00:05:14.888 ⇒ 00:05:25.379 Awaish Kumar: to to know like, do much here. I just want to understand how is your availability? And so we can like plan our week. Accordingly.
21 00:05:26.909 ⇒ 00:05:32.229 Vishnu: Yes, so last week around this early hours of est I had
22 00:05:32.970 ⇒ 00:05:47.780 Vishnu: I mean, we were not able to connect. But going forward from this week, I think. Like next 3 to 4 h from 10 am. 10 Am. Est should I should be available for call.
23 00:05:49.220 ⇒ 00:05:50.270 Awaish Kumar: Alright.
24 00:05:50.870 ⇒ 00:05:52.670 Awaish Kumar: Okay, help.
25 00:05:53.630 ⇒ 00:06:00.290 Awaish Kumar: Yeah. So we are going to work on this in in this order. So we are going to finish
26 00:06:00.430 ⇒ 00:06:04.399 Awaish Kumar: better program right now to to also solve this. You know, flag
27 00:06:04.630 ⇒ 00:06:24.039 Awaish Kumar: issue. After that we are going like you are going to finalize this to task. Then we are going to create Dbt task. So yeah, you don’t have to do this like this is, if you wanna like, you can ex like, you have to explore data, because otherwise, how are you going to create models?
28 00:06:24.040 ⇒ 00:06:24.450 Awaish Kumar: Yes.
29 00:06:24.450 ⇒ 00:06:33.449 Awaish Kumar: So, yeah, like, the DVD model is like, kind of SQL data transformation for that. Also, we need to understand table structures, schemas and the data itself.
30 00:06:33.770 ⇒ 00:06:38.119 Awaish Kumar: I’m just so this is kind of exploration. If you want to like.
31 00:06:38.600 ⇒ 00:06:45.860 Awaish Kumar: like, I can just remove it right from here because we are not. You don’t have to go to the real data, basically now.
32 00:06:46.070 ⇒ 00:06:46.430 Awaish Kumar: But
33 00:06:46.430 ⇒ 00:06:54.589 Awaish Kumar: real data is a visualization platform. So we? You are not going to handle the visualizations. I I will remove it from your plate.
34 00:06:55.630 ⇒ 00:06:57.220 Awaish Kumar: Okay? As well.
35 00:06:58.166 ⇒ 00:06:59.140 Awaish Kumar: So basically.
36 00:06:59.260 ⇒ 00:07:03.899 Awaish Kumar: we will be what we will be working on. We will still be working on all the same things
37 00:07:04.448 ⇒ 00:07:12.619 Awaish Kumar: kind of preparing the data and the modeler models for these dashboards. But the I will find out someone else’s
38 00:07:12.780 ⇒ 00:07:17.920 Awaish Kumar: time to build those dashboards for us, and we are going to work on this back end.
39 00:07:19.890 ⇒ 00:07:21.760 Awaish Kumar: So basically.
40 00:07:21.960 ⇒ 00:07:25.379 Awaish Kumar: So this is kind of now we are at the end of these 2.
41 00:07:25.630 ⇒ 00:07:28.459 Awaish Kumar: I think this these balls should be like
42 00:07:29.650 ⇒ 00:07:32.350 Awaish Kumar: I can keep it 5. But now it should not take much
43 00:07:32.860 ⇒ 00:07:35.010 Awaish Kumar: like time like it should be like
44 00:07:35.851 ⇒ 00:07:53.299 Awaish Kumar: after the snowflake issues all it should be done in few hours, and then we can create the Dbt project. And as you already have the meeting with marketing team, what I want from you now on this ticket is that like, create a notion document.
45 00:07:53.410 ⇒ 00:07:56.079 Awaish Kumar: you already have that meeting in the
46 00:07:56.679 ⇒ 00:08:01.070 Awaish Kumar: in the Brainforge dot like platform.brainforge.ai.
47 00:08:01.430 ⇒ 00:08:25.540 Awaish Kumar: Which I already shared on that platform. If you go there, you can figure out where’s your meeting? You can get your transcript from their notes from there. Everything. Just build a notion talk. Use the AI use chat, gpt, use whatever tool you wanna use and provide that transcription. We already included the AI boards inside that platform. You can even use that.
48 00:08:25.760 ⇒ 00:08:39.272 Awaish Kumar: So it can help you summarize your requirements and create action items. Things like that. So just creation create a notion document with the requirements that marketing team asked for. Like, kind of
49 00:08:40.720 ⇒ 00:09:05.160 Awaish Kumar: data kind of dashboard. They are looking for things like that. So we can. So output of this ticket is whatever you discuss and discuss in that meeting. Just put a link here of a notion document which basically will have all that asked from marketing. And then I’m I’m going to get this. Split it into a few tasks and all the back end.
50 00:09:05.330 ⇒ 00:09:11.010 Awaish Kumar: That’s where we have to work on the getting the data from somewhere or for the
51 00:09:11.170 ⇒ 00:09:14.390 Awaish Kumar: modeling. We are going to work on that. And then
52 00:09:14.580 ⇒ 00:09:18.120 Awaish Kumar: again, visualization will be going to somewhere else.
53 00:09:19.010 ⇒ 00:09:19.690 Vishnu: Okay.
54 00:09:19.690 ⇒ 00:09:20.670 Vishnu: Okay. Yes.
55 00:09:20.670 ⇒ 00:09:21.680 Awaish Kumar: So here.
56 00:09:22.410 ⇒ 00:09:30.979 Awaish Kumar: this is basically kind of at the end of it. This is also kind of just DVD creating a template project which is not going to be
57 00:09:31.110 ⇒ 00:09:40.090 Awaish Kumar: sort of. And then this document. So at least like if we can get all the all all of these to get today out.
58 00:09:40.480 ⇒ 00:09:41.060 Vishnu: Have a good guy.
59 00:09:41.993 ⇒ 00:09:46.800 Vishnu: Each can take like 1 1 and a half hour. Things like that’s all.
60 00:09:47.160 ⇒ 00:09:47.860 Vishnu: Okay.
61 00:09:50.590 ⇒ 00:09:58.749 Awaish Kumar: And then I can put more here. I can like I’m just putting some tasks in in there because
62 00:09:59.432 ⇒ 00:10:02.599 Awaish Kumar: today’s Tuesday. And I I just want
63 00:10:02.700 ⇒ 00:10:06.670 Awaish Kumar: that you have, you know already, like, what is the plan for the week?
64 00:10:09.360 ⇒ 00:10:17.520 Awaish Kumar: So like it’s companies are continuing to. So
65 00:10:20.540 ⇒ 00:10:28.849 Awaish Kumar: so for this, like, we need to have linkedin data also into our snowflake, I’m not sure if it’s only there.
66 00:10:28.970 ⇒ 00:10:55.219 Awaish Kumar: So what we basically want to do is number. First, st task is to get our internal data. Internal data made. All the posts which are done by brain forge and the team like my brain forge account. So we are going to get all those posts, and we are going to see the like we are going to like, analyze the impressions on the post, likes, comments, whatever like. We want to see how our performing
67 00:10:55.420 ⇒ 00:10:59.309 Awaish Kumar: our like, the mark our campaigns are doing like.
68 00:11:00.240 ⇒ 00:11:03.669 Awaish Kumar: So yeah, just I’m going to put it into do
69 00:11:04.366 ⇒ 00:11:10.780 Awaish Kumar: so this is just one internal one, and we have a similar one. I can say it.
70 00:11:12.030 ⇒ 00:11:16.476 Awaish Kumar: 2 million on assign, and the other one is
71 00:11:19.310 ⇒ 00:11:27.169 Awaish Kumar: is kind of similar, like we have to get Linkedin post information. But that’s more like, about the
72 00:11:27.500 ⇒ 00:11:36.749 Awaish Kumar: competitor. Competitor likes that companies which are kind of doing similar data consultancy work. And the
73 00:11:36.970 ⇒ 00:11:39.500 Awaish Kumar: we are going to analyze their post as well.
74 00:11:41.440 ⇒ 00:11:42.190 Vishnu: Okay.
75 00:11:43.870 ⇒ 00:12:01.519 Awaish Kumar: So 1st of all, we are going to bring in the data for internal build the modeling further, then we go after this one. Bring in the computer data. We’ll build some models and maybe then build some summary team of models which are going to compare our internal
76 00:12:01.910 ⇒ 00:12:07.460 Awaish Kumar: with with this competitors content, like, okay, like, for the last week.
77 00:12:07.670 ⇒ 00:12:10.659 Awaish Kumar: this is the engagement on the brain force
78 00:12:11.080 ⇒ 00:12:17.599 Awaish Kumar: platform. And this is the engagement for this competitor. Xyz computer. ABC’s things like that.
79 00:12:17.950 ⇒ 00:12:22.150 Vishnu: Okay, so do we have, like the names of the competitors, or we have to go search.
80 00:12:22.150 ⇒ 00:12:26.620 Awaish Kumar: Yeah, we are going to get. No, no, we are going to get get it from marketing team.
81 00:12:26.620 ⇒ 00:12:27.989 Vishnu: Got it. Okay, okay.
82 00:12:34.230 ⇒ 00:12:36.940 Awaish Kumar: Yeah, these are basically.
83 00:12:37.660 ⇒ 00:12:41.840 Awaish Kumar: So yeah, this like, this is kind of says, dashboard.
84 00:12:42.220 ⇒ 00:12:51.229 Awaish Kumar: Let’s see, I can just ingest internal internal means for our internal accounts.
85 00:12:53.630 ⇒ 00:12:54.559 Awaish Kumar: Do you have.
86 00:12:55.160 ⇒ 00:12:55.890 Vishnu: Yep.
87 00:12:56.300 ⇒ 00:13:04.949 Vishnu: I feel all of this should not take lot of time, just if we like. Figure like I’m I’m still not able to figure out the Snowflake connection. Like I.
88 00:13:04.950 ⇒ 00:13:06.300 Awaish Kumar: Yeah, very old.
89 00:13:06.300 ⇒ 00:13:10.670 Awaish Kumar: Let me finish this. Stand up like thing. Here.
90 00:13:10.670 ⇒ 00:13:11.000 Vishnu: Okay.
91 00:13:11.000 ⇒ 00:13:12.260 Awaish Kumar: Then we can. Now.
92 00:13:16.370 ⇒ 00:13:23.810 Awaish Kumar: yeah, then, we have to modeling internal Linkedin
93 00:13:28.310 ⇒ 00:13:34.819 Awaish Kumar: theater for me to visualize, we should our usage.
94 00:13:36.660 ⇒ 00:13:39.769 Awaish Kumar: But it’s so, yeah.
95 00:13:55.000 ⇒ 00:13:58.360 Awaish Kumar: so, yeah, this is kind of scrapping.
96 00:13:58.960 ⇒ 00:14:11.690 Awaish Kumar: This is ingesting is whatever. If we want to scrap or we can get through some Api like, this is what you have to explore, like how to get the internal data from our known accounts and from
97 00:14:11.800 ⇒ 00:14:16.469 Awaish Kumar: competitors account, and then model the internal and then model the
98 00:14:16.610 ⇒ 00:14:23.779 Awaish Kumar: coffee eaters Linkedin, so it should not take time. But I’m just putting some placeholders, miss.
99 00:14:24.000 ⇒ 00:14:29.130 Awaish Kumar: Basically. So we can just know, like what what we have done for?
100 00:14:39.830 ⇒ 00:14:40.790 Awaish Kumar: Okay.
101 00:14:54.630 ⇒ 00:14:58.210 Awaish Kumar: okay, anything else apart from this?
102 00:14:59.390 ⇒ 00:15:01.440 Awaish Kumar: Okay? And then
103 00:15:17.210 ⇒ 00:15:18.650 Awaish Kumar: the lease time.
104 00:15:18.870 ⇒ 00:15:23.310 Awaish Kumar: Yeah. So that’s it. I’m going to grow mother tickets for the
105 00:15:24.180 ⇒ 00:15:27.159 Awaish Kumar: We can talk about them afterwards. Okay, let’s
106 00:15:27.640 ⇒ 00:15:31.490 Awaish Kumar: share your screen, and we can do the debugging.
107 00:15:32.980 ⇒ 00:15:33.550 Vishnu: Okay.
108 00:15:53.370 ⇒ 00:15:55.420 Vishnu: Now, my screen is visible, right?
109 00:15:58.079 ⇒ 00:15:58.609 Awaish Kumar: Yep.
110 00:15:58.890 ⇒ 00:15:59.560 Vishnu: Okay?
111 00:16:00.270 ⇒ 00:16:07.719 Vishnu: Oh, so this was the entire. So initially this was the Api
112 00:16:07.820 ⇒ 00:16:13.290 Vishnu: call from our clockify. And so
113 00:16:13.786 ⇒ 00:16:18.210 Vishnu: the output. I stored in this just to like, see and explore the schema.
114 00:16:19.080 ⇒ 00:16:24.519 Vishnu: and then and clockify to snowflake pipeline.
115 00:16:25.177 ⇒ 00:16:28.800 Vishnu: This is the clockify Api. So.
116 00:16:29.140 ⇒ 00:16:31.640 Awaish Kumar: But can we just go to the Snowflake part.
117 00:16:32.410 ⇒ 00:16:36.360 Vishnu: Yeah, this is a snowflake part, and I was getting the
118 00:16:36.690 ⇒ 00:16:41.130 Awaish Kumar: So like, is this a pr, is this the real pr.
119 00:16:43.070 ⇒ 00:16:43.570 Vishnu: Oh, yeah.
120 00:16:43.570 ⇒ 00:16:48.880 Awaish Kumar: Yeah, you you pushed on the link in the the Pr request, complicated.
121 00:16:48.880 ⇒ 00:16:55.689 Vishnu: No, that was clockified to sheets, right? So that was different. That was here. Sorry that was operating pipeline.
122 00:16:55.910 ⇒ 00:16:56.740 Vishnu: Oh.
123 00:16:57.480 ⇒ 00:17:01.260 Awaish Kumar: Okay. But what? What is this project? I I can’t.
124 00:17:01.650 ⇒ 00:17:03.979 Vishnu: This is a clockify to snowflake.
125 00:17:04.540 ⇒ 00:17:08.449 Awaish Kumar: Yeah, so it should be. In what repository is it in? It should be in the.
126 00:17:09.560 ⇒ 00:17:10.439 Vishnu: Oh, okay, so.
127 00:17:10.440 ⇒ 00:17:11.720 Awaish Kumar: No, I’m I’m.
128 00:17:11.720 ⇒ 00:17:18.996 Vishnu: My own local file, like I made a different folder. And so I’m for testing purposes. I don’t want to mess with the
129 00:17:19.440 ⇒ 00:17:20.060 Vishnu: report.
130 00:17:20.069 ⇒ 00:17:20.659 Awaish Kumar: Okay.
131 00:17:20.660 ⇒ 00:17:26.097 Vishnu: Once I sorted out offline. I was like, Okay, then I’m gonna like, push it to the repo.
132 00:17:26.400 ⇒ 00:17:31.050 Awaish Kumar: But, like some of the things are like, I, we okay, you can.
133 00:17:31.270 ⇒ 00:17:39.889 Awaish Kumar: If if you like, you can develop locally in the same repo is not a problem. As long as you just create a
134 00:17:40.070 ⇒ 00:17:42.189 Awaish Kumar: like inside the same local.
135 00:17:42.839 ⇒ 00:17:47.869 Awaish Kumar: We have to create a new branch work there. If you were not happy with the work. Just
136 00:17:48.070 ⇒ 00:17:51.520 Awaish Kumar: discard the work in the branch right? Move out
137 00:17:51.760 ⇒ 00:17:53.960 Awaish Kumar: and delete that branch. So that’s
138 00:17:54.120 ⇒ 00:17:57.830 Awaish Kumar: like that’s that’s that way. You can utilize some of the things
139 00:17:58.210 ⇒ 00:18:08.749 Awaish Kumar: which are already in the like. For example, in reading the environment variables like, here you have to write about OS OS dot Getty, and we also
140 00:18:08.900 ⇒ 00:18:13.899 Awaish Kumar: there we are. We are going to get from Dexter’s. We’re going to use Dexter.
141 00:18:14.120 ⇒ 00:18:16.070 Awaish Kumar: even if you all think
142 00:18:16.240 ⇒ 00:18:23.309 Awaish Kumar: so that’s like, kind of you have to like, duplicate your work once we are, we get it running here. Then again, you have to.
143 00:18:23.847 ⇒ 00:18:32.610 Awaish Kumar: Transfer everything based on taxes. So that’s only thing. But we can debug here. No, no issues. You can do that afterwards for your next task.
144 00:18:32.610 ⇒ 00:18:46.251 Vishnu: Okay from yeah. Going forward. I’ll do that. So just to begin with, this was the entire pipeline that I built out based off the previous Google sheets pipeline and your Google sheets pipeline. So
145 00:18:46.750 ⇒ 00:18:48.340 Vishnu: then, what else.
146 00:18:48.340 ⇒ 00:18:53.030 Awaish Kumar: Let’s go to the exact part like I just want to have.
147 00:18:53.190 ⇒ 00:18:56.970 Awaish Kumar: Yes, so they comment out the other parts just.
148 00:18:56.970 ⇒ 00:18:58.529 Vishnu: So I just added it to a new.
149 00:18:58.530 ⇒ 00:19:00.210 Awaish Kumar: To establish the connection.
150 00:19:00.210 ⇒ 00:19:10.580 Vishnu: Yes, I I added it to a new file. And so here based of the slack message that you sent me. This is the private key this is the user account.
151 00:19:10.790 ⇒ 00:19:17.218 Vishnu: This is the account warehouse role database schema clockify
152 00:19:18.600 ⇒ 00:19:25.819 Vishnu: So here. Oh, where? The snowflake?
153 00:19:28.200 ⇒ 00:19:41.310 Vishnu: Yeah, I I’ve verified it here. So it yeah. All the permissions looked right. And I also asked, like Gemini to look and verify for me. And it said, Gemini also said, Yeah, it looks good.
154 00:19:41.490 ⇒ 00:19:44.780 Vishnu: So yeah, when I run this
155 00:19:47.520 ⇒ 00:19:47.840 Awaish Kumar: Yeah.
156 00:19:47.840 ⇒ 00:19:51.030 Vishnu: testconnection.py of.
157 00:19:52.050 ⇒ 00:20:00.450 Vishnu: So it starts the snowflake. It says, user and decoding private key and test field error, invalid private key. So
158 00:20:01.700 ⇒ 00:20:09.090 Vishnu: it, is it? It prints out all of this, it prints the it it starts, it enters this.
159 00:20:09.090 ⇒ 00:20:09.550 Awaish Kumar: That’s ring.
160 00:20:09.660 ⇒ 00:20:13.090 Vishnu: And then it exits with a error message.
161 00:20:19.417 ⇒ 00:20:23.179 Awaish Kumar: Privately is there? And you have the
162 00:20:25.240 ⇒ 00:20:27.560 Awaish Kumar: okay. Let me run it here
163 00:20:27.770 ⇒ 00:20:30.359 Awaish Kumar: on my machine. Let’s see what?
164 00:20:36.620 ⇒ 00:20:38.380 Awaish Kumar: Let me cancel.
165 00:20:48.210 ⇒ 00:20:49.060 Awaish Kumar: See?
166 00:21:17.680 ⇒ 00:21:18.510 Awaish Kumar: Okay?
167 00:21:19.747 ⇒ 00:21:22.729 Awaish Kumar: So I’m not getting any errors.
168 00:21:25.150 ⇒ 00:21:30.519 Awaish Kumar: So like, can I see your file?
169 00:21:31.895 ⇒ 00:21:38.029 Awaish Kumar: Let’s can we debug? Can we just put and and
170 00:21:39.330 ⇒ 00:21:43.880 Awaish Kumar: on the line number 36. Just put her like this break.
171 00:21:47.695 ⇒ 00:21:52.530 Awaish Kumar: Is it like this is Vs code, or something else? Vs, code? Right?
172 00:21:52.790 ⇒ 00:21:53.950 Vishnu: This is Windsurf.
173 00:21:55.120 ⇒ 00:21:57.599 Awaish Kumar: Can we? Can we debug in that.
174 00:21:57.940 ⇒ 00:22:00.290 Vishnu: Yes. After lunch.
175 00:22:00.290 ⇒ 00:22:01.540 Awaish Kumar: Only that we both won’t.
176 00:22:02.750 ⇒ 00:22:04.639 Awaish Kumar: Yeah, let me stop here.
177 00:22:07.940 ⇒ 00:22:10.140 Vishnu: Python, debugger, debug, python, file.
178 00:22:10.480 ⇒ 00:22:11.170 Awaish Kumar: Oh, yeah.
179 00:22:19.480 ⇒ 00:22:22.459 Awaish Kumar: yes, just click finish.
180 00:22:24.650 ⇒ 00:22:27.040 Awaish Kumar: Did it wine? Or what happened?
181 00:22:30.280 ⇒ 00:22:33.246 Awaish Kumar: Okay, yeah. Can you put this red?
182 00:22:33.930 ⇒ 00:22:41.039 Awaish Kumar: And there’s can you go on the line number 37, 36, basically.
183 00:22:41.180 ⇒ 00:22:42.110 Vishnu: 36.
184 00:22:42.110 ⇒ 00:22:46.249 Awaish Kumar: Yeah, just go on the where 36 is written
185 00:22:46.560 ⇒ 00:22:49.700 Awaish Kumar: on the left side. Just go in on that like you scroll
186 00:22:50.690 ⇒ 00:22:54.809 Awaish Kumar: scroll on the text where it says, 36,
187 00:22:55.980 ⇒ 00:22:58.220 Awaish Kumar: and and yeah, it’s again move
188 00:22:59.750 ⇒ 00:23:04.380 Awaish Kumar: questionable, like when you go on the line text where it says, 36.
189 00:23:05.630 ⇒ 00:23:06.430 Vishnu: Here.
190 00:23:08.500 ⇒ 00:23:11.030 Awaish Kumar: Thank the line number 36.
191 00:23:11.220 ⇒ 00:23:12.380 Vishnu: Yeah, I’m on line number 30.
192 00:23:12.380 ⇒ 00:23:17.109 Awaish Kumar: Yeah. But just go where it is written, 36. Where is 36?
193 00:23:17.280 ⇒ 00:23:18.560 Awaish Kumar: Can you see 36.
194 00:23:19.450 ⇒ 00:23:20.730 Vishnu: Yes. Yeah.
195 00:23:20.730 ⇒ 00:23:24.239 Awaish Kumar: Yes, yeah. Like, just stay there like, keep your mouse there.
196 00:23:24.550 ⇒ 00:23:24.870 Vishnu: Okay.
197 00:23:24.870 ⇒ 00:23:27.229 Awaish Kumar: On the 36, not on the line. Just
198 00:23:27.440 ⇒ 00:23:30.890 Awaish Kumar: keep like, go, yeah, move little bit left.
199 00:23:32.090 ⇒ 00:23:37.360 Awaish Kumar: Yeah, like, click, like, like, right? Yeah, click here. Now, run the debugger.
200 00:23:41.940 ⇒ 00:23:45.670 Awaish Kumar: Yeah. Your debugger is not running like it’s not configured.
201 00:23:46.810 ⇒ 00:23:49.225 Awaish Kumar: Can you like, go from the top?
202 00:23:52.750 ⇒ 00:23:54.729 Awaish Kumar: yeah. Okay. Now we are here.
203 00:23:57.170 ⇒ 00:24:03.655 Awaish Kumar: So it’s saying, invalid, private key. When you see Private Key is
204 00:24:04.810 ⇒ 00:24:09.510 Awaish Kumar: what is that. Cls, that’s not happening in my code. Just remove that line
205 00:24:11.550 ⇒ 00:24:14.139 Awaish Kumar: serialization like, I’m not doing that.
206 00:24:15.720 ⇒ 00:24:16.120 Vishnu: Okay,
207 00:24:16.520 ⇒ 00:24:26.459 Awaish Kumar: No, I’m I’m doing that. Basically. Okay. It says, serialization load der private key. Okay? And then what
208 00:24:27.770 ⇒ 00:24:32.240 Awaish Kumar: scroll down password and backend is default back end.
209 00:24:33.100 ⇒ 00:24:39.080 Awaish Kumar: Okay? So that’s okay, can we go again? Then to the
210 00:24:41.300 ⇒ 00:24:44.359 Awaish Kumar: can you just like, stop this run.
211 00:24:45.070 ⇒ 00:24:46.080 Awaish Kumar: Click on the red.
212 00:24:49.440 ⇒ 00:24:54.279 Awaish Kumar: Yeah. And just okay, in the also, in the connection.
213 00:24:54.480 ⇒ 00:24:57.500 Awaish Kumar: it’s not. It’s not something I have.
214 00:25:00.760 ⇒ 00:25:05.300 Awaish Kumar: It was like the connection is missing a parameter called authenticator.
215 00:25:05.450 ⇒ 00:25:08.900 Awaish Kumar: Is it in the connection, like scroll down.
216 00:25:09.680 ⇒ 00:25:10.495 Vishnu: Connector,
217 00:25:11.870 ⇒ 00:25:21.279 Awaish Kumar: There’s there’s no connector right in the Snowflake dot Connector dot connect. It has a parameter called authenticator.
218 00:25:22.750 ⇒ 00:25:24.370 Vishnu: Oh! Oh! 10!
219 00:25:24.650 ⇒ 00:25:28.350 Awaish Kumar: Yeah, just copy paste from my code. Right?
220 00:25:28.460 ⇒ 00:25:30.370 Awaish Kumar: I am not sure why.
221 00:25:31.850 ⇒ 00:25:33.840 Vishnu: Okay, 1 min.
222 00:25:40.470 ⇒ 00:25:41.610 Awaish Kumar: This part.
223 00:25:45.780 ⇒ 00:25:46.920 Vishnu: Authenticator.
224 00:25:47.400 ⇒ 00:25:48.500 Vishnu: Oh, okay.
225 00:25:57.170 ⇒ 00:26:03.029 Awaish Kumar: Authenticator. And also can you move? And I want to look, have a look at private key.
226 00:26:04.430 ⇒ 00:26:05.110 Vishnu: Oh!
227 00:26:05.810 ⇒ 00:26:09.240 Awaish Kumar: Can you also copy the private key from the sluice?
228 00:26:10.090 ⇒ 00:26:12.880 Awaish Kumar: Oh, you are doing reading it from here.
229 00:26:13.700 ⇒ 00:26:14.180 Vishnu: Oh, okay.
230 00:26:15.470 ⇒ 00:26:17.490 Awaish Kumar: Let me see, my!
231 00:26:18.402 ⇒ 00:26:19.910 Awaish Kumar: We have in.
232 00:26:20.590 ⇒ 00:26:22.690 Vishnu: I’ll just paste. It cheers.
233 00:26:22.690 ⇒ 00:26:27.769 Awaish Kumar: And then this, okay, this is just a copy paste.
234 00:26:27.770 ⇒ 00:26:28.190 Vishnu: Yes.
235 00:26:30.060 ⇒ 00:26:33.529 Awaish Kumar: Okay. Can you show me? Can you go back?
236 00:26:35.980 ⇒ 00:26:40.540 Awaish Kumar: And then, if you are doing reading from here, can you scroll up a little bit
237 00:26:41.708 ⇒ 00:26:46.090 Awaish Kumar: I think. Then we don’t need where is going?
238 00:26:47.130 ⇒ 00:26:50.619 Awaish Kumar: Fiber key? Can we scroll up a little bit?
239 00:26:52.770 ⇒ 00:26:54.280 Awaish Kumar: Yeah.
240 00:26:54.560 ⇒ 00:26:57.880 Awaish Kumar: Then, what is this private key 8, 6, 4.
241 00:26:58.310 ⇒ 00:27:00.819 Awaish Kumar: You copy, paste it from environment variable.
242 00:27:02.950 ⇒ 00:27:07.099 Awaish Kumar: Okay, then just remove this line split.
243 00:27:07.920 ⇒ 00:27:11.569 Awaish Kumar: We should not be. We should not need that line number 10.
244 00:27:13.670 ⇒ 00:27:18.009 Awaish Kumar: This. Yeah, this function. Just remove the all of that.
245 00:27:18.770 ⇒ 00:27:25.320 Awaish Kumar: Remove everything even removal the the bracket in the line number 10.
246 00:27:25.320 ⇒ 00:27:25.970 Vishnu: Yeah, yeah.
247 00:27:25.970 ⇒ 00:27:29.959 Awaish Kumar: And just, yeah, just remove this replace.
248 00:27:30.690 ⇒ 00:27:31.240 Vishnu: Just.
249 00:27:31.780 ⇒ 00:27:34.250 Awaish Kumar: Make it a string, a simple string.
250 00:27:37.100 ⇒ 00:27:42.960 Awaish Kumar: Right now I try to run it. What? It says.
251 00:27:50.350 ⇒ 00:27:55.019 Awaish Kumar: Okay, why are you getting that?
252 00:28:00.900 ⇒ 00:28:06.989 Awaish Kumar: What’s this prepays 64, p. 6, 42.
253 00:28:09.874 ⇒ 00:28:11.530 Vishnu: Except for value error.
254 00:28:30.670 ⇒ 00:28:31.060 Awaish Kumar: It’s.
255 00:28:31.060 ⇒ 00:28:35.150 Vishnu: Can I regenerate, like the public and private keys here.
256 00:28:35.980 ⇒ 00:28:43.369 Awaish Kumar: If you can. But why like? It’s not have you, you can regenerate. But the user is using this private key.
257 00:28:43.570 ⇒ 00:28:44.190 Vishnu: Okay.
258 00:28:44.190 ⇒ 00:28:45.330 Awaish Kumar: The snowflake.
259 00:28:45.570 ⇒ 00:28:52.270 Awaish Kumar: So this public, like public key against this private key. So hence, even if you
260 00:28:52.988 ⇒ 00:28:57.899 Awaish Kumar: generally, you have to change there and then, if you change there, then we all of us have to
261 00:28:58.110 ⇒ 00:29:01.101 Awaish Kumar: use your key. But like
262 00:29:01.900 ⇒ 00:29:08.370 Awaish Kumar: but this problem should not appear, because this is shareable, and oh.
263 00:29:09.070 ⇒ 00:29:13.979 Vishnu: Can I? Like, yeah, from next time I’ll just do it on a new branch. But yeah, I’m good.
264 00:29:13.980 ⇒ 00:29:31.370 Awaish Kumar: Let me just copy, paste this just copy, paste the my key. And use, it issues this
265 00:29:32.200 ⇒ 00:29:38.200 Awaish Kumar: in the yeah for the to use this. You have to.
266 00:29:48.910 ⇒ 00:29:51.499 Awaish Kumar: Now you have to split the line.
267 00:29:55.650 ⇒ 00:29:56.150 Vishnu: Oh!
268 00:29:56.310 ⇒ 00:30:00.730 Awaish Kumar: Yeah, either keep it in one line or just use this like.
269 00:30:01.240 ⇒ 00:30:03.239 Vishnu: I just use your entire thing.
270 00:30:03.560 ⇒ 00:30:04.220 Awaish Kumar: Yeah.
271 00:30:21.930 ⇒ 00:30:26.050 Awaish Kumar: Okay, can can you verify user account? And all these details?
272 00:30:26.700 ⇒ 00:30:30.400 Awaish Kumar: User is called internal service user reader.
273 00:30:31.040 ⇒ 00:30:38.200 Awaish Kumar: warehouse, is that correct? Like, can you confirm with my compare against the code there?
274 00:30:39.880 ⇒ 00:30:42.380 Awaish Kumar: Do you select from all.
275 00:31:06.650 ⇒ 00:31:13.159 Vishnu: This is your original, and this will be my.
276 00:31:27.100 ⇒ 00:31:34.960 Vishnu: a warehouse transform warehouse, transform roll, broad right role. Prod, right? So it looks correct. Right?
277 00:31:41.590 ⇒ 00:31:44.789 Vishnu: And I have added schema clockify.
278 00:31:45.560 ⇒ 00:31:49.230 Awaish Kumar: Okay, let’s go back and run this.
279 00:31:51.470 ⇒ 00:31:52.150 Vishnu: Okay.
280 00:31:58.190 ⇒ 00:32:01.120 Vishnu: run again, stop. First.st
281 00:32:13.680 ⇒ 00:32:14.919 Awaish Kumar: You too,
282 00:32:42.070 ⇒ 00:32:45.870 Vishnu: Oh, okay, it. It ran without any errors.
283 00:32:47.500 ⇒ 00:32:48.260 Awaish Kumar: Okay.
284 00:32:49.280 ⇒ 00:32:50.350 Vishnu: Until here!
285 00:32:51.450 ⇒ 00:32:52.340 Vishnu: Oh.
286 00:32:52.340 ⇒ 00:32:57.094 Awaish Kumar: Okay, we can run just just, please. No, no, just
287 00:32:57.870 ⇒ 00:33:05.249 Awaish Kumar: You could have just clicked on the play button on the left side.
288 00:33:05.250 ⇒ 00:33:05.970 Vishnu: This one.
289 00:33:06.530 ⇒ 00:33:10.980 Awaish Kumar: Yeah, continue, okay.
290 00:33:14.000 ⇒ 00:33:18.220 Vishnu: So that it entered here. And it
291 00:33:18.960 ⇒ 00:33:22.369 Vishnu: did it run a test? Query. It ran a test query.
292 00:33:22.470 ⇒ 00:33:31.120 Vishnu: And then, Okay, oh, okay, perfect. Oh, shit so it was just mistake with the copy.
293 00:33:35.770 ⇒ 00:33:45.029 Awaish Kumar: Now, like, let’s try to work on this like, let’s manually replace all these line splits.
294 00:33:46.310 ⇒ 00:33:47.650 Awaish Kumar: Let’s do it. Now.
295 00:33:47.880 ⇒ 00:33:51.000 Awaish Kumar: Here, okay, can you do it? Now?
296 00:33:51.200 ⇒ 00:33:55.329 Vishnu: Yes, yeah, I’ll go back to this.
297 00:33:56.710 ⇒ 00:33:57.520 Vishnu: And
298 00:33:58.680 ⇒ 00:34:04.440 Awaish Kumar: Not like just 1st work on that thing that let’s make this key
299 00:34:04.660 ⇒ 00:34:10.449 Awaish Kumar: and try, you know, like, just keep remove this replace function.
300 00:34:12.610 ⇒ 00:34:20.030 Awaish Kumar: I want this key to be in a single line. Remove the replace part, and make sure that
301 00:34:20.139 ⇒ 00:34:25.715 Awaish Kumar: there’s there are no line splits in the key itself. So just
302 00:34:27.489 ⇒ 00:34:29.399 Vishnu: Yeah, I’ll I’ll do that. I’ll do that.
303 00:34:29.843 ⇒ 00:34:34.950 Awaish Kumar: Keep the yeah, just keep the yeah, like these.
304 00:34:36.199 ⇒ 00:34:38.719 Vishnu: You want me to make it single line right?
305 00:34:38.719 ⇒ 00:34:46.659 Awaish Kumar: Yeah, just do it. Now we can put it and test it, and then we can put it in Dexter. So then it is easier for you to reference it.
306 00:34:46.989 ⇒ 00:34:51.879 Awaish Kumar: Okay, right? So I just do it while I’m here. Because again, the
307 00:34:52.179 ⇒ 00:34:54.839 Awaish Kumar: if there’s an issue like we sure
308 00:34:55.789 ⇒ 00:34:59.029 Awaish Kumar: we’ll have to like, we will be wasting our time again.
309 00:35:50.829 ⇒ 00:35:54.359 Awaish Kumar: I also remove this. What is that in the at the end?
310 00:35:55.909 ⇒ 00:36:01.949 Awaish Kumar: Yeah. And and also the line is split in the front and just move that.
311 00:36:04.499 ⇒ 00:36:09.839 Awaish Kumar: Yeah on the just go to the M and press back space.
312 00:36:12.809 ⇒ 00:36:16.039 Awaish Kumar: Okay, now try save it and try it.
313 00:36:18.629 ⇒ 00:36:20.569 Awaish Kumar: Yeah. Execute the.
314 00:36:32.589 ⇒ 00:36:33.879 Awaish Kumar: Are you running it?
315 00:36:34.180 ⇒ 00:36:35.996 Vishnu: Yes, I’m trying to run
316 00:36:37.290 ⇒ 00:36:38.130 Awaish Kumar: First.st
317 00:36:51.600 ⇒ 00:36:53.050 Vishnu: 1 min.
318 00:36:56.130 ⇒ 00:36:57.840 Awaish Kumar: You can press just as.
319 00:36:59.600 ⇒ 00:37:00.250 Vishnu: Okay.
320 00:37:07.470 ⇒ 00:37:10.009 Vishnu: let me stop the debug, and then I’ll run.
321 00:37:11.340 ⇒ 00:37:13.049 Awaish Kumar: Yeah, it’s okay. You can continue.
322 00:37:16.530 ⇒ 00:37:18.550 Awaish Kumar: Press on the continue button.
323 00:37:23.600 ⇒ 00:37:27.070 Vishnu: Yes, it is, it is running without errors.
324 00:37:28.530 ⇒ 00:37:29.180 Awaish Kumar: Is it.
325 00:37:29.180 ⇒ 00:37:29.620 Vishnu: Yes.
326 00:37:33.270 ⇒ 00:37:35.422 Awaish Kumar: Okay. So now,
327 00:37:36.140 ⇒ 00:37:38.499 Vishnu: It, it did, it did execute this.
328 00:37:38.500 ⇒ 00:37:43.049 Awaish Kumar: Let’s try to. Let’s try to create a table
329 00:37:43.620 ⇒ 00:37:47.540 Awaish Kumar: in the Cs dot execute, change the query to create table.
330 00:37:48.710 ⇒ 00:38:02.380 Awaish Kumar: So instead of select current timestamp. Just say, create table test, create table clockify dot test right
331 00:38:03.130 ⇒ 00:38:07.039 Awaish Kumar: in the snowflake in the clock. If I see one
332 00:38:07.220 ⇒ 00:38:12.540 Awaish Kumar: dot test is the table name and give a
333 00:38:15.420 ⇒ 00:38:18.439 Awaish Kumar: yeah. Just write the give the parenthesis and the
334 00:38:18.680 ⇒ 00:38:22.069 Awaish Kumar: name of the fun. One of the fields, a test field.
335 00:38:22.430 ⇒ 00:38:23.600 Vishnu: And then we can.
336 00:38:24.200 ⇒ 00:38:30.780 Awaish Kumar: Test table. Id int rookie, like, try to execute that.
337 00:38:40.690 ⇒ 00:38:45.159 Awaish Kumar: Okay, can we see in Snowflake if the table is created?
338 00:38:52.660 ⇒ 00:39:00.890 Awaish Kumar: Yeah, click on click on this home, this icon.
339 00:39:02.120 ⇒ 00:39:03.880 Vishnu: Data pieces.
340 00:39:04.640 ⇒ 00:39:05.500 Awaish Kumar: Yes.
341 00:39:05.680 ⇒ 00:39:06.550 Vishnu: Or I can search.
342 00:39:06.550 ⇒ 00:39:08.430 Awaish Kumar: Yeah, you can click on databases
343 00:39:10.260 ⇒ 00:39:12.900 Awaish Kumar: in the wrong clock if I
344 00:39:15.740 ⇒ 00:39:26.749 Awaish Kumar: tables test table. Okay? So it is can create table that features can also curate. So it is okay. So what you you have to create a table, and it is creating the table.
345 00:39:26.920 ⇒ 00:39:27.270 Vishnu: Yes.
346 00:39:27.270 ⇒ 00:39:33.129 Awaish Kumar: So it will solve your problem. So now copy that copy that private key.
347 00:39:34.530 ⇒ 00:39:39.350 Awaish Kumar: Let’s copy it without the quotes.
348 00:39:39.990 ⇒ 00:39:45.389 Awaish Kumar: Just copy the key from M to end of it
349 00:39:46.120 ⇒ 00:39:50.119 Awaish Kumar: and put it in like log into dexter cloud.
350 00:39:52.930 ⇒ 00:40:06.600 Awaish Kumar: In the deployments, environment variables, add environment variable, and name it as rainforge
351 00:40:10.330 ⇒ 00:40:18.750 Awaish Kumar: reinforge, internal service user reader, whatever it is from here.
352 00:40:21.675 ⇒ 00:40:22.070 Awaish Kumar: So.
353 00:40:22.070 ⇒ 00:40:24.070 Vishnu: I don’t know service.
354 00:40:24.070 ⇒ 00:40:26.030 Awaish Kumar: User reader.
355 00:40:26.030 ⇒ 00:40:26.845 Vishnu: User
356 00:40:27.660 ⇒ 00:40:31.959 Awaish Kumar: And the reader, and then also brain forge, underscore snowflake.
357 00:40:32.830 ⇒ 00:40:34.699 Awaish Kumar: So we know it’s for snowflake
358 00:40:37.734 ⇒ 00:40:38.490 Awaish Kumar: underscore.
359 00:40:39.360 ⇒ 00:40:44.420 Awaish Kumar: Yeah, where’s the value and the value?
360 00:40:44.590 ⇒ 00:40:46.049 Awaish Kumar: And just see if
361 00:40:49.140 ⇒ 00:40:50.020 Awaish Kumar: okay.
362 00:40:50.730 ⇒ 00:40:59.630 Awaish Kumar: So now you can just reference this thing value in your okay script and load it.
363 00:41:00.530 ⇒ 00:41:01.060 Awaish Kumar: So.
364 00:41:01.060 ⇒ 00:41:02.870 Vishnu: Okay, I guess. Okay. Oh, my God.
365 00:41:03.060 ⇒ 00:41:08.809 Vishnu: I spent a lot of time trying to like I I should have like checked the string itself.
366 00:41:10.240 ⇒ 00:41:19.189 Awaish Kumar: Okay, that’s okay. So you can now work on this. And I will like, let me know whenever you have a Pr ready to review. Okay, thank you.
367 00:41:19.500 ⇒ 00:41:21.659 Vishnu: Yeah, thank you. Avish. Bye-bye.