Meeting Title: Javy-Project-Internal-Review Date: 2024-10-14 Meeting participants: Nicolas Sucari, Uttam Kumaran, Payas Parab


WEBVTT

1 00:04:51.060 00:04:52.351 Payas Parab: Hey? How’s it going? Utam?

2 00:04:54.680 00:04:56.010 Uttam Kumaran: Hey, man! How are you?

3 00:04:56.010 00:04:57.430 Payas Parab: I’m doing all right.

4 00:04:58.040 00:04:59.120 Payas Parab: Can’t ring.

5 00:04:59.120 00:05:00.100 Nicolas Sucari: Hi Bayaz.

6 00:05:00.630 00:05:02.180 Payas Parab: Hey, Nico! How are you?

7 00:05:03.260 00:05:04.926 Nicolas Sucari: Doing good. How about you?

8 00:05:05.520 00:05:06.736 Payas Parab: I’m doing all right.

9 00:05:08.120 00:05:09.759 Payas Parab: You guys have a good weekend.

10 00:05:11.100 00:05:11.720 Nicolas Sucari: Yep.

11 00:05:11.890 00:05:13.539 Uttam Kumaran: Good, excited to be back.

12 00:05:13.540 00:05:14.680 Nicolas Sucari: All good.

13 00:05:15.010 00:05:17.249 Payas Parab: Where are you guys based? Again? Sorry, I forgot.

14 00:05:17.440 00:05:20.750 Uttam Kumaran: I’m in Austin and Nico’s in Argentina.

15 00:05:21.030 00:05:22.790 Payas Parab: In Argentina. Okay. Very nice.

16 00:05:22.790 00:05:24.410 Nicolas Sucari: In Buenos Aires.

17 00:05:24.410 00:05:26.189 Uttam Kumaran: Are you? Are you in a Sf.

18 00:05:26.190 00:05:27.290 Payas Parab: I’m in la.

19 00:05:27.460 00:05:28.590 Uttam Kumaran: Oh, nice!

20 00:05:28.900 00:05:29.670 Uttam Kumaran: Cool!

21 00:05:31.950 00:05:33.000 Payas Parab: Yeah, sweet?

22 00:05:34.480 00:05:41.320 Payas Parab: well, I’m sure you guys have like any stuff you guys wanna discuss. There’s 1 thing I threw in the chat that the Cfo is kind of just like

23 00:05:41.390 00:06:07.060 Payas Parab: he’s just like he just wants to see some stuff which I totally understand. So we want to just start sending him some updates. There’s some views like month over month, week over week, like specific views that would be nice to set up. We’ve done that I’ve done that before in Meta base as well as like hex dot tech right where you can like, basically refresh the data easily. And it’s like it’s a preset view. So I think we do need like, I love real, and it’s like self. Serve capabilities. But we also need like

24 00:06:07.180 00:06:28.476 Payas Parab: some level of like, Hey, I wrote a custom sequel for this, and I need somewhere to display it that I can share with Cfo. Non technical user. Easily. And they’re they’re planning to like hire a data analyst. So that person ultimately will also need a place to like put their outputs. That’ll be like their regular reporting. So I’m a big fan of hex tech if it’s for like non technical users.

25 00:06:28.780 00:06:44.349 Payas Parab: I, you know, you can like write documentation in addition, right? And like Meta base is like easy, cheap. But I, you guys, had recommendations. But what I don’t want. My biggest concern is like 2 different environments, right? It’s like for this thing. You have to go to real. And this.

26 00:06:44.350 00:06:44.980 Uttam Kumaran: I agree.

27 00:06:44.980 00:06:52.650 Payas Parab: Go to amplitude. Other thing you have to go to whatever. So I don’t know if you guys have a solutions or run into that, but that I definitely wanted to put on your radar.

28 00:06:52.650 00:07:09.340 Uttam Kumaran: Yeah, so real. They’re actually adding, this capability. But it’s not out yet. So let me paying them and be like, can we try it. But I also am on the same page, like I would much rather not give them like 2 tools to use.

29 00:07:09.340 00:07:09.890 Payas Parab: Yeah.

30 00:07:10.150 00:07:27.880 Uttam Kumaran: I think it also depends. Like, if they’re if they really are going more and like they want to see, like very custom dashboards. And yeah, real is gonna be a little bit tougher because it’s gonna be mainly for like you can do all this customers you can do like really great comparisons like you can do month over month stuff. But it’s not really like

31 00:07:30.450 00:07:31.060 Uttam Kumaran: equivalent.

32 00:07:31.060 00:07:35.010 Payas Parab: Yeah, for, like the Cfo audience is like he just wants like a tear sheet right? Like he just wants like a

33 00:07:35.440 00:07:43.799 Payas Parab: log in. Grab his month over month report and then add his analysis and recommendations to Justin. It’s sort of like.

34 00:07:44.670 00:07:52.909 Payas Parab: yeah, he can cost. I’m I’m sure, like that’s the thing it’s like, I know. They’ll value both of them right? I know they’ll value both of them, but we want to make sure we also can

35 00:07:53.150 00:07:56.290 Payas Parab: have something out of like. I used to do it in like streamlit right where it’s like.

36 00:07:56.290 00:07:56.850 Uttam Kumaran: Yeah, yeah.

37 00:07:56.850 00:08:00.520 Payas Parab: Tab that’d be like monthly report and then click on that, and it has

38 00:08:00.550 00:08:04.439 Payas Parab: the specific configurations. And then that person could just like export it.

39 00:08:04.706 00:08:13.350 Payas Parab: Export the data as needed, or like, click into it and just copy and paste like the chart that was generated. I’ve done stuff like that. So I’m just trying to figure out what

40 00:08:13.860 00:08:21.029 Payas Parab: is there a clever way that we can like? Redirect between real and like a streamlet app or real, and another like

41 00:08:22.430 00:08:32.690 Payas Parab: App. I’m I’m just curious. Or we can like embed Meta base charts somewhere in the real environment, like, maybe there’s like a workaround here. That sort of works. Curious, if you guys have any ideas on that.

42 00:08:32.690 00:08:43.869 Uttam Kumaran: I mean, there’s gonna be 2. There’s gonna be 2 modes of like consumption. Typically, there’s like consumption by like analysts or people that are wanting to do self serve stuff. And then there’s like fixed

43 00:08:43.919 00:08:46.270 Uttam Kumaran: dashboard reporting for people that are like.

44 00:08:46.580 00:08:48.539 Uttam Kumaran: I don’t want to do anything

45 00:08:48.600 00:08:51.204 Uttam Kumaran: like I don’t wanna do anything at all.

46 00:08:51.590 00:08:53.220 Uttam Kumaran: so like, it’s kind of

47 00:08:53.360 00:09:09.419 Uttam Kumaran: it’s so. The the good part is like these, it’s very common problem. The tough part is the price on tools that support both of those is really high, like Meta base is pretty horrible for self. Serve reporting. Okay, like.

48 00:09:09.570 00:09:11.269 Payas Parab: You need a equal person to do it.

49 00:09:11.270 00:09:12.889 Uttam Kumaran: Yeah. Hacks.

50 00:09:13.170 00:09:20.350 Uttam Kumaran: I would say also is like, if I I don’t know if I could throw a business person into hex and be like do this. But

51 00:09:20.500 00:09:28.080 Uttam Kumaran: like I think you can set up a lot of sales reporting real. I’m super comfortable, being like go in. You couldn’t press a button that would like mess things up.

52 00:09:28.080 00:09:29.469 Payas Parab: Totally 100%. Yeah.

53 00:09:29.770 00:09:45.119 Uttam Kumaran: But also like, I think this is where I want to get from a mon like what their budget is like. The nice thing is real, for our data size is gonna be pretty cheap, like, probably like 2, 50, or 500 a month. To give you a sense like

54 00:09:45.440 00:09:47.400 Uttam Kumaran: Something like looker

55 00:09:47.480 00:09:51.689 Uttam Kumaran: is like, gonna be more than a thousand bucks a month.

56 00:09:51.780 00:09:53.740 Uttam Kumaran: maybe like 2 KA month.

57 00:09:54.611 00:10:07.430 Uttam Kumaran: Metabase is free. So that’s why I think maybe it’s like a mix of real and metabase. And then basically, we use metabase for like fixed dashboards, and then we use or hex for fixed dashboard, and then we use real, for like operational.

58 00:10:07.430 00:10:09.939 Payas Parab: I’m I’m wondering then, then like for

