Meeting Title: Linear API Integration Check-in Date: 2025-10-15 Meeting participants: Mustafa Raja, Uttam Kumaran
WEBVTT
1 00:02:42.880 ⇒ 00:02:43.680 Mustafa Raja: Yay!
2 00:02:44.460 ⇒ 00:02:46.460 Uttam Kumaran: How’s everything?
3 00:02:46.920 ⇒ 00:02:47.810 Mustafa Raja: How are you.
4 00:02:48.560 ⇒ 00:02:48.990 Uttam Kumaran: Good.
5 00:02:48.990 ⇒ 00:02:49.520 Mustafa Raja: Good.
6 00:02:51.660 ⇒ 00:02:59.539 Mustafa Raja: Yeah, I just saw that the dbt version of Linear does not have email, so I’ll have to model it, and then I’ll push.
7 00:03:01.310 ⇒ 00:03:02.759 Uttam Kumaran: Oh, okay, okay.
8 00:03:08.790 ⇒ 00:03:09.510 Mustafa Raja: Yep.
9 00:03:17.500 ⇒ 00:03:19.610 Uttam Kumaran: One second…
10 00:03:21.370 ⇒ 00:03:21.920 Mustafa Raja: Yep.
11 00:03:23.650 ⇒ 00:03:27.499 Uttam Kumaran: So, for default, yeah, I just have to review…
12 00:03:27.630 ⇒ 00:03:35.039 Uttam Kumaran: your PDL, and then one thing… one thing I’m gonna do is I’m gonna send, an update to…
13 00:03:35.380 ⇒ 00:03:40.930 Uttam Kumaran: deanna from their team, asking if she had any…
14 00:03:41.880 ⇒ 00:03:46.549 Uttam Kumaran: Further asks on… for a customer help dashboard.
15 00:03:46.990 ⇒ 00:03:53.099 Uttam Kumaran: Was there anything else for us to discuss? I feel like the…
16 00:03:53.260 ⇒ 00:03:57.450 Uttam Kumaran: For this client, the tickets are pretty… Pretty chill.
17 00:03:58.240 ⇒ 00:04:01.780 Mustafa Raja: Yeah, the only thing would be the person, or sorry, the people thing.
18 00:04:01.900 ⇒ 00:04:03.080 Mustafa Raja: Other than that…
19 00:04:03.630 ⇒ 00:04:10.579 Mustafa Raja: And for the people, it’s only that, okay, for each company, we need 3 people. That’s going to be a big…
20 00:04:11.090 ⇒ 00:04:14.189 Mustafa Raja: Time-taking task, if we have to do it manually.
21 00:04:15.370 ⇒ 00:04:19.949 Uttam Kumaran: Yeah, so what… so your plan is to just, like, loop through and grab through people?
22 00:04:20.970 ⇒ 00:04:26.939 Mustafa Raja: Yeah… pretty similar to the… to how I built the company one.
23 00:04:27.360 ⇒ 00:04:28.020 Uttam Kumaran: Okay.
24 00:04:28.640 ⇒ 00:04:29.420 Mustafa Raja: Yeah.
25 00:04:29.600 ⇒ 00:04:32.170 Mustafa Raja: For the company one, what I did was…
26 00:04:32.320 ⇒ 00:04:36.720 Mustafa Raja: I used, Google AI.
27 00:04:38.220 ⇒ 00:04:42.409 Mustafa Raja: the Google search AI that comes with the Google Search.
28 00:04:43.200 ⇒ 00:04:45.479 Mustafa Raja: And it’s pretty accurate.
29 00:04:47.010 ⇒ 00:04:47.620 Uttam Kumaran: Okay.
30 00:04:48.140 ⇒ 00:04:50.650 Mustafa Raja: So I guess I’ll do that for personal culture.
31 00:04:50.800 ⇒ 00:04:51.440 Uttam Kumaran: Okay.
32 00:04:58.130 ⇒ 00:05:05.089 Uttam Kumaran: Okay, cool. Yeah, I guess I just wanted to check in with you on stuff, so I’m gonna… I can go through and check the…
33 00:05:05.300 ⇒ 00:05:10.139 Uttam Kumaran: PDL stuff. I guess my one question… while I have you.
34 00:05:10.360 ⇒ 00:05:15.309 Uttam Kumaran: is I was thinking about building a feature for the platform that is,
35 00:05:15.530 ⇒ 00:05:20.070 Uttam Kumaran: Like, I wanted to be able to chat with linear tickets.
36 00:05:22.910 ⇒ 00:05:30.129 Uttam Kumaran: for example, I want to make it easy for project managers to be able to see all the tickets completed in a week, and then generate
37 00:05:30.290 ⇒ 00:05:33.560 Uttam Kumaran: Like, a project summary, for example.
38 00:05:33.680 ⇒ 00:05:41.330 Uttam Kumaran: I was gonna try to do it all on the platform using Mastra, do you think it’s best…
39 00:05:41.700 ⇒ 00:05:47.339 Uttam Kumaran: For me to have a system that… just hits the linear API?
40 00:05:47.520 ⇒ 00:05:54.650 Uttam Kumaran: Like, for example, a project manager could select like… The client, and then select…
41 00:05:55.140 ⇒ 00:05:57.809 Uttam Kumaran: Which tickets to pull into context?
42 00:05:58.480 ⇒ 00:06:01.179 Mustafa Raja: Do you think that’s best, or…
43 00:06:01.900 ⇒ 00:06:07.319 Uttam Kumaran: I know, I don’t know, Artie, like, yeah, I guess… Or should I, yeah, go ahead.
44 00:06:07.670 ⇒ 00:06:18.499 Mustafa Raja: Yeah, so the RAG, for, if you do the RAG thing, we’ll have to add a lot of metadata stuff, to be able to filter to the particular week we are going to talk about.
45 00:06:19.070 ⇒ 00:06:34.939 Mustafa Raja: Which might be a little complex. So, if there’s a way, or you have, you have a feature in your mind that, PMs would be able to select tickets, obviously, for that, we’ll have to have some sort of UI.
46 00:06:35.160 ⇒ 00:06:43.740 Mustafa Raja: To talk to those, those old tickets that are selected, I think that, that would be better. And if we use Mastra, that… that would be good too.
47 00:06:45.670 ⇒ 00:06:50.350 Uttam Kumaran: So, yeah, I mean, I guess I would just make an API call once the user puts in all those filters.
48 00:06:50.730 ⇒ 00:06:51.579 Mustafa Raja: Yeah, that…
49 00:06:51.580 ⇒ 00:06:54.179 Uttam Kumaran: And it would do a get ticket contents, or whatever.
50 00:06:54.180 ⇒ 00:06:57.300 Mustafa Raja: Yeah Yeah.
51 00:06:58.290 ⇒ 00:07:06.020 Mustafa Raja: That’s… that’s good. We kind of… we kind of are doing this for ticket generator.
52 00:07:07.750 ⇒ 00:07:08.839 Uttam Kumaran: But you’re just writing.
53 00:07:08.840 ⇒ 00:07:14.160 Mustafa Raja: Yeah, yeah, and for, the summarizer also.
54 00:07:15.510 ⇒ 00:07:16.580 Uttam Kumaran: Oh, for Slack.
55 00:07:16.980 ⇒ 00:07:17.740 Mustafa Raja: Yeah.
56 00:07:18.810 ⇒ 00:07:23.569 Mustafa Raja: Okay. That sort of, does it for the whole cycle.
57 00:07:29.150 ⇒ 00:07:32.579 Uttam Kumaran: Okay, cool. I may work on that today.
58 00:07:33.360 ⇒ 00:07:33.910 Mustafa Raja: Yep.
59 00:07:41.610 ⇒ 00:07:45.660 Mustafa Raja: I will… what I will do is I will,
60 00:07:46.580 ⇒ 00:07:58.870 Mustafa Raja: So, for linear, do you want only the issues to be included in topic, or we want all of the tables, in the topic?
61 00:07:59.690 ⇒ 00:08:00.640 Mustafa Raja: Porico.
62 00:08:02.410 ⇒ 00:08:04.920 Uttam Kumaran: Oh, for Omni?
63 00:08:04.920 ⇒ 00:08:16.169 Mustafa Raja: that, yeah. Yeah, yeah. Because the prod one only has issues, and it doesn’t have email, so I won’t be able to link it to, operating at all.
64 00:08:18.200 ⇒ 00:08:21.580 Uttam Kumaran: But the issues have users, right? But you’re saying the users aren’t coming in?
65 00:08:21.980 ⇒ 00:08:26.829 Mustafa Raja: No, no, no, so, the… can I share my screen?
66 00:08:27.150 ⇒ 00:08:27.790 Uttam Kumaran: Yeah.
67 00:08:29.090 ⇒ 00:08:30.020 Mustafa Raja: If you misspeople.
68 00:08:31.700 ⇒ 00:08:38.830 Mustafa Raja: Okay, so… Yeah, I have ChatGPT with me, assisting me through this process. Okay, so…
69 00:08:39.850 ⇒ 00:08:51.340 Mustafa Raja: Issues do have user emails, but, this prod one that is, I guess, built with DPT does not, does not include the email field at all.
70 00:08:51.570 ⇒ 00:08:52.720 Mustafa Raja: Oh, then you shouldn’t.
71 00:08:52.720 ⇒ 00:08:53.330 Uttam Kumaran: Include it.
72 00:08:53.330 ⇒ 00:08:56.989 Mustafa Raja: Yeah, yeah, so…
73 00:08:57.180 ⇒ 00:09:02.150 Mustafa Raja: I haven’t worked with dbt, so let me know if I can, update the code, if it is somewhere…
74 00:09:02.530 ⇒ 00:09:06.129 Mustafa Raja: Otherwise, what I’ll do is I’ll just update
75 00:09:07.270 ⇒ 00:09:10.910 Mustafa Raja: I’ll just go in… in this topic.
76 00:09:11.050 ⇒ 00:09:13.679 Mustafa Raja: Pull this raw issues table.
77 00:09:14.380 ⇒ 00:09:18.930 Mustafa Raja: And just link, email, because it has email.
78 00:09:20.410 ⇒ 00:09:28.400 Uttam Kumaran: Yeah, well, I think if you go to OmniDBT, And the virtual schema?
79 00:09:29.660 ⇒ 00:09:30.870 Uttam Kumaran: Well, on the left.
80 00:09:31.690 ⇒ 00:09:33.080 Uttam Kumaran: Do virtual schema?
81 00:09:33.720 ⇒ 00:09:34.570 Mustafa Raja: Awesome.
82 00:09:37.270 ⇒ 00:09:38.340 Uttam Kumaran: Go to Models.
83 00:09:40.990 ⇒ 00:09:42.550 Mustafa Raja: Margins.
84 00:09:43.810 ⇒ 00:09:46.340 Uttam Kumaran: And then, yeah, open, intermediate, linear, yeah.
85 00:09:46.670 ⇒ 00:09:47.680 Uttam Kumaran: But you can just add it here.
86 00:09:50.170 ⇒ 00:09:55.069 Mustafa Raja: That’s super convenient. Oh, one more thing while I have you here. Yeah.
87 00:09:55.910 ⇒ 00:10:03.610 Mustafa Raja: And… But I have been… Okay, not this…
88 00:10:11.580 ⇒ 00:10:19.669 Mustafa Raja: Okay, so what I have been doing for transformation is I’m just transforming this raw.
89 00:10:19.730 ⇒ 00:10:36.489 Mustafa Raja: raw thing. So this is pretty similar to what dbt does, but it does not involve dbt at all. So, let me know if, all of this should be converted to dbt. Because, what happens is Snowflake is only giving us this field, raw data field.
90 00:10:36.490 ⇒ 00:10:37.359 Uttam Kumaran: And this is all…
91 00:10:37.360 ⇒ 00:10:48.849 Mustafa Raja: JSON. And I… and using this SQL, I am converting, this JSON to, somewhat that… something that we can use in…
92 00:10:49.030 ⇒ 00:10:57.969 Uttam Kumaran: Yeah, I think for now, short-term, I would just don’t worry about where it lives. I think once… after a week or two, like, once the data model matures, we can move it to dbt.
93 00:10:58.510 ⇒ 00:11:07.780 Mustafa Raja: Okay, yeah, that’s good. Okay, so I’ll, I’ll go ahead and include, The… Email in this.
94 00:11:07.930 ⇒ 00:11:16.429 Mustafa Raja: prompt thing, and then I’ll just, include this, this view in, in our topic, and merge.
95 00:11:17.140 ⇒ 00:11:22.550 Uttam Kumaran: Yeah, so basically, ideally, we want to create a view of, like, by week, the person, how many tickets they took.
96 00:11:24.200 ⇒ 00:11:27.850 Uttam Kumaran: Right, and then how many hours they booked, ideally.
97 00:11:28.330 ⇒ 00:11:28.990 Mustafa Raja: Yeah.
98 00:11:30.230 ⇒ 00:11:30.800 Uttam Kumaran: Okay.
99 00:11:33.940 ⇒ 00:11:35.040 Uttam Kumaran: Okay, perfect.
100 00:11:35.450 ⇒ 00:11:36.270 Uttam Kumaran: Alright.
101 00:11:36.450 ⇒ 00:11:37.359 Uttam Kumaran: Thanks, dude.
102 00:11:37.830 ⇒ 00:11:38.710 Mustafa Raja: Thank you.
103 00:11:38.940 ⇒ 00:11:39.790 Uttam Kumaran: Okay, bye.
104 00:11:40.380 ⇒ 00:11:40.960 Mustafa Raja: Bye.