Meeting Title: Uttam <> Nico Date: 2024-06-05 Meeting participants: Nicolas Sucari, Uttam Kumaran
WEBVTT
1 00:11:49.000 ⇒ 00:11:49.900 Uttam Kumaran: Nico.
2 00:11:53.260 ⇒ 00:11:55.289 Nicolas Sucari: Hi, Tom, how are you?
3 00:11:55.590 ⇒ 00:11:56.220 Uttam Kumaran: That?
4 00:11:59.300 ⇒ 00:12:00.120 Uttam Kumaran: How’s the day going.
5 00:12:00.120 ⇒ 00:12:01.040 Nicolas Sucari: That’s not.
6 00:12:01.660 ⇒ 00:12:04.130 Nicolas Sucari: It’s going fine. I’ve met with Argos before.
7 00:12:04.400 ⇒ 00:12:05.720 Uttam Kumaran: Oh, nice on! How is it?
8 00:12:05.720 ⇒ 00:12:06.400 Nicolas Sucari: Yeah.
9 00:12:06.730 ⇒ 00:12:08.560 Nicolas Sucari: yeah, it was really nice.
10 00:12:09.250 ⇒ 00:12:10.959 Nicolas Sucari: Got to meet him. Yeah.
11 00:12:12.840 ⇒ 00:12:14.620 Uttam Kumaran: Look really good. I’m jealous.
12 00:12:15.300 ⇒ 00:12:17.340 Nicolas Sucari: Yeah, it was really tasty.
13 00:12:17.940 ⇒ 00:12:23.769 Nicolas Sucari: Like, kind of like, yeah, national Argentineas food. It was really nice.
14 00:12:23.930 ⇒ 00:12:25.050 Uttam Kumaran: Yeah, perfect.
15 00:12:28.128 ⇒ 00:12:31.859 Uttam Kumaran: Yeah. Like, did you guys have flown for dessert? Is that what that is?
16 00:12:31.860 ⇒ 00:12:33.619 Nicolas Sucari: Yeah, it’s a plan. Yeah.
17 00:12:33.740 ⇒ 00:12:35.150 Uttam Kumaran: It’s my favorite.
18 00:12:35.960 ⇒ 00:12:37.429 Nicolas Sucari: It’s amazing.
19 00:12:37.430 ⇒ 00:12:38.160 Uttam Kumaran: It’s about.
20 00:12:38.160 ⇒ 00:12:42.380 Nicolas Sucari: The most. Yeah, it’s 1 of the most traditional desserts here. And it’s like, so
21 00:12:42.470 ⇒ 00:12:43.600 Nicolas Sucari: so good.
22 00:12:43.930 ⇒ 00:12:44.430 Nicolas Sucari: It’s.
23 00:12:44.430 ⇒ 00:12:45.230 Uttam Kumaran: So, yeah.
24 00:12:47.620 ⇒ 00:12:47.890 Uttam Kumaran: yeah.
25 00:12:50.560 ⇒ 00:12:53.349 Uttam Kumaran: It looks like 3 o’clock should work for everybody.
26 00:12:53.830 ⇒ 00:12:55.800 Nicolas Sucari: Yeah. So I’m gonna push the meeting now.
27 00:12:55.800 ⇒ 00:12:56.629 Uttam Kumaran: Okay, cool.
28 00:12:57.396 ⇒ 00:13:00.789 Uttam Kumaran: That would be a proper meeting, and then maybe
29 00:13:01.400 ⇒ 00:13:02.465 Uttam Kumaran: to go through
30 00:13:02.830 ⇒ 00:13:04.990 Uttam Kumaran: couple of things now and then.
31 00:13:05.910 ⇒ 00:13:08.976 Uttam Kumaran: hop back on. And you know keep talking
32 00:13:09.360 ⇒ 00:13:09.960 Nicolas Sucari: Yeah.
33 00:13:10.270 ⇒ 00:13:12.910 Uttam Kumaran: I think maybe we talk about.
34 00:13:14.280 ⇒ 00:13:17.250 Uttam Kumaran: Let’s talk about Stella. May we spend an hour
35 00:13:17.490 ⇒ 00:13:19.399 Uttam Kumaran: just talking about Stella stuff.
36 00:13:20.130 ⇒ 00:13:20.720 Nicolas Sucari: Yeah.
37 00:13:21.340 ⇒ 00:13:22.833 Uttam Kumaran: So overall.
38 00:13:24.580 ⇒ 00:13:32.681 Uttam Kumaran: I guess I could give you a little bit of background. On how we got Stella and my relationship with
39 00:13:33.200 ⇒ 00:13:34.590 Uttam Kumaran: Robert.
40 00:13:35.128 ⇒ 00:13:43.099 Uttam Kumaran: So Robert was introduced to me. So Robert was introduced to me by Clint. Clint runs wild.
41 00:13:43.120 ⇒ 00:13:50.425 Uttam Kumaran: Me and Quinn are like friends, for like 2 years I met him when I was starting at the company I was at before
42 00:13:51.097 ⇒ 00:13:54.980 Uttam Kumaran: and we just became friends. And then he was thinking about starting his product.
43 00:13:55.020 ⇒ 00:14:05.542 Uttam Kumaran: And then, as we kind of like blobber last 2 years, just stayed friends and kind of now it’s nice to kind of do some business together. But he introduced me to
44 00:14:06.290 ⇒ 00:14:10.469 Uttam Kumaran: to Robert. Robert runs. This company called Pungo Insights.
45 00:14:10.870 ⇒ 00:14:15.649 Uttam Kumaran: honestly kind of similar to us, but in terms of
46 00:14:15.730 ⇒ 00:14:21.859 Uttam Kumaran: the stack. They’re above us. So, as you know, like, we’re going from
47 00:14:22.050 ⇒ 00:14:28.829 Uttam Kumaran: data warehouse data engineering to modeling to then dashboards. He’s sitting at the dashboards and analysis later.
48 00:14:28.830 ⇒ 00:14:29.550 Nicolas Sucari: Yeah.
49 00:14:29.650 ⇒ 00:14:32.629 Nicolas Sucari: he’s like the last mile to present to the clients right?
50 00:14:32.630 ⇒ 00:14:39.928 Uttam Kumaran: Totally last mile. And so we’ve we started working. We were always thinking about like, Hey, we do a lot of
51 00:14:40.600 ⇒ 00:15:04.587 Uttam Kumaran: We do a lot of data modeling. And his his expertise is in that analysis piece, you know, I’ve actually tried to leverage him on some pool parts analysis stuff before. It just didn’t like work out and but Robert’s really great in that area. And he brought us into Stella to help them. Do the back end pieces of a couple of developments for dashboards.
52 00:15:05.010 ⇒ 00:15:09.309 Uttam Kumaran: So initially, what we set up was this document,
53 00:15:10.040 ⇒ 00:15:21.740 Uttam Kumaran: this document is just like the overview of the Stella project. It’s kind of changed a little bit. But basically they had 3 dashboards that they wanted. They wanted to build
54 00:15:22.472 ⇒ 00:15:31.290 Uttam Kumaran: an executive dashboard, a full story, dashboard in a Zendesk dashboard. And then they wanted to do a last dashboard here. Which is this one?
55 00:15:32.143 ⇒ 00:15:48.989 Uttam Kumaran: So basically, what we put together was like, hey, we have to win Snowflake 5 trin Dbt. For the models. I, you know, was able to get Nick, and Nick is kind of working as a sole engineer there. Patrick was helping a little bit on like the.
56 00:15:48.990 ⇒ 00:16:00.240 Uttam Kumaran: you know, like setting up Snowflake and setting up 5 tran but really, it’s now mainly just Nick. And so we’re basically walking through this process. So the thing we provided to him was a little bit about.
57 00:16:00.240 ⇒ 00:16:20.632 Uttam Kumaran: You know, what are the key problems? So like, there’s some. There’s some issues where they can’t combine some of their data together. They can’t identify issues and data. There’s some. There’s some issues with change management. There, they can’t. They can’t do a reporting. They can’t understand how their business pro progressing.
58 00:16:21.450 ⇒ 00:16:27.409 Uttam Kumaran: So this is a great document like that kind of highlights that. And this is what we put together for them to
59 00:16:27.780 ⇒ 00:16:33.229 Uttam Kumaran: to kind of present. And so Robert took this and presented to them, and then was able to bring us on the initial.
60 00:16:33.230 ⇒ 00:16:33.820 Nicolas Sucari: Okay. Scope.
61 00:16:33.820 ⇒ 00:16:44.939 Uttam Kumaran: Is is what what you see here, which we’re actually, of course, a month after which is mainly to kind of set up segment, set up some segment and amplitude requirements.
62 00:16:45.502 ⇒ 00:16:49.450 Uttam Kumaran: And bring some dates to Snowflake. So actually, a lot has changed in terms of the scope
63 00:16:49.500 ⇒ 00:16:51.250 Uttam Kumaran: which is really
64 00:16:51.706 ⇒ 00:17:02.003 Uttam Kumaran: what led to some miscommunication and like some delays. But also there’s there’s some stuff that I think we could take responsibility for as well. Basically
65 00:17:03.300 ⇒ 00:17:13.160 Uttam Kumaran: There are some. There are several pretty high lift data security requirements that Stella has that I wasn’t aware of when we initially put together the scope
66 00:17:13.680 ⇒ 00:17:17.490 Uttam Kumaran: kind of the reason why we’re talking to 5 trend. We had some issues with Snowflake.
67 00:17:17.609 ⇒ 00:17:22.550 Uttam Kumaran: basically 2 or 3 weeks of just like being blocked by that for some of for some data.
68 00:17:22.750 ⇒ 00:17:24.399 Uttam Kumaran: Second thing is
69 00:17:24.914 ⇒ 00:17:27.400 Uttam Kumaran: the Zendesk stuff has actually been.
70 00:17:27.460 ⇒ 00:17:39.049 Uttam Kumaran: I would say, going pretty well. But of course I think we have a little bit of like communication gaps between like Nick getting something done it getting delivered.
71 00:17:39.160 ⇒ 00:17:44.900 Uttam Kumaran: And like, I actually don’t think it’s any. I think it’s probably like a fault on Brainforges. It’s just like
72 00:17:45.532 ⇒ 00:17:51.590 Uttam Kumaran: nick actually had this stuff done, and they just like it was just got lost somewhere in slack because we’re talking about too many things.
73 00:17:51.620 ⇒ 00:17:55.480 Uttam Kumaran: And then Rob, within a week went by. We didn’t follow, so
74 00:17:55.650 ⇒ 00:18:02.259 Uttam Kumaran: there’s a little bit of things there. Ha! The overall status of the project is that Robert’s actually getting us an extension
75 00:18:03.290 ⇒ 00:18:15.830 Uttam Kumaran: and so we should hopefully have a 3 month extension with this project and Nick is gonna continue to be the primary developer on the project. But really the scope now is this Zendesk
76 00:18:16.280 ⇒ 00:18:17.910 Uttam Kumaran: and this
77 00:18:18.270 ⇒ 00:18:19.780 Uttam Kumaran: quote activity
78 00:18:19.970 ⇒ 00:18:21.070 Uttam Kumaran: dashboard.
79 00:18:21.969 ⇒ 00:18:29.380 Uttam Kumaran: The rest here are either delayed or basically being reassessed for priority by Robert.
80 00:18:29.750 ⇒ 00:18:30.790 Uttam Kumaran: Okay.
81 00:18:31.470 ⇒ 00:18:37.000 Uttam Kumaran: so that’s the kind of like overall architecture of the project.
82 00:18:39.290 ⇒ 00:18:43.260 Uttam Kumaran: and so otherwise, it’s fairly standard, like we use the same tools.
83 00:18:45.470 ⇒ 00:18:52.430 Uttam Kumaran: you know, I’ve I’ve asked them if they want to implement real. And so, like again. Robert is kind of our go to here. The thing we’ll have to.
84 00:18:52.786 ⇒ 00:18:53.499 Nicolas Sucari: Yeah. Stephanie.
85 00:18:53.500 ⇒ 00:18:55.170 Uttam Kumaran: Is like
86 00:18:55.680 ⇒ 00:19:07.589 Uttam Kumaran: is for one like. Are are we meeting with him on a good enough cadence, ready to get everything he needs? We definitely need to be closer with Nick, and understand from Nick what he’s being assigned and due dates. But otherwise
87 00:19:07.620 ⇒ 00:19:14.040 Uttam Kumaran: I would say, like, this is a nice project, because we’re not doing analysis. And so actually.
88 00:19:14.522 ⇒ 00:19:18.650 Uttam Kumaran: it should be fewer tickets and like longer lead times.
89 00:19:19.400 ⇒ 00:19:20.100 Nicolas Sucari: But which is.
90 00:19:21.009 ⇒ 00:19:26.320 Uttam Kumaran: With analysis. Of course, you know, there’s like a lot of communicating a lot of meetings back and forth.
91 00:19:27.332 ⇒ 00:19:33.228 Uttam Kumaran: It’s should be pretty straightforward. However, there’s only one person working on this
92 00:19:33.760 ⇒ 00:19:37.621 Uttam Kumaran: and that’s the way it’s most likely gonna continue
93 00:19:38.270 ⇒ 00:19:40.990 Uttam Kumaran: So it’ll so so correct. Yeah.
94 00:19:41.580 ⇒ 00:19:48.370 Nicolas Sucari: So what what do you think if we like try to like check if we have like that?
95 00:19:49.110 ⇒ 00:19:50.969 Nicolas Sucari: Tickets created in
96 00:19:51.020 ⇒ 00:19:58.379 Nicolas Sucari: Github, so that we know like, what is status right now, and like we know what is left to do for Nick. And
97 00:19:58.830 ⇒ 00:20:10.010 Nicolas Sucari: yeah, I think I think I get it like he’s working on all of these data models and getting like the correct data ready so that then can. So that then Robert can like? Do the analysis and create the dashboards right.
98 00:20:10.280 ⇒ 00:20:11.080 Uttam Kumaran: That’s correct.
99 00:20:11.510 ⇒ 00:20:18.139 Nicolas Sucari: Like our delivery to Robert should be like creating the correct data models. Right?
100 00:20:18.190 ⇒ 00:20:19.450 Nicolas Sucari: You had to be, what do we shit and.
101 00:20:19.815 ⇒ 00:20:26.020 Uttam Kumaran: Yeah, deliveries the data models created in Dbt, and then, it being available for him in Snowflake.
102 00:20:26.670 ⇒ 00:20:32.809 Nicolas Sucari: Okay. And we are using like an a different workspace of snowflake, or how we.
103 00:20:32.810 ⇒ 00:20:35.618 Uttam Kumaran: Yes, there is another snowflake.
104 00:20:36.270 ⇒ 00:20:41.059 Uttam Kumaran: let me make sure that the service account has access to this.
105 00:20:48.960 ⇒ 00:20:53.215 Uttam Kumaran: okay, looks like I’m just in here, but I’m going to add.
106 00:21:10.970 ⇒ 00:21:13.500 Nicolas Sucari: I don’t know if you can add, if you’re not the.
107 00:21:14.490 ⇒ 00:21:18.230 Uttam Kumaran: Well, I am account, I am account admin, but
108 00:21:19.080 ⇒ 00:21:23.440 Uttam Kumaran: looks like I think they. I think they change some settings, so we’ll have to.
109 00:21:23.440 ⇒ 00:21:24.320 Nicolas Sucari: Yeah. Don’t worry.
110 00:21:24.620 ⇒ 00:21:25.330 Uttam Kumaran: But
111 00:21:30.520 ⇒ 00:21:32.559 Uttam Kumaran: I’m just gonna put this in.
112 00:21:35.000 ⇒ 00:21:39.349 Uttam Kumaran: I’m just gonna put this in the other group. So you have it.
113 00:21:40.310 ⇒ 00:21:41.200 Nicolas Sucari: Yeah, okay.
114 00:21:43.650 ⇒ 00:21:47.649 Nicolas Sucari: But yeah, like, the way we need to deliver this to
115 00:21:47.680 ⇒ 00:21:55.310 Nicolas Sucari: Robert is like, we need to say, Hey, we need, we have this task ready. Go to Snowflake and check it out like, is that the way.
116 00:21:55.890 ⇒ 00:21:56.470 Uttam Kumaran: Yeah.
117 00:21:58.260 ⇒ 00:21:59.179 Nicolas Sucari: Okay, that’s it.
118 00:22:00.720 ⇒ 00:22:01.490 Nicolas Sucari: perfect.
119 00:22:03.780 ⇒ 00:22:05.975 Uttam Kumaran: So I guess let’s take a look at
120 00:22:06.600 ⇒ 00:22:08.790 Uttam Kumaran: the current project.
121 00:22:14.200 ⇒ 00:22:15.490 Uttam Kumaran: So
122 00:22:15.820 ⇒ 00:22:19.582 Uttam Kumaran: a couple of things that’s still on our plate.
123 00:22:21.270 ⇒ 00:22:25.420 Uttam Kumaran: one is adding github workflows for the Stella project.
124 00:22:26.440 ⇒ 00:22:28.240 Uttam Kumaran: So this is actually
125 00:22:28.430 ⇒ 00:22:30.490 Uttam Kumaran: somewhat blocked by
126 00:22:31.110 ⇒ 00:22:36.040 Uttam Kumaran: by Patrick’s ticket in pool parts. Mainly we’re using the new process
127 00:22:36.080 ⇒ 00:22:46.070 Uttam Kumaran: for like importing, and I just want to confirm that this is the right way of of doing it. I have a Pr, so I guess I’ll move it to review, but I need to have him kind of review it.
128 00:22:46.741 ⇒ 00:22:49.559 Uttam Kumaran: But there’s a p. There’s a p already for this.
129 00:22:50.260 ⇒ 00:22:52.379 Uttam Kumaran: The other thing is.
130 00:22:52.500 ⇒ 00:22:55.530 Uttam Kumaran: there’s this data etl ticket. So
131 00:22:56.360 ⇒ 00:22:58.579 Uttam Kumaran: I honestly don’t think that
132 00:23:00.700 ⇒ 00:23:02.380 Uttam Kumaran: I think this is done
133 00:23:03.310 ⇒ 00:23:07.670 Uttam Kumaran: cause we’re not doing any. We’re not doing nets. We are full story. So I’m gonna marry. This is done.
134 00:23:11.110 ⇒ 00:23:16.401 Uttam Kumaran: setup snow pipes, snowflake tasks from S. 3. This one is a won’t do.
135 00:23:18.481 ⇒ 00:23:23.629 Uttam Kumaran: Create s 3 bucket for Netsuite. This is a won’t do because we’re not doing the Netsuite right now.
136 00:23:24.946 ⇒ 00:23:27.857 Uttam Kumaran: Need a credit card for 5 tran
137 00:23:28.690 ⇒ 00:23:29.530 Nicolas Sucari: Schedules, the meeting.
138 00:23:29.530 ⇒ 00:23:30.770 Uttam Kumaran: And yeah.
139 00:23:31.870 ⇒ 00:23:36.800 Uttam Kumaran: so let’s just talk about the Zendesk updates. And where this is at, so looks like.
140 00:23:37.660 ⇒ 00:23:40.300 Uttam Kumaran: looks like, this is from
141 00:23:41.710 ⇒ 00:23:44.238 Uttam Kumaran: this is from Robert. So
142 00:23:44.690 ⇒ 00:23:48.310 Uttam Kumaran: can we add a ticket status to the Rpt user?
143 00:23:48.870 ⇒ 00:23:51.720 Uttam Kumaran: Seems like we can add this using the same join.
144 00:23:52.590 ⇒ 00:23:54.979 Uttam Kumaran: So let’s see.
145 00:23:55.360 ⇒ 00:23:57.629 Uttam Kumaran: like where this is in here.
146 00:24:03.840 ⇒ 00:24:05.830 Uttam Kumaran: Ticket status.
147 00:24:27.650 ⇒ 00:24:29.480 Uttam Kumaran: Okay? I mean, it looks like.
148 00:24:38.950 ⇒ 00:24:41.360 Uttam Kumaran: so what was requested
149 00:24:41.790 ⇒ 00:24:43.000 Uttam Kumaran: was
150 00:24:43.110 ⇒ 00:24:46.129 Uttam Kumaran: tenant id ticket status number of tickets.
151 00:24:47.320 ⇒ 00:24:49.950 Uttam Kumaran: Request your email ticket tag, number of tickets.
152 00:24:50.300 ⇒ 00:24:52.840 Uttam Kumaran: We’re missing the custom field
153 00:24:53.160 ⇒ 00:24:54.899 Uttam Kumaran: to tenant Id
154 00:24:58.560 ⇒ 00:24:59.700 Uttam Kumaran: and
155 00:25:04.450 ⇒ 00:25:05.490 Uttam Kumaran: okay.
156 00:25:29.870 ⇒ 00:25:36.440 Uttam Kumaran: or other fields. Okay, so this is where we kind of need to get organized on what’s basically remaining here.
157 00:25:37.090 ⇒ 00:25:37.950 Nicolas Sucari: Yeah, me.
158 00:25:37.950 ⇒ 00:25:40.519 Uttam Kumaran: Continue that. Let me just try to edit this
159 00:25:41.361 ⇒ 00:25:44.020 Uttam Kumaran: Stella ticket. So for Zendesk.
160 00:25:45.970 ⇒ 00:25:48.346 Uttam Kumaran: let’s just do, Zendesk.
161 00:26:20.680 ⇒ 00:26:22.350 Uttam Kumaran: So that’s 1.
162 00:26:37.540 ⇒ 00:26:39.980 Uttam Kumaran: There’s a second one. That’s like.
163 00:26:43.140 ⇒ 00:26:48.620 Uttam Kumaran: we’re missing custom. Field tenant id. Okay, so add tenant id.
164 00:27:59.380 ⇒ 00:28:02.839 Uttam Kumaran: And then it looks like we need to bring in this tenant id field.
165 00:28:03.220 ⇒ 00:28:04.260 Uttam Kumaran: Yeah.
166 00:28:07.220 ⇒ 00:28:11.210 Uttam Kumaran: this priority and requested Field.
167 00:28:23.450 ⇒ 00:28:25.860 Nicolas Sucari: Of the tenant. Id Nick.
168 00:28:26.444 ⇒ 00:28:32.239 Nicolas Sucari: Robert said that we need both tenant tenant id and the organization id together.
169 00:28:33.210 ⇒ 00:28:34.449 Nicolas Sucari: That thread.
170 00:28:42.860 ⇒ 00:28:45.300 Uttam Kumaran: I’m just gonna put in these
171 00:28:45.500 ⇒ 00:28:46.480 Uttam Kumaran: 2.
172 00:29:07.120 ⇒ 00:29:09.889 Nicolas Sucari: Priority, and requested from secular bank
173 00:29:10.140 ⇒ 00:29:11.779 Nicolas Sucari: stick to the Fab.
174 00:29:11.780 ⇒ 00:29:12.900 Uttam Kumaran: The date. Okay.
175 00:29:24.660 ⇒ 00:29:28.220 Uttam Kumaran: okay, so let’s just keep following this thread. So
176 00:29:28.870 ⇒ 00:29:30.659 Uttam Kumaran: looks like he has
177 00:29:30.960 ⇒ 00:29:33.790 Uttam Kumaran: this tenant and organization mapping.
178 00:29:53.660 ⇒ 00:29:56.550 Uttam Kumaran: Okay, looks like you found the custom field here.
179 00:29:58.050 ⇒ 00:30:00.359 Uttam Kumaran: So this is where tenant Id is.
180 00:30:05.960 ⇒ 00:30:07.999 Uttam Kumaran: Tenant Id is found there.
181 00:30:12.920 ⇒ 00:30:14.859 Uttam Kumaran: So looks like that’s a
182 00:30:15.850 ⇒ 00:30:17.130 Uttam Kumaran: this one.
183 00:30:30.260 ⇒ 00:30:32.069 Uttam Kumaran: Can we add to
184 00:30:33.690 ⇒ 00:30:36.730 Uttam Kumaran: debort. Zendesk. Okay.
185 00:30:37.280 ⇒ 00:30:39.869 Uttam Kumaran: so let’s even get more specific here.
186 00:30:42.560 ⇒ 00:30:47.150 Uttam Kumaran: Bring in organization. Id, 10. And id. Okay, so actually, let’s do this.
187 00:30:49.200 ⇒ 00:30:52.300 Uttam Kumaran: This is for this devmart. Zendesk.
188 00:30:52.300 ⇒ 00:30:53.760 Nicolas Sucari: Zendesk, yeah.
189 00:30:55.560 ⇒ 00:30:57.349 Uttam Kumaran: And let’s do
190 00:30:58.960 ⇒ 00:31:00.150 Uttam Kumaran: this one.
191 00:31:03.470 ⇒ 00:31:05.070 Uttam Kumaran: Let’s do.
192 00:31:05.810 ⇒ 00:31:07.830 Uttam Kumaran: Actually, it should be
193 00:31:16.450 ⇒ 00:31:18.520 Uttam Kumaran: organization, Id
194 00:31:20.730 ⇒ 00:31:22.009 Uttam Kumaran: and id
195 00:31:23.870 ⇒ 00:31:25.360 Uttam Kumaran: priority
196 00:31:26.680 ⇒ 00:31:28.290 Uttam Kumaran: state dates.
197 00:32:14.830 ⇒ 00:32:16.082 Uttam Kumaran: Okay, let me
198 00:32:21.690 ⇒ 00:32:23.929 Nicolas Sucari: And then there is something about ticket tags.
199 00:32:25.950 ⇒ 00:32:30.370 Nicolas Sucari: number of tickets by ticket tag that Robert was requesting
200 00:32:30.520 ⇒ 00:32:32.239 Nicolas Sucari: a flattened table.
201 00:32:34.690 ⇒ 00:32:35.259 Uttam Kumaran: Can we get that.
202 00:32:35.260 ⇒ 00:32:37.590 Nicolas Sucari: Network. Yeah, that one. That’s right.
203 00:32:38.450 ⇒ 00:32:40.749 Nicolas Sucari: I don’t know if. And then.
204 00:32:41.620 ⇒ 00:32:43.409 Nicolas Sucari: yeah, probably we can
205 00:32:43.930 ⇒ 00:32:47.249 Nicolas Sucari: have this there so that we check if Nick already
206 00:32:47.390 ⇒ 00:32:48.609 Nicolas Sucari: worked on this.
207 00:32:51.610 ⇒ 00:32:55.970 Nicolas Sucari: This is what it was. Today’s ever, but I don’t know if it was finally
208 00:32:56.410 ⇒ 00:32:57.599 Nicolas Sucari: down or not.
209 00:33:20.590 ⇒ 00:33:25.389 Uttam Kumaran: Okay, then this one we need to figure out. So I wanna add one ticket about
210 00:33:25.510 ⇒ 00:33:29.520 Uttam Kumaran: the overall like schema structure in Snowflake.
211 00:33:29.520 ⇒ 00:33:30.160 Nicolas Sucari: Okay.
212 00:33:31.000 ⇒ 00:33:32.775 Uttam Kumaran: So let’s just let’s
213 00:33:37.130 ⇒ 00:33:38.667 Uttam Kumaran: let’s do that.
214 00:34:11.139 ⇒ 00:34:11.850 Uttam Kumaran: thank you.
215 00:35:14.830 ⇒ 00:35:16.900 Uttam Kumaran: Okay, this one
216 00:35:17.370 ⇒ 00:35:20.030 Uttam Kumaran: I’m just gonna take for now.
217 00:35:25.330 ⇒ 00:35:29.779 Uttam Kumaran: Okay, so that that’s probably. So let’s just confirm there’s anything else on Zendesk.
218 00:35:30.520 ⇒ 00:35:34.449 Uttam Kumaran: So the custom priority fields. I’m having a lot more trouble finding.
219 00:35:35.932 ⇒ 00:35:41.189 Uttam Kumaran: So he got that he got the he got the tenant id, but he can’t find the customer.
220 00:35:41.190 ⇒ 00:35:42.559 Nicolas Sucari: Priority. And yeah.
221 00:35:42.890 ⇒ 00:35:44.059 Nicolas Sucari: the other ones.
222 00:35:49.880 ⇒ 00:35:50.740 Uttam Kumaran: Okay.
223 00:35:51.340 ⇒ 00:35:56.190 Nicolas Sucari: And and we don’t. Yeah, we do. Robert hasn’t, responded that one
224 00:35:57.450 ⇒ 00:35:59.309 Nicolas Sucari: who react to it only.
225 00:36:01.980 ⇒ 00:36:05.060 Uttam Kumaran: Okay, okay, great. So, okay, so this is still remaining.
226 00:36:05.670 ⇒ 00:36:06.250 Nicolas Sucari: Yeah.
227 00:37:04.100 ⇒ 00:37:05.110 Uttam Kumaran: Not doable.
228 00:37:09.810 ⇒ 00:37:12.160 Uttam Kumaran: Okay? So then, this is in progress.
229 00:37:14.600 ⇒ 00:37:15.300 Nicolas Sucari: Right.
230 00:37:17.710 ⇒ 00:37:22.180 Uttam Kumaran: Or should we split this up? I guess we could. Just let’s have it all here.
231 00:37:50.890 ⇒ 00:37:51.680 Uttam Kumaran: Okay.
232 00:37:51.680 ⇒ 00:37:54.889 Nicolas Sucari: So that is everything that we’ve got to do about
233 00:37:55.040 ⇒ 00:37:56.470 Nicolas Sucari: send disk.
234 00:37:56.720 ⇒ 00:37:57.490 Uttam Kumaran: Yes.
235 00:37:58.510 ⇒ 00:38:00.720 Nicolas Sucari: Because it said in the
236 00:38:02.362 ⇒ 00:38:10.400 Nicolas Sucari: in the doc, it says like we need something regarding request or email get tags. You know.
237 00:38:10.650 ⇒ 00:38:12.500 Nicolas Sucari: we need to do something else.
238 00:38:13.280 ⇒ 00:38:16.816 Uttam Kumaran: So let’s see, I think that all may be done.
239 00:38:26.170 ⇒ 00:38:26.700 Nicolas Sucari: Touch one.
240 00:38:33.680 ⇒ 00:38:37.149 Nicolas Sucari: Okay, anything else regarding like this new
241 00:38:37.900 ⇒ 00:38:45.489 Nicolas Sucari: data that we are like introducing to Snowflake like, we need to create some tests or anything like that, so that we need to create a ticket.
242 00:38:45.890 ⇒ 00:38:48.890 Uttam Kumaran: I don’t think so. I think ideally
243 00:38:51.940 ⇒ 00:38:54.870 Uttam Kumaran: I mean, ideally. We have elementary setup again here
244 00:38:56.280 ⇒ 00:38:57.450 Uttam Kumaran: for alerting.
245 00:39:00.420 ⇒ 00:39:01.220 Nicolas Sucari: May.
246 00:39:06.180 ⇒ 00:39:08.859 Nicolas Sucari: who, who is setting up an elementary.
247 00:39:08.860 ⇒ 00:39:13.940 Uttam Kumaran: I think also, maybe if Ryan wants to set up a documentation and then Nick can handle it.
248 00:39:15.870 ⇒ 00:39:16.980 Nicolas Sucari: Yeah, sure.
249 00:39:17.320 ⇒ 00:39:19.369 Nicolas Sucari: Probably we can add a ticket there
250 00:39:20.636 ⇒ 00:39:22.540 Nicolas Sucari: for the documentation, right?
251 00:39:22.740 ⇒ 00:39:23.420 Uttam Kumaran: Yeah.
252 00:39:25.380 ⇒ 00:39:26.659 Uttam Kumaran: how to set up.
253 00:39:27.860 ⇒ 00:39:28.520 Nicolas Sucari: Yeah.
254 00:39:58.840 ⇒ 00:40:01.250 Nicolas Sucari: Do you want me to create a ticket? I have it here.
255 00:40:01.631 ⇒ 00:40:06.129 Nicolas Sucari: Create a document on how to set up elementary for a new project. Yeah.
256 00:40:06.130 ⇒ 00:40:06.700 Uttam Kumaran: Yeah.
257 00:40:12.076 ⇒ 00:40:14.130 Nicolas Sucari: Right easy.
258 00:40:53.110 ⇒ 00:40:55.240 Nicolas Sucari: You want me to assign Ryan.
259 00:40:55.680 ⇒ 00:40:56.440 Uttam Kumaran: Yes.
260 00:41:31.980 ⇒ 00:41:35.740 Nicolas Sucari: One is to create the document. And then we need like, yeah.
261 00:41:52.600 ⇒ 00:41:55.590 Uttam Kumaran: Yeah, one is, create a document. Second is
262 00:41:55.650 ⇒ 00:41:57.379 Uttam Kumaran: follow document and implement.
263 00:41:58.040 ⇒ 00:41:58.719 Nicolas Sucari: Yeah, you can.
264 00:41:58.720 ⇒ 00:41:59.799 Uttam Kumaran: You can hand to Nick.
265 00:42:00.390 ⇒ 00:42:01.170 Uttam Kumaran: Yeah.
266 00:42:45.280 ⇒ 00:42:47.589 Nicolas Sucari: How can I link 2 tasks together?
267 00:42:48.410 ⇒ 00:42:49.380 Nicolas Sucari: He knows.
268 00:42:49.530 ⇒ 00:42:52.730 Uttam Kumaran: Comment them in 1 1 or the other. It’ll it’ll link
269 00:42:53.290 ⇒ 00:42:53.970 Uttam Kumaran: fake.
270 00:44:12.890 ⇒ 00:44:13.710 Nicolas Sucari: Grave
271 00:44:17.390 ⇒ 00:44:18.110 Nicolas Sucari: popped.
272 00:44:52.450 ⇒ 00:44:53.580 Uttam Kumaran: So
273 00:44:54.657 ⇒ 00:45:02.772 Uttam Kumaran: if you look into this ticket, there’s this link called dB diagram. Typically, this is used for creating
274 00:45:04.340 ⇒ 00:45:07.490 Uttam Kumaran: creating these sorts of Erds, basically just like
275 00:45:07.520 ⇒ 00:45:12.259 Uttam Kumaran: how these tables are related to one another, to see that these all have, like.
276 00:45:12.260 ⇒ 00:45:12.690 Nicolas Sucari: Okay.
277 00:45:12.690 ⇒ 00:45:14.123 Uttam Kumaran: The columns.
278 00:45:15.090 ⇒ 00:45:20.620 Uttam Kumaran: so basically, it looks like Nick will just need to create these 5 tables.
279 00:45:20.800 ⇒ 00:45:22.080 Uttam Kumaran: which is
280 00:45:22.480 ⇒ 00:45:23.700 Uttam Kumaran: tenants
281 00:45:24.030 ⇒ 00:45:25.240 Uttam Kumaran: org.
282 00:45:25.970 ⇒ 00:45:28.889 Uttam Kumaran: And let me try to just rearrange these.
283 00:45:31.100 ⇒ 00:45:31.960 Uttam Kumaran: Yeah.
284 00:45:44.420 ⇒ 00:45:51.729 Nicolas Sucari: So those are like all 5 different tables, and how they are like joined together like with which which key right.
285 00:45:51.980 ⇒ 00:45:52.810 Uttam Kumaran: Correct.
286 00:45:53.670 ⇒ 00:45:54.640 Nicolas Sucari: Excellent.
287 00:45:54.640 ⇒ 00:45:56.970 Uttam Kumaran: So like quotes tenants
288 00:45:59.560 ⇒ 00:46:01.080 Uttam Kumaran: quote items.
289 00:46:01.190 ⇒ 00:46:03.120 Uttam Kumaran: Okay, yeah, it’s this one.
290 00:46:15.990 ⇒ 00:46:18.970 Nicolas Sucari: And there is one more of our organization, right? Something like that.
291 00:46:23.790 ⇒ 00:46:25.380 Uttam Kumaran: Yeah, organizations.
292 00:47:09.010 ⇒ 00:47:10.780 Uttam Kumaran: Okay, this seems good.
293 00:47:11.990 ⇒ 00:47:13.609 Nicolas Sucari: Yeah, that that
294 00:47:14.290 ⇒ 00:47:19.870 Nicolas Sucari: relationship diagram. It’s just like a picture that. And who who made that.
295 00:47:20.290 ⇒ 00:47:21.399 Uttam Kumaran: Robert made it.
296 00:47:22.020 ⇒ 00:47:23.660 Nicolas Sucari: Okay, excellent.
297 00:47:24.390 ⇒ 00:47:24.960 Nicolas Sucari: perfect.
298 00:47:28.790 ⇒ 00:47:33.153 Nicolas Sucari: Sorry. Just trying to understand. If I ask like dumb questions.
299 00:47:33.550 ⇒ 00:47:40.559 Uttam Kumaran: Dumb, I mean. Look, if if you saw us for the 1st time, it’s like what the what the hell is going on. So no, this is perfect. So this is something that like
300 00:47:40.730 ⇒ 00:47:45.880 Uttam Kumaran: I’ve used in the past. It’s like a pretty common tool called dB diagram, just to like set up the.
301 00:47:45.880 ⇒ 00:47:46.520 Nicolas Sucari: Yeah.
302 00:47:47.090 ⇒ 00:47:51.620 Uttam Kumaran: It’s really nice, like we didn’t get any of this sort of thing from any of our other clients.
303 00:47:51.830 ⇒ 00:47:54.620 Uttam Kumaran: So in a sense, this is like perfect.
304 00:47:54.640 ⇒ 00:47:58.299 Uttam Kumaran: What I’ll be expecting Nick to say is that like
305 00:47:59.247 ⇒ 00:48:02.190 Uttam Kumaran: obviously like Nick, you have everything like this.
306 00:48:02.280 ⇒ 00:48:03.860 Uttam Kumaran: This should take like a day.
307 00:48:04.530 ⇒ 00:48:06.769 Uttam Kumaran: Right? So.
308 00:48:06.770 ⇒ 00:48:07.090 Nicolas Sucari: Late.
309 00:48:07.090 ⇒ 00:48:07.710 Uttam Kumaran: These.
310 00:48:07.710 ⇒ 00:48:08.129 Nicolas Sucari: I mean, yeah.
311 00:48:08.130 ⇒ 00:48:11.450 Uttam Kumaran: Like if the keys don’t join, or if some of these columns are.
312 00:48:11.450 ⇒ 00:48:12.220 Nicolas Sucari: Yeah. Ching.
313 00:48:12.410 ⇒ 00:48:16.020 Uttam Kumaran: Then there’ll be an issue. But apart from that, he honestly is like almost has, like
314 00:48:16.340 ⇒ 00:48:18.219 Uttam Kumaran: the blueprint here. So.
315 00:48:18.620 ⇒ 00:48:23.869 Nicolas Sucari: So he needs to go and search for each of these columns in all of the data as we are.
316 00:48:23.950 ⇒ 00:48:28.359 Nicolas Sucari: Yeah, getting from from the client, and like, join
317 00:48:28.400 ⇒ 00:48:30.469 Nicolas Sucari: those columns into the sales.
318 00:48:31.090 ⇒ 00:48:31.869 Uttam Kumaran: So that we can.
319 00:48:31.870 ⇒ 00:48:33.290 Nicolas Sucari: And create these tables.
320 00:48:33.920 ⇒ 00:48:40.200 Uttam Kumaran: Yeah, it looks like this table, which is Sf, prod legacy. dB, snowflake.
321 00:48:40.930 ⇒ 00:48:41.670 Nicolas Sucari: Banning.
322 00:48:42.820 ⇒ 00:48:44.989 Uttam Kumaran: If I even go there.
323 00:48:52.850 ⇒ 00:48:55.739 Nicolas Sucari: Oh, yeah, I can’t. I need to log into Snowflake.
324 00:49:03.930 ⇒ 00:49:05.880 Uttam Kumaran: Yeah. See, look, there’s all these tables.
325 00:49:07.620 ⇒ 00:49:12.950 Uttam Kumaran: Let’s see, there is an orders there is like a there’ll be an organization somewhere
326 00:49:19.740 ⇒ 00:49:22.309 Uttam Kumaran: for this one. There’ll have to probably be some back and forth.
327 00:49:24.340 ⇒ 00:49:25.140 Uttam Kumaran: Ray.
328 00:49:42.350 ⇒ 00:49:46.379 Uttam Kumaran: Okay, let me just even message Nick, to see if he’s free today.