59 00:10:09.960 00:10:22.530 Payas Parab: instead of hex, then what if we do streamlink? A streamlin is free with snowflake and in theory, anyway. Like, now, I’m gonna start adding the Cfo to these intermediate tables so he can just pull data as he needs and so.

60 00:10:22.530 00:10:33.709 Uttam Kumaran: Sure. Yes, I mean the the thing with streamlet that I get nervous about is like some people haven’t used streamlit. I’ve used streamlit a bunch. So if you’re comfortable building, and yeah, you can build it directly in

61 00:10:35.270 00:10:39.506 Uttam Kumaran: in snowflake, then I think we should go for that.

62 00:10:40.700 00:10:48.200 Uttam Kumaran: it’s just that, like making modifications to that is gonna land on you. It’s so that’s a it’s a tough. I feel like it’s not as easy to make modifications.

63 00:10:48.200 00:10:52.429 Payas Parab: Oh, it’s not at all yeah, it it sort of is like, even if you want to change a chart like.

64 00:10:52.620 00:10:53.090 Uttam Kumaran: Yeah.

65 00:10:53.400 00:11:04.259 Payas Parab: I mean, I’m speaking like, maybe like I I think, like I think if they hire a good they want to replace essentially like having a retained data consultancy with like an actual data analyst.

66 00:11:04.380 00:11:16.762 Payas Parab: If they know python, they should be able to figure it out like streamline isn’t hard like it isn’t like. It’s like St. Dot bar graph like it’s not like, oh, that it takes rocket science to figure out what to do there.

67 00:11:17.210 00:11:26.309 Payas Parab: So I think if they know python, they should be okay. I think we may want to check in on that with that before we move forward, because the hex is like.

68 00:11:26.320 00:11:36.070 Payas Parab: I think the person they’re gonna end up. Hiring is just gonna be like a sequel person. And some of the python scripting stuff may not be in their skill set, especially the budget they’re looking at right?

69 00:11:36.381 00:11:52.980 Payas Parab: So I think maybe it’s worth checking in. I think we’ll we’ll present both options to them on. Maybe that’s like a point of discussion tomorrow, of like what your users look like. We’re gonna start sharing intermediate tables and snowflake. Maybe we can even just like jot a few notes down of like snowflake versus sorry, streamlit versus

70 00:11:53.030 00:12:04.179 Payas Parab: like Meta, base versus whatever hex like just a quick, like couple of bullet points. So we can just get a decision from him based on what people are going to use it for. So then we can like make it.

71 00:12:04.400 00:12:07.790 Payas Parab: Yeah. And I think we’ll put. I’ll I’ll add some notes about like

72 00:12:08.280 00:12:19.709 Payas Parab: when you’re hiring someone to take on this responsibility. What the considerations are like they have to know python a little bit to be able to handle streamlit. But if they’re pure sequel, you’ll need to do like hex or something else.

73 00:12:20.160 00:12:26.950 Uttam Kumaran: Yeah, I think it’s also yeah. I mean, look, if it’s also just for one person, and they just want a dashboard. Then I would just say, Do it in Meta base

74 00:12:26.990 00:12:33.630 Uttam Kumaran: until like. And then again, I’m gonna find out from real like if they can add that functionality. But

75 00:12:33.860 00:12:48.919 Uttam Kumaran: the nice. The nice thing about about real is you just don’t need to do a lot of that stuff. So it saves a ton of time. But it it’s like you can do month over month. Pivot tables and like, have that stuff in there, but it’s not like as clean as like having a fixed

76 00:12:48.940 00:12:52.700 Uttam Kumaran: dashboard, but the dashboarding tools are expensive, so.

77 00:12:53.080 00:13:00.489 Nicolas Sucari: I mean, we we can’t like try to fix those dashboards using the bookmarks views in real.

78 00:13:01.280 00:13:05.670 Nicolas Sucari: I mean, I I know, isn’t like. It is not the nicest tool.

79 00:13:06.170 00:13:09.399 Uttam Kumaran: They just want to see like they want to see tiles like this is what.

80 00:13:09.400 00:13:10.209 Nicolas Sucari: I know, I know.

81 00:13:10.210 00:13:12.220 Uttam Kumaran: They’re used to this

82 00:13:12.550 00:13:13.260 Uttam Kumaran: for.

83 00:13:13.260 00:13:23.949 Nicolas Sucari: No, because I I was gonna say evidence then. But it’s pretty time consuming to set that set every dashboard in evidence, too. So yeah. Maybe scope with

84 00:13:24.320 00:13:25.500 Nicolas Sucari: with another one.

85 00:13:25.930 00:13:26.920 Uttam Kumaran: Yeah.

86 00:13:30.240 00:13:31.552 Uttam Kumaran: okay, so let’s

87 00:13:32.030 00:13:37.510 Uttam Kumaran: So like, I think we should let me let me find out from real. And then let’s in our meeting tomorrow. We can discuss.

88 00:13:37.900 00:13:38.570 Payas Parab: Yeah.

89 00:13:38.570 00:13:41.490 Uttam Kumaran: Are for for them on, like what their budget is like. This.

90 00:13:41.490 00:13:59.050 Payas Parab: And we can. We can also tell, like, there’s the the workaround also is like, we can just send links to Snowflake, right? That are like the data, is there? Because part of like the Cfo job ultimately is like turning this into reporting. So like, anyway, he’s gonna be in excel doing some of the stuff. So it’s really just a matter of, does he have access easily to that data? That’s reflected.

91 00:13:59.050 00:14:05.099 Uttam Kumaran: Saying like, does it? Does he just want like the raw data? Or does he actually like want like a Pdf of a dashboard?

92 00:14:05.100 00:14:17.169 Payas Parab: That that I don’t know. He like he like I tried to like. I tried to like make something in sheets, just to kind of show as proof of concept. And he’s like, well, I could have just done this myself. So I’m like, Okay, well, then, like.

93 00:14:17.740 00:14:19.230 Payas Parab: what do you want from me? Right?

94 00:14:19.230 00:14:23.709 Uttam Kumaran: That’s why that’s why I think like, for for those who are on the Excel side.

95 00:14:23.920 00:14:27.980 Uttam Kumaran: they don’t care if the colors of the thing are good.

96 00:14:27.980 00:14:29.720 Payas Parab: Yeah, they don’t care if it’s like an aesthetic.

97 00:14:29.720 00:14:37.010 Uttam Kumaran: They want the they just want the the export, and that that’s why I feel like he might like real. But I don’t know. Let’s see. And then.

98 00:14:37.010 00:15:04.379 Payas Parab: I think I think he’ll like real. I think he’ll like real, but it’s just like certain views. I know he wants Preset, where it’s just like every week. I’m just guessing he has responsibilities like the weekly report, right? The monthly investor report. And it’s just like, and he just know where that data is, and I don’t want to have to like, go hunt it down and then run a bunch of excel formulas. It’s like cool like Aov grew 10%. And I can like write that in the investor report. That’s my guess. Unfortunately. And you know, keep this very much. He’s just kind of a dick. So.

99 00:15:04.380 00:15:05.729 Uttam Kumaran: Yeah, it. Sounds like.

100 00:15:05.730 00:15:12.819 Payas Parab: He’s just kind of an asshole. So like, he’s not really helpful, like, he just says, Okay, this isn’t helpful, this. And like, I’m like, okay.

101 00:15:12.900 00:15:21.999 Payas Parab: like, that’s fine. I’m trying my best here dog. But he he’s just he’s just kind of a dick. So I think that also, like impacts the like.

102 00:15:22.000 00:15:22.430 Uttam Kumaran: Yeah.

103 00:15:22.430 00:15:37.130 Payas Parab: How much usability we get. And that’s why, like, when rill is ready, real, and some of these snowflake dashboards, I just want to dump it to him and be like cool. This is done. And then I put it in a sheet. 1 1 question I did have for you guys was, have you guys ever worked with like Google sheets

104 00:15:37.310 00:15:46.240 Payas Parab: from Snowflake like loading in data from a snowflake instance into Google sheets? Because then, also that spreadsheet I built him can just be an auto refreshable thing as well.

105 00:15:46.240 00:15:48.640 Uttam Kumaran: Yeah, the only problem is,

106 00:15:50.220 00:15:52.459 Uttam Kumaran: yeah, we’ve done it before.

107 00:15:54.010 00:15:57.349 Uttam Kumaran: I would say the better. Yeah, I mean, it’s just like

108 00:15:57.490 00:16:05.940 Uttam Kumaran: sometimes when we have pipelines that go to someplace like Google sheets. Then we get nervous about like people making a single change somewhere, and then it like

109 00:16:06.510 00:16:07.530 Uttam Kumaran: access to like

