Meeting Title: Stella-Regroup Date: 2024-04-30 Meeting participants: Nick Baker, Robert Tseng, Patrick Trainer, Uttam Kumaran


WEBVTT

1 00:00:20.270 00:00:21.810 Patrick Trainer: Hey, Robert, how’s it going?

2 00:00:31.250 00:00:31.920 Patrick Trainer: Loop?

3 00:00:33.650 00:00:36.130 Patrick Trainer: Don’t think I can hear you yet.

4 00:00:36.350 00:00:37.730 Patrick Trainer: Inflected, may.

5 00:00:43.140 00:00:43.840 Uttam Kumaran: Hey!

6 00:00:45.015 00:00:45.430 Patrick Trainer: Hey!

7 00:00:46.240 00:00:47.399 Uttam Kumaran: How’s it going.

8 00:00:47.910 00:00:49.050 Patrick Trainer: It’s going good

9 00:00:49.540 00:00:51.290 Patrick Trainer: finding out of like

10 00:00:51.390 00:00:53.879 Patrick Trainer: triple booked like 6 things.

11 00:00:54.636 00:00:55.930 Patrick Trainer: So like

12 00:00:56.020 00:00:57.692 Patrick Trainer: 18 way booked.

13 00:01:00.790 00:01:01.989 Patrick Trainer: It’s Tuesdays, man.

14 00:01:03.490 00:01:04.379 Uttam Kumaran: Funny.

15 00:01:09.820 00:01:10.811 Patrick Trainer: How’s it going with you.

16 00:01:12.030 00:01:14.377 Uttam Kumaran: That is good.

17 00:01:15.680 00:01:22.480 Uttam Kumaran: yeah. I’m excited for the interviews and stuff today. And I gotta send some notes out about that. And

18 00:01:23.230 00:01:26.490 Uttam Kumaran: yeah, otherwise, stuff is good normal.

19 00:01:27.400 00:01:28.140 Patrick Trainer: And that.

20 00:01:29.570 00:01:30.889 Robert Tseng: Okay, I can hear you guys.

21 00:01:31.520 00:01:32.100 Uttam Kumaran: A.

22 00:01:32.380 00:01:32.775 Robert Tseng: Yeah.

23 00:01:35.076 00:01:36.943 Uttam Kumaran: Let me message, Nick.

24 00:01:38.290 00:01:39.000 Uttam Kumaran: Excuse me.

25 00:01:42.720 00:01:43.390 Uttam Kumaran: oops.

26 00:01:44.090 00:01:45.899 Uttam Kumaran: it’s running a few late.

27 00:02:02.580 00:02:04.709 Patrick Trainer: Robert, where are you calling in from.

28 00:02:05.040 00:02:06.290 Robert Tseng: I’m in New York.

29 00:02:06.750 00:02:07.540 Patrick Trainer: Okay. Nice.

30 00:02:07.540 00:02:08.220 Robert Tseng: Yeah.

31 00:02:08.910 00:02:12.759 Robert Tseng: I guess specifically, Jersey City. But yeah.

32 00:02:12.760 00:02:13.440 Patrick Trainer: And okay.

33 00:02:13.440 00:02:15.620 Robert Tseng: Right across Friday, yeah.

34 00:02:16.020 00:02:17.010 Patrick Trainer: I know.

35 00:02:17.460 00:02:21.280 Patrick Trainer: like a tiny bit of the landscape of New York.

36 00:02:21.280 00:02:21.610 Robert Tseng: Okay.

37 00:02:21.610 00:02:24.429 Patrick Trainer: But so, yeah, I know New Jersey is

38 00:02:25.280 00:02:28.770 Patrick Trainer: little to the East. That’s about it.

39 00:02:28.770 00:02:36.969 Robert Tseng: I, yeah, I’m I’m just west of the Hudson River. So I’m like, I’m on the waterfront. Yeah, so I can see you work for my for my window, but

40 00:02:37.010 00:02:39.099 Robert Tseng: not exactly in New York. Yeah.

41 00:02:39.240 00:02:40.590 Patrick Trainer: That’s that’s a good view.

