Meeting Title: Dexter Cloud Daily Standup Date: 2025-07-08 Meeting participants: Awaish Kumar, Vishnu
WEBVTT
1 00:01:33.200 ⇒ 00:01:34.050 Vishnu: Hello!
2 00:01:35.660 ⇒ 00:01:37.220 Vishnu: Oh, good morning! Avish!
3 00:01:38.340 ⇒ 00:01:39.880 Awaish Kumar: Yeah. Good morning.
4 00:01:42.073 ⇒ 00:01:46.209 Vishnu: Yes, to give you an update on yesterday’s work.
5 00:01:46.865 ⇒ 00:01:52.390 Vishnu: I got stuck at the clockify Api key. I was not able to figure out that
6 00:01:52.820 ⇒ 00:01:54.350 Vishnu: click, a button.
7 00:01:54.830 ⇒ 00:01:56.610 Awaish Kumar: Have you logged into Dexter Cloud.
8 00:01:58.500 ⇒ 00:01:59.340 Vishnu: Yes.
9 00:01:59.710 ⇒ 00:02:01.860 Awaish Kumar: So can you please share your screen?
10 00:02:04.090 ⇒ 00:02:05.479 Vishnu: Hold on!
11 00:02:07.490 ⇒ 00:02:08.180 Vishnu: Oh.
12 00:02:25.910 ⇒ 00:02:27.599 Vishnu: my screen is visible right.
13 00:02:30.865 ⇒ 00:02:33.630 Awaish Kumar: Yes. Can you please open the tax store.
14 00:02:34.180 ⇒ 00:02:34.795 Vishnu: Yes,
15 00:02:35.800 ⇒ 00:02:37.719 Awaish Kumar: So can you go to deployment.
16 00:02:39.310 ⇒ 00:02:40.070 Vishnu: Deployment.
17 00:02:40.670 ⇒ 00:02:47.380 Awaish Kumar: Risk environment variables and search for clockify.
18 00:02:48.140 ⇒ 00:02:49.210 Vishnu: Yes. Okay.
19 00:02:49.210 ⇒ 00:02:54.410 Awaish Kumar: Yeah, so you can click on this. I I couldn’t.
20 00:02:54.750 ⇒ 00:02:56.430 Awaish Kumar: And we can see the pi key.
21 00:02:57.500 ⇒ 00:03:00.349 Awaish Kumar: You can copy that and put it in your
22 00:03:00.730 ⇒ 00:03:10.160 Awaish Kumar: dot, envy, like in like, in your environment, you must. You have, for example, if you have a if you are using virtual environment, you can like.
23 00:03:10.550 ⇒ 00:03:11.960 Awaish Kumar: just export it.
24 00:03:13.900 ⇒ 00:03:17.830 Awaish Kumar: This environment variable with the name Google clockify Api key.
25 00:03:18.140 ⇒ 00:03:21.120 Awaish Kumar: and then your script will just read it.
26 00:03:22.170 ⇒ 00:03:23.190 Vishnu: Okay. Okay.
27 00:03:23.530 ⇒ 00:03:24.280 Awaish Kumar: And then you can.
28 00:03:24.280 ⇒ 00:03:26.889 Vishnu: Okay, I guess I’ll do that. Yeah, okay.
29 00:03:27.290 ⇒ 00:03:27.880 Vishnu: And
30 00:03:28.920 ⇒ 00:03:40.344 Vishnu: I was just figuring out when we talk on meetings. Right? Is there a tool for us to like summarize the meetings or like. So I was thinking, I just installed one software.
31 00:03:40.680 ⇒ 00:03:42.349 Awaish Kumar: Don’t need to. I told you that.
32 00:03:42.945 ⇒ 00:03:53.179 Awaish Kumar: You can go into the in the initial meeting. I I have directed you to go to demo.brainfolk.com.
33 00:03:54.150 ⇒ 00:03:59.500 Awaish Kumar: Oh, yes, yes, form, and you can go there. Find the meetings. You can see the notes and everything.
34 00:04:02.370 ⇒ 00:04:05.049 Awaish Kumar: Gordon, you will have. You will have all the meetings.
35 00:04:06.360 ⇒ 00:04:09.459 Vishnu: Okay. Once the meeting is ended, it will come here. Okay. Got it.
36 00:04:09.460 ⇒ 00:04:13.800 Awaish Kumar: Yeah, we consult in the top based on the
37 00:04:14.220 ⇒ 00:04:17.560 Awaish Kumar: title or the id of the meeting, and you can just.
38 00:04:19.779 ⇒ 00:04:20.449 Vishnu: Okay.
39 00:04:22.469 ⇒ 00:04:23.759 Vishnu: Daily. Stand up.
40 00:04:24.270 ⇒ 00:04:25.680 Awaish Kumar: No, it’s not one.
41 00:04:25.840 ⇒ 00:04:28.310 Awaish Kumar: It’s it’s just got very stand up. So
42 00:04:30.066 ⇒ 00:04:33.659 Awaish Kumar: yeah, if if if it is not there, just let me know. I will
43 00:04:33.940 ⇒ 00:04:38.420 Awaish Kumar: ask the team to put these into the stop.
44 00:04:39.273 ⇒ 00:04:40.980 Awaish Kumar: Yes, okay.
45 00:04:41.240 ⇒ 00:04:46.345 Vishnu: So today, this this I think, preoccupy
46 00:04:46.810 ⇒ 00:04:48.339 Awaish Kumar: Can you open the linear.
47 00:04:49.380 ⇒ 00:04:49.870 Vishnu: Yes.
48 00:04:50.780 ⇒ 00:04:52.719 Awaish Kumar: So we can go over the.
49 00:04:54.360 ⇒ 00:05:00.590 Awaish Kumar: So this is your pipe. 1st of 1st task is to get this data into the snowflake.
50 00:05:00.770 ⇒ 00:05:03.389 Awaish Kumar: And can you open the other view
51 00:05:05.980 ⇒ 00:05:10.799 Awaish Kumar: so it should be done like you are already. You have already done it right. You just test it, and.
52 00:05:10.800 ⇒ 00:05:11.380 Vishnu: Yes, sure.
53 00:05:11.380 ⇒ 00:05:16.810 Awaish Kumar: Send it to my way, and I can review it right? So after you push it
54 00:05:16.910 ⇒ 00:05:23.259 Awaish Kumar: and you test it locally, you can start on the other task, which is.
55 00:05:24.530 ⇒ 00:05:25.040 Vishnu: Just.
56 00:05:25.040 ⇒ 00:05:27.940 Awaish Kumar: When do you have a marketing meeting?
57 00:05:29.100 ⇒ 00:05:29.830 Awaish Kumar: It’s interesting.
58 00:05:29.830 ⇒ 00:05:37.510 Vishnu: I had marketing meeting yesterday with Hannah, and then she scheduled another meeting tomorrow day after tomorrow on.
59 00:05:37.510 ⇒ 00:05:42.499 Awaish Kumar: Okay, so do you have clear requirements from her, like what to do on marketing side.
60 00:05:43.470 ⇒ 00:05:46.619 Vishnu: No, she said, she’s going to talk about it on Thursday.
61 00:05:47.050 ⇒ 00:05:48.962 Awaish Kumar: Okay, so let me,
62 00:05:50.130 ⇒ 00:05:57.309 Awaish Kumar: okay, then you can create a project. So we can start off with the operation data. If you go back to linear.
63 00:05:58.510 ⇒ 00:06:02.330 Awaish Kumar: you will create a new repository in the Github.
64 00:06:02.330 ⇒ 00:06:02.980 Vishnu: Okay.
65 00:06:03.130 ⇒ 00:06:04.250 Awaish Kumar: And okay.
66 00:06:06.680 ⇒ 00:06:10.380 Awaish Kumar: And we can then create like that will be for Dbt project
67 00:06:11.510 ⇒ 00:06:17.090 Awaish Kumar: and structure. Your DVD project based on you can find some other
68 00:06:18.841 ⇒ 00:06:21.930 Awaish Kumar: DVD. Projects in there for for clients.
69 00:06:22.160 ⇒ 00:06:25.239 Vishnu: So we like. 1st of all, it will be Standard Dbt.
70 00:06:25.490 ⇒ 00:06:33.780 Awaish Kumar: Calm structure like the, and then inside of models folder, we will have the 3 more folders called raw.
71 00:06:34.040 ⇒ 00:06:36.619 Awaish Kumar: intermediate, and the march.
72 00:06:37.470 ⇒ 00:06:38.130 Vishnu: Okay.
73 00:06:38.130 ⇒ 00:06:42.600 Awaish Kumar: This will be our structure of a tape, the project. And then we can start adding the models.
74 00:06:43.150 ⇒ 00:06:45.140 Awaish Kumar: So we have clockified data.
75 00:06:45.240 ⇒ 00:06:50.139 Awaish Kumar: We have the linear data already in Flowflack.
76 00:06:51.530 ⇒ 00:06:57.700 Awaish Kumar: And so you can start on productivity, dash like the building. The productivity dashboard.
77 00:06:57.920 ⇒ 00:07:02.549 Awaish Kumar: So what we will do is like create a DVD project
78 00:07:02.900 ⇒ 00:07:14.190 Awaish Kumar: and based on that, you can start modeling the we can photos
79 00:07:14.400 ⇒ 00:07:22.239 Awaish Kumar: for our linear data and clockified data. If like, if you want to run some transformation for clockified data.
80 00:07:23.140 ⇒ 00:07:23.600 Vishnu: Okay.
81 00:07:24.411 ⇒ 00:07:35.670 Awaish Kumar: Before building a dashboard and also for linear data. So linear tickets, data is already in the snowflake. And this is the one. You are going to send it to Snowflake.
82 00:07:35.820 ⇒ 00:07:36.766 Awaish Kumar: and then
83 00:07:37.929 ⇒ 00:07:46.890 Awaish Kumar: for marketing. We’ll see how how we can get the data. So. But we will start with this first.st in the meantime,
84 00:07:47.480 ⇒ 00:07:52.300 Awaish Kumar: once you’re done because we don’t know what kind of models we need to create right now.
85 00:07:53.990 ⇒ 00:08:04.000 Awaish Kumar: So just create a DVD project and set like, define the structure and all then leave it in the.
86 00:08:05.960 ⇒ 00:08:10.579 Awaish Kumar: If you already have ideas based on what what you have already discussed with Uton.
87 00:08:11.424 ⇒ 00:08:20.545 Awaish Kumar: You can start building that model. But you, if you’re not clear, then one other thing we can do is if you go back
88 00:08:22.350 ⇒ 00:08:24.770 Awaish Kumar: to the issues view.
89 00:08:26.600 ⇒ 00:08:27.640 Vishnu: Issues.
90 00:08:28.830 ⇒ 00:08:33.110 Awaish Kumar: So we have there. We have connect with real data with Snowflake.
91 00:08:33.740 ⇒ 00:08:34.280 Awaish Kumar: So you.
92 00:08:34.280 ⇒ 00:08:34.600 Vishnu: Okay.
93 00:08:34.600 ⇒ 00:08:38.460 Awaish Kumar: You can. You can assign it to you because Abigail is away for this week.
94 00:08:39.240 ⇒ 00:08:39.980 Vishnu: Okay.
95 00:08:41.250 ⇒ 00:09:00.709 Awaish Kumar: So basically, what we will be doing is real data is kind of visualization platform. We already have data in linear data. And the clock. If I data, we will have it at Snowflake. You can connect Snowflake with real and start exploring data, creating charts. When you try to create a chart. You will understand that. Okay.
96 00:09:00.820 ⇒ 00:09:09.589 Awaish Kumar: I can’t create it like that. I need to transform this table. I need to join these tables. Things like that. When we have that requirement.
97 00:09:09.890 ⇒ 00:09:38.789 Awaish Kumar: So when I go in and I see, like, okay for the linear ticket data, I can’t find the users. It only has user. Id. Then we don’t. I don’t know what kind of projects it has. It only has Project Id. I need to join few table. I need to transform it, I may need to aggregate it and put in some other form. It’s in pivoted form, like, let’s move it some other form like things like that. So when you go and try something, explore the data, you will know, like, okay, you need to transform it some way.
98 00:09:39.020 ⇒ 00:09:40.609 Awaish Kumar: And when you know that
99 00:09:41.040 ⇒ 00:09:56.539 Awaish Kumar: when you have that transformation request. We go to Dvt project and build a model for that. We will run a model, build a model with that transformation, and then we will have a new table, which we will connect with thrill and build the charts. So that’s how we will proceed.
100 00:09:58.230 ⇒ 00:09:59.129 Vishnu: Got it. Okay.
101 00:09:59.130 ⇒ 00:10:08.310 Awaish Kumar: This ticket is just connect real with Snowflake and explore the linear and clock. If I data, it only says linear. But you can explore the clock data as well.
102 00:10:09.930 ⇒ 00:10:10.420 Vishnu: Okay.
103 00:10:12.790 ⇒ 00:10:21.640 Awaish Kumar: Okay? And and yeah, connectivity chart table. Dbt project, create a Dbtv project repository as well. So these 2 like.
104 00:10:22.170 ⇒ 00:10:30.389 Awaish Kumar: so you can work on these 2 today, and we will see tomorrow how how the progress is. And if you, in the meantime, if you get stuck somewhere.
105 00:10:30.590 ⇒ 00:10:33.499 Awaish Kumar: if you need more clarity like. Just let me know, and.
106 00:10:34.580 ⇒ 00:10:48.420 Vishnu: Got it so today I’m going to complete the work towards the second half of the day, because I just have to go out to meet some like meet one of my professor, and once that is done, I’m gonna come back and finish like.
107 00:10:48.420 ⇒ 00:10:51.160 Awaish Kumar: But like, that’s okay. But just
108 00:10:51.360 ⇒ 00:10:54.220 Awaish Kumar: like, check your real data access
109 00:10:54.570 ⇒ 00:11:00.840 Awaish Kumar: check. If you can connect to Snowflake, because these are the things like you will need our help if if you are not able. You don’t have access.
110 00:11:01.595 ⇒ 00:11:04.950 Awaish Kumar: Just just do those things where you need teams, help
111 00:11:05.190 ⇒ 00:11:07.290 Awaish Kumar: in getting the access and things like that.
112 00:11:07.510 ⇒ 00:11:12.220 Awaish Kumar: After that you can go like you can work on on your time like we don’t have any issues.
113 00:11:13.160 ⇒ 00:11:13.540 Vishnu: Okay.
114 00:11:15.980 ⇒ 00:11:18.199 Awaish Kumar: Okay, I’ll see you then.
115 00:11:18.870 ⇒ 00:11:20.780 Vishnu: Alright! Yes, thank you. Bye, bye.