110 00:16:07.550 00:16:25.979 Uttam Kumaran: how that data gets refreshed. But we can also figure that out again. It’s just figuring out like the one thing we’ll do is like if we can put a couple of options in front of the Cfo and be like, what do you like? And why, then it’s easy for us to figure out like, okay, he cares about this. He doesn’t care about this. And it’s like, Okay, if you need a Csv of this table.

111 00:16:26.720 00:16:27.370 Payas Parab: Yeah, like that.

112 00:16:27.370 00:16:30.319 Uttam Kumaran: Google Sheet. Then we can make that happen.

113 00:16:30.320 00:16:30.670 Payas Parab: So.

114 00:16:30.670 00:16:32.409 Uttam Kumaran: Now, until it’s like, exactly like.

115 00:16:32.410 00:16:43.199 Payas Parab: So now we have the deliverables. Right? It’s like the Google sheet. Then we have the real. And then I maybe even like whatever I did in Google sheets. Maybe I’ll just like mock up a very basic version of it. And stream lit.

116 00:16:43.200 00:16:43.530 Uttam Kumaran: Yeah.

117 00:16:43.530 00:16:55.650 Payas Parab: We put, and then we have the spreadsheet as well. So we have, like 4 different ways that this is done, and like this is an iterative process we’re still working on, like all of the other things we’re working on. But we want some feedback on, like what is the most helpful to you.

118 00:16:55.650 00:16:56.240 Nicolas Sucari: Yeah.

119 00:16:56.240 00:17:00.089 Payas Parab: Without it. We can’t do like we will keep building everything else.

120 00:17:00.450 00:17:22.754 Payas Parab: But yeah, I think that’s I like that approach. Let’s just put everything like, let’s just bombard him essentially with like everything that we have potentially of like here, the 4 different delivery methods. The Google sheets, we can refresh Downside is, it breaks pretty easily. Right? Snowflake is like it’s not aesthetic, but it gets the job done. You can pull the data and we can format it for you.

121 00:17:23.280 00:17:24.680 Payas Parab: so yeah.

122 00:17:25.390 00:17:35.749 Payas Parab: okay, makes sense. I I’m I’m clear on that approach. I just wanna make sure you guys were kind of aware. And we figure out this component. But let’s let’s do what you said. I’ll I’ll take care of that. I’ll own that I’m just like

123 00:17:35.870 00:17:47.889 Payas Parab: I mean also, because you guys aren’t in touch with Cfo, I’ll just get in touch with them. Be like, here are the different options. Here’s what it looks like. This is what we’re working on and like, how we build the pipelines will be informed by which you like better. And what’s more effective for you.

124 00:17:50.070 00:17:50.680 Nicolas Sucari: Okay.

125 00:17:51.240 00:17:53.910 Uttam Kumaran: Are you able to log into real and like play around.

126 00:17:54.470 00:18:00.260 Payas Parab: I was able to view the online one. I’m still having trouble. It’s because, I use a windows computer.

127 00:18:01.230 00:18:01.850 Nicolas Sucari: Oh.

128 00:18:02.140 00:18:12.610 Nicolas Sucari: it’s okay, yeah, I think I should give you. Or if you go to the notion, to the real documentation there should be a different way of installing real in a way.

129 00:18:12.610 00:18:16.260 Payas Parab: Yeah, I tried that. And I’m still just having issues. I don’t.

130 00:18:17.800 00:18:22.719 Payas Parab: I don’t know. Cause I I have to use like like a Linux like.

131 00:18:22.720 00:18:23.470 Nicolas Sucari: Yeah.

132 00:18:23.790 00:18:28.250 Payas Parab: Like a Linux interpreter that I had to download and like. Then I run that and I’m just

133 00:18:28.790 00:18:37.629 Payas Parab: it, just I I it doesn’t even clear what the error is, because it is loading like I’m able to pull up local. But it’s like nothing is rendering, nor nothing is like.

134 00:18:37.680 00:18:42.650 Payas Parab: I can’t like edit anything, but it’s like, There, I’m in the real like local host pulls up real.

135 00:18:42.830 00:18:43.239 Uttam Kumaran: Oh, okay.

136 00:18:43.240 00:18:43.570 Nicolas Sucari: Okay.

137 00:18:43.570 00:18:49.440 Payas Parab: Stumped there as to like what like I got it downloaded. I got like into the repo and everything. But I’m just.

138 00:18:49.440 00:18:58.108 Nicolas Sucari: So if if you’re able to start it, maybe it’s an error between the connector with Snowflake with your snowflake credentials, or something like that.

139 00:18:58.430 00:19:13.499 Uttam Kumaran: Yeah, maybe, Nico, you probably just have to meet. If you guys just meet and like you go through, looks like locally, it’s probably just something small, because usually the way, if you, if you usually there’s an issue with you, just getting it up locally. So if you have it up, you’re close.

140 00:19:13.500 00:19:14.870 Payas Parab: That’s right.

141 00:19:14.870 00:19:15.529 Uttam Kumaran: Yeah, that’s.

142 00:19:15.530 00:19:16.570 Payas Parab: Tweet. Okay?

143 00:19:18.000 00:19:23.129 Payas Parab: Alright, yeah. Anika will. Maybe I’ll just ping you after if we have like 2 min, just to quickly go over it.

144 00:19:23.130 00:19:24.520 Nicolas Sucari: Yeah, of course.

145 00:19:24.950 00:19:26.479 Payas Parab: Alright awesome. Thank you.

146 00:19:28.110 00:19:28.920 Uttam Kumaran: Okay, cool.

147 00:19:31.590 00:19:35.030 Uttam Kumaran: Yeah. I know Brian isn’t on this meeting.

148 00:19:35.313 00:19:38.209 Uttam Kumaran: I can ask him. I’ll ask him to send his updates.

149 00:19:38.210 00:20:03.110 Payas Parab: Yeah, we are missing some data for, like from some of the gross margin, some of the stuff like, I think there’s just some data that’s missing a little bit. I just wanna check on that. There, there must be some other tables around like costing. And like cause we had those events like the events that fired an amplitude. Had that data so like it must exist somewhere, because I’m sure they were pulling. It was like some preset amplitude, configuration for shopify.

150 00:20:03.110 00:20:12.160 Payas Parab: So I I know it must be there, and I can send stuff in amplitude, or I can like see what it’s called. I also dug around the tables, and it’s like I just don’t see it.

151 00:20:12.380 00:20:12.770 Uttam Kumaran: Yeah.

152 00:20:12.770 00:20:25.069 Payas Parab: Figured out. The inventory cost stuff, but outside of that, like 3 pl. Pick and pack fees is what they call them, or 3 pl fees, logistics and the shipping. I think there is shipping cost in there, but

153 00:20:25.140 00:20:41.140 Payas Parab: it should be available on a per order base like I think there are sorry a per item basis. There’s like some estimated shipping that is important. So if you can get Brian to do those that will help us again. It’s it’s really about keeping this guy off my back, because he just anytime he message me irritates me. So

154 00:20:42.680 00:20:45.669 Payas Parab: sorry. I I really, yeah, this is just between us.

155 00:20:45.670 00:20:46.680 Uttam Kumaran: Yeah, yeah, makes sense.

156 00:20:46.680 00:20:48.730 Payas Parab: Boys, I’m only here. But yeah.

157 00:20:48.730 00:20:49.445 Uttam Kumaran: Yeah.

158 00:20:50.160 00:20:50.760 Payas Parab: Like.

159 00:20:50.760 00:20:54.519 Uttam Kumaran: No, I mean dude. This is the game like, especially in your world, and like

160 00:20:54.770 00:20:56.290 Uttam Kumaran: Bi and.

161 00:20:57.330 00:20:57.850 Nicolas Sucari: Yeah.

162 00:20:57.850 00:21:00.795 Uttam Kumaran: Just dealing with the people that are very, very subjective.

163 00:21:02.730 00:21:24.649 Payas Parab: So, okay. So I think that if he can figure that costing stuff out, that would be great. And the other thing I I think I I mentioned, I just wanna like, I know, we have a lot of other stuff going on. So. But I want to get on the like the other data sources we may want to integrate. Right? I think the tick tock, there’s definitely just like some issues with that, we need to check with them on if he can get us a source of truth like a dashboard, or like

164 00:21:24.690 00:21:41.890 Payas Parab: access to their Tiktok shop, so we can try and validate the Tiktok shop data, I’ve been told, looks off by Aman and Jared. So the Amazon. Sorry. Sorry. The Tiktok shop data that’s part of shopify. Something might be a little off on that. So I think we need to investigate that.