42 00:02:41.000 00:02:44.498 Robert Tseng: Yeah, yeah, I think it’s better than the other way. Looking at.

43 00:02:45.418 00:02:47.302 Patrick Trainer: Yeah, probably, so.

44 00:02:49.550 00:02:51.269 Robert Tseng: And you’re in New Orleans, Patrick.

45 00:02:51.270 00:02:52.960 Patrick Trainer: Yeah. Yeah. New Orleans

46 00:02:53.581 00:02:55.629 Patrick Trainer: been been here for a bit.

47 00:02:55.850 00:02:56.759 Patrick Trainer: That’s good as long as.

48 00:02:56.760 00:02:58.669 Uttam Kumaran: How long have you been there, pat.

49 00:02:59.005 00:03:00.010 Patrick Trainer: We’ve been about

50 00:03:00.470 00:03:02.160 Patrick Trainer: close to 10 years

51 00:03:02.340 00:03:04.280 Patrick Trainer: moved down here after college.

52 00:03:04.560 00:03:05.290 Robert Tseng: Wow!

53 00:03:05.520 00:03:06.500 Uttam Kumaran: Nice.

54 00:03:06.880 00:03:09.520 Robert Tseng: Buy a place? Are you renting out where you would you live in.

55 00:03:09.983 00:03:13.690 Patrick Trainer: We’re renting right now. It’s kinda

56 00:03:13.730 00:03:19.340 Patrick Trainer: doing that. We’ve been moving around a bit. But then kinda yeah, looking into

57 00:03:19.990 00:03:26.290 Patrick Trainer: well, well, so like right before all of like the the housing interest rates flew up and.

58 00:03:26.290 00:03:26.740 Robert Tseng: Yeah.

59 00:03:26.740 00:03:29.990 Patrick Trainer: We’re we’re looked around. Then that flew up, and then that kinda

60 00:03:30.410 00:03:32.389 Patrick Trainer: but like a a damper

61 00:03:32.450 00:03:36.210 Patrick Trainer: on stuff and holding out so. But we’re seeing a lot of

62 00:03:36.880 00:03:41.640 Patrick Trainer: I mean, I guess, like prices going back down. But interest rates really not so much, and.

63 00:03:41.640 00:03:41.964 Robert Tseng: Right.

64 00:03:42.290 00:03:45.260 Patrick Trainer: My wife. My wife’s dad was like, Oh, man.

65 00:03:45.630 00:03:53.932 Patrick Trainer: looks like you’re never gonna buy a house like to miss missed your chance with the interest rates you’re just like, oh.

66 00:03:54.850 00:03:56.700 Patrick Trainer: guess we never will. So.

67 00:03:57.130 00:04:00.327 Robert Tseng: Yeah, well, there’s yeah. Yeah.

68 00:04:00.860 00:04:03.139 Patrick Trainer: I’m I’m kidding. But yeah.

69 00:04:06.270 00:04:09.052 Uttam Kumaran: Yeah, I’m like thinking about. I just put

70 00:04:10.040 00:04:14.149 Uttam Kumaran: I just told my apartment. I’m not gonna renew. I’m gonna try to rent a house in July

71 00:04:14.742 00:04:19.769 Uttam Kumaran: cause Austin is having like a huge supply shock like

72 00:04:20.140 00:04:34.290 Uttam Kumaran: it’s really crazy, which is really helpful for me, cause so much supplies coming online. I mean, like, if you if you go on like the Wall Street Journal, you search up Austin, you’ll see a lot of the articles. But there’s so much supply coming online. And Austin is actually done like

73 00:04:34.360 00:04:38.379 Uttam Kumaran: an amazing job responding to the covid influx by like changing permits.

74 00:04:38.380 00:04:39.490 Patrick Trainer: Really.

75 00:04:39.490 00:04:42.990 Uttam Kumaran: And fast tracking a ton of new construction.

76 00:04:43.000 00:04:44.130 Uttam Kumaran: So

77 00:04:44.200 00:04:46.540 Uttam Kumaran: like prices are like coming down like

78 00:04:47.190 00:04:49.259 Uttam Kumaran: few percent every month.

