Meeting Title: DBT issue sync Date: 2025-10-16 Meeting participants: Mustafa Raja, Awaish Kumar, Mustafa’s Loom Notetaker
WEBVTT
1 00:01:25.610 ⇒ 00:01:26.639 Mustafa Raja: Hey, how are you?
2 00:01:27.320 ⇒ 00:01:29.050 Awaish Kumar: I’m good, how about you?
3 00:01:29.230 ⇒ 00:01:30.400 Mustafa Raja: Yeah, doing good.
4 00:01:32.190 ⇒ 00:01:32.740 Awaish Kumar: Okay.
5 00:01:37.100 ⇒ 00:01:39.639 Mustafa Raja: Okay, so let me share my screen.
6 00:01:46.580 ⇒ 00:01:47.430 Mustafa Raja: This one…
7 00:01:47.430 ⇒ 00:01:49.149 Awaish Kumar: Just give me a minute, Tom.
8 00:01:49.150 ⇒ 00:01:50.850 Mustafa Raja: Oh, yeah, yeah, yeah. Oh, yeah.
9 00:02:23.190 ⇒ 00:02:24.120 Awaish Kumar: Yep.
10 00:02:26.160 ⇒ 00:02:42.630 Mustafa Raja: Yeah, so, so the… what I’m trying to do is, keep the campaign name, similar to what they are doing right now. Let me also open up the sheet that…
11 00:02:43.110 ⇒ 00:02:45.220 Mustafa Raja: I don’t know, but shit.
12 00:02:52.260 ⇒ 00:02:55.080 Mustafa Raja: I think I must have shared it with you, sir.
13 00:02:55.280 ⇒ 00:02:56.689 Mustafa Raja: Could be healing, yeah.
14 00:02:58.180 ⇒ 00:03:03.990 Mustafa Raja: Okay, so, I’ve tried to keep it very similar to what they are doing right now.
15 00:03:04.320 ⇒ 00:03:04.750 Awaish Kumar: for the…
16 00:03:04.750 ⇒ 00:03:15.810 Mustafa Raja: ease. And, so there’s date, then channel, which they’re already doing, and then theme and offer, I derived it from this.
17 00:03:15.960 ⇒ 00:03:19.790 Awaish Kumar: Sample data.
18 00:03:21.190 ⇒ 00:03:28.689 Mustafa Raja: Try to, you know, make sense of it and, make types of it, segment it out.
19 00:03:28.690 ⇒ 00:03:31.020 Awaish Kumar: We are all free.
20 00:03:32.830 ⇒ 00:03:33.560 Mustafa Raja: Yeah?
21 00:03:33.560 ⇒ 00:03:35.729 Awaish Kumar: Product category, then.
22 00:03:36.280 ⇒ 00:03:42.030 Mustafa Raja: Yeah, so product category is actually coming from Holistics.
23 00:03:42.400 ⇒ 00:03:48.939 Awaish Kumar: Yeah, that’s okay, but, like, in this offer currently they have, they don’t have a product category and product, right?
24 00:03:49.090 ⇒ 00:03:52.149 Mustafa Raja: They sometimes do, and sometimes do not.
25 00:03:52.550 ⇒ 00:03:53.320 Awaish Kumar: Okay.
26 00:03:53.320 ⇒ 00:04:07.939 Mustafa Raja: So this cookie… so this cookies is actually a product category, and then the product is 12-pack, and they do sometimes in their, what’s it called? Campaign, highlight that.
27 00:04:09.250 ⇒ 00:04:26.459 Mustafa Raja: let’s search for… yeah, so the 12-pack is the… what’s it called? Product, and sometimes they’ll add product category. So I guess if they are doing product, it shouldn’t be… it shouldn’t be much hard to add product category also, no?
28 00:04:26.780 ⇒ 00:04:27.590 Awaish Kumar: Yep.
29 00:04:27.770 ⇒ 00:04:34.270 Mustafa Raja: Yeah, so intent is also derived from whatever, whatever examples I could put
30 00:04:34.390 ⇒ 00:04:37.559 Mustafa Raja: get from here, so I try to make sense of it.
31 00:04:37.770 ⇒ 00:04:47.550 Mustafa Raja: We can say it’s, really, derived from this segment, these more, so conversion awareness.
32 00:04:49.530 ⇒ 00:04:50.049 Awaish Kumar: And then…
33 00:04:50.050 ⇒ 00:04:53.299 Mustafa Raja: And that. Oh, and… yeah?
34 00:04:53.300 ⇒ 00:04:57.680 Awaish Kumar: Okay, intent is, like, what is the purpose of the campaign, right?
35 00:04:57.680 ⇒ 00:04:58.640 Mustafa Raja: Yeah, yeah, yeah.
36 00:04:59.110 ⇒ 00:05:00.050 Awaish Kumar: And then we have.
37 00:05:00.050 ⇒ 00:05:00.920 Mustafa Raja: I guess…
38 00:05:01.290 ⇒ 00:05:02.509 Awaish Kumar: Segment is what…
39 00:05:02.700 ⇒ 00:05:12.320 Mustafa Raja: Segment is, the, RFM segment of customers. This is also coming from Holistics. They do not do it right now.
40 00:05:12.600 ⇒ 00:05:28.600 Mustafa Raja: the campaigns… the campaign names do not involve any segments of customers right now, but I guess if we want to drill down to the segment that they are targeting, we can then include this also.
41 00:05:29.830 ⇒ 00:05:31.740 Awaish Kumar: Multi-product.
42 00:05:32.660 ⇒ 00:05:48.950 Mustafa Raja: Yeah, so multi-segment, multi-product, if we… if we are target… if they are targeting multiple segments, if they are trying to advertise multiple products, we can say any, but the product should have a… product should belong to one category, or we can…
43 00:05:48.970 ⇒ 00:05:53.690 Mustafa Raja: You know, expand this more, or think about this more.
44 00:05:53.740 ⇒ 00:05:56.209 Mustafa Raja: And so for this one, we are combining…
45 00:05:56.210 ⇒ 00:06:04.409 Awaish Kumar: From their sample data, is there any, like, product, any campaign which is targeting multiple products?
46 00:06:05.590 ⇒ 00:06:09.780 Mustafa Raja: So, there is… there are campaigns
47 00:06:14.060 ⇒ 00:06:16.670 Mustafa Raja: Let me see, actually, so…
48 00:06:18.390 ⇒ 00:06:32.220 Mustafa Raja: By multiple products, those would have only the category and not the product itself. So that’s how I drive that, okay, they might be doing multiple products or something.
49 00:06:35.990 ⇒ 00:06:36.480 Awaish Kumar: Okay.
50 00:06:36.480 ⇒ 00:06:38.290 Mustafa Raja: Let me search.
51 00:06:40.910 ⇒ 00:06:47.799 Awaish Kumar: Okay, so my question is, It is also possible, sometimes, they don’t do
52 00:06:49.620 ⇒ 00:06:52.730 Awaish Kumar: campaigned for a specific product, like, maybe it’s…
53 00:06:53.000 ⇒ 00:06:55.560 Awaish Kumar: Then we just have offer, right?
54 00:06:56.050 ⇒ 00:06:56.850 Mustafa Raja: Yeah.
55 00:06:56.850 ⇒ 00:06:59.999 Awaish Kumar: Like, they can do N,
56 00:07:00.260 ⇒ 00:07:04.300 Awaish Kumar: They can send an offer for a national day.
57 00:07:04.300 ⇒ 00:07:05.000 Mustafa Raja: Yeah.
58 00:07:05.000 ⇒ 00:07:06.479 Awaish Kumar: Kind of a holiday.
59 00:07:06.480 ⇒ 00:07:07.280 Mustafa Raja: Yeah, they’re doing that.
60 00:07:07.280 ⇒ 00:07:08.190 Awaish Kumar: Oops.
61 00:07:08.510 ⇒ 00:07:11.430 Awaish Kumar: And then… for all products.
62 00:07:12.380 ⇒ 00:07:16.029 Mustafa Raja: Yeah, so it’s National Cookie Day.
63 00:07:17.350 ⇒ 00:07:24.929 Mustafa Raja: So I think this is, this is, related to, the, their product category cookie.
64 00:07:25.200 ⇒ 00:07:38.069 Awaish Kumar: Okay, but if there is a use case, like, if I… I’m sending… I want to send an offer on Christmas for all products, I can do that, right? And then this campaign…
65 00:07:38.310 ⇒ 00:07:42.449 Awaish Kumar: Is, basically, we, we assume that this is…
66 00:07:43.330 ⇒ 00:07:46.140 Awaish Kumar: Not specific to one product, and hence.
67 00:07:49.410 ⇒ 00:07:52.329 Awaish Kumar: That should… that just applies to all the products, so…
68 00:07:52.450 ⇒ 00:07:55.290 Awaish Kumar: We shouldn’t, like, have a segment for that.
69 00:07:55.950 ⇒ 00:07:59.049 Awaish Kumar: Like, an example… a template for that as well.
70 00:07:59.300 ⇒ 00:08:00.529 Mustafa Raja: Hmm, hmm.
71 00:08:01.160 ⇒ 00:08:06.909 Mustafa Raja: So, I guess we can have a segment that does not involve product at all, right?
72 00:08:09.790 ⇒ 00:08:12.690 Awaish Kumar: Yeah, like, ideally, I would like that…
73 00:08:13.210 ⇒ 00:08:19.200 Awaish Kumar: If, like, for me to analyze any conversion of a campaign.
74 00:08:19.380 ⇒ 00:08:25.330 Awaish Kumar: And segment it by product, like, how it rented for individual product.
75 00:08:25.510 ⇒ 00:08:40.090 Awaish Kumar: for me, it’s… it would be nicer if we can… if… even if we are running same campaign, like, this is a Christmas Day campaign, so I can say, okay, Christmas Day campaign for product A, product B, product C, product D.
76 00:08:40.210 ⇒ 00:08:42.060 Awaish Kumar: I can duplicate.
77 00:08:42.280 ⇒ 00:08:49.670 Awaish Kumar: all these… names for individual products. Although the Main offer theme is same.
78 00:08:50.060 ⇒ 00:08:54.160 Awaish Kumar: We force them to still maybe create duplicates.
79 00:08:55.030 ⇒ 00:09:01.579 Awaish Kumar: P1, P2, P3, P4. That will give us the exact conversion, otherwise we don’t know, right?
80 00:09:01.580 ⇒ 00:09:02.439 Mustafa Raja: Yeah, yeah, yeah.
81 00:09:03.330 ⇒ 00:09:07.040 Awaish Kumar: And we got this much revenue. But which product was sent…
82 00:09:08.010 ⇒ 00:09:11.100 Awaish Kumar: Like, that would be hard to figure out.
83 00:09:11.290 ⇒ 00:09:28.060 Mustafa Raja: Yeah, yeah. So Holistics also had product type, and product category and type was kind of similar, so it felt redundant, so I chose type, product category. We can also write that scenario, right? If…
84 00:09:28.280 ⇒ 00:09:33.199 Awaish Kumar: There’s a generic offer for all products, then we should just duplicate.
85 00:09:33.880 ⇒ 00:09:48.439 Mustafa Raja: Yeah, okay, so you’re suggesting that if they want to do, what’s it called? A campaign for all products, we should have a template for that also, right?
86 00:09:48.780 ⇒ 00:09:55.160 Awaish Kumar: Yeah, like, that covers your multi-product… Your multi-product thing covers that.
87 00:09:55.490 ⇒ 00:09:58.119 Mustafa Raja: But it must have a product category.
88 00:09:58.120 ⇒ 00:09:59.510 Awaish Kumar: Yeah, yeah.
89 00:09:59.510 ⇒ 00:10:01.360 Mustafa Raja: That’s… that is an issue.
90 00:10:01.360 ⇒ 00:10:03.390 Awaish Kumar: I want them to have it.
91 00:10:03.820 ⇒ 00:10:05.340 Awaish Kumar: Oh, my question, ma’am.
92 00:10:05.340 ⇒ 00:10:07.690 Mustafa Raja: Oh, okay. Instead of any.
93 00:10:07.890 ⇒ 00:10:22.479 Awaish Kumar: instead of mentioning any product name, we want them to create individual, right? So I have 4 products, and if you want to run the same generic campaign for all four, just create 4 different campaigns.
94 00:10:23.040 ⇒ 00:10:25.539 Mustafa Raja: yeah, it makes sense.
95 00:10:31.390 ⇒ 00:10:40.440 Awaish Kumar: So, like, That’s ideal for… in terms of, for analytical purposes. I’m not sure how that…
96 00:10:40.970 ⇒ 00:10:44.310 Awaish Kumar: Will affect the,
97 00:10:44.820 ⇒ 00:10:49.809 Awaish Kumar: For the marketing team, like, how that’s… if that’s really a painful thing to do, or…
98 00:10:49.810 ⇒ 00:11:02.300 Mustafa Raja: Yeah, I guess, making one campaign, and then if they are targeting 4 products in the same campaign, they’ll now have to do 4 campaigns, so this is going to be painful.
99 00:11:02.300 ⇒ 00:11:06.569 Awaish Kumar: I… but let’s… if I brainstorm that, is that…
100 00:11:07.320 ⇒ 00:11:11.030 Awaish Kumar: feasible. Like, I don’t think so they will agree.
101 00:11:11.210 ⇒ 00:11:17.780 Awaish Kumar: Like, now that I’m talking, like, for example, if you are an end user.
102 00:11:18.160 ⇒ 00:11:26.799 Awaish Kumar: And I want to, advertise my offers to you, and I have…
103 00:11:27.460 ⇒ 00:11:31.359 Awaish Kumar: a Christmas offer, which is on my all products.
104 00:11:31.480 ⇒ 00:11:34.880 Awaish Kumar: Then I… I have to send you 4 different messages.
105 00:11:35.210 ⇒ 00:11:40.990 Awaish Kumar: Right? And you will be, like, kind of spammed. So end user will not be happy
106 00:11:42.170 ⇒ 00:11:45.250 Awaish Kumar: That is just spammed by a company.
107 00:11:45.500 ⇒ 00:11:46.450 Awaish Kumar: Right?
108 00:11:48.990 ⇒ 00:11:50.720 Awaish Kumar: Are you… are you following?
109 00:11:52.940 ⇒ 00:11:53.750 Awaish Kumar: Hello?
110 00:11:53.750 ⇒ 00:11:55.899 Mustafa Raja: Oh, sorry, my connection dropped.
111 00:11:56.730 ⇒ 00:12:02.640 Awaish Kumar: So, yeah, I’m saying, are you following me that if I, as a marketing person, I have to work here for…
112 00:12:02.760 ⇒ 00:12:04.750 Awaish Kumar: Campaign, that’s not a problem.
113 00:12:04.750 ⇒ 00:12:09.239 Mustafa Raja: But then I have to advertise that, I have to send 4 different messages to you.
114 00:12:09.440 ⇒ 00:12:10.480 Awaish Kumar: Right? To then…
115 00:12:10.850 ⇒ 00:12:13.359 Awaish Kumar: And user will feel spammed, right?
116 00:12:13.360 ⇒ 00:12:14.820 Mustafa Raja: Yeah, yeah, yeah.
117 00:12:14.820 ⇒ 00:12:23.430 Awaish Kumar: So, for… we can’t send, an offer, for individual, product, If that offer is offered.
118 00:12:23.430 ⇒ 00:12:23.665 Mustafa Raja: Hmm.
119 00:12:23.900 ⇒ 00:12:31.550 Awaish Kumar: products, because I have to send them 10 messages to someone, and that’s costly, and that’s not, oh.
120 00:12:32.130 ⇒ 00:12:36.679 Awaish Kumar: Good in terms… in terms of the, like, end user, so…
121 00:12:37.800 ⇒ 00:12:40.850 Awaish Kumar: I think that’s… that’s a problem, right?
122 00:12:41.180 ⇒ 00:12:46.520 Mustafa Raja: Yeah, yeah, yeah, yeah, I’m following you. Yeah, this is a problem, this is going to be a problem.
123 00:12:47.190 ⇒ 00:12:53.839 Awaish Kumar: So we said, okay, I think then we… yeah, any is okay. In that case, we might just…
124 00:12:55.990 ⇒ 00:13:02.789 Awaish Kumar: kind of from… some order got placed, and we ran the campaign.
125 00:13:03.540 ⇒ 00:13:11.090 Awaish Kumar: And, yeah, I would say, like, it’s for… And, like…
126 00:13:12.710 ⇒ 00:13:15.339 Awaish Kumar: Maybe we, we just say, anyone up?
127 00:13:15.560 ⇒ 00:13:22.770 Awaish Kumar: We could choose two ways. Either attribute it to any one of the products, or… Just,
128 00:13:22.940 ⇒ 00:13:27.870 Awaish Kumar: Just spread it for… spread it for all the products, right?
129 00:13:28.270 ⇒ 00:13:32.769 Awaish Kumar: Like, if I… if I threw a campaign, I got 100 orders.
130 00:13:32.880 ⇒ 00:13:36.700 Awaish Kumar: I assume it could be, like, for any of the orders, that’s all.
131 00:13:36.890 ⇒ 00:13:41.770 Awaish Kumar: And this… and the cost spent on the… on that campaign will also be, like.
132 00:13:42.200 ⇒ 00:13:46.899 Awaish Kumar: Spread out across the product based on the
133 00:13:47.060 ⇒ 00:13:49.349 Awaish Kumar: How many products were sold, right?
134 00:13:50.090 ⇒ 00:13:53.259 Awaish Kumar: The number of orders, we just distribute the cost.
135 00:13:54.110 ⇒ 00:14:01.960 Awaish Kumar: In the… for the individual product. In that case, when we have to apply it for… all the products.
136 00:14:03.190 ⇒ 00:14:06.419 Mustafa Raja: So, can we then say that…
137 00:14:09.280 ⇒ 00:14:13.100 Awaish Kumar: That’s… I think it… yeah, we can then remove…
138 00:14:13.430 ⇒ 00:14:14.460 Mustafa Raja: Let me do this, then?
139 00:14:14.840 ⇒ 00:14:15.630 Awaish Kumar: Yeah, yeah.
140 00:14:20.110 ⇒ 00:14:20.750 Mustafa Raja: Hey.
141 00:14:22.850 ⇒ 00:14:25.089 Awaish Kumar: Yeah, we can do that, Annie, Annie,
142 00:14:26.660 ⇒ 00:14:29.409 Awaish Kumar: Or we can remove it altogether, like…
143 00:14:31.130 ⇒ 00:14:35.219 Awaish Kumar: Like, there’s no product means all… it’s for all products.
144 00:14:36.570 ⇒ 00:14:37.870 Awaish Kumar: We can say all.
145 00:14:38.060 ⇒ 00:14:38.929 Awaish Kumar: Oh, baby.
146 00:14:42.080 ⇒ 00:14:42.950 Awaish Kumar: Hello?
147 00:14:46.870 ⇒ 00:14:50.229 Mustafa Raja: Sorry, my internet connection is a little weak.
148 00:14:52.270 ⇒ 00:15:02.269 Awaish Kumar: Okay, well, I’m saying if… if it is for, yeah, so… So we… we just say, remove it. Remove it. Completely remove it.
149 00:15:03.100 ⇒ 00:15:06.040 Mustafa Raja: Okay, so, okay.
150 00:15:07.060 ⇒ 00:15:07.970 Awaish Kumar: Yeah, because…
151 00:15:07.970 ⇒ 00:15:22.580 Mustafa Raja: My idea was, we’d know, okay, after theme, we’ll have product category, if it’s any, we can skip it, and then product, if it’s any, we can skip it, you know, for regular expressions to identify.
152 00:15:23.080 ⇒ 00:15:23.750 Awaish Kumar: Come on.
153 00:15:24.540 ⇒ 00:15:26.859 Awaish Kumar: Yeah, but
154 00:15:30.690 ⇒ 00:15:33.650 Awaish Kumar: That is also, like, Possible.
155 00:15:33.930 ⇒ 00:15:34.640 Mustafa Raja: Yeah.
156 00:15:34.780 ⇒ 00:15:41.849 Mustafa Raja: Because we’ll know, okay, because I’m using these.
157 00:15:41.850 ⇒ 00:15:44.479 Awaish Kumar: Yeah, placeholder, as a placeholder.
158 00:15:44.480 ⇒ 00:15:56.209 Mustafa Raja: Yeah, this is delimiter, and we know after first delimiter comes product category, second one is product, and if it’s any and any, we’ll know, okay, it’s among all of them.
159 00:15:56.500 ⇒ 00:15:57.120 Awaish Kumar: Okay.
160 00:15:57.580 ⇒ 00:15:59.439 Mustafa Raja: Yeah, if it makes sense to you.
161 00:16:00.940 ⇒ 00:16:02.140 Awaish Kumar: Yeah, yeah, it makes sense.
162 00:16:02.140 ⇒ 00:16:07.649 Mustafa Raja: Okay, okay. So, so… So what do you think about this, then, overall?
163 00:16:07.880 ⇒ 00:16:08.970 Mustafa Raja: Is there…
164 00:16:08.970 ⇒ 00:16:13.490 Awaish Kumar: Well, I think it’s good, it’s good, right? It’s how we need to inform…
165 00:16:13.900 ⇒ 00:16:14.740 Mustafa Raja: Okay.
166 00:16:14.880 ⇒ 00:16:16.300 Awaish Kumar: And eat it now.
167 00:16:16.300 ⇒ 00:16:19.819 Mustafa Raja: So the, what’s it called? The…
168 00:16:20.720 ⇒ 00:16:31.439 Mustafa Raja: The purpose or the idea I had in my mind creating this was to be able to drill down to products and segments.
169 00:16:31.790 ⇒ 00:16:33.739 Mustafa Raja: Of users.
170 00:16:34.210 ⇒ 00:16:36.079 Awaish Kumar: Segment of user means…
171 00:16:37.210 ⇒ 00:16:40.189 Awaish Kumar: What are… can you give some of the examples of segments?
172 00:16:40.890 ⇒ 00:16:46.550 Mustafa Raja: So, segments, or the user segment that they are targeting with it.
173 00:16:46.770 ⇒ 00:16:47.590 Awaish Kumar: Okay.
174 00:16:47.870 ⇒ 00:16:51.710 Mustafa Raja: Yeah, they have that in holistics.
175 00:16:53.750 ⇒ 00:16:55.650 Mustafa Raja: Do we want to take a look at that?
176 00:16:56.900 ⇒ 00:17:00.299 Awaish Kumar: That’s okay, I already looked at holistic data.
177 00:17:00.680 ⇒ 00:17:01.920 Mustafa Raja: Okay.
178 00:17:03.100 ⇒ 00:17:04.810 Awaish Kumar: Can we go back to the sheet?
179 00:17:05.060 ⇒ 00:17:05.730 Mustafa Raja: Yep.
180 00:17:07.460 ⇒ 00:17:11.950 Awaish Kumar: So, there is a segment in the base taxonomy, and then,
181 00:17:13.060 ⇒ 00:17:16.049 Awaish Kumar: Oh, it’s a multi-segment, we will say multi-segment.
182 00:17:17.420 ⇒ 00:17:18.359 Mustafa Raja: Hmm.
183 00:17:18.359 ⇒ 00:17:19.900 Awaish Kumar: Oh, okay.
184 00:17:20.020 ⇒ 00:17:29.930 Awaish Kumar: That makes sense. Actually, I’ve been just exploring data to connect these customers with offers and… campaigns and,
185 00:17:30.880 ⇒ 00:17:32.969 Awaish Kumar: If I find anything, I will let you know.
186 00:17:32.970 ⇒ 00:17:33.810 Mustafa Raja: Oh!
187 00:17:34.850 ⇒ 00:17:35.960 Awaish Kumar: Permitting looks good.
188 00:17:35.960 ⇒ 00:17:47.070 Mustafa Raja: Yeah, yeah, so you’ve been trying to see how you can connect users, with, with these campaigns. Oh, let me, let me share what I found.
189 00:17:48.360 ⇒ 00:17:52.110 Mustafa Raja: Breeze… Export API.
190 00:17:53.850 ⇒ 00:17:57.459 Awaish Kumar: Actually, I’m trying to find it in holistics.
191 00:17:58.400 ⇒ 00:18:00.690 Mustafa Raja: Yeah, Holistics might not have it, though.
192 00:18:01.540 ⇒ 00:18:08.139 Mustafa Raja: But if you want to take a look, I can share what I’ve found on how we can link.
193 00:18:08.580 ⇒ 00:18:10.680 Mustafa Raja: Can I share it?
194 00:18:11.410 ⇒ 00:18:15.500 Awaish Kumar: Yeah, yeah, but I see that, Rousseau. Okay.
195 00:18:15.710 ⇒ 00:18:26.159 Mustafa Raja: Yeah, so, so, what this endpoint gives us is users and the campaigns they have received in last 90 days.
196 00:18:26.370 ⇒ 00:18:33.590 Mustafa Raja: So this is… I shared some of the things, like, in our last meeting also. Yeah, yeah.
197 00:18:33.960 ⇒ 00:18:35.759 Awaish Kumar: So I, I, I asked…
198 00:18:36.270 ⇒ 00:18:41.210 Awaish Kumar: I did say that that’s the… that’s the… if we can do that, that’s really…
199 00:18:41.210 ⇒ 00:18:42.730 Mustafa Raja: hmm, hmm.
200 00:18:42.730 ⇒ 00:18:47.540 Awaish Kumar: But in general… I don’t know where we end up on this.
201 00:18:47.540 ⇒ 00:19:06.950 Mustafa Raja: Yeah, yeah, so what… the issue with this is, when we export this data, it actually goes into their, S3 or whatever data source or cloud they have connected, and we don’t have access of that, although I have made a few exports of data.
202 00:19:06.950 ⇒ 00:19:09.200 Awaish Kumar: He will work on getting that.
203 00:19:09.200 ⇒ 00:19:10.989 Mustafa Raja: Yeah, yeah, yeah, yeah, yeah, yeah, yeah.
204 00:19:11.350 ⇒ 00:19:11.670 Awaish Kumar: Okay.
205 00:19:11.670 ⇒ 00:19:17.120 Mustafa Raja: So this is what I had on, something that we can connect with users, right?
206 00:19:17.120 ⇒ 00:19:17.790 Awaish Kumar: break.
207 00:19:18.280 ⇒ 00:19:27.459 Awaish Kumar: So, okay, we have a naming convention on the site to share it with them, right? Number one. Number two, Otam is going to get the access.
208 00:19:27.640 ⇒ 00:19:30.290 Awaish Kumar: For their data store.
209 00:19:30.660 ⇒ 00:19:33.030 Awaish Kumar: Third, I’m looking at realistic data.
210 00:19:33.260 ⇒ 00:19:35.550 Awaish Kumar: To connect… connect these.
211 00:19:37.860 ⇒ 00:19:42.899 Awaish Kumar: Okay, let’s… Okay, that’s all for insomnia, or is there anything else?
212 00:19:42.900 ⇒ 00:19:46.410 Mustafa Raja: Yes, this should be it for Inzone, Mia.
213 00:19:46.560 ⇒ 00:19:47.380 Awaish Kumar: Okay.
214 00:19:47.380 ⇒ 00:19:54.950 Mustafa Raja: And then… Dish, yeah, I want your assistance on Omni.
215 00:19:57.120 ⇒ 00:20:00.270 Mustafa Raja: Hello?
216 00:20:00.460 ⇒ 00:20:02.580 Mustafa Raja: Oh, no, no, I shouldn’t do it.
217 00:20:06.820 ⇒ 00:20:07.630 Mustafa Raja: Okay.
218 00:20:11.400 ⇒ 00:20:21.369 Mustafa Raja: So, what is happening is we are, joining, data across all these different platforms based on user email, right?
219 00:20:22.730 ⇒ 00:20:26.650 Awaish Kumar: Let’s, let’s, let’s click on this DVT.
220 00:20:26.800 ⇒ 00:20:27.460 Awaish Kumar: IBM.
221 00:20:27.460 ⇒ 00:20:28.819 Mustafa Raja: Indeed. Yeah.
222 00:20:28.820 ⇒ 00:20:29.350 Awaish Kumar: Okay.
223 00:20:30.790 ⇒ 00:20:33.040 Awaish Kumar: popular model.
224 00:20:35.920 ⇒ 00:20:37.979 Mustafa Raja: So the issue is this, that this is read-only.
225 00:20:37.980 ⇒ 00:20:42.310 Awaish Kumar: Maybe try to exploit, maybe, I don’t know.
226 00:20:42.310 ⇒ 00:20:44.390 Mustafa Raja: Explore… Okay.
227 00:20:48.530 ⇒ 00:20:49.750 Awaish Kumar: Oh, no, man.
228 00:20:50.180 ⇒ 00:20:56.530 Awaish Kumar: Go back. Oh, if I click on Open in Workbook, is it still recommended?
229 00:20:56.530 ⇒ 00:21:02.829 Mustafa Raja: So, what happens is it doesn’t run at all. It says… it throws an error. Let me show you.
230 00:21:06.190 ⇒ 00:21:12.489 Mustafa Raja: And this would be… we would be able to save it as query view, but it wouldn’t be the same thing.
231 00:21:12.600 ⇒ 00:21:14.470 Mustafa Raja: It wouldn’t update the code.
232 00:21:15.190 ⇒ 00:21:17.009 Awaish Kumar: Yeah, let’s… let’s see.
233 00:21:17.900 ⇒ 00:21:18.839 Awaish Kumar: What is the error?
234 00:21:18.840 ⇒ 00:21:21.769 Mustafa Raja: So, yeah, it says.
235 00:21:22.760 ⇒ 00:21:24.859 Awaish Kumar: At the bottom, yeah, scroll down.
236 00:21:25.320 ⇒ 00:21:26.390 Awaish Kumar: Scroll down.
237 00:21:27.130 ⇒ 00:21:27.700 Awaish Kumar: Okay.
238 00:21:27.700 ⇒ 00:21:28.689 Mustafa Raja: Yeah, this is… this is it.
239 00:21:28.880 ⇒ 00:21:40.880 Awaish Kumar: The error is that in the line number 47, Put users.name thing in the… Code, quote, single, like…
240 00:21:41.870 ⇒ 00:21:42.560 Mustafa Raja: Okay.
241 00:21:44.630 ⇒ 00:21:45.670 Mustafa Raja: Like this?
242 00:21:45.670 ⇒ 00:21:47.440 Awaish Kumar: Yeah, and now run it.
243 00:21:47.990 ⇒ 00:21:49.130 Mustafa Raja: Aww.
244 00:21:51.710 ⇒ 00:21:57.150 Mustafa Raja: I thought… I thought the environment was messy or something.
245 00:22:05.790 ⇒ 00:22:06.560 Awaish Kumar: What happened?
246 00:22:06.860 ⇒ 00:22:10.290 Mustafa Raja: It’s running, yeah, yeah, the data is there now.
247 00:22:10.290 ⇒ 00:22:12.330 Awaish Kumar: So now click on Model on the top.
248 00:22:12.750 ⇒ 00:22:14.840 Mustafa Raja: Model this.
249 00:22:14.840 ⇒ 00:22:17.959 Awaish Kumar: Yeah, and then you say push to dbt repo.
250 00:22:18.280 ⇒ 00:22:21.070 Mustafa Raja: Push to dbt.co. Wow!
251 00:22:22.900 ⇒ 00:22:23.630 Awaish Kumar: Oh, yeah.
252 00:22:23.920 ⇒ 00:22:24.840 Mustafa Raja: This is good?
253 00:22:25.070 ⇒ 00:22:25.730 Awaish Kumar: Oh,
254 00:22:26.900 ⇒ 00:22:28.030 Mustafa Raja: I can push, right?
255 00:22:28.030 ⇒ 00:22:29.570 Awaish Kumar: Okay.
256 00:22:30.510 ⇒ 00:22:32.440 Awaish Kumar: Push and create a pull request.
257 00:22:32.550 ⇒ 00:22:33.430 Mustafa Raja: Sorry.
258 00:22:34.920 ⇒ 00:22:37.930 Mustafa Raja: Apr…
259 00:22:39.030 ⇒ 00:22:42.380 Awaish Kumar: Great, now you can assign it to me for review, and I can merge it.
260 00:22:42.670 ⇒ 00:22:43.600 Mustafa Raja: Okay.
261 00:22:43.910 ⇒ 00:22:45.870 Awaish Kumar: Simply appear in the chat.
262 00:22:46.310 ⇒ 00:22:47.549 Mustafa Raja: Okay.
263 00:22:47.840 ⇒ 00:22:49.149 Mustafa Raja: And let me do that.
264 00:22:51.510 ⇒ 00:22:52.319 Awaish Kumar: In the Zoom chat.
265 00:22:52.670 ⇒ 00:22:54.239 Mustafa Raja: Oh, Zoom chat, sorry.
266 00:22:54.400 ⇒ 00:22:58.080 Mustafa Raja: Small town.
267 00:23:00.340 ⇒ 00:23:01.630 Mustafa Raja: St.
268 00:23:02.600 ⇒ 00:23:05.700 Awaish Kumar: Great, I just… Okay.
269 00:23:05.700 ⇒ 00:23:11.660 Mustafa Raja: So, one more thing, while I have you here.
270 00:23:12.580 ⇒ 00:23:14.290 Mustafa Raja: Need some more advice.
271 00:23:21.280 ⇒ 00:23:29.099 Mustafa Raja: Okay, so, I am trying to connect, operating user with, with this linear data, right?
272 00:23:29.100 ⇒ 00:23:33.309 Awaish Kumar: I would suggest you to do that,
273 00:23:33.470 ⇒ 00:23:36.869 Awaish Kumar: Don’t do it here. Go back to, yeah, this view.
274 00:23:36.970 ⇒ 00:23:44.009 Awaish Kumar: Oh… Go, yeah, and then… you want… now tell me what you want to do?
275 00:23:44.010 ⇒ 00:23:49.909 Mustafa Raja: So we will need emails of the users, so assignee email, and then the creator email.
276 00:23:51.220 ⇒ 00:23:53.599 Awaish Kumar: Great, what’s… what’s happening on the…
277 00:23:53.760 ⇒ 00:23:56.400 Awaish Kumar: On the left-hand side, can you just…
278 00:23:56.700 ⇒ 00:24:00.860 Awaish Kumar: Click, like, close this, clockify, linear, and do…
279 00:24:01.340 ⇒ 00:24:03.919 Mustafa Raja: The… the… oh…
280 00:24:03.920 ⇒ 00:24:08.969 Awaish Kumar: No, no, no, no, no, left-hand side, just, yeah, I… Sorry. How?
281 00:24:11.350 ⇒ 00:24:16.190 Awaish Kumar: Mice… Let me open… the project.
282 00:24:21.040 ⇒ 00:24:24.260 Awaish Kumar: platform, I have duty for all rights.
283 00:24:24.760 ⇒ 00:24:26.230 Awaish Kumar: Monos.
284 00:24:27.570 ⇒ 00:24:30.279 Awaish Kumar: I have mods, called Finance.
285 00:24:30.710 ⇒ 00:24:32.820 Awaish Kumar: And then I have my…
286 00:24:37.040 ⇒ 00:24:44.890 Awaish Kumar: Intermediate, and now… Is this not the… Could we…
287 00:24:49.370 ⇒ 00:24:55.119 Awaish Kumar: Bronhiding, or what’s… Can we… can we go back to this?
288 00:24:55.490 ⇒ 00:25:02.070 Awaish Kumar: Settings, like, in the settings?
289 00:25:07.100 ⇒ 00:25:14.449 Awaish Kumar: Yeah, Snowflake connection… Second… Oh, in the, in the DVT.
290 00:25:15.160 ⇒ 00:25:16.840 Awaish Kumar: Click on DBT on the top.
291 00:25:18.420 ⇒ 00:25:24.020 Awaish Kumar: Good platform, good project main, DVD project.
292 00:25:24.190 ⇒ 00:25:25.310 Awaish Kumar: That’s all.
293 00:25:27.010 ⇒ 00:25:28.580 Awaish Kumar: PayPal data platform.
294 00:25:33.700 ⇒ 00:25:41.209 Awaish Kumar: That’s all good, does… Can you run migration on this left-hand side? Yeah.
295 00:25:41.370 ⇒ 00:25:42.550 Awaish Kumar: Go right-hand side.
296 00:25:44.340 ⇒ 00:25:46.039 Mustafa Raja: is that, this?
297 00:25:46.040 ⇒ 00:25:46.640 Awaish Kumar: Yep.
298 00:25:51.270 ⇒ 00:25:53.400 Awaish Kumar: Override, override, maybe.
299 00:25:53.770 ⇒ 00:25:56.800 Mustafa Raja: Override, and run it, right?
300 00:26:07.280 ⇒ 00:26:10.809 Awaish Kumar: Now go to Setting, on the… settings on the top also.
301 00:26:11.840 ⇒ 00:26:14.860 Awaish Kumar: on this red underprint for Snowflake connection.
302 00:26:15.250 ⇒ 00:26:18.139 Awaish Kumar: On the right-hand side, refresh now.
303 00:26:20.930 ⇒ 00:26:23.110 Mustafa Raja: Yeah, do we need anything over here, or should I refresh?
304 00:26:23.410 ⇒ 00:26:24.540 Awaish Kumar: Refresh on.
305 00:26:26.500 ⇒ 00:26:30.869 Awaish Kumar: Now, let’s go back to the DPT.
306 00:26:33.770 ⇒ 00:26:36.610 Mustafa Raja: Should we wait for it to signal it’s done, or…
307 00:26:36.610 ⇒ 00:26:37.520 Awaish Kumar: Yes, yes.
308 00:26:48.020 ⇒ 00:26:49.410 Awaish Kumar: And it’s done.
309 00:26:51.050 ⇒ 00:26:58.209 Awaish Kumar: Hmm… Okay, schemas are these, which…
310 00:27:00.770 ⇒ 00:27:03.999 Awaish Kumar: Okay, now go to the dbt icon.
311 00:27:12.640 ⇒ 00:27:19.709 Awaish Kumar: Okay, you… what I wanted you to basically, created in workbook.
312 00:27:22.960 ⇒ 00:27:24.860 Mustafa Raja: Yeah, so I want to open it in Workbook, right?
313 00:27:27.300 ⇒ 00:27:30.619 Awaish Kumar: Open it in workbook, and
314 00:27:32.000 ⇒ 00:27:35.500 Awaish Kumar: Now, can you… why are you not able to…
315 00:27:35.620 ⇒ 00:27:37.980 Awaish Kumar: Can you see if we can create new files here?
316 00:27:38.190 ⇒ 00:27:39.249 Awaish Kumar: On the left.
317 00:27:40.630 ⇒ 00:27:43.200 Awaish Kumar: Is there any way to upgrade news?
318 00:27:46.240 ⇒ 00:27:55.640 Mustafa Raja: Hmm… I don’t think because… These are the views only, and not the…
319 00:27:56.990 ⇒ 00:28:03.549 Mustafa Raja: Can you… yeah, what is… Oh, if we go back, let me see if I can create the…
320 00:28:04.180 ⇒ 00:28:06.219 Mustafa Raja: If I can create here…
321 00:28:07.530 ⇒ 00:28:11.649 Awaish Kumar: No, no. Oh, I think what you can do is basically go back again.
322 00:28:13.230 ⇒ 00:28:14.929 Awaish Kumar: To the workbook.
323 00:28:15.820 ⇒ 00:28:17.170 Mustafa Raja: Oh, to the workbooks.
324 00:28:17.370 ⇒ 00:28:18.120 Mustafa Raja: Yeah.
325 00:28:18.120 ⇒ 00:28:21.960 Awaish Kumar: And just don’t open any existing model, just…
326 00:28:22.620 ⇒ 00:28:29.260 Awaish Kumar: like, write in the editor, write your GIRI, And this code editor.
327 00:28:29.750 ⇒ 00:28:30.520 Mustafa Raja: Hmm.
328 00:28:30.520 ⇒ 00:28:33.249 Awaish Kumar: I don’t know if it’s going to update anything.
329 00:28:34.010 ⇒ 00:28:36.110 Awaish Kumar: Like, can we get an empty one? Like…
330 00:28:36.900 ⇒ 00:28:44.030 Mustafa Raja: There’s only… there’s… we can only open, I think.
331 00:28:44.030 ⇒ 00:28:46.410 Awaish Kumar: Just, like, Ctrl-A, delete it.
332 00:28:49.500 ⇒ 00:28:53.730 Awaish Kumar: Let me write any SQL, select a static from something.
333 00:29:00.380 ⇒ 00:29:02.790 Mustafa Raja: From Lima?
334 00:29:04.900 ⇒ 00:29:05.990 Mustafa Raja: Can I do that?
335 00:29:07.540 ⇒ 00:29:13.030 Awaish Kumar: You can’t, basically, but let’s… Let’s click on model, for example. No.
336 00:29:13.290 ⇒ 00:29:19.069 Awaish Kumar: What you can do is, like, yeah, like, put… press Ctrl-Z,
337 00:29:23.340 ⇒ 00:29:26.269 Awaish Kumar: Like, get back the previous curry.
338 00:29:27.980 ⇒ 00:29:32.929 Awaish Kumar: Yeah, and… Let’s maybe run it.
339 00:29:49.700 ⇒ 00:29:50.520 Awaish Kumar: Oh.
340 00:29:50.870 ⇒ 00:29:53.139 Mustafa Raja: Oh, yeah, we need to use…
341 00:30:01.930 ⇒ 00:30:07.629 Awaish Kumar: We put the fix, and I merged it, but still, it’s not in sync, I don’t know why.
342 00:30:07.630 ⇒ 00:30:09.890 Mustafa Raja: Hmm…
343 00:30:12.280 ⇒ 00:30:18.610 Mustafa Raja: This is moist? Okay. I guess I can, retry, it might be… it might be because of…
344 00:30:18.610 ⇒ 00:30:22.069 Awaish Kumar: See, click on model, for example.
345 00:30:23.900 ⇒ 00:30:25.200 Awaish Kumar: No, no, no.
346 00:30:25.490 ⇒ 00:30:27.220 Awaish Kumar: Why?
347 00:30:27.660 ⇒ 00:30:30.850 Awaish Kumar: I want, like, the… the above…
348 00:30:31.350 ⇒ 00:30:36.019 Awaish Kumar: there’s one, like, push to dbt repo, right? There’s one more…
349 00:30:40.770 ⇒ 00:30:48.089 Awaish Kumar: Okay, let’s get… Let’s go to the, Explore page. Explore.
350 00:30:49.400 ⇒ 00:30:50.380 Mustafa Raja: in the…
351 00:30:52.740 ⇒ 00:30:54.020 Awaish Kumar: Who’s that?
352 00:30:55.170 ⇒ 00:30:57.320 Awaish Kumar: I think it’s not here.
353 00:30:57.430 ⇒ 00:31:00.760 Awaish Kumar: Just go back from the double… yeah, this one, maybe.
354 00:31:06.960 ⇒ 00:31:09.469 Awaish Kumar: Yeah, but we are in the same…
355 00:31:12.690 ⇒ 00:31:13.380 Mustafa Raja: Yeah.
356 00:31:13.380 ⇒ 00:31:15.660 Awaish Kumar: When you click on model,
357 00:31:16.570 ⇒ 00:31:20.999 Awaish Kumar: I want, if you go to the model,
358 00:31:21.470 ⇒ 00:31:27.909 Awaish Kumar: I want this convert to dbt model. I want this thing to be active. Right now, it’s inactive.
359 00:31:28.870 ⇒ 00:31:30.279 Awaish Kumar: Curious already?
360 00:31:30.750 ⇒ 00:31:36.630 Awaish Kumar: Yeah, because our queue isn’t already dbtSQL code, Aww.
361 00:31:45.220 ⇒ 00:31:46.969 Awaish Kumar: Okay, let’s write.
362 00:31:47.150 ⇒ 00:31:52.839 Awaish Kumar: Poly… select star from polyatomic linear dot issues.
363 00:32:00.770 ⇒ 00:32:02.360 Awaish Kumar: Yeah, volatile.
364 00:32:02.610 ⇒ 00:32:04.180 Awaish Kumar: broad intermediate.
365 00:32:05.270 ⇒ 00:32:08.380 Awaish Kumar: the database name, Proud Intermediate.
366 00:32:14.250 ⇒ 00:32:15.179 Mustafa Raja: This one, right?
367 00:32:20.260 ⇒ 00:32:21.490 Awaish Kumar: execute, like…
368 00:32:21.860 ⇒ 00:32:22.460 Mustafa Raja: Okay.
369 00:32:29.550 ⇒ 00:32:31.370 Awaish Kumar: No, no, let’s finish, let it finish.
370 00:32:43.320 ⇒ 00:32:50.340 Awaish Kumar: Okay, now, if we go to module… It’s just a… was…
371 00:32:54.350 ⇒ 00:32:55.800 Awaish Kumar: Through my energy.
372 00:32:57.930 ⇒ 00:33:02.890 Awaish Kumar: Let me also… Open from Omni.
373 00:33:06.820 ⇒ 00:33:09.570 Awaish Kumar: I think, basically, what you can, do…
374 00:33:13.690 ⇒ 00:33:16.570 Awaish Kumar: What you can do is,
375 00:33:23.230 ⇒ 00:33:25.220 Awaish Kumar: And maybe I could do a nope.
376 00:34:41.620 ⇒ 00:34:43.639 Mustafa Raja: Can we try with this SQL?
377 00:34:46.960 ⇒ 00:34:53.809 Awaish Kumar: Yeah, when you go to the Explorer in the, like, query view, basically we can create
378 00:34:55.090 ⇒ 00:34:59.299 Awaish Kumar: like, what I’m trying to say is, if you go back to the develop.
379 00:35:00.550 ⇒ 00:35:01.850 Mustafa Raja: Yeah, I’m developed.
380 00:35:01.850 ⇒ 00:35:06.290 Awaish Kumar: Yeah, now if you write a normal query, I just…
381 00:35:07.230 ⇒ 00:35:12.049 Awaish Kumar: Not just, like, click on Explore and… Just write a query.
382 00:35:14.530 ⇒ 00:35:15.890 Awaish Kumar: Esquilia.
383 00:35:17.010 ⇒ 00:35:25.079 Awaish Kumar: If you write a simple query and then click on convert to dbt model, it will just work.
384 00:35:26.910 ⇒ 00:35:28.760 Awaish Kumar: Like, she’s like a style from…
385 00:35:32.540 ⇒ 00:35:40.680 Awaish Kumar: Broad, intermediate, interlinear… interlinear issues, and put limit on maybe 100, so it executes faster.
386 00:35:47.580 ⇒ 00:35:53.430 Awaish Kumar: now the top model convert to dbt actually works.
387 00:35:53.430 ⇒ 00:35:54.490 Mustafa Raja: Oh, yeah.
388 00:35:55.830 ⇒ 00:35:57.189 Awaish Kumar: So I shall click it.
389 00:35:58.170 ⇒ 00:36:00.150 Awaish Kumar: But the problem, what I’m…
390 00:36:03.160 ⇒ 00:36:06.950 Awaish Kumar: Okay, so… If you…
391 00:36:13.560 ⇒ 00:36:16.259 Awaish Kumar: So, yeah, if you click it, then…
392 00:36:16.380 ⇒ 00:36:25.880 Awaish Kumar: it will convert it to a model, but then you push it in the dbt repo, and when you push it, it will ask for the
393 00:36:26.090 ⇒ 00:36:30.669 Awaish Kumar: Name of the file and the location, you can decide where to put it.
394 00:36:31.070 ⇒ 00:36:32.590 Mustafa Raja: Okay, okay.
395 00:36:38.790 ⇒ 00:36:43.050 Mustafa Raja: And then, if I try to push it… It will ask me.
396 00:36:46.990 ⇒ 00:36:48.000 Mustafa Raja: So, top…
397 00:36:48.000 ⇒ 00:36:48.780 Awaish Kumar: Finally.
398 00:36:48.780 ⇒ 00:36:51.109 Mustafa Raja: Oh, finally, okay, okay, okay.
399 00:36:51.710 ⇒ 00:36:56.449 Mustafa Raja: Okay, yeah, we don’t have… we don’t have to push this, though, right?
400 00:36:57.100 ⇒ 00:37:04.139 Awaish Kumar: No, no, we don’t have to push this, but I… I’m just telling you, if you want to combine, just write… try to write a query.
401 00:37:05.000 ⇒ 00:37:23.149 Awaish Kumar: Right? You know that there is linear data, there’s QBO with the operating data, and just generate explore, figure out what you can use to combine them, maybe using email or username, whatever, and when you join it, you will have a combined model.
402 00:37:23.180 ⇒ 00:37:25.890 Awaish Kumar: Then you can push that model out.
403 00:37:26.190 ⇒ 00:37:29.599 Awaish Kumar: And then use it in your dashboard.
404 00:37:30.040 ⇒ 00:37:33.829 Mustafa Raja: Okay, yeah, so regarding that, I have a problem.
405 00:37:33.830 ⇒ 00:37:38.250 Awaish Kumar: Also, if you don’t want to work directly in Omni, you can just
406 00:37:38.470 ⇒ 00:37:45.119 Awaish Kumar: this code is in GitHub. You can just clone there and run in, like, cursor.
407 00:37:45.650 ⇒ 00:37:46.280 Mustafa Raja: Okay.
408 00:37:46.590 ⇒ 00:37:53.289 Mustafa Raja: Okay, that’s helpful. So, so regarding this, I have one issue. So,
409 00:37:54.090 ⇒ 00:37:57.160 Mustafa Raja: Let me actually show you…
410 00:38:08.080 ⇒ 00:38:16.080 Mustafa Raja: So I created a query view because, I needed, I needed to, create this model, yesterday.
411 00:38:16.280 ⇒ 00:38:25.489 Mustafa Raja: Now I do have the, assignee email and creator email, and what I am doing is…
412 00:38:36.570 ⇒ 00:38:45.489 Awaish Kumar: Yes, I… Nick, that’s what I… I… I don’t know this thing. We… basically, here, you have to figure out this new syntax.
413 00:38:45.980 ⇒ 00:39:02.450 Mustafa Raja: Yeah, yeah, no, this isn’t… this isn’t an issue. The relations are all good. The issue is that, so, so we have two types of users, in this model, right? One is creator, and another one is assignee.
414 00:39:02.450 ⇒ 00:39:11.440 Mustafa Raja: I, I joined, I joined the, users from, operating to, creator email.
415 00:39:11.440 ⇒ 00:39:12.250 Mustafa Raja: Oh, no.
416 00:39:12.590 ⇒ 00:39:19.499 Awaish Kumar: Use assignee email, because assignee is the one who is working on the ticket. Creator is just someone who creates the ticket.
417 00:39:19.500 ⇒ 00:39:26.149 Mustafa Raja: Okay, okay. And if I do that, that should be able to cover most of the use cases, right?
418 00:39:27.510 ⇒ 00:39:35.089 Awaish Kumar: I don’t know, like, you have to figure out. Okay. You have to just, like, take a list of emails from operating.
419 00:39:35.790 ⇒ 00:39:41.119 Awaish Kumar: Also, for the assignee email, get the list of assignee people.
420 00:39:41.240 ⇒ 00:39:42.189 Mustafa Raja: I like that.
421 00:39:42.310 ⇒ 00:39:48.699 Awaish Kumar: And then see if you can exactly match. For example, you get the email from,
422 00:39:48.970 ⇒ 00:40:00.520 Awaish Kumar: from operating, you get an email, awish.kumar, and it reinforces.ai, but in tickets, maybe you just get awish.kumar, and not my exact email, and then it won’t join, right?
423 00:40:00.520 ⇒ 00:40:02.739 Mustafa Raja: Yeah, yeah, yeah, so I am able to join…
424 00:40:02.740 ⇒ 00:40:06.809 Awaish Kumar: Optimize the names in both places, and then it can work.
425 00:40:07.180 ⇒ 00:40:11.469 Mustafa Raja: Okay, okay. Okay, so for both, I’m able to join all of them.
426 00:40:12.150 ⇒ 00:40:16.670 Awaish Kumar: If you are… if you are able to join all the users, then that’s okay, it covers everything.
427 00:40:16.670 ⇒ 00:40:19.089 Mustafa Raja: Okay, okay, okay, yeah. Yeah.
428 00:40:19.090 ⇒ 00:40:34.769 Awaish Kumar: I’m just saying, like, some… like, I have worked on this thing. In my… I have worked on linear data, so I have worked on Clockify data, and both the… and I’ve combined them together also in the mods, if you look at the repository.
429 00:40:35.040 ⇒ 00:40:37.259 Awaish Kumar: So that’s what is happening is.
430 00:40:38.340 ⇒ 00:40:55.609 Awaish Kumar: In Clockify, sometimes name is different, sometimes, and sometimes linear. From linear, I’m getting an email from Clockify. For some entries, I’m getting a person’s name, and for some entries, I’m getting a person’s email in the same field.
431 00:40:55.690 ⇒ 00:41:00.530 Awaish Kumar: like, I’m getting Mustafar.raja, then I’m getting Mustafar.rajat.printfor.ai.
432 00:41:00.570 ⇒ 00:41:18.659 Awaish Kumar: Both for Clockify, and then for linear, I’m just… I’m getting the email. So, I can join on emails, but those entries, which are basically only with your name, and not the full email, I will lose them. So, we just have to… just…
433 00:41:18.780 ⇒ 00:41:23.499 Awaish Kumar: Give, like, review the fields in both… both the…
434 00:41:23.750 ⇒ 00:41:31.980 Awaish Kumar: sources and see there’s no duplicates. For a single one person, there’s only one identifier.
435 00:41:32.590 ⇒ 00:41:36.629 Awaish Kumar: If it’s an email, if it’s a name, whatever it is, and the same appears in the…
436 00:41:36.830 ⇒ 00:41:39.049 Awaish Kumar: other source as well, and no.
437 00:41:39.050 ⇒ 00:41:39.540 Mustafa Raja: Okay.
438 00:41:39.540 ⇒ 00:41:40.120 Awaish Kumar: Nope.
439 00:41:41.890 ⇒ 00:41:56.919 Mustafa Raja: Okay… Okay, one last thing… Define, we’ll have… No, this one…
440 00:41:57.080 ⇒ 00:41:59.150 Mustafa Raja: Sorry if I’m taking too much time.
441 00:42:05.120 ⇒ 00:42:06.310 Mustafa Raja: Yeah, project.
442 00:42:07.640 ⇒ 00:42:16.419 Mustafa Raja: So, so, so clockified diameteries have a project name, and then linear also has a project name.
443 00:42:20.430 ⇒ 00:42:25.910 Mustafa Raja: There’s a T1… So, Elena would have a team name. Team name.
444 00:42:26.150 ⇒ 00:42:32.150 Mustafa Raja: Yeah, so, we would want to join those, but these… these two names aren’t going to match.
445 00:42:32.150 ⇒ 00:42:37.099 Awaish Kumar: Yeah, I have already worked on some of these things. For linear clockify…
446 00:42:37.220 ⇒ 00:42:41.590 Awaish Kumar: If you look at the… modem…
447 00:42:44.360 ⇒ 00:42:46.909 Awaish Kumar: Yeah, if you look at our summary, maybe…
448 00:42:47.660 ⇒ 00:42:49.149 Mustafa Raja: our summary.
449 00:42:52.010 ⇒ 00:42:55.719 Awaish Kumar: So I have a standardized username, I have a standardized team name.
450 00:42:55.980 ⇒ 00:43:03.400 Awaish Kumar: And I’ve standardized them using some macros in dbt. So if you look at the dbt project, Just…
451 00:43:03.540 ⇒ 00:43:06.710 Awaish Kumar: clone the GitHub repository in your cursor and read
452 00:43:07.010 ⇒ 00:43:09.549 Awaish Kumar: read, like, Luke, have a look at that, you will…
453 00:43:09.790 ⇒ 00:43:13.689 Awaish Kumar: figure out, like, I’m… how I’m standardizing all these things.
454 00:43:13.690 ⇒ 00:43:17.329 Mustafa Raja: Okay, okay, yeah Okay, that’s helpful then.
455 00:43:17.900 ⇒ 00:43:27.030 Mustafa Raja: I’ll first, I’ll first, read this thoroughly, whatever we have in March, and then see if, I need to do anything else.
456 00:43:27.460 ⇒ 00:43:28.420 Awaish Kumar: No, okay.
457 00:43:28.420 ⇒ 00:43:29.580 Mustafa Raja: Okay, thank you so much.
458 00:43:29.580 ⇒ 00:43:30.260 Awaish Kumar: Thank you.
459 00:43:31.490 ⇒ 00:43:32.849 Mustafa Raja: And that’s all from me.