165 00:21:41.890 00:21:42.310 Nicolas Sucari: Okay.

166 00:21:42.310 00:21:42.855 Payas Parab: These

167 00:21:43.520 00:21:53.299 Payas Parab: like additional sources of truth on like marketing resources. So like marketing. Because one thing we’re not able to reconcile now, right is like we have the Ltv, we have like customer databases.

168 00:21:53.300 00:22:17.740 Payas Parab: but we need to like run that against like marketing, spend right? So where they’re spending on those types of details were available in amplitude. But we want to make sure that’s on the roadmap as well to get that data in there. So whether it’s like Facebook ads, data, Snapchat ads, data. I don’t know. Like all the sources they have, maybe that can also be an item to confirm with them on, and we want those in the because on the on the documentation and notion, I didn’t see that on the roadmap.

169 00:22:17.880 00:22:25.790 Payas Parab: So I wanted to make sure that that will be important, I think, as part of this whole reason for this is that that data can be stitched together easily.

170 00:22:27.290 00:22:47.050 Nicolas Sucari: Yeah, I think that’s fine. I mean, what you’re seeing on notion is based on our first, st yeah, on our 1st conversation with the man where we try to identify, like all of the sources that we have, and we agreed that 1st step was going to be shopify, and Amazon, the Tiktok information from shopify. I think it’s being marked with the tags that we have in shopify.

171 00:22:47.730 00:23:04.580 Nicolas Sucari: But yeah, I think we need to look a little bit deeper to to into that data, to understand where? Where are the differences that you’re seeing? And other sources? Yeah, we’ll need a man to share some access, maybe, so that we can start bringing that information in and see what reports can we create with that one.

172 00:23:05.200 00:23:06.019 Payas Parab: The other thing. Yeah.

173 00:23:06.020 00:23:17.009 Nicolas Sucari: But yeah, if you if you know for marketing stuff that they have Facebook or Google ads, accounts or anything, we we should ask Aman for access, and we can start taking a look there.

174 00:23:17.210 00:23:24.270 Payas Parab: That would be great. Let’s let’s add that to the itinerary for tomorrow, just because I I think I think that will be key for.

175 00:23:24.780 00:23:46.130 Payas Parab: like stitching all their data together. So they kind of want to build those bridges with the marketing data, the sales data. And we want to do that easily in sequel for them. So I think that needs to be yeah, we’ll have to ask him on, get that, and maybe he has to access. But I I think we should have that high priority. I also don’t want it to sneak up on us, basically where it comes up. And they’re like, Okay, cool. You have orders data. But like, I can pull orders.

176 00:23:46.560 00:23:57.680 Payas Parab: shopify like whoop, do you fucking? Do right? Like, it needs to be like your orders. Data stitch together with your customer profile, stitch together with your marketing like, we need to build that whole

177 00:23:57.760 00:24:02.989 Payas Parab: pipeline by the end of December. So I wanna make sure we’re we’re ready for that and we have access.

178 00:24:03.686 00:24:12.249 Payas Parab: So that that’s the other one. And the other thing I had as well. Was like for amplitude data. I I think that’s on the documentation I think I saw.

179 00:24:12.770 00:24:15.130 Payas Parab: is it? Or am I blanking.

180 00:24:16.840 00:24:25.109 Payas Parab: Like the data actually, from amplitude, right? The events and things like that are. There’s a way to kind of aggregate the snowflake databases. Is that

181 00:24:25.520 00:24:27.900 Payas Parab: cause, anyway? Amplitude uses Snowflake right?

182 00:24:28.850 00:24:32.070 Uttam Kumaran: Yeah, probably a question for Brian. I’m not exactly sure

183 00:24:32.120 00:24:36.459 Uttam Kumaran: we can. I mean, we can get the data via 5 tran into Snowflake.

184 00:24:37.462 00:24:40.860 Uttam Kumaran: But I don’t know if we have. I don’t think we have the amplitude data there.

185 00:24:41.370 00:24:46.099 Nicolas Sucari: No, I I think we don’t have it there. We only have Amazon and shopify, I think.

186 00:24:48.520 00:24:51.520 Nicolas Sucari: But yeah, I’m gonna ask Brian if you want, because I’m not sure.

187 00:24:51.520 00:24:52.570 Payas Parab: It’s bad

188 00:24:52.760 00:25:00.600 Payas Parab: again on the roadmap of like when we deliver at the end of December. We just want to show that this is all set up. The amplitude events

189 00:25:00.780 00:25:12.109 Payas Parab: again. Like to what extent, what events we save. I mean, that’s a shit ton of data. So we don’t need to like, move all of it into Snowflake. But certain critical event data. I think we also need to put into the data warehouse as well.

190 00:25:13.380 00:25:18.740 Nicolas Sucari: Okay, maybe if we don’t want to get all of those, all of that data, because I think it will

191 00:25:20.520 00:25:23.489 Nicolas Sucari: be reflected on the costs if we bring all of it.

192 00:25:23.887 00:25:29.629 Nicolas Sucari: We need to understand which events you want, and and we can go directly for them.

193 00:25:29.840 00:25:34.300 Nicolas Sucari: because if not getting everything through Fivetran may increase the cost.

194 00:25:34.654 00:25:44.579 Payas Parab: Want it from 5 Tran. I believe there’s some type of native snowflake amplitude integration, because they already, I believe, amplitude stores their data and snowflake as well.

195 00:25:44.750 00:25:54.749 Payas Parab: So like, anyway, they’re storing the data in Snowflake. So I believe there’s some type of a native integration that can help us move the data, or at least access it from our data warehouse.

196 00:25:56.510 00:25:57.990 Nicolas Sucari: Okay. Okay.

197 00:25:58.402 00:26:02.610 Nicolas Sucari: Excellent. Well, maybe you can show us which are those events, and we can try to.

198 00:26:02.610 00:26:03.740 Payas Parab: Yeah, we

199 00:26:04.260 00:26:28.859 Payas Parab: if you guys get there like, what I would love from you guys is to set up the or just help me understand what the infra is to like, move it over right like, is it like they continue to store it? Can we move data if we have to move it. I can help you narrow down the list essentially of like, okay, we can connect via 5 trend to amplitude and then pull data. And like, I can get from amplitude. I can go and amplitude myself, and just get you the list of what I think are critical.

200 00:26:29.142 00:26:37.900 Payas Parab: But I think there is some. There’s something unique. Robert knows this. Maybe I Robert’s just getting back from vacation. Maybe we need to just ping him in the chat.

201 00:26:37.900 00:26:38.310 Nicolas Sucari: Compare.

202 00:26:38.310 00:26:42.289 Payas Parab: He. He’s worked with this before, though I think he’s done something related to this.

203 00:26:43.600 00:26:48.152 Payas Parab: Yeah, maybe let me let me just ping him right now. He’s probably in transit right now.

204 00:26:49.110 00:26:50.160 Payas Parab: But.

205 00:26:50.320 00:26:51.290 Payas Parab: baby.

206 00:26:51.400 00:26:53.829 Payas Parab: let me pull that snowflake

207 00:26:54.490 00:26:56.770 Payas Parab: one or 2

208 00:27:00.060 00:27:09.729 Payas Parab: great. Okay? Yeah. Just wanted to put that on your radar as well, because I think that event data will be will be part of the story of everything’s in your warehouse now. Yeah.

209 00:27:12.070 00:27:12.730 Nicolas Sucari: Okay.

210 00:27:13.688 00:27:20.789 Nicolas Sucari: Okay. Excellent. Do you wanna stay like 2 min and try to figure out your bill locally what’s going on.

211 00:27:20.790 00:27:27.200 Payas Parab: Yup, wanted to just check with you guys. Is there anything I owe you guys? There’s a chance that it kind of slipped through the cracks. Is there anything that I

212 00:27:27.260 00:27:31.506 Payas Parab: didn’t get you guys or told you I was gonna review, but didn’t actually do.

213 00:27:32.830 00:27:33.720 Nicolas Sucari: I don’t think so.

214 00:27:33.720 00:27:38.830 Uttam Kumaran: Oh, I’m just gonna I’m just gonna message Brian to just get updates in slack. Yeah.

215 00:27:38.830 00:27:43.610 Payas Parab: Okay, yeah, and feel free to like ping me harass me if I if I forget something I owe you guys.

216 00:27:44.010 00:27:44.750 Uttam Kumaran: Okay. Cool.

217 00:27:45.310 00:27:49.135 Uttam Kumaran: Okay, Nico. I’ll I’ll let you stay on with Pius, and then I’m gonna.