79 00:04:49.260 00:04:49.940 Patrick Trainer: Oh! Damn!

80 00:04:50.248 00:04:56.421 Uttam Kumaran: So like it’s come down like it’s come down like probably 15% in the last, like 3, 4 months.

81 00:04:56.730 00:04:57.150 Robert Tseng: And he goes.

82 00:04:57.150 00:05:12.690 Uttam Kumaran: Someone zillow like looking. And the same houses are available. And it’s just like minus some amount minus some amount. And there’s building so much here which I think is like how it should be in our in our country like it should be easy to get housing in there.

83 00:05:12.690 00:05:13.480 Patrick Trainer: Right.

84 00:05:13.836 00:05:15.260 Uttam Kumaran: I just think like

85 00:05:15.390 00:05:19.774 Uttam Kumaran: here they, I think in Texas they just build like nonstop.

86 00:05:20.140 00:05:21.170 Patrick Trainer: Just kept going.

87 00:05:21.170 00:05:23.220 Uttam Kumaran: They just keep going out like further.

88 00:05:23.220 00:05:24.050 Patrick Trainer: Yeah.

89 00:05:24.490 00:05:47.039 Patrick Trainer: that’s that’s kind of the issue with New Orleans is like, because we are surrounded literally by swamp, swamp, and untenable land. There’s a like a very hard cap on the supply of housing. And so it’s like, it’s like demands always going to grow or like more people are always going to be there unless we get like wiped out by hurricane

90 00:05:47.727 00:05:49.580 Patrick Trainer: but like the

91 00:05:50.430 00:05:59.149 Patrick Trainer: yeah, the demand is always going to be higher than the supply. And then it’s like we can’t expand out. So it’s just getting like worse and worse, this self

92 00:05:59.540 00:06:01.070 Patrick Trainer: perpetuating

93 00:06:01.230 00:06:06.504 Patrick Trainer: shit cycle. And then then you got all like the. It’s Louisiana type

94 00:06:07.190 00:06:11.260 Patrick Trainer: problems that come along with just being in Louisiana.

95 00:06:12.140 00:06:19.069 Uttam Kumaran: Yeah, makes sense. Yeah, here, I think they’re kind of lucky because they can start kind of new on a lot of stuff like it’s not.

96 00:06:19.070 00:06:19.530 Patrick Trainer: Yeah.

97 00:06:19.530 00:06:24.200 Uttam Kumaran: It’s it’s an old town, but not like how much populations here now, so they can

98 00:06:24.440 00:06:26.619 Uttam Kumaran: kind of like try to do some planning.

99 00:06:26.940 00:06:28.610 Patrick Trainer: Right? Right?

100 00:06:29.700 00:06:40.409 Patrick Trainer: Yeah, it’s it’s like, my house was built in 1,875, and like to do like renovations and stuff on it. You have to

101 00:06:40.500 00:06:47.629 Patrick Trainer: contact like the store district and get all these permits, and it’s like changing windows

102 00:06:48.110 00:06:51.209 Patrick Trainer: will take like months like it’s it’s absurd.

103 00:06:51.210 00:06:51.760 Uttam Kumaran: Dang!

104 00:06:53.910 00:06:56.870 Patrick Trainer: So much red tape for really not much.

105 00:06:57.910 00:06:59.339 Patrick Trainer: not much benefit.

106 00:06:59.650 00:07:00.310 Patrick Trainer: Hmm.

107 00:07:01.534 00:07:03.759 Uttam Kumaran: Cool. Maybe we get started.

108 00:07:03.760 00:07:05.090 Robert Tseng: Yeah. Hey? Nick.

109 00:07:05.140 00:07:06.240 Robert Tseng: James, okay.

110 00:07:06.240 00:07:06.920 Nick Baker: Might.

111 00:07:09.550 00:07:17.420 Uttam Kumaran: Yeah, cool. So I think, we kind of have had everything tracked here basically made a ton of good progress on

112 00:07:17.430 00:07:20.660 Uttam Kumaran: snowflake setup and dbt setup.

