Meeting Title: Stella-Weekly-Regroup Date: 2024-06-06 Meeting participants: Patrick Trainer, Nicolas Sucari, Robert Tseng, Uttam Kumaran, Nick Baker
WEBVTT
1 00:00:54.480 ⇒ 00:00:55.260 Nicolas Sucari: Yeah. Patrick.
2 00:00:56.050 ⇒ 00:00:57.800 Patrick Trainer: Hey? How’s it going.
3 00:00:59.300 ⇒ 00:01:00.523 Nicolas Sucari: I’m fine, but you.
4 00:01:02.870 ⇒ 00:01:04.334 Patrick Trainer: Pretty good. I think
5 00:01:04.830 ⇒ 00:01:08.999 Patrick Trainer: I might have action figured out now
6 00:01:10.770 ⇒ 00:01:14.630 Patrick Trainer: it’s it’s a fucking class. It’s just
7 00:01:14.970 ⇒ 00:01:17.489 Patrick Trainer: such a pain in the ass to debug
8 00:01:19.880 ⇒ 00:01:20.620 Patrick Trainer: ethnic.
9 00:01:26.340 ⇒ 00:01:27.320 Patrick Trainer: Oh.
10 00:01:34.340 ⇒ 00:01:35.630 Patrick Trainer: okay.
11 00:01:43.850 ⇒ 00:01:45.060 Patrick Trainer: thank God.
12 00:01:55.600 ⇒ 00:01:56.910 Patrick Trainer: cannot have done it.
13 00:02:01.020 ⇒ 00:02:03.570 Patrick Trainer: Think I might have
14 00:02:04.160 ⇒ 00:02:05.719 Patrick Trainer: fucking done it.
15 00:02:10.030 ⇒ 00:02:11.700 Patrick Trainer: Now let’s
16 00:02:12.250 ⇒ 00:02:13.560 Patrick Trainer: try.
17 00:02:21.840 ⇒ 00:02:23.990 Patrick Trainer: Okay, Gabe Bradle.
18 00:02:32.010 ⇒ 00:02:32.700 Nicolas Sucari: Hi, Nick.
19 00:02:33.320 ⇒ 00:02:35.229 Nick Baker: Hey? What’s going on? How you doing.
20 00:02:35.690 ⇒ 00:02:36.910 Nicolas Sucari: Nice to meet you.
21 00:02:37.280 ⇒ 00:02:38.240 Nick Baker: Like grass.
22 00:02:40.550 ⇒ 00:02:41.480 Uttam Kumaran: Yo.
23 00:02:50.350 ⇒ 00:02:51.740 Nick Baker: Notetaker.
24 00:02:54.040 ⇒ 00:02:55.330 Robert Tseng: Oh, hey, guys.
25 00:02:56.210 ⇒ 00:02:56.596 Nick Baker: Well, it’s
26 00:02:57.185 ⇒ 00:02:57.580 Patrick Trainer: Hey!
27 00:02:58.220 ⇒ 00:02:58.810 Uttam Kumaran: Elk.
28 00:03:05.800 ⇒ 00:03:07.539 Uttam Kumaran: should we jump right into stuff
29 00:03:10.720 ⇒ 00:03:11.420 Uttam Kumaran: and.
30 00:03:12.400 ⇒ 00:03:13.060 Patrick Trainer: To it.
31 00:03:16.810 ⇒ 00:03:17.570 Patrick Trainer: Yep.
32 00:03:19.280 ⇒ 00:03:23.570 Uttam Kumaran: Cool. I think the only thing to really chat about
33 00:03:24.076 ⇒ 00:03:25.940 Uttam Kumaran: is the S Fab
34 00:03:26.250 ⇒ 00:03:27.539 Uttam Kumaran: data model.
35 00:03:28.173 ⇒ 00:03:40.459 Uttam Kumaran: So the Zendesk thing things are done for the SFI think I’ll just set the scene. Basically, it’s just cleaning up and creating some
36 00:03:41.061 ⇒ 00:03:46.029 Uttam Kumaran: joins between tables directly from the Sf product. Database.
37 00:03:46.726 ⇒ 00:03:48.020 Uttam Kumaran: I guess.
38 00:03:48.410 ⇒ 00:03:57.719 Uttam Kumaran: Nick, I’ll let you jump right into. I saw you message something this morning, but we can talk through it, and even if we have enough time today, we can even we can work on stuff or
39 00:03:58.760 ⇒ 00:04:00.970 Uttam Kumaran: that’s primarily the thing I wanted to talk about.
40 00:04:00.970 ⇒ 00:04:24.790 Nick Baker: Cool. Yeah. So I I went through and I looked at the Ids, pulled through all the fields that were indicated on them. The ticket was saying that I was going from the Sf. Database, but there’s also or Sf. Schema, but there’s also an Ss schema, so I just wanted to clarify the difference between those 2. Especially because some of the tables don’t exist on the Sf. Schema.
41 00:04:26.176 ⇒ 00:04:37.240 Robert Tseng: The ss should be like once, Sab, and once Stella, so yeah should. It should be the Sf, not. Ss, I think, is what I put in the already.
42 00:04:37.240 ⇒ 00:04:37.775 Nick Baker: Okay.
43 00:04:38.310 ⇒ 00:04:38.670 Robert Tseng: Yeah.
44 00:04:38.670 ⇒ 00:04:46.849 Nick Baker: So those. So then, tenants, users, and organization, all 3 of those are not in or I couldn’t find them in the
45 00:04:47.650 ⇒ 00:04:52.130 Nick Baker: the let me find it. The SF
46 00:04:52.220 ⇒ 00:04:53.960 Nick Baker: legacy database
47 00:04:57.000 ⇒ 00:04:59.510 Robert Tseng: Okay, let me look at this again.
48 00:05:12.730 ⇒ 00:05:14.360 Robert Tseng: Okay, actually
49 00:05:14.760 ⇒ 00:05:17.460 Robert Tseng: scratch what I said, Sf, and Ss are both
50 00:05:18.480 ⇒ 00:05:24.359 Robert Tseng: are are both as fat. I don’t know. Yeah. So yeah, so I guess we we should pull from.
51 00:05:24.470 ⇒ 00:05:26.189 Robert Tseng: Yeah, from from my, from my area.
52 00:05:26.680 ⇒ 00:05:39.230 Nick Baker: Cool. Okay, so I’ve got that where I’ve pulled both of them, or I pulled all those tables, and then I need to. There are a couple of fields that I indicated on the ticket that are that I didn’t find on that table.
53 00:05:39.580 ⇒ 00:05:43.739 Nick Baker: So I wanted to just flag those for you cause those are highlighted.
54 00:05:43.900 ⇒ 00:05:50.240 Nick Baker: And then the other piece was, I saw that these are all like
55 00:05:50.320 ⇒ 00:05:57.579 Nick Baker: I I see, where the keys are set, but wanted to clarify what the output. What the actual output is that we’re trying to get.
56 00:05:59.030 ⇒ 00:05:59.599 Robert Tseng: Sure.
57 00:06:05.780 ⇒ 00:06:07.510 Robert Tseng: let me pull up the
58 00:06:08.090 ⇒ 00:06:09.430 Robert Tseng: modeling, Doc.
59 00:06:23.220 ⇒ 00:06:26.840 Robert Tseng: yeah, so these. So these 5, sorry, did I? Customer? I didn’t
60 00:06:27.080 ⇒ 00:06:28.279 Robert Tseng: got it. Okay.
61 00:06:28.630 ⇒ 00:06:36.150 Robert Tseng: yeah, so from from these 5 tables. Right? We have. Yeah, this is just like, quote data, join to like
62 00:06:36.180 ⇒ 00:06:39.155 Robert Tseng: organizations users, right? More or less. And
63 00:06:39.760 ⇒ 00:06:45.420 Robert Tseng: yeah, I think the the output from here is that monthly quote activity. I think there’s just a lot of
64 00:06:45.788 ⇒ 00:06:48.989 Robert Tseng: I think there are a lot of questions around just being able to visualize
65 00:06:49.328 ⇒ 00:06:56.959 Robert Tseng: Or report on like quote data over time. So I’ll I’ll retag you in one of the deliverables that was specifically asked for
66 00:06:59.820 ⇒ 00:07:01.719 Robert Tseng: But yeah, I think we can.
67 00:07:01.750 ⇒ 00:07:06.070 Robert Tseng: If you want, I can extend this because this is this is not.
68 00:07:06.900 ⇒ 00:07:08.830 Robert Tseng: This is just gonna be like quote.
69 00:07:09.140 ⇒ 00:07:14.179 Robert Tseng: like quote value over time, like an an adequate aggregate level level. So.
70 00:07:14.180 ⇒ 00:07:14.620 Nick Baker: Okay.
71 00:07:15.070 ⇒ 00:07:15.529 Nick Baker: Yeah, I, just.
72 00:07:15.530 ⇒ 00:07:16.819 Robert Tseng: Organization, button.
73 00:07:16.820 ⇒ 00:07:30.189 Nick Baker: I just didn’t know the fields. You need, basically. So like, right now, I’ve got these like super wide, like staging table. Or I put them as end tables, basically, which is just like recasting and renaming the fields and snake case. But actual output of
74 00:07:30.488 ⇒ 00:07:40.680 Nick Baker: of what you’re hoping to see? Like I’m I’m happy to put that together. I just didn’t see that access explicitly laid out anywhere as some of the prior requirements that we have for some of those other tables.
75 00:07:40.850 ⇒ 00:07:43.780 Robert Tseng: Yeah, I see. I see what you mean, like what I did for the Zendesk.
76 00:07:43.780 ⇒ 00:07:49.990 Nick Baker: Yeah is good. Cause that’s I know the target is, and then I can ask questions if I get stuck on any of the like.
77 00:07:51.480 ⇒ 00:07:57.850 Nick Baker: You know how the tables fit together, or redundancy, or duplication, or many to one really like all that.
78 00:07:58.110 ⇒ 00:08:02.010 Robert Tseng: Okay, I’ll add that to the issue. Later. After this call, yeah.
79 00:08:02.010 ⇒ 00:08:08.069 Nick Baker: Perfect. Yeah. And then I’ll I’ll be able to move forward on that, and can let you know. If I have any additional questions. There.
80 00:08:08.470 ⇒ 00:08:09.060 Robert Tseng: Cool.
81 00:08:09.060 ⇒ 00:08:17.247 Uttam Kumaran: Yeah, Robert, I think you and the doc you had like visualize cost distribution and like percent of costs attributed to materialist labor. I just couldn’t break that down.
82 00:08:17.740 ⇒ 00:08:19.159 Robert Tseng: Yeah, I’ll break down. Yeah.
83 00:08:19.160 ⇒ 00:08:20.650 Uttam Kumaran: Okay. Cool. Okay. Great.
84 00:08:20.800 ⇒ 00:08:21.370 Robert Tseng: Yeah.
85 00:08:21.780 ⇒ 00:08:22.350 Robert Tseng: Loop.
86 00:08:22.350 ⇒ 00:08:24.652 Nick Baker: Yeah, just little context will help a ton.
87 00:08:25.190 ⇒ 00:08:30.610 Nick Baker: Otherwise on my side, that’s that’s pretty much everything. We got those other tickets closed out Zendesk stuff.
88 00:08:31.070 ⇒ 00:08:32.520 Robert Tseng: Yeah, so that’s what’s good. Yeah.
89 00:08:32.520 ⇒ 00:08:39.760 Nick Baker: Yeah. And so if there’s anything else that’s in there, you know, just just flag it to me, and I’ll I can take care of it. I’ve got a ton of time today tomorrow, for sure.
90 00:08:40.049 ⇒ 00:08:40.809 Nick Baker: Great.
91 00:08:41.960 ⇒ 00:08:47.879 Uttam Kumaran: Yeah, so maybe we could close this S. Fab stuff out in Dbt, like today tomorrow. And then.
92 00:08:47.880 ⇒ 00:08:48.300 Robert Tseng: Yeah.
93 00:08:48.300 ⇒ 00:08:57.729 Uttam Kumaran: I know, Robert, we’re working on a next set of requirements. So I think, Nick, probably just like hang tight that we get that to you sometime midweek next week, or whenever.
94 00:08:57.730 ⇒ 00:08:58.530 Nick Baker: Got it.
95 00:08:59.820 ⇒ 00:09:06.820 Nicolas Sucari: I think. Sorry you, Tom, that we have still pending the setting up the elementary dashboard. If that’s okay, too.
96 00:09:07.420 ⇒ 00:09:13.319 Uttam Kumaran: Oh, yeah, I think that’s honestly not a blocker for anything. And that we just wrote some documentation. So,
97 00:09:13.620 ⇒ 00:09:18.240 Uttam Kumaran: Nick, we’re we’re working on. We, we have. You use elementary before. So
98 00:09:18.550 ⇒ 00:09:29.400 Uttam Kumaran: elementary is kind of like like, what is not data full, but like one of those data, observability tools where basically, you can write tests. And there’s like a really nice ui for running like anomaly tests
99 00:09:29.828 ⇒ 00:09:35.209 Uttam Kumaran: like source freshness test, primary key test, and we’re using it across every client
100 00:09:35.280 ⇒ 00:09:36.660 Uttam Kumaran: for free
101 00:09:36.690 ⇒ 00:09:47.980 Uttam Kumaran: and we just have a little bit of a documentation on how to set that up, and that way we can set up like test and alerting for the inevitability that something fucks on. So
102 00:09:48.250 ⇒ 00:09:49.180 Uttam Kumaran: Jason.
103 00:09:49.180 ⇒ 00:09:51.561 Nick Baker: Sounds good. I’ll look out for that for more. Info.
104 00:09:52.050 ⇒ 00:09:52.680 Uttam Kumaran: Alright!
105 00:09:55.760 ⇒ 00:09:56.770 Nicolas Sucari: So you’re really, yeah.
106 00:09:58.000 ⇒ 00:09:59.230 Uttam Kumaran: Yeah.
107 00:10:00.480 ⇒ 00:10:07.110 Robert Tseng: Oh, yeah, I mean, I was just gonna say, in case, yeah, I’ve I’ve kind of communicated to you, Tom. I don’t know if it got to Nick. But
108 00:10:07.170 ⇒ 00:10:26.780 Robert Tseng: yeah, I mean the the original Google, Doc. Yeah. Obviously, we tried to present the Zendesk piece is done, and then we kind of wind it down, we we unplug full story. So we’re not doing any reporting on that. And then, yeah. So that’s why we’ve just been focusing on. Sf, and we’re I’m rescoping the next set of deliverables with the client.
109 00:10:28.070 ⇒ 00:10:33.490 Robert Tseng: and so that’s why we this is this week has kind of been a lull with no new requirements. We’re just trying to finish up what we have.
110 00:10:34.350 ⇒ 00:10:35.740 Nick Baker: Cool thanks.
111 00:10:39.260 ⇒ 00:10:39.906 Uttam Kumaran: Hell. Yeah.
112 00:10:42.010 ⇒ 00:10:42.710 Uttam Kumaran: Here.
113 00:10:44.650 ⇒ 00:10:48.720 Uttam Kumaran: Okay, cool. If nothing else, we’ll just talk on slack
114 00:10:49.790 ⇒ 00:10:50.380 Uttam Kumaran: carried.
115 00:10:50.380 ⇒ 00:10:50.970 Robert Tseng: Yep.
116 00:10:51.700 ⇒ 00:10:57.060 Nicolas Sucari: Nick, I can share you the documentation of elementary. So when you have time, you can take a look at that. Okay.
117 00:10:57.544 ⇒ 00:10:59.789 Nick Baker: That sounds good. Yeah, please do. I’ll look out for it.
118 00:11:00.710 ⇒ 00:11:01.590 Nick Baker: Thank you.
119 00:11:03.200 ⇒ 00:11:04.160 Nick Baker: Okay.
120 00:11:04.160 ⇒ 00:11:05.490 Uttam Kumaran: I’ll talk to you over soon.
121 00:11:05.490 ⇒ 00:11:06.580 Robert Tseng: Alright! See y’all.