218 00:27:49.390 00:27:51.260 Payas Parab: Appreciate it. Thank you, Tom.

219 00:27:51.260 00:27:52.770 Nicolas Sucari: Okay, bye, your time.

220 00:27:54.230 00:28:02.090 Nicolas Sucari: do you wanna share? Yeah, no, don’t worry. I think it’s fine. I mean, if you already started real you’re like, really, really, close on.

221 00:28:02.090 00:28:02.580 Payas Parab: Yeah.

222 00:28:02.580 00:28:03.619 Nicolas Sucari: It, to work.

223 00:28:06.535 00:28:08.319 Payas Parab: Sharing my screen now.

224 00:28:08.880 00:28:11.809 Payas Parab: Sorry it’s vertical. Oh, that’s annoying!

225 00:28:12.183 00:28:12.930 Nicolas Sucari: No problem.

226 00:28:12.930 00:28:14.710 Payas Parab: It to a horizontal screen.

227 00:28:14.710 00:28:17.259 Nicolas Sucari: Are you using Vs code or.

228 00:28:18.296 00:28:23.499 Payas Parab: I usually use I use Vs code, but I’ve started switching the cursor now.

229 00:28:24.110 00:28:24.770 Nicolas Sucari: Okay.

230 00:28:25.080 00:28:35.050 Payas Parab: Cause. It’s like the AI enhanced one. I don’t know if you’ve seen that. It’s pretty cool, though, like all these AI coding tools, they’re all overhyped, but it’s like kind of mildly helpful.

231 00:28:35.595 00:28:36.870 Payas Parab: Let me just.

232 00:28:37.490 00:28:39.040 Payas Parab: I lost the window.

233 00:28:40.200 00:28:43.290 Payas Parab: I’m just getting used to this like Linux thing. Here.

234 00:28:44.350 00:28:46.719 Payas Parab: let me see, navigate to further.

235 00:28:47.470 00:28:52.439 Payas Parab: And then I’ll see on the screen. Yeah, basically, I need to like, get to the folder. There’s like a special path

236 00:28:52.860 00:28:55.928 Payas Parab: that I can do it in from this terminal.

237 00:29:25.370 00:29:27.349 Payas Parab: give me a second my apologies.

238 00:29:30.130 00:29:31.849 Payas Parab: something like this. Yeah.

239 00:29:37.620 00:29:40.510 Nicolas Sucari: We already installed Wsl.

240 00:29:42.290 00:29:42.670 Payas Parab: That’s a good.

241 00:29:42.670 00:29:44.440 Nicolas Sucari: One to one already dealt.

242 00:29:44.440 00:29:47.860 Payas Parab: Yeah, yeah. That’s yeah. What you’re seeing on the screen is the

243 00:29:49.590 00:29:50.170 Nicolas Sucari: Yeah.

244 00:29:50.570 00:29:51.990 Payas Parab: So then I can.

245 00:29:54.300 00:29:56.089 Nicolas Sucari: Javi, yeah, I think is.

246 00:30:00.380 00:30:01.779 Payas Parab: Let’s put it in.

247 00:30:05.140 00:30:06.140 Payas Parab: Oh, sorry!

248 00:30:09.510 00:30:10.880 Payas Parab: There it is.

249 00:30:13.240 00:30:14.460 Payas Parab: Should be

250 00:30:15.940 00:30:19.210 Payas Parab: onedrive, dash, desktop dash.

251 00:30:19.620 00:30:20.300 Payas Parab: So

252 00:30:20.800 00:30:23.180 Payas Parab: everything dash, is it? Just Joby.

253 00:30:27.430 00:30:31.669 Nicolas Sucari: No, I think it’s not. I think you’re missing the B in pub.

254 00:30:31.980 00:30:32.969 Payas Parab: Correct. Thank you.

255 00:30:33.572 00:30:35.379 Nicolas Sucari: There we go!

256 00:30:35.870 00:30:36.870 Payas Parab: Joby, cocko.

257 00:30:36.870 00:30:38.370 Nicolas Sucari: Including chubby coffee.

258 00:30:39.000 00:30:42.790 Payas Parab: Sweet. Okay? So then I just do like, isn’t it? Just like the command is just real.

259 00:30:43.270 00:30:47.439 Nicolas Sucari: First.st Yeah. But you need to go to the Javi Javi coffee reel folder.

260 00:30:47.840 00:30:49.530 Payas Parab: Oh, into that folder.

261 00:30:49.530 00:30:51.580 Nicolas Sucari: Yeah, go into that folder first.st

262 00:30:52.570 00:30:53.110 Payas Parab: Okay.

263 00:30:53.110 00:30:54.680 Nicolas Sucari: Audio start if you want.

264 00:30:57.530 00:31:01.240 Nicolas Sucari: and these should open locally and load the sources.

265 00:31:04.510 00:31:08.509 Nicolas Sucari: Also, you have another process running on that locally.

266 00:31:09.570 00:31:12.459 Nicolas Sucari: Did you have another window there, maybe.

267 00:31:12.460 00:31:16.690 Payas Parab: Yeah. It’s possible that I was like playing around with it this morning. Let me kill

268 00:31:17.850 00:31:20.810 Payas Parab: that process. I don’t know how.

269 00:31:22.140 00:31:26.086 Payas Parab: Give me a second. Let me ask Chat. Gp. Sorry it’s all new for me.

270 00:31:26.350 00:31:27.630 Nicolas Sucari: Yeah, that’s fine.

271 00:31:27.860 00:31:33.209 Payas Parab: You know, like, when you set up your environment, exactly how you like it. And then suddenly, there’s like.

272 00:31:33.820 00:31:35.240 Payas Parab: okay on Linux.

273 00:31:35.240 00:31:35.940 Nicolas Sucari: Hmm.

274 00:31:36.210 00:31:37.050 Payas Parab: We’ll let you take.

275 00:31:37.050 00:31:39.589 Nicolas Sucari: Don’t know about this. I use Mac. I’m a.

276 00:31:39.590 00:31:40.080 Payas Parab: Thank you.

277 00:31:40.080 00:31:41.467 Nicolas Sucari: Thank you, sir.

278 00:31:42.600 00:31:48.689 Nicolas Sucari: and I I don’t have like a technical background. So I’m also learning a lot doing all this kind of stuff.

279 00:31:48.690 00:31:49.240 Payas Parab: Yeah.

280 00:31:49.240 00:31:50.020 Nicolas Sucari: But yeah.

281 00:31:50.690 00:31:53.890 Payas Parab: It’s crazy like this is the hardest part about coding. It’s just like it’s like.

282 00:31:53.890 00:31:54.330 Nicolas Sucari: Yeah.

283 00:31:54.770 00:31:55.749 Payas Parab: It’s this far.

284 00:31:57.310 00:32:00.820 Nicolas Sucari: Yeah, not coding. It’s getting the things ready.

285 00:32:01.120 00:32:02.030 Payas Parab: Yeah.

286 00:32:03.120 00:32:07.440 Payas Parab: Pid, okay, so then I’ll just kill that. So if I do.

287 00:32:07.590 00:32:09.280 Payas Parab: negative, 9

288 00:32:09.710 00:32:11.660 Payas Parab: Pid is 8 into 2.

289 00:32:16.760 00:32:18.550 Payas Parab: Yep, there we go.

290 00:32:27.030 00:32:30.309 Payas Parab: I think it is running right. Local host. I just gotta find.

291 00:32:34.110 00:32:34.710 Nicolas Sucari: Yeah.

292 00:32:39.740 00:32:42.960 Payas Parab: By the way, how many clients do you guys manage at a time? Sort of curious.

293 00:32:44.392 00:32:48.330 Nicolas Sucari: So right now we’re kind of managing

294 00:32:49.200 00:32:51.930 Nicolas Sucari: kind of 3 or 4.

295 00:32:52.200 00:32:53.050 Payas Parab: Okay.

296 00:32:55.310 00:33:01.129 Nicolas Sucari: But yeah, the idea, I mean the I it it depends on the client and the amount of hours that.

297 00:33:01.130 00:33:01.700 Payas Parab: Yeah.

298 00:33:01.700 00:33:08.780 Nicolas Sucari: We that they book with us. But yeah, it depends. We have more engineers, and they’re trying to grow a little bit more cloud.

299 00:33:08.780 00:33:09.360 Payas Parab: Yeah.

300 00:33:09.360 00:33:09.980 Nicolas Sucari: For now.

301 00:33:11.380 00:33:16.740 Nicolas Sucari: So that is working. If you click on. Yeah, the model is working, I think.

