Meeting Title: Stella-Weekly-Regroup Date: 2024-05-14 Meeting participants: Nick Baker, Robert Tseng, Patrick Trainer, Uttam Kumaran
WEBVTT
1 00:01:57.440 ⇒ 00:01:58.120 Uttam Kumaran: Hey, guys.
2 00:01:58.800 ⇒ 00:01:59.480 Nick Baker: Nope.
3 00:02:04.660 ⇒ 00:02:05.620 Nick Baker: oops.
4 00:02:05.980 ⇒ 00:02:06.380 Uttam Kumaran: Yo.
5 00:02:06.865 ⇒ 00:02:07.350 Robert Tseng: Hello!
6 00:02:07.880 ⇒ 00:02:08.870 Uttam Kumaran: Hey! Good morning!
7 00:02:09.770 ⇒ 00:02:11.060 Uttam Kumaran: Good afternoon!
8 00:02:11.060 ⇒ 00:02:12.560 Robert Tseng: Good afternoon. Yeah.
9 00:02:12.710 ⇒ 00:02:13.820 Uttam Kumaran: Starting there.
10 00:02:14.170 ⇒ 00:02:14.605 Robert Tseng: Yeah.
11 00:02:15.240 ⇒ 00:02:16.330 Uttam Kumaran: Yeah, it’s crazy.
12 00:02:17.340 ⇒ 00:02:19.130 Robert Tseng: You’re in a different room, Utah.
13 00:02:19.520 ⇒ 00:02:21.429 Uttam Kumaran: I am in a, we work today.
14 00:02:21.630 ⇒ 00:02:22.560 Robert Tseng: I’ve got it!
15 00:02:24.460 ⇒ 00:02:25.999 Uttam Kumaran: Back to the old digs.
16 00:02:27.540 ⇒ 00:02:33.109 Uttam Kumaran: Just try to get out of the just try to get out of the house I was in. I was inside all day yesterday.
17 00:02:33.460 ⇒ 00:02:34.660 Uttam Kumaran: Wow! That’s
18 00:02:34.870 ⇒ 00:02:36.219 Uttam Kumaran: I guess. Ceiling.
19 00:02:36.520 ⇒ 00:02:39.479 Robert Tseng: Yeah, they. They give you lifetime membership or something.
20 00:02:40.010 ⇒ 00:02:41.649 Uttam Kumaran: No, you’d be surprised.
21 00:02:42.837 ⇒ 00:02:47.980 Uttam Kumaran: I’m just happy that that. People still hired me after that company, so
22 00:02:50.050 ⇒ 00:02:50.570 Uttam Kumaran: not.
23 00:02:50.570 ⇒ 00:02:51.680 Robert Tseng: Wasn’t your fault.
24 00:02:51.990 ⇒ 00:02:53.289 Uttam Kumaran: It was not my fault.
25 00:02:53.290 ⇒ 00:02:53.880 Robert Tseng: Yeah.
26 00:02:53.880 ⇒ 00:02:56.940 Uttam Kumaran: People did try to blame me. You’d be surprised, though.
27 00:02:56.940 ⇒ 00:02:58.120 Robert Tseng: Oh, really! Oh.
28 00:02:58.250 ⇒ 00:02:59.819 Robert Tseng: sorry for another time.
29 00:03:00.020 ⇒ 00:03:02.651 Uttam Kumaran: A lot of drama at the end. There.
30 00:03:03.180 ⇒ 00:03:09.360 Uttam Kumaran: cool I guess. Let’s just run through kind of like high level things.
31 00:03:10.710 ⇒ 00:03:15.530 Uttam Kumaran: first being. Let’s just talk briefly about the
32 00:03:17.180 ⇒ 00:03:21.150 Uttam Kumaran: azure blog stuff. So I know we worked yesterday, I guess.
33 00:03:21.210 ⇒ 00:03:23.302 Uttam Kumaran: between Robert and
34 00:03:24.810 ⇒ 00:03:29.749 Uttam Kumaran: pat but also we need to close that out. I think we probably just need like one more
35 00:03:29.900 ⇒ 00:03:33.301 Uttam Kumaran: similar like role grant accessing to the blob. But
36 00:03:34.440 ⇒ 00:03:35.430 Uttam Kumaran: let me know.
37 00:03:35.640 ⇒ 00:03:36.440 Uttam Kumaran: Stop.
38 00:03:36.870 ⇒ 00:03:42.739 Patrick Trainer: Well, so if we’re if we’re adding like a a new blob. But if the blobs in a different tenant
39 00:03:43.160 ⇒ 00:03:47.939 Patrick Trainer: WA storage integration can only belong to one tenant at a time
40 00:03:48.570 ⇒ 00:03:53.969 Patrick Trainer: but can have like multiple accounts and blobs within that same tenant.
41 00:03:54.130 ⇒ 00:03:56.099 Patrick Trainer: So if we have another tenant
42 00:03:56.691 ⇒ 00:04:01.810 Patrick Trainer: then we’re gonna have to create a whole new storage integration like, separate from that
43 00:04:02.274 ⇒ 00:04:07.949 Patrick Trainer: and then create the stage and all all of that for that. But that’s really
44 00:04:09.010 ⇒ 00:04:16.630 Patrick Trainer: all. It is otherwise, if it’s in the same tenant and in a different account in the different blob, but the same tenant.
45 00:04:16.850 ⇒ 00:04:22.360 Patrick Trainer: Then it’s just a quick like we put in the the azure, URL, and and it just like
46 00:04:22.380 ⇒ 00:04:23.284 Patrick Trainer: works.
47 00:04:24.460 ⇒ 00:04:29.129 Patrick Trainer: But if it’s a like, I said, if it’s a different tenant. We need to set up a new integration.
48 00:04:29.330 ⇒ 00:04:34.390 Robert Tseng: Yeah. So I guess that’s why bad for not knowing it until I
49 00:04:34.470 ⇒ 00:04:37.909 Robert Tseng: figured out yesterday that it’s on a different tenant. Yeah.
50 00:04:37.910 ⇒ 00:04:38.760 Uttam Kumaran: What’s up?
51 00:04:38.760 ⇒ 00:04:39.280 Patrick Trainer: No worries.
52 00:04:39.280 ⇒ 00:04:40.069 Uttam Kumaran: All good.
53 00:04:40.430 ⇒ 00:04:41.080 Robert Tseng: Yeah.
54 00:04:41.230 ⇒ 00:04:41.970 Robert Tseng: South.
55 00:04:41.970 ⇒ 00:04:43.665 Uttam Kumaran: Hi guys, yeah.
56 00:04:44.530 ⇒ 00:04:46.200 Patrick Trainer: That’s why they pay us the big bucks.
57 00:04:47.120 ⇒ 00:04:50.692 Robert Tseng: Yeah, I mean, well, we’re definitely gonna be charging.
58 00:04:54.140 ⇒ 00:04:58.939 Uttam Kumaran: So I guess like, should we just hop on another call with I forgot
59 00:04:59.310 ⇒ 00:05:00.999 Uttam Kumaran: his name again. But what or.
60 00:05:01.000 ⇒ 00:05:01.350 Robert Tseng: Yeah.
61 00:05:01.350 ⇒ 00:05:02.100 Uttam Kumaran: We should do.
62 00:05:03.870 ⇒ 00:05:15.673 Robert Tseng: So I mean, I guess you. We just need to get the same creds, and I can send it to him, and then we’ll hop on another call. I think. He was. He was my point of contact assigned by the head of engineering, but I guess
63 00:05:15.920 ⇒ 00:05:21.200 Robert Tseng: he he didn’t really know where things were, so I think that’s why he hook. He hooked us up to an empty block.
64 00:05:22.490 ⇒ 00:05:31.980 Uttam Kumaran: Cool. Okay. So whenever we wanna get that all done, let’s just do that again. I think it’ll take like 10 min on the call with him. He seemed pretty fine to just press whatever buttons we need to press, so.
65 00:05:31.980 ⇒ 00:05:32.640 Robert Tseng: Yeah.
66 00:05:32.640 ⇒ 00:05:33.560 Uttam Kumaran: Let’s make that happen.
67 00:05:35.460 ⇒ 00:05:39.897 Robert Tseng: Yeah. So whatever works for you guys? I have access to his calendar. So I can just throw a time on whenever.
68 00:05:40.720 ⇒ 00:05:42.289 Patrick Trainer: Okay, cool. Yeah. The only thing.
69 00:05:42.290 ⇒ 00:05:42.980 Robert Tseng: So I mean, I’m.
70 00:05:42.980 ⇒ 00:05:47.019 Patrick Trainer: We’ll need to do from my side, like I can create the
71 00:05:47.180 ⇒ 00:05:52.080 Patrick Trainer: initial organization. I can pass you the those keys that come back from it
72 00:05:52.549 ⇒ 00:05:58.939 Patrick Trainer: and then they’ll need to create that like service principle and the IM roles on their side, and then
73 00:05:59.850 ⇒ 00:06:03.400 Patrick Trainer: and then it should work like what we did yesterday.
74 00:06:03.570 ⇒ 00:06:05.139 Robert Tseng: Okay, that sounds good.
75 00:06:06.620 ⇒ 00:06:07.450 Robert Tseng: Okay.
76 00:06:08.100 ⇒ 00:06:11.530 Uttam Kumaran: I mean, honestly, if he’s down to just do all that on a call.
77 00:06:12.510 ⇒ 00:06:14.319 Uttam Kumaran: we should just we could just do that.
78 00:06:14.960 ⇒ 00:06:17.030 Robert Tseng: Okay, yeah, I’ll I’ll I can get him on.
79 00:06:17.030 ⇒ 00:06:21.879 Uttam Kumaran: Cause. I don’t think any of those are any of those. Take more than 30 min. So you can do all that. Basically.
80 00:06:22.090 ⇒ 00:06:22.510 Robert Tseng: Okay.
81 00:06:25.500 ⇒ 00:06:31.470 Robert Tseng: And do you guys want to do it today? I can just his calendar looks empty to me so I can just throw a time whenever.
82 00:06:31.980 ⇒ 00:06:35.162 Patrick Trainer: I can’t. Today I got something this afternoon, but
83 00:06:35.990 ⇒ 00:06:36.870 Patrick Trainer: later on.
84 00:06:37.150 ⇒ 00:06:41.269 Robert Tseng: Yeah, you you let me know that that, and I’ll I’ll I’ll put. I’ll put time on his calendar.
85 00:06:41.766 ⇒ 00:06:45.740 Patrick Trainer: We could probably do tomorrow tomorrow.
86 00:06:46.690 ⇒ 00:06:49.120 Patrick Trainer: Not at what is.
87 00:06:51.600 ⇒ 00:06:54.120 Patrick Trainer: I’ve got a thing tomorrow
88 00:06:54.270 ⇒ 00:06:54.930 Patrick Trainer: clock.
89 00:06:58.620 ⇒ 00:06:59.350 Uttam Kumaran: And all.
90 00:07:01.540 ⇒ 00:07:02.730 Patrick Trainer: Tomorrow from
91 00:07:03.650 ⇒ 00:07:08.050 Patrick Trainer: everything. It’s tomorrow’s good except for one to 3, central for me.
92 00:07:08.050 ⇒ 00:07:08.680 Robert Tseng: Okay.
93 00:07:08.850 ⇒ 00:07:09.800 Robert Tseng: sounds good.
94 00:07:10.320 ⇒ 00:07:11.919 Robert Tseng: I’ll follow up on that. Then.
95 00:07:15.020 ⇒ 00:07:15.760 Uttam Kumaran: Cool
96 00:07:17.490 ⇒ 00:07:23.674 Uttam Kumaran: on the snowflake side. So I’m going to reach out to them.
97 00:07:25.010 ⇒ 00:07:30.640 Uttam Kumaran: I I like I. The the spend on snowflakes should be very, very low. Frankly.
98 00:07:30.974 ⇒ 00:07:46.010 Uttam Kumaran: The 5 transpend is going to be the main driver. If we’re even if like, I guess I was gonna ask. I guess we could tie in the 5 trade conversation to. I’m I’m actually like about to send email to Lucas, who’s our like am for 5 trans stuff
99 00:07:46.110 ⇒ 00:07:50.299 Uttam Kumaran: he’ll, I’m sure he’ll just make the trial. He’ll just extend the trial, basically, if we need to.
100 00:07:50.927 ⇒ 00:08:05.449 Uttam Kumaran: But also we’ll kick off kind of conversations, for, like what long term pricing is and see like how much we can move on discounts, I guess. Like, how do you want to handle conversation, for both of those are those separate and like, what do you think we should do?
101 00:08:06.511 ⇒ 00:08:23.099 Robert Tseng: Yeah, I mean, if we can get an extension like that’d be that’d be that’d be the best. But I’ve already. Before this call. I was talking to my my main sponsor at the at the client on the phone client. And so she’s aware of, like the cost the cost of our projected cost. Currently.
102 00:08:23.911 ⇒ 00:08:29.439 Robert Tseng: Yeah, I mean, we we actually talked through like eliminating full story as a source moving forward. So.
103 00:08:29.869 ⇒ 00:08:38.540 Robert Tseng: yeah, I mean, I’ve already looked at the data in there as well. So it just seems like, Yeah, let’s not. Let’s not spend much time there. I think
104 00:08:38.770 ⇒ 00:08:48.279 Robert Tseng: I won’t say that we’re ready to pull the trigger on that yet, but I think that’s where she she wants to head towards yeah, it just it’s really just a qualitative like
105 00:08:48.610 ⇒ 00:08:53.839 Robert Tseng: the mapping and like session recording tool that does like basic pay views and clicks.
106 00:08:54.161 ⇒ 00:09:12.740 Robert Tseng: But we don’t really need to be bringing that data into the warehouse. Like that. It’s, you know, 1,000 bucks a month is more than what they’re paying for that tool so I don’t think they would want to keep it so and keep it in the in the warehouse. So I think it was good for us. Just be able to help help them see that. But yeah.
107 00:09:13.450 ⇒ 00:09:15.739 Uttam Kumaran: Okay, cool. So you think Long term will probably
108 00:09:15.760 ⇒ 00:09:19.629 Uttam Kumaran: just use the full story direct. Connect to Snowflake.
109 00:09:20.357 ⇒ 00:09:22.579 Robert Tseng: Well, actually, I I I set up.
110 00:09:22.580 ⇒ 00:09:23.050 Uttam Kumaran: Or.
111 00:09:23.050 ⇒ 00:09:24.729 Robert Tseng: For them. So that’s what that’s.
112 00:09:24.730 ⇒ 00:09:27.649 Uttam Kumaran: That’s what I was thinking, cause I didn’t even have amplitude set up at all.
113 00:09:27.830 ⇒ 00:09:36.289 Robert Tseng: Yeah. And since it was on this for scope, but I mean, I I want amplitude to replace full story for them. And I think they they will eventually. Yeah.
114 00:09:36.290 ⇒ 00:09:38.220 Uttam Kumaran: Okay. Okay, okay.
115 00:09:39.250 ⇒ 00:09:50.419 Uttam Kumaran: okay, so let me let me just tease up with 5 train on that. And then we can move on those. And then I’ll also tell snow like that, like, Hey, we’re planning on. They just want to complete this initial proof of concept. We just need some more time.
116 00:09:50.710 ⇒ 00:09:52.159 Robert Tseng: Yeah. Thanks.
117 00:09:52.410 ⇒ 00:09:53.660 Robert Tseng: Okay. Great.
118 00:09:54.061 ⇒ 00:10:00.568 Uttam Kumaran: And then let’s talk about modeling. I guess, Nick, if you wanna talk a little bit about the pro current biggest priority is like the Zendesk stuff.
119 00:10:00.830 ⇒ 00:10:02.705 Uttam Kumaran: but I guess we could talk about everything.
120 00:10:03.290 ⇒ 00:10:13.459 Nick Baker: Yeah. So I commented out, just like prototype queries. I can convert those into models today. So, Robert, I just want to get a naming convention for those?
121 00:10:13.830 ⇒ 00:10:26.210 Nick Baker: so we can. You can just throw that on a comment for each of those things, and then I will output those I should be able to output those today. That for the full story, I think that we also had.
122 00:10:26.788 ⇒ 00:10:30.190 Nick Baker: I also have that, I think, ready to go.
123 00:10:31.860 ⇒ 00:10:39.113 Nick Baker: The issue is just. Some of the fields were like named a little differently, but I also think that I should be able to have brick models for those done also today.
124 00:10:39.870 ⇒ 00:10:41.739 Robert Tseng: That’s all the spreadsheet that you sent me.
125 00:10:41.740 ⇒ 00:10:46.240 Nick Baker: Yeah. Yeah. Spreadsheet the the Google sheet, the original one.
126 00:10:46.240 ⇒ 00:10:47.859 Robert Tseng: Academic. Yeah, correct. But.
127 00:10:47.860 ⇒ 00:11:06.465 Nick Baker: It’s like kind of a backup in case the full story stuff gets any more convoluted. There’s a lot of fields on one of the 2 tables. That’s like, probably all the quoting information and stuff like that, too, for the segment events. So something we might need to go through and and kind of tag those for for where we’ll need them. But for now that I don’t think that’s important.
128 00:11:07.200 ⇒ 00:11:13.990 Nick Baker: So yeah, if you just give me names for them. I’ll bang out tables one of the questions that I have is regarding the orchestration.
129 00:11:14.526 ⇒ 00:11:25.860 Nick Baker: I don’t know what our like. I again, I can run these, but and like we’ll have them and they will exist. But I’m gonna treat them as tables, for now we can migrate them to incremental if that becomes something that’s that we need
130 00:11:26.531 ⇒ 00:11:56.089 Nick Baker: especially with the full story stuff given the the volume of the of the events. But wanted to ask guys, Patrick, what the like, the or the orchestration look the switch for stuff running looks like. And I also might need to ping you for some support on the schema. My like output schema stuff. I I’ve used Snowflake before, but for some reason bolting it onto some of the Dbt. Those packages that I’m using is giving me a little bit of a little bit of flack for some stuff.
131 00:11:56.810 ⇒ 00:12:02.952 Patrick Trainer: Okay, so with that, would like we’d have to look into like the specific packages that you’re using. There.
132 00:12:03.260 ⇒ 00:12:12.319 Nick Baker: Something I can do to supersede it, and I just need I. I looked at a little bit, but I didn’t look that much. So if it’s something that you already know I can, I can ping you the specific. So then we can talk about that. Async.
133 00:12:12.770 ⇒ 00:12:13.976 Patrick Trainer: Cool. Cool. Cool. Cool
134 00:12:14.801 ⇒ 00:12:18.340 Uttam Kumaran: Send them the channel, too. And then I think we can get the actions basically done.
135 00:12:18.600 ⇒ 00:12:26.520 Patrick Trainer: Yeah, yeah, yeah. The the orchestration part. It’s we’re we’re all gonna run through github actions and run on those runners.
136 00:12:26.700 ⇒ 00:12:33.252 Patrick Trainer: So we can either set up like a cron, but also a like a pull request trigger that
137 00:12:34.290 ⇒ 00:12:35.950 Patrick Trainer: deploys everything automatically.
138 00:12:35.950 ⇒ 00:12:41.810 Uttam Kumaran: Yeah, that that is basically like, we just have to push like, just a little bit of code. So I can turn all that on
139 00:12:42.510 ⇒ 00:12:46.029 Uttam Kumaran: but feel free to just keep running stuff
140 00:12:46.230 ⇒ 00:12:48.549 Uttam Kumaran: like locally as needed.
141 00:12:49.073 ⇒ 00:12:53.560 Uttam Kumaran: But then, yeah, if you send me the error, too, because I guess I’m interested. I’ll take a look as well.
142 00:12:54.340 ⇒ 00:13:13.150 Nick Baker: Okay, cool. Yeah, I can do that. But yeah, I expect that I’ll have the those reporting tables ready to go so that we can move on to the next stuff. Again, like presenting the actual dashboard and also moving on to translating some of the some of their like in house data stuff to which I think, is it we all kind of know is gonna be a bit more cumbersome.
143 00:13:13.790 ⇒ 00:13:15.379 Robert Tseng: Yeah, we yeah.
144 00:13:16.270 ⇒ 00:13:22.559 Uttam Kumaran: So okay, so let me follow up on like snowflake. 5 trans stuff. We’re gonna see if I can get those pushed.
145 00:13:22.570 ⇒ 00:13:26.010 Uttam Kumaran: I’m talking to the snowflake guy about a bunch of other stuff already right now.
146 00:13:26.610 ⇒ 00:13:27.750 Uttam Kumaran: And then.
147 00:13:27.980 ⇒ 00:13:31.949 Uttam Kumaran: Pat, I guess what what let’s get. We can get something booked for
148 00:13:31.980 ⇒ 00:13:34.291 Uttam Kumaran: azure tomorrow, and then
149 00:13:35.340 ⇒ 00:13:40.750 Uttam Kumaran: We could look into those Dbtras. And then I’m gonna get the workflows. I’ll set up some time tonight so that should be all good.
150 00:13:40.750 ⇒ 00:13:41.740 Patrick Trainer: Okay. Cool.
151 00:13:42.140 ⇒ 00:13:56.650 Uttam Kumaran: So let’s just like, I think biggest thing is like, we can just stay really close to getting whatever Robert needs for the dashboard this week in terms of models. Biggest thing is like, if we can get everything in Snowflake ready to analyze this, that’s the number one, and then getting everything orchestrated
152 00:13:56.940 ⇒ 00:13:58.990 Uttam Kumaran: like, totally not nervous by any of that
153 00:14:00.130 ⇒ 00:14:06.250 Uttam Kumaran: So just making sure, Nick, that all your models and stuff are there, and then everything else basically take care of.
154 00:14:08.570 ⇒ 00:14:15.789 Uttam Kumaran: okay, cool. I’m I’m available all week. So keep talking in the Channel. Anything else? Let me know.
155 00:14:16.430 ⇒ 00:14:17.340 Uttam Kumaran: So yeah, sweet.
156 00:14:17.340 ⇒ 00:14:20.652 Robert Tseng: I’ll get back to you soon, real soon. Nick on on the on the meeting.
157 00:14:21.050 ⇒ 00:14:23.959 Nick Baker: Perfect. Yeah, that’s that’s my gate. Once I have that, I can go.
158 00:14:24.180 ⇒ 00:14:24.950 Robert Tseng: Okay.
159 00:14:25.910 ⇒ 00:14:26.690 Robert Tseng: Okay.
160 00:14:26.690 ⇒ 00:14:27.160 Patrick Trainer: Or.
161 00:14:27.160 ⇒ 00:14:27.793 Uttam Kumaran: Awesome guys.
162 00:14:28.340 ⇒ 00:14:29.400 Uttam Kumaran: Alright, thank you.
163 00:14:29.610 ⇒ 00:14:30.180 Robert Tseng: Yeah.
164 00:14:30.530 ⇒ 00:14:31.260 Uttam Kumaran: Oxen.