Meeting Title: Stella-Weekly-Regroup Date: 2024-08-13 Meeting participants: Robert Tseng, Nicolas Sucari
WEBVTT
1 00:00:41.180 ⇒ 00:00:42.060 Nicolas Sucari: Hey, Robert.
2 00:00:42.850 ⇒ 00:00:43.840 Robert Tseng: In Nico.
3 00:00:44.600 ⇒ 00:00:45.449 Nicolas Sucari: How are you?
4 00:00:45.680 ⇒ 00:00:46.670 Robert Tseng: Good! How are you?
5 00:00:47.860 ⇒ 00:00:48.760 Nicolas Sucari: All good.
6 00:00:52.630 ⇒ 00:00:54.889 Nicolas Sucari: Let me check if Utan’s joining.
7 00:00:56.040 ⇒ 00:00:56.670 Robert Tseng: Sure.
8 00:03:23.640 ⇒ 00:03:26.099 Nicolas Sucari: Yeah, he’s not answering now.
9 00:03:26.220 ⇒ 00:03:28.740 Nicolas Sucari: I don’t know. Probably someone’s gonna join.
10 00:03:31.240 ⇒ 00:03:39.110 Nicolas Sucari: yeah, Nick is gonna be is not gonna be joining now, but he’s gonna be online later today.
11 00:03:39.270 ⇒ 00:03:45.029 Nicolas Sucari: So can we go and check what are the priorities? So I can communicate them
12 00:03:45.180 ⇒ 00:03:46.690 Nicolas Sucari: to him later.
13 00:03:47.100 ⇒ 00:03:47.820 Robert Tseng: Sure.
14 00:03:49.480 ⇒ 00:03:54.160 Nicolas Sucari: I mean, I think we have 2 issues from last week. One is the
15 00:03:54.390 ⇒ 00:03:57.100 Nicolas Sucari: update of the data of some tables right.
16 00:03:58.360 ⇒ 00:03:59.860 Robert Tseng: Yes. Can you see my screen?
17 00:04:00.370 ⇒ 00:04:01.110 Robert Tseng: Yep.
18 00:04:01.110 ⇒ 00:04:01.700 Nicolas Sucari: Yes.
19 00:04:01.850 ⇒ 00:04:17.889 Robert Tseng: Okay, yeah. So I took this out of your email update. These are just ongoing items. Few questions that were left standing weren’t answered over slack. So on the Zendesk side. Yeah, I think this is this is pretty spot on. There’s custom fields that we’re missing. This is the Zendesk issues here
20 00:04:18.060 ⇒ 00:04:20.240 Robert Tseng: where I basically said.
21 00:04:20.290 ⇒ 00:04:26.190 Robert Tseng: these 2 reporting fields like, I don’t know why we created them like these are just like
22 00:04:26.840 ⇒ 00:04:28.110 Robert Tseng: these were just
23 00:04:28.460 ⇒ 00:04:41.400 Robert Tseng: raw tables that were pretty much recording. So it doesn’t really actually answer the the question, or doesn’t. It doesn’t meet the requirement. Think it’s just. We need to bring in custom stat like that? I I looked.
24 00:04:41.590 ⇒ 00:04:48.700 Robert Tseng: Where do we find custom? Status? I pointed out like, this is where you would find it. These are some this so he could.
25 00:04:48.870 ⇒ 00:04:59.009 Robert Tseng: so we could bring join it on with the custom status table. And then I wrote a query giving an example of what it was like to get to the number of ado tickets by custom status. So
26 00:04:59.816 ⇒ 00:05:00.749 Robert Tseng: I think.
27 00:05:02.050 ⇒ 00:05:12.009 Robert Tseng: Yeah, I think that that was really the ask. Here it was like, Okay, we have statuses by ticket, but only open pending solved. It doesn’t include the custom
28 00:05:12.050 ⇒ 00:05:16.549 Robert Tseng: statuses, which that’s what my query below is is
29 00:05:17.250 ⇒ 00:05:23.530 Robert Tseng: serve serves to do so. I took a screenshot of the custom status table, the custom field table.
30 00:05:23.915 ⇒ 00:05:28.330 Robert Tseng: And I asked to to bring. Yeah, I asked to bring this like not
31 00:05:28.930 ⇒ 00:05:33.830 Robert Tseng: to bring it into into the enriched data table. So that’s the ask. There.
32 00:05:34.180 ⇒ 00:05:36.359 Nicolas Sucari: Perfect. Yeah, that’s for Zendesk.
33 00:05:36.520 ⇒ 00:05:44.050 Robert Tseng: Yeah, on the Hubspot integration side. I’m struggling to figure out fine, like, where did this come from? Like.
34 00:05:46.540 ⇒ 00:05:56.820 Robert Tseng: yeah, I’m not. I’m just not seeing it in the open issue, so I don’t know if we talked about this or like where we talked about it, but I haven’t been able to find it. So I think there’s like kind of question marks over like.
35 00:05:56.900 ⇒ 00:05:58.860 Robert Tseng: what was this for?
36 00:06:01.070 ⇒ 00:06:01.890 Nicolas Sucari: Okay.
37 00:06:04.532 ⇒ 00:06:06.647 Nicolas Sucari: that one is open, I think.
38 00:06:07.190 ⇒ 00:06:08.769 Robert Tseng: Like. Which issue is this, like
39 00:06:08.790 ⇒ 00:06:10.580 Robert Tseng: I am? I’m not. I’m not sure.
40 00:06:11.640 ⇒ 00:06:17.509 Nicolas Sucari: That issue that says, Rpt. Quota upl reporting on upl usage at the quote level.
41 00:06:17.510 ⇒ 00:06:18.280 Robert Tseng: Okay.
42 00:06:18.640 ⇒ 00:06:20.520 Robert Tseng: yeah, this one, exactly.
43 00:06:29.740 ⇒ 00:06:40.749 Robert Tseng: Yeah, I don’t. I’m not really connecting the dots here. So working on defining, adding metrics for active users. I think this is a separate issue. So probably not what this is talking about.
44 00:06:40.800 ⇒ 00:06:42.160 Robert Tseng: Also.
45 00:06:42.680 ⇒ 00:06:51.795 Robert Tseng: yeah, okay, I mean, I think I’ll just delete these. I don’t think this is really what I’m asking for here. So this is up. If this is upl, then
46 00:06:55.280 ⇒ 00:06:56.160 Robert Tseng: okay.
47 00:07:15.670 ⇒ 00:07:20.839 Robert Tseng: I think, yeah. The ask here is just to have a reporting table that
48 00:07:21.470 ⇒ 00:07:23.110 Robert Tseng: lets me see
49 00:07:23.910 ⇒ 00:07:25.160 Robert Tseng: company.
50 00:07:25.730 ⇒ 00:07:29.150 Robert Tseng: and how many times they use a particular upl.
51 00:07:29.803 ⇒ 00:07:32.920 Robert Tseng: This is a Stella request. So it’s not for S. Fab.
52 00:07:33.500 ⇒ 00:07:34.250 Nicolas Sucari: Okay.
53 00:07:37.960 ⇒ 00:07:41.840 Robert Tseng: So I’m sure this is probably something else. I just I just can’t. I can’t.
54 00:07:41.840 ⇒ 00:07:42.540 Nicolas Sucari: Okay. But.
55 00:07:42.570 ⇒ 00:07:44.110 Robert Tseng: Nick, Nick.
56 00:07:44.110 ⇒ 00:07:47.960 Nicolas Sucari: And it created a new table, I think, on this one, if you scroll down a little bit.
57 00:07:49.930 ⇒ 00:07:53.810 Nicolas Sucari: yeah. He created that rpt real code usage. So.
58 00:07:56.220 ⇒ 00:07:58.600 Nicolas Sucari: But there was an issue with the Id.
59 00:08:05.750 ⇒ 00:08:07.210 Robert Tseng: To apl.
60 00:08:11.146 ⇒ 00:08:15.600 Nicolas Sucari: There are some changes. But yeah, created
61 00:08:16.360 ⇒ 00:08:19.610 Nicolas Sucari: 2 dimensions, I think. And then.
62 00:08:19.610 ⇒ 00:08:23.399 Robert Tseng: Here we’re like, I guess. What I’m understanding is
63 00:08:28.520 ⇒ 00:08:32.889 Robert Tseng: there’s an issue with the upl id that I referenced here
64 00:08:33.840 ⇒ 00:08:36.770 Robert Tseng: in the Stella quote line. So
65 00:08:37.260 ⇒ 00:08:40.099 Robert Tseng: that’s why there are so many nulls. I think.
66 00:08:44.630 ⇒ 00:08:45.460 Nicolas Sucari: Okay.
67 00:08:49.330 ⇒ 00:08:51.640 Robert Tseng: Why is it like this.
68 00:08:54.200 ⇒ 00:08:56.620 Nicolas Sucari: Where? Where he’s joining in.
69 00:08:57.100 ⇒ 00:09:00.570 Nicolas Sucari: What’s what’s the field? It’s joining upid and product, variant id.
70 00:09:01.270 ⇒ 00:09:07.329 Robert Tseng: Yeah, cause not every product variant id is a upl. Id
71 00:09:08.390 ⇒ 00:09:09.570 Robert Tseng: okay. But
72 00:09:09.800 ⇒ 00:09:10.600 Robert Tseng: you
73 00:09:10.930 ⇒ 00:09:16.790 Robert Tseng: yeah, like, the pro, a product variant is like a larger set of ids.
74 00:09:16.830 ⇒ 00:09:22.660 Robert Tseng: Upl is a smaller set of ids within product variant. So it makes sense to me that
75 00:09:23.430 ⇒ 00:09:25.800 Robert Tseng: there are a lot of
76 00:09:26.890 ⇒ 00:09:34.249 Robert Tseng: null fields with. I don’t think this is actually upl description. He probably just labeled it. This, this is probably like product. Variant description
77 00:09:34.580 ⇒ 00:09:35.899 Robert Tseng: makes sense to me.
78 00:09:36.625 ⇒ 00:09:48.015 Robert Tseng: I think this is fine. We just if there’s no uplid, we just leave it null. We can keep the we can just call it the product product, variant description, or whatever. And
79 00:09:49.500 ⇒ 00:09:51.899 Robert Tseng: yeah, for upls.
80 00:09:53.920 ⇒ 00:10:00.600 Robert Tseng: When there’s a valid upl id, then we should have the upl description the number of times it was used.
81 00:10:00.750 ⇒ 00:10:09.749 Robert Tseng: I just feel like this description is is off like I don’t know why a description would be called test or saw test, like I think where there’s more testing that needs to be due done here.
82 00:10:10.226 ⇒ 00:10:15.889 Robert Tseng: So I don’t know. Maybe he’s maybe there’s a bit of confusion there, but I I think this is like, almost there, I just
83 00:10:16.490 ⇒ 00:10:22.899 Robert Tseng: yeah, I think he just has not. Every, not every line is going to have a upl id.
84 00:10:23.990 ⇒ 00:10:28.233 Robert Tseng: And the the descriptions are a bit questionable to me. I I think
85 00:10:29.620 ⇒ 00:10:30.000 Nicolas Sucari: Do you just.
86 00:10:30.000 ⇒ 00:10:30.340 Robert Tseng: Go in.
87 00:10:30.340 ⇒ 00:10:37.419 Nicolas Sucari: The upl description upl description is coming from. It’s telequote line.
88 00:10:39.660 ⇒ 00:10:40.730 Nicolas Sucari: let me see.
89 00:10:42.170 ⇒ 00:10:44.110 Nicolas Sucari: where is that one coming from?
90 00:10:45.200 ⇒ 00:10:46.109 Nicolas Sucari: But yeah.
91 00:10:46.310 ⇒ 00:10:50.170 Nicolas Sucari: it’s staying. It’s coming from the Stellar quote line table, probably.
92 00:10:50.890 ⇒ 00:10:53.739 Nicolas Sucari: Do you have one that says, Int.
93 00:10:59.410 ⇒ 00:11:01.509 Nicolas Sucari: what’s the 4th line? Come with me?
94 00:11:02.900 ⇒ 00:11:03.580 Nicolas Sucari: Oh.
95 00:11:19.990 ⇒ 00:11:22.440 Nicolas Sucari: still a customer activity. Yeah, probably not.
96 00:11:24.120 ⇒ 00:11:25.454 Nicolas Sucari: There should be
97 00:11:32.740 ⇒ 00:11:34.969 Nicolas Sucari: and try and go to Snowflake. That’s it.
98 00:11:36.330 ⇒ 00:11:47.050 Nicolas Sucari: But yeah, okay, don’t worry. I’m gonna try. Get me to change that one and see where we’re coming, that. But if we go the Id as new, that’s okay. Right?
99 00:11:47.980 ⇒ 00:11:51.399 Robert Tseng: Yeah, I mean, I think we just have to rename this
100 00:11:51.860 ⇒ 00:11:53.810 Nicolas Sucari: Description. Yeah, you build description.
101 00:11:57.990 ⇒ 00:11:59.020 Robert Tseng: Yeah, so like.
102 00:11:59.630 ⇒ 00:12:07.560 Robert Tseng: right now, I can see, this is product. Ver, this is really product variant id, this is really product variant description.
103 00:12:11.440 ⇒ 00:12:12.060 Robert Tseng: yeah, I was like.
104 00:12:12.060 ⇒ 00:12:12.390 Nicolas Sucari: Okay.
105 00:12:12.390 ⇒ 00:12:13.350 Robert Tseng: I think
106 00:12:20.870 ⇒ 00:12:30.450 Robert Tseng: I’m okay with keeping it upl id just everything needs to be null. If it doesn’t have uplid. And that way I’ll be able to filter off of this and say, like.
107 00:12:31.220 ⇒ 00:12:59.940 Robert Tseng: Okay, of all the product variants, like, only 10% of them are actually upl. I I upls. And then here are the descriptions number of time they’ve been used per per customer per company like that’s like that. That would be fine to me. I mean, I just want to validate. Is this description actually what it says it is is this actually upl description, because it doesn’t make sense to me that a upl would be called erp, or pieces, or something like it. Some of this just doesn’t seem right to me
108 00:13:00.040 ⇒ 00:13:02.120 Robert Tseng: on the description side, so.
109 00:13:02.120 ⇒ 00:13:02.750 Nicolas Sucari: Okay.
110 00:13:02.750 ⇒ 00:13:11.319 Robert Tseng: Yeah, just I. I miss. I I feel like the right field is product, variant description. Because that’s what the word, that’s what the product variant Id would be associated with
111 00:13:11.972 ⇒ 00:13:23.069 Robert Tseng: and but you know, in the upl tables like, there should be a yeah in the upl. If we look at the what is it? Dim upl product variant.
112 00:13:35.550 ⇒ 00:13:38.039 Robert Tseng: Yeah. So here’s the variant id.
113 00:13:38.780 ⇒ 00:13:44.299 Robert Tseng: Oh, but this is the dimensional table. Okay, maybe it’s because I gave them wrong. Is this even the right table?
114 00:13:46.970 ⇒ 00:13:55.509 Robert Tseng: yeah, okay. So I think I gave him the wrong table to use. It’s not variant dimensions. It should be variant catalog
115 00:13:55.770 ⇒ 00:14:01.050 Robert Tseng: that’ll get you the product variant id. And then this product, id is
116 00:14:01.450 ⇒ 00:14:06.869 Robert Tseng: is the upl id. I believe I could just run a quick test on this.
117 00:14:10.540 ⇒ 00:14:14.380 Nicolas Sucari: Product, id table or id column. There.
118 00:14:15.590 ⇒ 00:14:21.189 Robert Tseng: Yeah. So basically, what I’m gonna do is run a query, Where
119 00:14:22.450 ⇒ 00:14:24.149 Robert Tseng: where’s hangar?
120 00:14:49.350 ⇒ 00:14:50.200 Robert Tseng: Huh?
121 00:14:53.610 ⇒ 00:14:57.119 Nicolas Sucari: There are no equal ids between product ids and.
122 00:14:57.120 ⇒ 00:15:01.400 Robert Tseng: I mean, okay, that makes sense to me. So I.
123 00:15:02.770 ⇒ 00:15:04.570 Nicolas Sucari: You need to join with the other table.
124 00:15:04.570 ⇒ 00:15:08.899 Robert Tseng: Yeah, whatever we’re calling upl, id, it needs. Yeah, it is.
125 00:15:09.050 ⇒ 00:15:10.169 Robert Tseng: Maybe it’s
126 00:15:10.240 ⇒ 00:15:18.320 Robert Tseng: okay. Well, I mean, we’re going back to the Ros here. But yeah, I I think maybe I just gave him the wrong join here.
127 00:15:18.540 ⇒ 00:15:19.550 Robert Tseng: But that’s
128 00:15:19.870 ⇒ 00:15:29.250 Robert Tseng: upl product, variant catalog. To me there is a clear mapping between product, variant, id and product. Id, which this is. This should be the upl id.
129 00:15:30.490 ⇒ 00:15:31.120 Nicolas Sucari: Okay.
130 00:15:33.230 ⇒ 00:15:35.170 Robert Tseng: Yeah, I’m
131 00:15:35.230 ⇒ 00:15:46.260 Robert Tseng: I don’t know if this is what got joined onto the quote line cable. I was expecting an install quote line uplid like that. Maybe like, that’s that’s the right way to join it. I I guess I could.
132 00:15:46.750 ⇒ 00:15:48.290 Robert Tseng: This is such a mess.
133 00:15:54.000 ⇒ 00:15:57.593 Robert Tseng: okay, I I think it’s important to just get this distinction, I think.
134 00:15:59.440 ⇒ 00:16:02.380 Robert Tseng: and Stella
135 00:16:02.460 ⇒ 00:16:04.280 Robert Tseng: vertical line. Okay.
136 00:16:05.460 ⇒ 00:16:07.120 Nicolas Sucari: Yeah, that one start line.
137 00:16:08.720 ⇒ 00:16:10.070 Robert Tseng: Yeah.
138 00:16:12.140 ⇒ 00:16:14.130 Nicolas Sucari: Uplid area.
139 00:16:47.680 ⇒ 00:16:50.980 Robert Tseng: Yeah, I don’t know what the Zpl id is then, and I don’t know if it’s not coming.
140 00:16:50.980 ⇒ 00:16:52.040 Nicolas Sucari: I mean I.
141 00:16:52.060 ⇒ 00:16:55.850 Nicolas Sucari: And if you try with product variant id, not with the
142 00:16:57.780 ⇒ 00:16:59.260 Nicolas Sucari: for an Iv.
143 00:16:59.260 ⇒ 00:17:00.089 Robert Tseng: Id here.
144 00:17:00.680 ⇒ 00:17:02.890 Nicolas Sucari: No, no, not on this one or from the other one.
145 00:17:05.530 ⇒ 00:17:06.760 Robert Tseng: Oh, I see!
146 00:17:10.490 ⇒ 00:17:12.060 Nicolas Sucari: Just dry. I don’t know.
147 00:17:12.960 ⇒ 00:17:13.900 Nicolas Sucari: That’s it.
148 00:17:13.900 ⇒ 00:17:14.650 Robert Tseng: Okay.
149 00:17:15.470 ⇒ 00:17:16.520 Robert Tseng: Yeah.
150 00:17:19.530 ⇒ 00:17:23.039 Nicolas Sucari: So what is the product? Id that we have in the 1st table.
151 00:17:25.040 ⇒ 00:17:28.059 Robert Tseng: So the first.st This is the uplid, so I think we.
152 00:17:28.060 ⇒ 00:17:28.500 Nicolas Sucari: I know. Yeah.
153 00:17:29.930 ⇒ 00:17:34.719 Robert Tseng: we basically called the product variant id the upl id, which is not true.
154 00:17:35.340 ⇒ 00:17:39.419 Robert Tseng: I think what we misunderstood also was that
155 00:17:40.520 ⇒ 00:17:48.440 Robert Tseng: upl id is never going to be part of product variant id, it’s actually there. But there, yeah, it’s in this
156 00:17:48.760 ⇒ 00:17:55.480 Robert Tseng: product, variant catalog. There’s a list of product variants that get associated with upl ids.
157 00:17:55.690 ⇒ 00:17:59.610 Robert Tseng: And like, that’s what we’re missing. So I think this is why it doesn’t work.
158 00:18:00.620 ⇒ 00:18:01.525 Robert Tseng: So
159 00:18:04.530 ⇒ 00:18:07.830 Robert Tseng: so yeah, I think what we need to do. Yeah, from like
160 00:18:11.060 ⇒ 00:18:20.940 Robert Tseng: from Intel, a quote line, the upl id itself is already in the product variant id, we’re joining that with, this is the wrong table product, variant cataloged.
161 00:18:20.960 ⇒ 00:18:25.679 Robert Tseng: So I think the logic here was right, actually. But it just didn’t give us the actual uplid.
162 00:18:26.200 ⇒ 00:18:27.330 Robert Tseng: And then
163 00:18:27.440 ⇒ 00:18:38.829 Robert Tseng: from there, like, we were supposed to be able to get the product name from this upl product variant catalog table. That would be the upl product name.
164 00:18:46.210 ⇒ 00:18:47.000 Robert Tseng: yeah.
165 00:18:48.450 ⇒ 00:18:55.070 Robert Tseng: And while we’re at it we should just we should just pull on everything that’s from this table, like shape, name, material, name, all that. We should just pull it in.
166 00:18:55.670 ⇒ 00:18:56.670 Robert Tseng: So.
167 00:18:57.825 ⇒ 00:19:03.014 Robert Tseng: okay, yeah, I think that’s that’s that’s the change to the requirements we need to make here.
168 00:19:03.550 ⇒ 00:19:06.039 Robert Tseng: do you got it, or do you want me to to do it?
169 00:19:06.690 ⇒ 00:19:12.219 Nicolas Sucari: If you wanna leave a comment there, now, that will be perfect, so that we just have it there.
170 00:19:12.270 ⇒ 00:19:13.900 Nicolas Sucari: I already have the
171 00:19:14.150 ⇒ 00:19:16.320 Nicolas Sucari: screenshot of that query below.
172 00:19:16.600 ⇒ 00:19:17.510 Nicolas Sucari: but.
173 00:19:20.950 ⇒ 00:19:28.009 Robert Tseng: Okay, yeah, I’ll I’ll write a comment later. I want to. I want to touch on the other things. I before I would have a hard. I have a hard stop. So
174 00:19:31.840 ⇒ 00:19:32.430 Nicolas Sucari: May.
175 00:19:33.790 ⇒ 00:19:38.320 Nicolas Sucari: Okay. So that was from swab Stella for the upr reporting labels. Okay
176 00:19:38.800 ⇒ 00:19:44.200 Nicolas Sucari: for sendes. We already talked about the we need to the custom statuses in
177 00:19:44.460 ⇒ 00:19:47.000 Nicolas Sucari: and not just the raw data. Right?
178 00:19:49.147 ⇒ 00:19:55.610 Robert Tseng: Yeah, there’s the custom status custom field join, plus like adding a couple of those fields that I I it’s like.
179 00:19:56.230 ⇒ 00:19:57.170 Nicolas Sucari: Yeah.
180 00:19:59.600 ⇒ 00:20:04.666 Robert Tseng: Yeah, if you just like run this query like, I think it gives me what I want, like, I just
181 00:20:17.620 ⇒ 00:20:18.220 Nicolas Sucari: Okay.
182 00:20:18.670 ⇒ 00:20:19.380 Robert Tseng: So.
183 00:20:23.260 ⇒ 00:20:26.779 Robert Tseng: Well, I guess this is the actor. It’s not just inactive. Oh.
184 00:20:51.730 ⇒ 00:20:54.990 Robert Tseng: yeah, this was my original request 2 weeks ago. Yeah.
185 00:20:55.340 ⇒ 00:20:56.140 Robert Tseng: like, I just want.
186 00:20:56.140 ⇒ 00:20:56.840 Nicolas Sucari: Yeah, I mean.
187 00:20:56.840 ⇒ 00:20:57.640 Robert Tseng: That.
188 00:20:57.950 ⇒ 00:21:10.100 Nicolas Sucari: What we need is a a column with that statuses, but we were not bringing in the the custom ones that says escalated right. The other ones. We already have them. We just need to figure out how to Ca, to bring those statuses.
189 00:21:10.430 ⇒ 00:21:15.470 Robert Tseng: Yeah, so these are the custom statuses. These are the custom fields.
190 00:21:15.580 ⇒ 00:21:25.239 Robert Tseng: Yeah, I wanted those to be like options in the enriched table that we had. I think that was what I was trying to do. And then.
191 00:21:26.320 ⇒ 00:21:33.540 Robert Tseng: yeah, I I created a query to demonstrate what that would look like for one example. But this isn’t the only one like
192 00:21:33.700 ⇒ 00:21:39.962 Robert Tseng: this is just specifically, custom status equals escalated in ado. And when it’s active, so
193 00:21:40.380 ⇒ 00:21:41.010 Nicolas Sucari: Right.
194 00:21:41.340 ⇒ 00:21:44.010 Robert Tseng: But I, what I actually want is like
195 00:21:44.020 ⇒ 00:21:48.109 Robert Tseng: the ability to look at all the different options.
196 00:21:49.070 ⇒ 00:21:49.730 Nicolas Sucari: Okay.
197 00:21:50.660 ⇒ 00:21:53.810 Robert Tseng: That include both custom and non custom.
198 00:21:54.460 ⇒ 00:22:02.650 Nicolas Sucari: Yeah, yeah, okay, yeah. We need in in one table the statuses, like in some home, to have everything and to reference to each quote, right?
199 00:22:03.350 ⇒ 00:22:04.160 Robert Tseng: Yeah.
200 00:22:05.820 ⇒ 00:22:06.640 Nicolas Sucari: Okay, perfect.
201 00:22:07.050 ⇒ 00:22:07.430 Robert Tseng: Okay.
202 00:22:07.430 ⇒ 00:22:11.579 Nicolas Sucari: So that was, send this. We already took the upl. What else do we have.
203 00:22:11.600 ⇒ 00:22:17.729 Robert Tseng: Reporting the active reporting table. So what I here have here is a query that I wrote
204 00:22:18.751 ⇒ 00:22:22.760 Robert Tseng: I’ve written out description of what this is.
205 00:22:23.270 ⇒ 00:22:24.880 Robert Tseng: And
206 00:22:25.040 ⇒ 00:22:29.930 Robert Tseng: I attached a Csv of like what the output should look like.
207 00:22:30.709 ⇒ 00:22:34.750 Robert Tseng: which is basically like what this query is. So
208 00:22:37.210 ⇒ 00:22:40.309 Robert Tseng: I think that’s all we need like.
209 00:22:45.060 ⇒ 00:22:46.670 Nicolas Sucari: Okay. Okay.
210 00:22:55.230 ⇒ 00:22:58.799 Nicolas Sucari: Perfect. What else do we have apart from this ticket?
211 00:22:59.331 ⇒ 00:23:01.940 Nicolas Sucari: Okay, that one is in
212 00:23:02.360 ⇒ 00:23:07.969 Nicolas Sucari: triage. Is it okay to move to backlog now or to this week. Yes.
213 00:23:09.110 ⇒ 00:23:12.319 Nicolas Sucari: Oh, you’re not seeing those. Don’t worry. Yeah, I have that ticket.
214 00:23:14.020 ⇒ 00:23:15.960 Robert Tseng: Yeah, I’m not seeing what you’re talking about.
215 00:23:15.960 ⇒ 00:23:22.470 Nicolas Sucari: Yeah, yeah, don’t worry. I can I? But it. It is ready to start work. Right? We can start working on that query.
216 00:23:22.470 ⇒ 00:23:27.959 Robert Tseng: Yeah, yeah. I mean, I just wanna make sure I have the most recent version
217 00:23:28.550 ⇒ 00:23:30.740 Robert Tseng: that’s like pasted in there.
218 00:23:32.900 ⇒ 00:23:34.670 Robert Tseng: Believe that this is it.
219 00:23:53.160 ⇒ 00:23:53.890 Nicolas Sucari: Okay.
220 00:24:00.240 ⇒ 00:24:01.060 Robert Tseng: Yeah.
221 00:24:02.290 ⇒ 00:24:11.499 Robert Tseng: so, yeah, this is, these are all the fields in the, in, the, in the, in the table that I’m asking for. If you open the Csv. It’ll include everything that’s here. So.
222 00:24:12.180 ⇒ 00:24:15.010 Nicolas Sucari: Okay, perfect. Okay.
223 00:24:15.300 ⇒ 00:24:17.690 Nicolas Sucari: I’ll I’ll ask Nick to take a look to this one.
224 00:24:17.900 ⇒ 00:24:18.420 Robert Tseng: Yeah.
225 00:24:18.420 ⇒ 00:24:18.850 Nicolas Sucari: Great.
226 00:24:19.090 ⇒ 00:24:26.770 Robert Tseng: Yeah, I mean, I think those are. Those are the things that I feel like. That’s that’s a lot already. So those are the things we need to get done this week.
227 00:24:28.150 ⇒ 00:24:31.469 Robert Tseng: yeah. The other questions were more like process questions like.
228 00:24:31.470 ⇒ 00:24:32.340 Nicolas Sucari: Yeah.
229 00:24:32.340 ⇒ 00:24:51.789 Robert Tseng: I don’t know how often our tables are being refreshed. I know we have a column on the reporting tables, but like when I go in, and I run queries like, when I was building this out and I was pulling from int and raw tables. I was just like, Why is this data only from like June or July. And it’s just yeah, I don’t. I don’t feel like, I understand, like.
230 00:24:52.140 ⇒ 00:24:57.179 Robert Tseng: how often yeah, I don’t. I don’t think I understand how often we we refresh tables and then
231 00:24:57.587 ⇒ 00:25:02.580 Robert Tseng: the off issues like, it’s fine. I think it’s not really our problem. So I’m gonna just keep.
232 00:25:02.800 ⇒ 00:25:12.230 Robert Tseng: I don’t. Yeah, I think I know. I think U, Tom and Pat tried to tried to help there, and I was gonna ask some questions live. But if not, it’s not urgent.
233 00:25:13.125 ⇒ 00:25:13.660 Robert Tseng: Okay?
234 00:25:14.020 ⇒ 00:25:23.910 Robert Tseng: And then just from an organization perspective. Yeah, I mean, I feel like this, snowflake environment is hard for me to understand and like
235 00:25:24.500 ⇒ 00:25:28.660 Robert Tseng: I mean, let alone anybody else. In the company like there’s just so much
236 00:25:29.510 ⇒ 00:25:42.299 Robert Tseng: there’s just so much stuff. That like I feel like it’s unused, like duplicate, dev staging dev prod like I I just think that it’s getting very bloated and complex. And I I just I don’t really know.
237 00:25:42.430 ⇒ 00:25:47.000 Robert Tseng: like, what? Like, what our process like, how we’re like, yeah.
238 00:25:47.000 ⇒ 00:25:47.400 Nicolas Sucari: Yeah.
239 00:25:47.400 ⇒ 00:25:50.999 Robert Tseng: Would we even have a like a vision for how this should be modeled?
240 00:25:51.493 ⇒ 00:25:57.840 Robert Tseng: And like, with Nick pulling in like a couple Zendesk tables from raw straight to Mart, like
241 00:25:58.780 ⇒ 00:26:00.609 Robert Tseng: I don’t know like this is just
242 00:26:00.750 ⇒ 00:26:04.099 Robert Tseng: like I don’t even I don’t even. I don’t use most of these, and like nobody.
243 00:26:04.100 ⇒ 00:26:10.859 Nicolas Sucari: Yeah, I I get it. Yeah, it’s becoming to be to be like, really big. And we need to clean this up so that we can.
244 00:26:11.607 ⇒ 00:26:13.219 Nicolas Sucari: Use it more.
245 00:26:13.580 ⇒ 00:26:21.890 Nicolas Sucari: Yeah. So that needs to be, it becomes simpler to use. That’s okay. I can have a discussion with you, Tom and Patrick there and see how we can.
246 00:26:23.630 ⇒ 00:26:29.889 Nicolas Sucari: yeah, get. Get exactly what we need here and what we don’t need. Just remove it, so they don’t mess up with the other stuff.
247 00:26:30.320 ⇒ 00:26:39.019 Robert Tseng: Yeah. And I get like, Pat’s telling me, oh, yeah, there’s a particular order to how these tables should. But it’s like he’s speaking in ideals like when I.
248 00:26:39.020 ⇒ 00:26:39.980 Nicolas Sucari: Yeah, yeah, I know.
249 00:26:39.980 ⇒ 00:26:45.650 Robert Tseng: Built this out like I was pulling from raw, from ends, from pro like I was pulling everywhere because I didn’t have a.
250 00:26:45.650 ⇒ 00:26:46.740 Nicolas Sucari: Yeah, what?
251 00:26:46.740 ⇒ 00:26:47.430 Robert Tseng: In the march.
252 00:26:47.430 ⇒ 00:27:08.519 Nicolas Sucari: Yeah, exactly what we were doing. For our client is like, we have everything that under analytics. And if you need to model something. Yeah, we you model some anything. And then you get anything for reporting from an analytics folder where you have like all the tables. So probably we should do something like that. I’m gonna ask them to try it. And
253 00:27:08.530 ⇒ 00:27:12.760 Nicolas Sucari: yeah, figure out how we can work on everything here, too.
254 00:27:13.130 ⇒ 00:27:15.570 Robert Tseng: Yeah, I think that makes more sense to me.
255 00:27:16.230 ⇒ 00:27:17.750 Robert Tseng: Okay, yeah.
256 00:27:17.880 ⇒ 00:27:34.499 Nicolas Sucari: Yeah, yeah. So that obviously, if we like, raw should be only raw data, and we don’t change anything, then we should have like a place where we are doing some modeling, and then, when that modeling is final, we should have another place where we are getting everything for our reports right.
257 00:27:35.250 ⇒ 00:27:40.209 Robert Tseng: Yeah. Well, I I just feel like we’re not. We’re not actually doing that. But that’s that’s what.
258 00:27:40.690 ⇒ 00:27:44.850 Robert Tseng: Yeah, that’s what Pat and Utahm said that we were trying to do, but I don’t see.
259 00:27:44.850 ⇒ 00:27:45.510 Nicolas Sucari: Yes.
260 00:27:46.340 ⇒ 00:27:50.649 Nicolas Sucari: okay, yeah, yeah. I’m gonna try. Ask them and see how we can actually
261 00:27:51.127 ⇒ 00:27:56.209 Nicolas Sucari: have that working so that we do that process, and we don’t mess it up. Okay.
262 00:27:56.990 ⇒ 00:27:57.620 Robert Tseng: Yeah.
263 00:27:58.990 ⇒ 00:28:00.480 Nicolas Sucari: Perfect. Okay.
264 00:28:00.730 ⇒ 00:28:11.469 Nicolas Sucari: great I’ll I’ll send Nick all of these tasks and detail a little bit to him. But if you wanna leave any comment on the tickets. That’s helpful for us.
265 00:28:11.871 ⇒ 00:28:17.180 Nicolas Sucari: And I will try to catch up with him later, and we can talk more end of the week if you want.
266 00:28:17.530 ⇒ 00:28:22.699 Robert Tseng: Okay, yeah, I’ll leave a comment for this. And then, yeah, I gotta move on. So.
267 00:28:22.910 ⇒ 00:28:26.020 Nicolas Sucari: Excellent, perfect, cool. Thank you, Robert.
268 00:28:26.020 ⇒ 00:28:27.419 Robert Tseng: Yup talk to you later.
269 00:28:27.890 ⇒ 00:28:28.470 Nicolas Sucari: Bye, bye.
270 00:28:28.470 ⇒ 00:28:29.090 Robert Tseng: Right.