302 00:33:16.810 00:33:19.610 Nicolas Sucari: Click on the on the model file

303 00:33:19.800 00:33:20.699 Nicolas Sucari: on the left.

304 00:33:21.400 00:33:22.730 Payas Parab: Models. Okay.

305 00:33:22.730 00:33:25.099 Nicolas Sucari: Models on that file. Yeah.

306 00:33:26.860 00:33:28.870 Nicolas Sucari: let let’s see if these loads.

307 00:33:28.930 00:33:32.280 Nicolas Sucari: and if you click on sources, everything is loading right.

308 00:33:32.890 00:33:35.869 Payas Parab: Yeah, yeah, it just seems it’s the dashboard.

309 00:33:36.240 00:33:41.749 Nicolas Sucari: The dashboard. Yeah, I already fixed that. But if you wanna do it locally, I I don’t know if you pulled already the new.

310 00:33:41.750 00:33:45.359 Payas Parab: Oh, there! So there was just an upstream error. Then there was actually a.

311 00:33:46.100 00:33:50.710 Nicolas Sucari: Okay, but don’t worry. I mean delete the dashboard and do it again. If you want.

312 00:33:55.970 00:33:56.930 Payas Parab: Oh!

313 00:33:57.290 00:34:07.040 Nicolas Sucari: Yeah, I I already I already changed some stuff, but I don’t know why. If if the dashboard is not working, just delete it and create a new one if you want.

314 00:34:09.070 00:34:12.159 Nicolas Sucari: so you can click there on the 3 dots next to the name.

315 00:34:12.880 00:34:13.520 Nicolas Sucari: Left

316 00:34:13.820 00:34:15.610 Nicolas Sucari: just delete this dashboard.

317 00:34:15.960 00:34:16.710 Payas Parab: Yeah.

318 00:34:16.710 00:34:18.549 Nicolas Sucari: Go to the model. Now.

319 00:34:20.429 00:34:22.499 Nicolas Sucari: Did you delete it? I know. Okay.

320 00:34:22.500 00:34:24.420 Payas Parab: I didn’t know it. No

321 00:34:26.735 00:34:27.590 Payas Parab: Delete

322 00:34:28.440 00:34:29.589 Payas Parab: failed to delete.

323 00:34:29.590 00:34:30.659 Nicolas Sucari: To the

324 00:34:33.900 00:34:35.510 Nicolas Sucari: what was saying.

325 00:34:40.110 00:34:41.400 Payas Parab: No such.

326 00:34:42.949 00:34:45.599 Payas Parab: Maybe it did delete. It just didn’t refresh here.

327 00:34:47.860 00:34:51.860 Payas Parab: It says it doesn’t exist. So I’m like that means it probably already got deleted.

328 00:34:52.940 00:34:54.129 Nicolas Sucari: Yeah, but okay.

329 00:34:54.130 00:34:54.830 Payas Parab: Host.

330 00:34:54.830 00:34:58.050 Nicolas Sucari: But if you want, if not, yeah, check the file.

331 00:34:58.050 00:35:01.040 Payas Parab: It did. It did get deleted. Yeah, it did get deleted. It’s just not refreshed.

332 00:35:01.040 00:35:03.790 Nicolas Sucari: Okay, maybe re-refresh this one. If you want

333 00:35:05.050 00:35:06.650 Nicolas Sucari: refresh local host.

334 00:35:08.150 00:35:10.270 Nicolas Sucari: let’s see if that fixes.

335 00:35:10.560 00:35:13.420 Nicolas Sucari: If not, yeah, I think you don’t have the.

336 00:35:13.580 00:35:15.409 Nicolas Sucari: Or if you go to dashboard.

337 00:35:16.470 00:35:20.739 Nicolas Sucari: you’re in the model. Go to dashboard. Yeah, it doesn’t found the dashboard.

338 00:35:24.160 00:35:25.360 Payas Parab: Okay. Now it’s gone.

339 00:35:25.960 00:35:27.980 Nicolas Sucari: It’s gone. Okay, so go to the model again.

340 00:35:28.430 00:35:29.160 Payas Parab: Yeah.

341 00:35:30.460 00:35:35.249 Nicolas Sucari: And why it says, Go to dashboard. This is weird and not create dashboard.

342 00:35:35.870 00:35:37.099 Nicolas Sucari: Let me check

343 00:35:37.180 00:35:39.440 Nicolas Sucari: quick check on your user.

344 00:35:40.550 00:35:43.659 Nicolas Sucari: I don’t know if I can check your user from here. But let me see.

345 00:35:43.880 00:35:47.720 Payas Parab: I mean, I’m not logged in. No, it’s local, right?

346 00:35:48.750 00:35:50.170 Nicolas Sucari: It’s local. Yeah. But

347 00:35:52.340 00:35:53.350 Nicolas Sucari: yeah.

348 00:36:14.710 00:36:21.739 Nicolas Sucari: and check you’re logged in in local host. If you go to like, yeah, you’re not logged in right.

349 00:36:23.350 00:36:27.540 Nicolas Sucari: Let me create. Oh, okay, do you? You are now with what email.

350 00:36:29.050 00:36:30.470 Payas Parab: I’m logged in now.

351 00:36:32.515 00:36:33.969 Nicolas Sucari: Okay, with your

352 00:36:34.290 00:36:37.460 Nicolas Sucari: this is that if you go to your terminal.

353 00:36:39.540 00:36:40.590 Nicolas Sucari: can you

354 00:36:42.680 00:36:44.910 Nicolas Sucari: run the command real user list.

355 00:36:45.970 00:36:47.679 Nicolas Sucari: not on your email.

356 00:36:49.390 00:36:50.709 Payas Parab: Sorry. Go to where?

357 00:36:51.480 00:36:53.180 Nicolas Sucari: Go to the terminal where you

358 00:36:53.430 00:36:55.060 Nicolas Sucari: did real start.

359 00:36:55.060 00:36:55.850 Payas Parab: Alright!

360 00:36:56.640 00:36:59.810 Nicolas Sucari: Try running real user list to check the users.

361 00:37:00.820 00:37:03.790 Payas Parab: Real user list, one word.

362 00:37:04.370 00:37:07.930 Nicolas Sucari: Yes. User. Space list. Sorry.

363 00:37:12.200 00:37:13.960 Payas Parab: No organization is set.

364 00:37:16.010 00:37:17.060 Nicolas Sucari: Wait!

365 00:37:18.310 00:37:20.460 Nicolas Sucari: Why don’t you have the organizer?

366 00:37:22.560 00:37:24.130 Nicolas Sucari: Let me check.

367 00:37:36.300 00:37:37.949 Nicolas Sucari: Go to real

368 00:37:38.080 00:37:40.420 Nicolas Sucari: org, create space

369 00:37:41.730 00:37:43.400 Nicolas Sucari: or real org

370 00:37:43.660 00:37:45.699 Nicolas Sucari: list, maybe missing.

371 00:37:46.160 00:37:46.950 Nicolas Sucari: Sorry.

372 00:37:47.200 00:37:50.170 Nicolas Sucari: Go, just kill it. If you want.

373 00:37:51.100 00:37:52.890 Nicolas Sucari: go to real org list.

374 00:37:56.100 00:37:56.640 Payas Parab: Hmm.

375 00:37:56.640 00:37:58.470 Nicolas Sucari: Chubby coffee. Okay? So now.

376 00:37:58.660 00:38:04.339 Nicolas Sucari: so that organization exists. So how we select that one, let me check

377 00:38:09.390 00:38:11.389 Nicolas Sucari: relearn switch. Maybe.

378 00:38:17.110 00:38:18.110 Nicolas Sucari: Yeah, okay.

379 00:38:18.240 00:38:19.540 Nicolas Sucari: is correct. And.

380 00:38:19.540 00:38:23.900 Payas Parab: You hit. Enter. Okay, set default organization to Jarvi coffee.

381 00:38:25.540 00:38:26.100 Payas Parab: Naturally.

382 00:38:26.100 00:38:27.859 Nicolas Sucari: Do the ring user list.

383 00:38:28.120 00:38:34.090 Nicolas Sucari: Reuse our list first.st If you want check, let’s check that user sees for you.

384 00:38:34.450 00:38:37.129 Nicolas Sucari: Okay, you don’t have. Let me see

385 00:38:40.450 00:38:42.819 Nicolas Sucari: real user, add

386 00:38:43.550 00:38:46.979 Nicolas Sucari: admin, and let me see your email.

387 00:38:49.810 00:38:54.230 Nicolas Sucari: I mean, this is locally. But if I maybe if I add this and deploy.