113 00:07:21.315 00:07:23.570 Uttam Kumaran: I think the big things today.

114 00:07:23.970 00:07:26.290 Uttam Kumaran: I wanted to talk a little bit about

115 00:07:27.400 00:07:29.919 Uttam Kumaran: setting up 5 tran and like, I think.

116 00:07:30.535 00:07:41.854 Uttam Kumaran: like handling. That second thing is etl for the like azure objects. And then, third thing is like just getting started with with modeling.

117 00:07:42.664 00:07:50.859 Uttam Kumaran: So I guess first thing, we don’t need to really add a credit card to the Snowflake account for a while. They have like a pretty generous, free trial. So

118 00:07:50.930 00:08:01.090 Uttam Kumaran: we’re just gonna run through that but probably Robert, which is, try to get ahead of it. I think we put a reminder. But we’ll try to get ahead of it and message you when that like that comes due.

119 00:08:01.090 00:08:01.760 Robert Tseng: Okay.

120 00:08:03.040 00:08:09.629 Uttam Kumaran: The next thing is everyone should have access to Snowflake, I’m pretty sure, and that should all be

121 00:08:10.281 00:08:15.918 Uttam Kumaran: good to go, and a lot of like the ways we set that up is all documented. So that’s great.

122 00:08:16.770 00:08:23.579 Uttam Kumaran: the second thing is, we’re we run. We’re running dbt, like as like a cloud workflow.

123 00:08:23.970 00:08:40.139 Uttam Kumaran: That way. You just don’t have to even pay for dbt I guess Nick, like. I don’t know if if you’re like, really like, you need to have cloud, we can do cloud for like one free user but if you do everything in vs, there’s like no difference.

124 00:08:40.450 00:08:57.960 Nick Baker: Yeah, I don’t. I don’t have any strong preference there. I didn’t know what the your guys preferred setup would be for that. So yeah, if it’s core with some sort of some sort of orchestration. I just need to see what the orchestration looks like, so that I understand it, so I haven’t necessarily used this version before, and then I’ll I’ll be good to go.

125 00:08:58.130 00:09:07.226 Uttam Kumaran: Cool. Okay, yeah, we just like, we’re having a couple of companies like running these workflows that we maintain. And it’s just running Dbt test and like source and.

126 00:09:07.780 00:09:08.400 Nick Baker: Yeah.

127 00:09:08.400 00:09:12.420 Uttam Kumaran: Directly from core. And then, yeah, it just runs directly as a Github

128 00:09:12.910 00:09:15.959 Uttam Kumaran: action. And it’s it’s pretty straightforward.

129 00:09:15.960 00:09:24.819 Nick Baker: Cool. Yeah, yeah, I just need to. Yeah, if you just walk me through it, I’ll be. I’ll be good and I need to figure out what I want for my local dev setup, but I’m sure it’ll be easy enough.

130 00:09:25.040 00:09:39.260 Uttam Kumaran: Okay, the next thing is on 5 train setup. So I think this is probably something, Nick, you could probably just do. Or I mean, I’m happy to handle. But it’s literally just like initializing 5 trend. And then there’s a couple of

131 00:09:40.080 00:09:41.784 Uttam Kumaran: there’s a couple of

132 00:09:43.460 00:09:47.480 Uttam Kumaran: docs for all 3 of the different sources we want to bring in

133 00:09:47.500 00:09:52.289 Uttam Kumaran: for 5 train we have like A, they’ll have. There’ll be a 14 day free trial, and then

134 00:09:52.659 00:09:59.450 Uttam Kumaran: you will just pay for like the new rows. So hopefully, in the 14 days we can get a sense

135 00:09:59.490 00:10:02.373 Uttam Kumaran: of like the cost. Basically

136 00:10:03.090 00:10:07.209 Uttam Kumaran: The only one I’m worried about is like anything with like an event stream.

137 00:10:07.574 00:10:17.460 Uttam Kumaran: So I’m not exactly sure what next week is. Gonna look like the other like we’ve done, Zendesk, for a couple of people is pretty fine, and then I’ll have to look at full story. But