388 00:38:54.620 00:38:56.500 Nicolas Sucari: this can help you

389 00:38:56.870 00:38:58.629 Nicolas Sucari: with something. I’m not sure.

390 00:38:59.400 00:39:00.190 Nicolas Sucari: Okay.

391 00:39:03.600 00:39:07.540 Nicolas Sucari: but you should be able. Try real start and see if

392 00:39:08.820 00:39:09.960 Nicolas Sucari: if that works

393 00:39:20.050 00:39:21.419 Nicolas Sucari: go to local host.

394 00:39:31.600 00:39:32.430 Payas Parab: Okay.

395 00:39:35.350 00:39:37.160 Payas Parab: No, I don’t see anything.

396 00:39:38.850 00:39:39.960 Nicolas Sucari: Why

397 00:39:41.930 00:39:44.730 Nicolas Sucari: can can you open the repo on.

398 00:39:44.930 00:39:49.720 Nicolas Sucari: on, on this code or anything, so that we can see if there was any change.

399 00:39:49.720 00:39:51.539 Payas Parab: Yeah, let me.

400 00:39:53.580 00:39:55.209 Nicolas Sucari: You’re gonna open up a new.

401 00:39:56.150 00:39:57.010 Nicolas Sucari: We do

402 00:40:05.010 00:40:06.299 Nicolas Sucari: chubby coffee. There.

403 00:40:16.700 00:40:19.870 Payas Parab: And I see no dashboards. I do see sources.

404 00:40:20.220 00:40:22.379 Nicolas Sucari: Go to Emv file.

405 00:40:23.680 00:40:25.000 Payas Parab: Oh! Which one.

406 00:40:25.000 00:40:27.109 Nicolas Sucari: Dot. Tmv, did that one? Yeah.

407 00:40:27.510 00:40:38.260 Nicolas Sucari: So you have everything there. That’s fine. Open the the term. The term not here is the second icon there on the top left. Do you have?

408 00:40:38.890 00:40:39.830 Nicolas Sucari: Yeah.

409 00:40:39.830 00:40:40.200 Payas Parab: Not in.

410 00:40:40.200 00:40:45.600 Nicolas Sucari: Sorry. Sorry top right? Top, right? Top, right? Yeah. The the one that’s that one

411 00:40:47.720 00:40:53.880 Nicolas Sucari: that terminal and do real start sorry. CD, to the Javi coffee. Real folder first.st

412 00:40:54.510 00:40:56.130 Payas Parab: Yeah. Oh, oh.

413 00:40:56.632 00:40:59.790 Payas Parab: the real won’t work here on the terminal. I have to use the.

414 00:41:00.370 00:41:02.550 Nicolas Sucari: Oh, you. You okay.

415 00:41:04.340 00:41:06.120 Payas Parab: Wsl. Or whatever.

416 00:41:08.450 00:41:11.639 Nicolas Sucari: And go to see what changes you have here. You have the temp.

417 00:41:11.650 00:41:14.030 Nicolas Sucari: the temporary changes. There.

418 00:41:15.200 00:41:17.189 Payas Parab: This real.ml.

419 00:41:17.770 00:41:19.199 Nicolas Sucari: No, that’s fine.

420 00:41:21.410 00:41:22.750 Payas Parab: This one

421 00:41:23.730 00:41:26.310 Payas Parab: looks like there’s some weird, duplicate thing.

422 00:41:27.520 00:41:30.219 Nicolas Sucari: No. But this is okay. Yeah. Do you? Can you delete.

423 00:41:30.220 00:41:31.020 Payas Parab: Or maybe

424 00:41:32.030 00:41:33.597 Payas Parab: pull from the remote.

425 00:41:34.890 00:41:36.909 Nicolas Sucari: Yeah, maybe if you can do that.

426 00:41:36.910 00:41:38.019 Payas Parab: Yeah, let me

427 00:41:39.230 00:41:41.900 Payas Parab: let me discard these changes.

428 00:41:42.490 00:41:43.470 Payas Parab: Yeah.

429 00:41:54.640 00:42:00.770 Nicolas Sucari: The issue is about these terminals, and that you need the environment because everything is there. The files are there.

430 00:42:01.050 00:42:02.550 Nicolas Sucari: Oh, yeah.

431 00:42:03.030 00:42:05.300 Nicolas Sucari: maybe it’s a mess up with the environment.

432 00:42:06.480 00:42:09.929 Nicolas Sucari: You’re doing fine and and be before when we loaded.

433 00:42:10.180 00:42:14.120 Nicolas Sucari: When you started real, you have the sources. And they were loading.

434 00:42:16.440 00:42:17.800 Payas Parab: Remove, that

435 00:42:34.270 00:42:35.930 Payas Parab: is, it called main.

436 00:42:37.060 00:42:38.130 Nicolas Sucari: Main, yeah.

437 00:42:42.540 00:42:43.670 Payas Parab: Sweet. Okay?

438 00:42:44.300 00:42:46.570 Payas Parab: And then maybe let me go back to

439 00:42:47.840 00:42:51.319 Payas Parab: my local host. See if anything pulled through.

440 00:42:55.710 00:42:56.650 Payas Parab: Okay.

441 00:42:57.050 00:43:07.000 Payas Parab: maybe it just needs a little bit of a reset. I don’t know what happened. But this work, this. So okay, send models. Let’s see if that data loads right? Okay, it looks like it’s loading right? So the permission.

442 00:43:07.000 00:43:07.690 Nicolas Sucari: Excellent.

443 00:43:08.450 00:43:11.769 Payas Parab: And then this dashboard. Let’s check here. Okay.

444 00:43:12.500 00:43:13.300 Payas Parab: alright me.

445 00:43:13.300 00:43:17.690 Nicolas Sucari: You can update or preview. Yeah, because I don’t know if this is from the old one.

446 00:43:17.860 00:43:18.290 Payas Parab: Yeah.

447 00:43:18.290 00:43:24.310 Nicolas Sucari: Yeah, this is kind of strange, because it’s it appears there, but it that you don’t have it like if you go to the model.

448 00:43:25.950 00:43:26.610 Payas Parab: Yeah.

449 00:43:27.100 00:43:31.159 Nicolas Sucari: It says, create new dashboard. So maybe generate a new dashboard. Yeah.

450 00:43:31.200 00:43:33.590 Nicolas Sucari: let’s this generate a new one

451 00:43:35.100 00:43:36.630 Nicolas Sucari: this way. It will work.

452 00:43:42.310 00:43:43.390 Nicolas Sucari: Let’s wait.

453 00:44:07.810 00:44:09.960 Nicolas Sucari: I don’t know why it’s taking so long.

454 00:44:10.560 00:44:11.290 Payas Parab: Yeah.

455 00:44:12.080 00:44:13.840 Nicolas Sucari: Can. Can you refresh this

456 00:44:14.320 00:44:15.200 Nicolas Sucari: and localhost

457 00:44:16.050 00:44:16.750 Nicolas Sucari: something.

458 00:44:19.680 00:44:23.409 Payas Parab: If it’s really this much of a pain, I do have a Mac

459 00:44:23.510 00:44:31.629 Payas Parab: specifically for like this. So if our time is better, use of me just having carried 2 laptops. When I’m working on this during the day.

460 00:44:32.170 00:44:35.230 Payas Parab: I’ll live. Yeah, I’m okay to.

461 00:44:36.280 00:44:38.290 Nicolas Sucari: Don’t worry. We can try, but

462 00:44:38.420 00:44:39.760 Nicolas Sucari: it should work.

463 00:44:40.000 00:44:40.780 Payas Parab: Oh! Whoops!

464 00:44:40.780 00:44:42.859 Nicolas Sucari: You know why that he doesn’t find

465 00:44:42.930 00:44:44.869 Nicolas Sucari: it is still loading this one.

466 00:44:46.460 00:44:51.050 Nicolas Sucari: and you don’t. Did you have anything changing the code like any file update.

467 00:44:51.050 00:44:54.390 Payas Parab: So yeah, I just hard push or hard pulled all the.

468 00:44:55.210 00:44:56.290 Nicolas Sucari: Yeah, that’s fine.

469 00:44:56.570 00:44:56.950 Payas Parab: Yeah.

470 00:44:56.950 00:44:58.019 Nicolas Sucari: Should work.

471 00:45:00.210 00:45:07.240 Nicolas Sucari: I don’t know why, the because the the issue is on the on the dashboard. But if you go to the model, the model is working and the data is there.

472 00:45:07.270 00:45:11.759 Nicolas Sucari: So we need to find a way to delete that dashboard and like start from scratch.

473 00:45:12.440 00:45:28.200 Payas Parab: I’m also like, like, if it comes down to like checking how the dashboard is rendering. If I can just model stuff here in the models and like, just send you the sequel query. And we just update it. That that’s okay with me. Frankly, I think that it’s just like

474 00:45:28.400 00:45:38.980 Payas Parab: this thing is really not made for writing custom sequel at the end of the day. Right? It would just be like the all you would get from this is just like getting rid of excess columns. Everything else should just operate.

475 00:45:38.980 00:45:39.490 Nicolas Sucari: Oh!

476 00:45:39.490 00:45:40.150 Payas Parab: Right.

477 00:45:40.150 00:45:46.479 Nicolas Sucari: Yeah. But I mean, if you want to write custom sequel, you can write it up there. I mean, you can do whatever you want here.

478 00:45:48.030 00:45:48.540 Payas Parab: Okay.

479 00:45:48.540 00:45:52.840 Nicolas Sucari: See on there, where? Where you have the query at the top. I mean, you can write whatever you want.

480 00:45:52.840 00:45:53.300 Payas Parab: Yeah, yeah.

481 00:45:53.672 00:45:58.510 Nicolas Sucari: Save like in the file, in the model. And then we can create.

482 00:45:58.510 00:46:06.650 Payas Parab: If I’ve made like monthly cuts, right like if I do a group by 4 month, there’s no point in doing that here, because, anyway, you put in the Time series.

483 00:46:07.170 00:46:10.550 Nicolas Sucari: Exactly no point for doing that crap by time series.

484 00:46:10.890 00:46:12.649 Payas Parab: Yeah. Okay. Alright.

485 00:46:12.950 00:46:23.070 Nicolas Sucari: I mean, if you want to do like any modeling like joining to columns, summing to different things. That’s that’s like kind of the stuff that you want to do on that model

486 00:46:23.190 00:46:25.380 Nicolas Sucari: like SQL. Modeling files.

487 00:46:25.390 00:46:32.360 Nicolas Sucari: And then we can create any dashboards. But if you wanna like, do cuts by time series. That’s maybe

488 00:46:32.580 00:46:33.629 Nicolas Sucari: yeah. Not worth.

489 00:46:33.630 00:46:33.970 Payas Parab: Because.

490 00:46:33.970 00:46:39.289 Nicolas Sucari: We can do it later with filters or any other stuff in the real Ui.

491 00:46:39.590 00:46:52.539 Payas Parab: I’m comfortable with, like, yeah, at the end of the day, anyway, the the dashboarding, I think, will happen in stream lit or hex, or whatever tool we decide on. So either way, I’m I’m it’s okay. If I don’t fully get real up and running, I like real

492 00:46:53.280 00:46:56.994 Payas Parab: as just like their self service tool. And I can make updates like

493 00:46:57.720 00:47:00.640 Payas Parab: to the like, the schema right to the model.

494 00:47:00.650 00:47:05.810 Payas Parab: just to pull in only the relevant columns and things like that that I can just do directly.

495 00:47:06.660 00:47:10.359 Nicolas Sucari: Okay, let me try showing you how it should work.

496 00:47:10.690 00:47:14.330 Nicolas Sucari: But this is okay. We have the sources. All are loading.

497 00:47:14.470 00:47:15.799 Nicolas Sucari: You can check here

498 00:47:17.644 00:47:25.220 Nicolas Sucari: there. So these are fine. The models are okay. And if you do any change here, for example, I don’t know

499 00:47:25.450 00:47:26.560 Nicolas Sucari: where

500 00:47:26.930 00:47:32.910 Nicolas Sucari: something, or if I do any change here. I’m already seeing like the change. Here, you see.

501 00:47:32.910 00:47:34.080 Payas Parab: Yeah, yeah.

502 00:47:34.780 00:47:35.500 Payas Parab: it’s it’s.

503 00:47:35.500 00:47:36.170 Nicolas Sucari: That’s how like.

504 00:47:36.170 00:47:39.840 Payas Parab: The windows. Yeah, the windows just doesn’t work as well, which I I could.

505 00:47:40.370 00:47:42.660 Nicolas Sucari: It’s possible. Yeah. And

506 00:47:42.750 00:47:47.240 Nicolas Sucari: but the the dashboard should be easily, and then you can preview it.

507 00:47:49.420 00:47:50.060 Payas Parab: Yeah.

508 00:47:50.060 00:47:55.030 Nicolas Sucari: And it should be like that quick. And then if you wanna do, let me disappear. This. Yeah.

509 00:47:55.060 00:47:58.210 Nicolas Sucari: if you wanna do any like

510 00:47:58.470 00:48:24.470 Nicolas Sucari: view different view. With dates. You can go custom and filter. You can compare it with same period, other dates, whatever. And if you then want, like some like custom data with like export, you can go to pivot tables and create like using the measures and dimensions that you want and export that data that if you want to share like, if you want to share like a specific table or anything with the Cfo like.

511 00:48:25.700 00:48:27.680 Payas Parab: Yeah, I’ll just do that.

512 00:48:28.140 00:48:32.729 Payas Parab: Just be like, Hey, here’s your demo environment to play around with data. This is all.

513 00:48:32.730 00:48:33.650 Nicolas Sucari: Yeah, exactly.

514 00:48:33.650 00:48:37.080 Payas Parab: Remind me which it’s updated. It’s once a day.

515 00:48:37.630 00:48:46.049 Nicolas Sucari: It’s yeah, once a day, I think, for now I think we have it here in the real Yamo. Yeah, it’s refreshes every 24 h resources.

516 00:48:46.050 00:48:46.690 Payas Parab: Okay.

517 00:48:47.090 00:49:06.990 Payas Parab: alright cool. Let me let me just compile that message to the Cfo. Just being like, here’s what building blah blah! And then that snowflake query that I’m putting together for him, and then bundle all that, send it out, and then with them on tomorrow we gotta talk about additional data sources as well as the tooling for preset queries. Right? And just lay that out.

518 00:49:06.990 00:49:17.809 Payas Parab: Yeah. And I can take that as an action item for me. So my action items, yeah, like getting that like, at least just drafting that message for a month and then

519 00:49:17.820 00:49:22.240 Payas Parab: getting for the Cfo like the different cuts of the data and see where we go. From. There.

520 00:49:22.820 00:49:32.610 Nicolas Sucari: Let me know if you have like any query that you want to create like a model file or anything, send that to me, and I can create it, deploy it to real cloud, and you will have it live there.

521 00:49:32.610 00:49:33.050 Payas Parab: Okay.

522 00:49:33.050 00:49:38.130 Nicolas Sucari: You can. Yeah, actually show that using the link that we already deployed if you want.

523 00:49:38.300 00:49:40.129 Payas Parab: Sure that would be helpful. Okay.

524 00:49:40.580 00:49:41.480 Payas Parab: yep.

525 00:49:41.480 00:49:42.330 Nicolas Sucari: Excellent.

526 00:49:42.590 00:49:44.010 Payas Parab: Sounds good. Alright, Nico

527 00:49:44.700 00:49:47.690 Payas Parab: also. Is it you go? Or Nichola? Nicholas?

528 00:49:48.400 00:49:49.869 Nicolas Sucari: Nico is fine. That’s okay.

529 00:49:49.870 00:49:53.799 Payas Parab: I I don’t know. I I said that at the beginning, and I was like, I’m not sure if, like that, you go by me. I have.

530 00:49:53.800 00:49:54.370 Nicolas Sucari: Yeah, yeah.

531 00:49:54.876 00:49:57.410 Payas Parab: So they go by. Nico.

532 00:49:57.710 00:49:58.409 Payas Parab: do you go.

533 00:49:58.410 00:49:58.800 Nicolas Sucari: Thank you.

534 00:49:58.800 00:50:00.080 Payas Parab: I prefer Nicholas.

535 00:50:00.080 00:50:08.139 Nicolas Sucari: Yeah, I go by. Nico, yeah, is kind of a formal when you wanna approach me and be like formal. You say, Nicolas. But here in Argentina nobody.

536 00:50:08.630 00:50:09.879 Payas Parab: Alright, sounds good.

537 00:50:09.880 00:50:10.315 Nicolas Sucari: Yeah.

538 00:50:10.750 00:50:12.720 Payas Parab: Appreciate all the help here. Thank you, Nico.

539 00:50:13.230 00:50:14.710 Nicolas Sucari: No problem. Bye-bye.

540 00:50:14.710 00:50:16.290 Payas Parab: Alright! See you bye.