138 00:10:19.228 00:10:24.651 Uttam Kumaran: So that should be pretty straightforward to do. Each of these has a like a little bit of a different setup.

139 00:10:25.160 00:10:34.740 Uttam Kumaran: some of them require an Api key. Some of them require, like a user who’s authorized in the application to click the button, and then it like

140 00:10:35.030 00:10:36.830 Uttam Kumaran: goes to a lot. So

141 00:10:37.440 00:10:43.940 Uttam Kumaran: it may be just something like you and Robert could probably pair on really quick and just figure out if there’s need anything from the client.

142 00:10:45.220 00:10:45.520 Uttam Kumaran: Big.

143 00:10:45.520 00:10:54.639 Patrick Trainer: So only or the like. Netsuite will probably give the most trouble in terms of like needing somebody else to click the button.

144 00:10:55.790 00:10:56.590 Uttam Kumaran: Okay, cool

145 00:10:59.750 00:11:03.380 Uttam Kumaran: and then the last thing is just the storage integration for

146 00:11:03.650 00:11:05.050 Uttam Kumaran: blob storage

147 00:11:06.198 00:11:12.439 Uttam Kumaran: like this is probably since we’ve been working through. This is probably mo more important than the 5 trend

148 00:11:12.980 00:11:14.159 Uttam Kumaran: related stuff.

149 00:11:14.510 00:11:15.580 Uttam Kumaran: Or it

150 00:11:15.640 00:11:16.660 Uttam Kumaran: is it like

151 00:11:16.680 00:11:21.259 Uttam Kumaran: kind of same priority? Because I know we’ve this is all the stuff related to the Erds and things.

152 00:11:25.295 00:11:38.079 Patrick Trainer: The thing for this, all that, like the back and forth that will need to be done is there’s like, we need like the blob storage URL, to like to azure like where the buckets located.

153 00:11:38.630 00:11:50.269 Patrick Trainer: And then there’s a couple of steps like when we’re setting up the last piece of the storage integration where, we need to give basically like a snowflake generated key

154 00:11:50.320 00:12:00.600 Patrick Trainer: to azure. And then azure gives like a the symmetrical key, and that we store in Snowflake and so that’ll just take like a little bit of coordination.

155 00:12:01.214 00:12:05.310 Patrick Trainer: But that’s really the most of it. The rest of it is just

156 00:12:05.510 00:12:08.530 Patrick Trainer: some like Ddl

157 00:12:08.850 00:12:11.749 Patrick Trainer: type stuff, some admin stuff on the Snowflake side.

158 00:12:25.820 00:12:30.600 Uttam Kumaran: I think that’s kind of it. So I think the next steps is just like I can probably

159 00:12:30.660 00:12:32.959 Uttam Kumaran: work with Nick to create like

160 00:12:33.420 00:12:36.200 Uttam Kumaran: some rough tickets for the models.

161 00:12:36.360 00:12:42.030 Uttam Kumaran: But I think pretty much we’re we’re close this to the point where we can probably hand some stuff off.

162 00:12:45.290 00:12:46.800 Uttam Kumaran: yeah, I guess.

163 00:12:47.040 00:12:48.750 Uttam Kumaran: How do we feel? What do we think?

164 00:12:52.610 00:12:53.620 Patrick Trainer: All good for me.

165 00:12:53.880 00:12:54.510 Uttam Kumaran: Okay.

166 00:12:55.030 00:13:13.616 Nick Baker: Yeah, I think good time. I might want to set up the do. The 5 trend set up with you just because I haven’t had to start that from scratch before. Sure, it’s easy enough, but I would be. I don’t wanna fuck it up somehow, going through the like. The the sources and stuff seems like again, this follow the team with the instructions.

167 00:13:14.740 00:13:28.767 Nick Baker: so I think that part’s good. Yeah. And then talking about what the like. First modeling steps. Look like, I also, yeah, want to go through the Dbt setup just to make sure that I understand how to how to run stuff and how to run. Dev

168 00:13:29.680 00:13:34.290 Nick Baker: But other than that, yeah, it’s just it’s just like, like like environment setup shit, basically.

169 00:13:34.290 00:13:45.619 Uttam Kumaran: Okay, okay, yeah, let’s do that. Let’s do that today. If we can, I’ll I’ll set up a meeting and then run through the 5 train, because I wanna record that. And as well. And then

170 00:13:47.090 00:13:55.530 Uttam Kumaran: yeah, the for the Github action stuff. It’s probably either me or Patrick, but it’s again, we. We have everything running in as an action. And it’s nice cause.

171 00:13:55.840 00:14:00.649 Uttam Kumaran: Like, all the failures are linked really nicely. And then, yeah, the local depth setup is

172 00:14:00.680 00:14:04.700 Uttam Kumaran: like, always kind of a pain. So we’ll just like, make sure that’s all like good to go.

173 00:14:05.370 00:14:06.020 Nick Baker: Okay.

174 00:14:06.580 00:14:09.189 Uttam Kumaran: So pat. Maybe once we have, like the

175 00:14:09.250 00:14:13.999 Uttam Kumaran: Dbt like project kind of like scaffolded, we could just do an onboarding for

176 00:14:14.430 00:14:16.180 Uttam Kumaran: for Nick onto that.

177 00:14:17.150 00:14:19.978 Patrick Trainer: Cool. I think I actually have.

178 00:14:22.200 00:14:23.819 Patrick Trainer: like a local setup

179 00:14:24.640 00:14:27.529 Patrick Trainer: kind of script already up in there.

180 00:14:27.960 00:14:29.929 Patrick Trainer: Yup, I totally do.

181 00:14:30.250 00:14:30.790 Patrick Trainer: But yeah.

182 00:14:30.790 00:14:32.300 Uttam Kumaran: The stellar repo.

183 00:14:34.870 00:14:35.490 Patrick Trainer: Yes.

184 00:14:36.820 00:14:40.486 Patrick Trainer: yeah. So I’ve got that in like the make file. But

185 00:14:41.150 00:14:45.470 Patrick Trainer: we can. Yeah, we can help you get everything set up and done easy.

186 00:14:45.870 00:14:48.440 Uttam Kumaran: Yeah, I think I mean, it’s a good test for the make file.

187 00:14:50.560 00:14:50.935 Uttam Kumaran: Okay.

188 00:14:57.010 00:15:01.130 Patrick Trainer: I’ll see you tear down the environment too real quickly.

189 00:15:15.170 00:15:18.180 Uttam Kumaran: Cool, and then maybe we can also just try to push like first model.

190 00:15:18.700 00:15:21.800 Uttam Kumaran: Then make sure that gets run by the actions.

191 00:15:23.160 00:15:23.830 Uttam Kumaran: Cool.

192 00:15:24.610 00:15:25.470 Uttam Kumaran: Okay.

193 00:15:26.470 00:15:31.365 Uttam Kumaran: cool. I’ll try to set up. Maybe I’ll set this meeting up again for next week, just as a placeholder.

194 00:15:32.426 00:15:33.660 Uttam Kumaran: and then

195 00:15:35.022 00:15:41.189 Uttam Kumaran: yeah, the big things will be again getting Nick on boarded hopefully, kicking 5 Tran stuff off.

196 00:15:41.700 00:15:45.259 Uttam Kumaran: And then Pat is, gonna look into the storage blob stuff. So.

197 00:15:48.470 00:15:49.340 Uttam Kumaran: okay.

198 00:15:50.730 00:15:51.750 Robert Tseng: That was good guys.

199 00:15:51.980 00:15:52.760 Uttam Kumaran: Alright.

200 00:15:53.310 00:15:55.459 Uttam Kumaran: if anything else we’re on slack. So.

201 00:15:56.230 00:15:56.900 Patrick Trainer: Right on.

202 00:15:57.120 00:15:57.530 Uttam Kumaran: Okay.

203 00:15:57.530 00:15:57.980 Robert Tseng: Help!

204 00:15:57.980 00:15:58.770 Nick Baker: I do it bye.

205 00:15:58.770 00:16:00.009 Robert Tseng: Alright! See you.

206 00:16:00.010 00:16:00.730 Uttam Kumaran: Thank you.