Meeting Title: Analysis-Planning-Session Date: 2024-07-29 Meeting participants: Nicolas Sucari, Bryce Codell, Jakob Kagel, Uttam
WEBVTT
1 00:00:45.740 ⇒ 00:00:46.540 You.
2 00:00:46.540 ⇒ 00:00:47.340 Nicolas Sucari: He’s all.
3 00:00:49.920 ⇒ 00:00:50.989 Jakob Kagel: Hey? How’s it going.
4 00:00:52.730 ⇒ 00:00:53.930 Nicolas Sucari: Oh, good!
5 00:01:01.910 ⇒ 00:01:06.290 Jakob Kagel: Oh, so yeah, let me share my screen. It says, Cool
6 00:01:07.209 ⇒ 00:01:11.400 Jakob Kagel: or should we do we wanna wait for? Is it I’m gonna join, or something.
7 00:01:12.170 ⇒ 00:01:12.800 Jakob Kagel: He.
8 00:01:12.800 ⇒ 00:01:14.659 Nicolas Sucari: Yeah, I think he was gonna join.
9 00:01:15.030 ⇒ 00:01:15.989 Jakob Kagel: Oh, okay.
10 00:01:16.350 ⇒ 00:01:16.980 Jakob Kagel: Cool.
11 00:01:16.980 ⇒ 00:01:18.110 Nicolas Sucari: Bad. L,
12 00:01:18.160 ⇒ 00:01:21.959 Nicolas Sucari: yeah. What I was saying is that you’re you’re looking at the
13 00:01:22.270 ⇒ 00:01:26.889 Nicolas Sucari: at the queries. But you you should be looking at the sources, because that’s that query
14 00:01:26.960 ⇒ 00:01:28.790 Nicolas Sucari: comes from another file.
15 00:01:29.000 ⇒ 00:01:34.330 Jakob Kagel: Right. But in the sources it’s still like this is what which one were we looking at again? It’s like refund by.
16 00:01:34.330 ⇒ 00:01:35.379 Nicolas Sucari: Yeah, that one
17 00:01:35.440 ⇒ 00:01:37.099 Nicolas Sucari: refund by state. Yeah.
18 00:01:37.440 ⇒ 00:01:39.769 Jakob Kagel: Right. But this is the actual table
19 00:01:40.010 ⇒ 00:01:43.380 Jakob Kagel: like this isn’t what you had like analytics, something.
20 00:01:43.680 ⇒ 00:01:44.300 Jakob Kagel: Yeah.
21 00:01:44.625 ⇒ 00:01:44.950 Nicolas Sucari: Check!
22 00:01:45.110 ⇒ 00:01:46.109 Jakob Kagel: I don’t know.
23 00:01:46.730 ⇒ 00:01:49.079 Nicolas Sucari: Hey? It’s a it’s a analytics. I know why.
24 00:01:49.500 ⇒ 00:01:56.950 Nicolas Sucari: No, okay, I know. Let me see. So the refund by state that one
25 00:01:57.940 ⇒ 00:01:59.120 Nicolas Sucari: that.
26 00:02:01.330 ⇒ 00:02:01.920 Bryce Codell: What’s up? Guys?
27 00:02:01.920 ⇒ 00:02:02.730 Nicolas Sucari: I know.
28 00:02:02.730 ⇒ 00:02:03.420 Jakob Kagel: Hey! How are you?
29 00:02:03.789 ⇒ 00:02:04.160 Nicolas Sucari: Bryce.
30 00:02:05.030 ⇒ 00:02:05.460 Jakob Kagel: Sorry.
31 00:02:05.460 ⇒ 00:02:06.899 Bryce Codell: Hey? I’m doing alright.
32 00:02:06.900 ⇒ 00:02:08.150 Jakob Kagel: I mean real quick.
33 00:02:08.800 ⇒ 00:02:12.184 Bryce Codell: No worries, Jacob. I don’t think we’ve met yet, but it’s nice to meet you.
34 00:02:12.600 ⇒ 00:02:15.220 Jakob Kagel: Great to meet you. Great to meet you. Where are you? Based out of.
35 00:02:15.800 ⇒ 00:02:17.540 Bryce Codell: I’m in Brooklyn right now. What about you.
36 00:02:17.540 ⇒ 00:02:20.299 Jakob Kagel: Cool. I’m in Austin, Texas.
37 00:02:22.060 ⇒ 00:02:22.950 Bryce Codell: Nice.
38 00:02:23.560 ⇒ 00:02:24.453 Jakob Kagel: Yeah, yeah.
39 00:02:25.290 ⇒ 00:02:30.400 Nicolas Sucari: I don’t know what happened, Jacob, but I’m seeing it like analytics.
40 00:02:30.410 ⇒ 00:02:32.240 Nicolas Sucari: It doesn’t say for me.
41 00:02:32.630 ⇒ 00:02:33.269 Jakob Kagel: Share your.
42 00:02:34.153 ⇒ 00:02:35.036 Nicolas Sucari: Activity.
43 00:02:36.575 ⇒ 00:02:37.099 Nicolas Sucari: amazing.
44 00:02:37.100 ⇒ 00:02:38.609 Jakob Kagel: What you’re looking at. Yeah.
45 00:02:38.970 ⇒ 00:02:40.050 Nicolas Sucari: Has
46 00:02:40.120 ⇒ 00:02:41.850 Nicolas Sucari: super weird. But yeah.
47 00:02:41.850 ⇒ 00:02:42.250 Jakob Kagel: You know.
48 00:02:42.250 ⇒ 00:02:42.880 Nicolas Sucari: A.
49 00:02:43.211 ⇒ 00:02:47.850 Jakob Kagel: It’s like the juice is not worth the squeeze here. It’s like, it’s really
50 00:02:49.490 ⇒ 00:02:50.210 Jakob Kagel: just.
51 00:02:50.210 ⇒ 00:02:50.960 Nicolas Sucari: Luke.
52 00:02:51.090 ⇒ 00:02:52.090 Nicolas Sucari: The sea.
53 00:02:53.980 ⇒ 00:02:58.120 Nicolas Sucari: like it, says, analytics, I am on sources. Snowflake.
54 00:02:59.990 ⇒ 00:03:01.960 Jakob Kagel: That’s very strange.
55 00:03:02.400 ⇒ 00:03:05.609 Nicolas Sucari: And I I don’t have any change like I just
56 00:03:06.736 ⇒ 00:03:07.129 Jakob Kagel: You replace.
57 00:03:07.130 ⇒ 00:03:07.789 Nicolas Sucari: Today again.
58 00:03:08.165 ⇒ 00:03:13.420 Jakob Kagel: Hit the refresh button at the bottom like by where it says main right.
59 00:03:14.010 ⇒ 00:03:20.070 Nicolas Sucari: Oh, yeah, yeah, but I I am using it. Have desktop and don’t have any change, and I clone.
60 00:03:21.250 ⇒ 00:03:25.428 Bryce Codell: Could this be related to the renaming of all the schemas from like.
61 00:03:25.750 ⇒ 00:03:26.380 Nicolas Sucari: Think yes.
62 00:03:26.380 ⇒ 00:03:28.210 Bryce Codell: Smart, to to just smart.
63 00:03:29.170 ⇒ 00:03:31.430 Nicolas Sucari: I don’t know if that one is.
64 00:03:31.950 ⇒ 00:03:40.660 Nicolas Sucari: but probably probably it has something to do with that one, because I’m seeing that some of the stuff is under. Dbt. Underscore Mart.
65 00:03:41.144 ⇒ 00:03:44.600 Nicolas Sucari: Here, like all of the sources are from there.
66 00:03:45.460 ⇒ 00:03:51.409 Nicolas Sucari: you see. But I’m seeing all of them that says analytics like they. They are in an analytics table.
67 00:03:53.075 ⇒ 00:03:57.214 Jakob Kagel: So is this like, did you just click on the repo? Is this like.
68 00:03:57.670 ⇒ 00:03:58.360 Jakob Kagel: I mean.
69 00:03:58.360 ⇒ 00:04:01.119 Nicolas Sucari: Let’s go to see. Let’s go to see the code. If you want.
70 00:04:01.490 ⇒ 00:04:02.190 Jakob Kagel: No, no, I mean.
71 00:04:02.640 ⇒ 00:04:03.089 Nicolas Sucari: Scott!
72 00:04:03.090 ⇒ 00:04:04.841 Jakob Kagel: Trying to think like,
73 00:04:07.300 ⇒ 00:04:11.443 Jakob Kagel: I I mean, I’m trying to think like, how do we fix it? Basically
74 00:04:12.700 ⇒ 00:04:16.130 Jakob Kagel: because mine should be up to date, too. I mean, like.
75 00:04:17.140 ⇒ 00:04:17.940 Nicolas Sucari: Yeah.
76 00:04:19.860 ⇒ 00:04:20.260 Jakob Kagel: I mean.
77 00:04:20.269 ⇒ 00:04:21.209 Nicolas Sucari: Check, like.
78 00:04:21.490 ⇒ 00:04:22.550 Jakob Kagel: Yeah, and wait.
79 00:04:23.330 ⇒ 00:04:26.380 Nicolas Sucari: Sources. Snowflake refund by state.
80 00:04:26.700 ⇒ 00:04:29.939 Nicolas Sucari: Yeah, it says analytics on the code. I don’t know what happened.
81 00:04:29.940 ⇒ 00:04:30.810 Jakob Kagel: Hit hub.
82 00:04:31.670 ⇒ 00:04:36.280 Nicolas Sucari: Yeah, okay, let let me share. How can I change my
83 00:04:39.060 ⇒ 00:04:40.059 Nicolas Sucari: I mean, join.
84 00:04:40.060 ⇒ 00:04:45.559 Jakob Kagel: Like. Do I need to like? Reclone the repo then, and like change all of them, or like.
85 00:04:46.910 ⇒ 00:04:48.010 Nicolas Sucari: I don’t know.
86 00:04:49.020 ⇒ 00:04:49.950 Jakob Kagel: Yeah, me, neither.
87 00:04:52.250 ⇒ 00:04:54.139 Nicolas Sucari: But you see, like this is what we were.
88 00:04:54.140 ⇒ 00:04:55.020 Jakob Kagel: Just seeing.
89 00:04:55.860 ⇒ 00:05:00.401 Nicolas Sucari: And it says, analytics here, Bryce, do you know if these like
90 00:05:01.190 ⇒ 00:05:02.780 Nicolas Sucari: probably change
91 00:05:02.820 ⇒ 00:05:05.910 Nicolas Sucari: when once when we change kind of that
92 00:05:06.430 ⇒ 00:05:07.839 Nicolas Sucari: file and stuff.
93 00:05:08.350 ⇒ 00:05:10.100 Nicolas Sucari: I don’t know that folder.
94 00:05:11.210 ⇒ 00:05:15.299 Nicolas Sucari: I’m i i really don’t have an idea of what
95 00:05:16.590 ⇒ 00:05:27.850 Nicolas Sucari: what happened here, but what I see from the error that you showed me. Jacob is like the file that is doesn’t exist, because when I go to check these on Snowflake.
96 00:05:28.160 ⇒ 00:05:28.490 Jakob Kagel: Yeah.
97 00:05:28.490 ⇒ 00:05:30.079 Nicolas Sucari: To snowflake. Here it.
98 00:05:30.080 ⇒ 00:05:30.840 Jakob Kagel: Yeah nice. Piece.
99 00:05:30.840 ⇒ 00:05:31.190 Nicolas Sucari: We do?
100 00:05:31.596 ⇒ 00:05:42.570 Jakob Kagel: Yeah, of course it doesn’t exist. I get that so here, let me share my screen real quick again. So how can I ensure. I mean.
101 00:05:43.110 ⇒ 00:05:47.250 Jakob Kagel: mine should be up to date right. Can you see my screen?
102 00:05:49.130 ⇒ 00:05:49.790 Jakob Kagel: Hmm.
103 00:05:51.190 ⇒ 00:05:51.930 Jakob Kagel: Yep.
104 00:05:52.210 ⇒ 00:05:54.399 Jakob Kagel: so like if I go here right
105 00:05:55.630 ⇒ 00:06:01.069 Jakob Kagel: like everything like like, why are mine not up to date? Do I need to like
106 00:06:02.220 ⇒ 00:06:04.629 Jakob Kagel: repool the repo, or something.
107 00:06:06.170 ⇒ 00:06:08.330 Nicolas Sucari: Can you do? You have github desktop
108 00:06:08.880 ⇒ 00:06:10.620 Nicolas Sucari: because you have to change this year.
109 00:06:11.850 ⇒ 00:06:13.759 Jakob Kagel: Right? Right? Yeah, exactly.
110 00:06:15.300 ⇒ 00:06:16.870 Jakob Kagel: But this was just the ones. Yeah.
111 00:06:16.870 ⇒ 00:06:18.000 Nicolas Sucari: Oh, yeah, okay.
112 00:06:18.600 ⇒ 00:06:19.880 Nicolas Sucari: yeah. I don’t know.
113 00:06:21.020 ⇒ 00:06:22.050 Nicolas Sucari: I’m not sure.
114 00:06:22.510 ⇒ 00:06:23.360 Jakob Kagel: Okay.
115 00:06:24.270 ⇒ 00:06:26.679 Jakob Kagel: alright. Well, we gotta get somebody.
116 00:06:26.760 ⇒ 00:06:29.168 Jakob Kagel: They can figure this out.
117 00:06:30.090 ⇒ 00:06:32.525 Uttam: Hey, guys, just John? Sorry. Just in a
118 00:06:33.110 ⇒ 00:06:33.900 Uttam: in person, I mean.
119 00:06:33.900 ⇒ 00:06:34.550 Nicolas Sucari: Some.
120 00:06:34.970 ⇒ 00:06:35.550 Uttam: 8.
121 00:06:35.730 ⇒ 00:06:36.839 Jakob Kagel: Hey! How are you?
122 00:06:37.490 ⇒ 00:06:38.320 Uttam: Bad.
123 00:06:40.530 ⇒ 00:06:44.187 Jakob Kagel: basically a little, a little bit of trouble in Paradise here.
124 00:06:45.400 ⇒ 00:06:49.220 Jakob Kagel: so like, I don’t know the github, like.
125 00:06:50.260 ⇒ 00:07:02.540 Jakob Kagel: basically like the repo is showing. Like all of the I don’t know. Nico is. Maybe there. You share your screen actually 1st here and show kind of the repo cause, like
126 00:07:02.980 ⇒ 00:07:09.809 Jakob Kagel: the thing is, too, is like the the way that it is in the repo. Now, I don’t think that is right. Like.
127 00:07:11.770 ⇒ 00:07:12.680 Nicolas Sucari: The analytics.
128 00:07:12.680 ⇒ 00:07:27.880 Jakob Kagel: Instead of dbt like instead of it saying, dbt, like dot dbt. Mark like select from Dbt. Dot, dbt. Mart dot shopify orders, or whatever it’s saying, like analytics in all of them. And we’re like, kind of confused like, how this change happened.
129 00:07:28.420 ⇒ 00:07:29.731 Uttam: We made the change.
130 00:07:30.620 ⇒ 00:07:34.170 Uttam: Nika, we were working on all the role-based access control and snowflake stuff.
131 00:07:34.380 ⇒ 00:07:35.409 Uttam: So everything.
132 00:07:35.410 ⇒ 00:07:36.080 Nicolas Sucari: Okay.
133 00:07:36.080 ⇒ 00:07:36.830 Uttam: Webex.
134 00:07:39.420 ⇒ 00:07:40.100 Uttam: so.
135 00:07:40.100 ⇒ 00:07:42.200 Nicolas Sucari: Okay, so that’s that’s the issue. Probably.
136 00:07:42.650 ⇒ 00:07:43.990 Nicolas Sucari: Yeah, I got sure.
137 00:07:44.520 ⇒ 00:07:47.220 Uttam: No, those are all the changes we made on
138 00:07:48.080 ⇒ 00:07:49.760 Uttam: last Thursday, Friday.
139 00:07:49.820 ⇒ 00:07:52.629 Uttam: Jacob, where we like, cleaned up a bunch of stuff and
140 00:07:52.650 ⇒ 00:07:59.480 Uttam: made role-based access control. So there’s gonna be some small hiccups. Everything should be coming from analytics now.
141 00:07:59.945 ⇒ 00:08:03.870 Uttam: But if it’s not again, that should be something like Patrick, can probably take care of.
142 00:08:04.580 ⇒ 00:08:08.180 Jakob Kagel: So that’s like, there’s an actual analytic schema. Now, okay, I see that. Okay.
143 00:08:08.180 ⇒ 00:08:09.890 Uttam: It’s an analytics, database.
144 00:08:09.890 ⇒ 00:08:10.850 Jakob Kagel: I see that. Okay.
145 00:08:11.375 ⇒ 00:08:11.660 Nicolas Sucari: Here.
146 00:08:12.000 ⇒ 00:08:13.270 Nicolas Sucari: or we send the attendees.
147 00:08:13.270 ⇒ 00:08:17.149 Uttam: Or yeah, whatever it was coming from previously. You can just select.
148 00:08:17.770 ⇒ 00:08:21.520 Uttam: you can just select the database. It shouldn’t. The schema should not have changed.
149 00:08:22.500 ⇒ 00:08:23.600 Jakob Kagel: Okay, that’s some.
150 00:08:23.600 ⇒ 00:08:24.770 Nicolas Sucari: Something. Something
151 00:08:24.930 ⇒ 00:08:40.460 Nicolas Sucari: has changed because we were using on this code. Here, for example, these all orders source as a sequel file. And when I went to change, to check. If these all order schema was there. It like, it’s not here on analytics.
152 00:08:41.640 ⇒ 00:08:43.860 Uttam: So it’s not all order, schema. That’s the table.
153 00:08:44.740 ⇒ 00:08:47.509 Nicolas Sucari: Okay, okay. The table doesn’t exist here.
154 00:08:48.100 ⇒ 00:08:50.849 Uttam: It’s not under Dbt. Mart, or Mart, or anything.
155 00:08:51.470 ⇒ 00:08:53.330 Bryce Codell: Try querying. Just march.
156 00:08:54.620 ⇒ 00:08:55.710 Nicolas Sucari: You see I.
157 00:08:55.710 ⇒ 00:08:56.720 Uttam: Or go on, go on.
158 00:08:56.720 ⇒ 00:08:57.140 Nicolas Sucari: Say right.
159 00:08:57.140 ⇒ 00:08:58.280 Uttam: Go under, mart.
160 00:08:59.410 ⇒ 00:09:01.849 Jakob Kagel: Oh, yeah, so it isn’t on there.
161 00:09:02.260 ⇒ 00:09:04.209 Nicolas Sucari: No, it’s not here too.
162 00:09:07.390 ⇒ 00:09:09.720 Bryce Codell: What’s the role? What’s the role that you’re using.
163 00:09:12.140 ⇒ 00:09:13.120 Bryce Codell: And Dbt role.
164 00:09:13.120 ⇒ 00:09:14.859 Nicolas Sucari: Dbt, yeah. Dbt, role.
165 00:09:16.490 ⇒ 00:09:17.104 Nicolas Sucari: I was there.
166 00:09:17.310 ⇒ 00:09:17.630 Bryce Codell: You have.
167 00:09:17.877 ⇒ 00:09:20.850 Uttam: Scroll down on this? Can you scroll down to schemas real quick?
168 00:09:24.840 ⇒ 00:09:26.310 Uttam: Can you look under staging.
169 00:09:27.410 ⇒ 00:09:28.620 Nicolas Sucari: Understanding, okay.
170 00:09:30.480 ⇒ 00:09:31.210 Nicolas Sucari: no.
171 00:09:32.950 ⇒ 00:09:36.269 Uttam: If you search for all orders at the top, you see there’s a search bar.
172 00:09:36.300 ⇒ 00:09:37.760 Uttam: You see anything? Come up.
173 00:09:46.210 ⇒ 00:09:48.300 Uttam: Nothing comes up under analytics.
174 00:09:49.340 ⇒ 00:09:50.930 Nicolas Sucari: Under analytics.
175 00:09:51.270 ⇒ 00:09:53.020 Jakob Kagel: And look here, yeah.
176 00:09:53.620 ⇒ 00:09:54.490 Nicolas Sucari: Yeah. Nope.
177 00:09:56.790 ⇒ 00:10:00.979 Nicolas Sucari: it’s under under. Dbt, okay, I can see it here under Mart.
178 00:10:01.630 ⇒ 00:10:02.590 Nicolas Sucari: But where.
179 00:10:02.590 ⇒ 00:10:05.399 Uttam: But this is the so like the Dbt.
180 00:10:08.560 ⇒ 00:10:09.419 Uttam: okay, I mean.
181 00:10:09.420 ⇒ 00:10:10.229 Nicolas Sucari: Yeah, it’s it.
182 00:10:10.960 ⇒ 00:10:15.119 Uttam: I could take a look. I’ll be home in a sec. But yeah, it’s probably something to do with our change.
183 00:10:15.990 ⇒ 00:10:16.295 Nicolas Sucari: Okay.
184 00:10:17.030 ⇒ 00:10:19.290 Nicolas Sucari: yeah, it’s not under analytics. Okay.
185 00:10:19.890 ⇒ 00:10:22.249 Nicolas Sucari: so what we need to figure out is
186 00:10:22.370 ⇒ 00:10:27.300 Nicolas Sucari: that all of the sources that we have here on the code for the
187 00:10:27.410 ⇒ 00:10:28.470 Nicolas Sucari: evidence
188 00:10:28.660 ⇒ 00:10:32.440 Nicolas Sucari: pages like we, we have them there on us analytics.
189 00:10:33.040 ⇒ 00:10:39.800 Nicolas Sucari: because probably all I think the one that is messing with everything is all order items and all orders.
190 00:10:40.150 ⇒ 00:10:44.330 Nicolas Sucari: Those are the ones that are like, yeah, everywhere.
191 00:10:44.560 ⇒ 00:10:46.759 Jakob Kagel: Using probably basically everything.
192 00:10:47.310 ⇒ 00:10:47.880 Nicolas Sucari: Yeah.
193 00:10:48.190 ⇒ 00:10:49.260 Jakob Kagel: And yeah.
194 00:10:50.330 ⇒ 00:10:55.829 Uttam: Okay, yeah, I guess, Bryce, I don’t know. Well, I guess maybe we could talk and just figure out, cause
195 00:10:55.980 ⇒ 00:10:59.419 Uttam: I just want to make sure everything ends up in the analytics.
196 00:10:59.440 ⇒ 00:11:00.459 Uttam: and then we can also.
197 00:11:00.460 ⇒ 00:11:00.780 Bryce Codell: So.
198 00:11:01.088 ⇒ 00:11:02.630 Uttam: Schemas and then basically drop
199 00:11:03.450 ⇒ 00:11:07.460 Uttam: like we probably just need to drop some old databases. I just didn’t do it on Friday.
200 00:11:07.460 ⇒ 00:11:08.170 Jakob Kagel: Main. I’m sorry.
201 00:11:08.170 ⇒ 00:11:08.490 Bryce Codell: So.
202 00:11:08.490 ⇒ 00:11:08.830 Jakob Kagel: Period.
203 00:11:08.830 ⇒ 00:11:19.149 Bryce Codell: I have access to analytics dot mart dot all orders from my user account. And like in the snowflake ui. So I’m not really.
204 00:11:19.150 ⇒ 00:11:19.540 Uttam: Like hey.
205 00:11:19.540 ⇒ 00:11:24.352 Bryce Codell: Might be a user level access issue. Given that I can access it. And
206 00:11:25.040 ⇒ 00:11:27.200 Uttam: Can you switch to service user?
207 00:11:27.370 ⇒ 00:11:32.109 Uttam: Is there is there a role called role transform? Can you switch to that and see if you see it.
208 00:11:32.320 ⇒ 00:11:32.910 Jakob Kagel: Yeah.
209 00:11:34.220 ⇒ 00:11:37.319 Uttam: And then we’ll also go and drop old roles. Basically, because
210 00:11:37.800 ⇒ 00:11:39.949 Uttam: that role that you’re using is stale
211 00:11:40.050 ⇒ 00:11:41.550 Uttam: as of Thursday.
212 00:11:42.660 ⇒ 00:11:43.140 Nicolas Sucari: You’re welcome.
213 00:11:43.140 ⇒ 00:11:44.230 Bryce Codell: Refresh button.
214 00:11:44.630 ⇒ 00:11:48.700 Bryce Codell: You see the in this next to the search bar up at the top, there’s a refresh
215 00:11:48.880 ⇒ 00:11:49.710 Bryce Codell: or yeah.
216 00:11:52.680 ⇒ 00:11:55.419 Nicolas Sucari: Under analytics, smart tables.
217 00:11:55.930 ⇒ 00:11:56.640 Nicolas Sucari: Nope.
218 00:11:56.860 ⇒ 00:11:58.840 Nicolas Sucari: road transform doesn’t have it yet.
219 00:12:00.210 ⇒ 00:12:02.200 Nicolas Sucari: What what role are you using? Bryce.
220 00:12:03.520 ⇒ 00:12:06.709 Bryce Codell: I was in Dbt. Will, which is very confusing
221 00:12:06.960 ⇒ 00:12:08.720 Bryce Codell: cause that’s what you were in as well.
222 00:12:09.300 ⇒ 00:12:17.890 Jakob Kagel: So just curious like, why did we like? Why did we wanna mute move it to analytics instead of just keeping it in? Dbt.
223 00:12:20.729 ⇒ 00:12:26.880 Uttam: So there’s a couple of reasons. One, we basically have like 5 versions of everything. And it was like really fucking, confusing.
224 00:12:26.980 ⇒ 00:12:28.160 Uttam: So
225 00:12:28.230 ⇒ 00:12:34.849 Uttam: we just needed to clean up. Second thing is we needed to create roles for each of the service accounts and for
226 00:12:35.260 ⇒ 00:12:42.989 Uttam: everybody here, basically. And like, we have like a role based access control. It’s just it was just a clean up thing we had to do for security.
227 00:12:43.498 ⇒ 00:12:47.000 Uttam: So there’s gonna be some hiccups like this. I I wasn’t.
228 00:12:47.070 ⇒ 00:12:48.120 Uttam: I was just basically.
229 00:12:48.120 ⇒ 00:12:48.899 Jakob Kagel: Think it’s either what.
230 00:12:48.900 ⇒ 00:12:49.890 Uttam: Was breaking
231 00:12:50.720 ⇒ 00:12:51.880 Uttam: again. It’s
232 00:12:51.890 ⇒ 00:12:57.220 Uttam: it’s probably something that’ll take like 30 min to figure out. This isn’t like a huge thing. Just need to go find it.
233 00:12:57.400 ⇒ 00:13:06.869 Jakob Kagel: Okay? So another question, I have real quick. Sorry. This is related to evidence. But, like basically, me and Nico are trying to work through some of these bugs like earlier today. So
234 00:13:07.770 ⇒ 00:13:13.609 Jakob Kagel: basically with now, like the updated y’all made like with the connection file, it’s like.
235 00:13:13.730 ⇒ 00:13:21.329 Jakob Kagel: every time, if I want to test something locally, I need to put in my credentials. But then, but when I like, commit the changes.
236 00:13:21.550 ⇒ 00:13:26.370 Jakob Kagel: I basically need to revert it back to this like template. Is that right? Am I understanding that correct.
237 00:13:26.370 ⇒ 00:13:29.620 Uttam: No, you, you just need to use an environment file
238 00:13:29.840 ⇒ 00:13:30.900 Uttam: locally.
239 00:13:31.130 ⇒ 00:13:31.650 Uttam: Why.
240 00:13:31.650 ⇒ 00:13:32.120 Jakob Kagel: You know how we.
241 00:13:32.120 ⇒ 00:13:36.460 Uttam: We we’ve used like dot Ed files. You guys talked to Patrick yet today about this.
242 00:13:37.430 ⇒ 00:13:37.950 Jakob Kagel: Alright. Yeah.
243 00:13:37.950 ⇒ 00:13:39.730 Nicolas Sucari: Thinking that. Yeah.
244 00:13:39.730 ⇒ 00:13:42.180 Uttam: Okay. I mean, I would like, yeah, I wouldn’t.
245 00:13:42.400 ⇒ 00:13:46.529 Uttam: I would just call Patrick about all this, because he he knows exactly what I know about this. But
246 00:13:46.560 ⇒ 00:13:51.539 Uttam: yeah, you, we just need to set up environment files just like you have for Dbt.
247 00:13:51.590 ⇒ 00:14:04.809 Uttam: where you have like something dot, env. Basically, you’ll have your credentials in a dot env file, basically similar to how we have real, or you have a real dot env file. You’ll just have a local environment file with your credentials.
248 00:14:05.030 ⇒ 00:14:09.920 Uttam: The nice thing is using. Get ignore. That file doesn’t end up getting committed.
249 00:14:10.649 ⇒ 00:14:14.539 Uttam: And then you won’t need to make any changes to the template file.
250 00:14:16.220 ⇒ 00:14:16.740 Jakob Kagel: Okay.
251 00:14:16.740 ⇒ 00:14:19.140 Uttam: Again. If that’s just all like word salad, I can.
252 00:14:19.810 ⇒ 00:14:20.250 Jakob Kagel: No, that.
253 00:14:20.250 ⇒ 00:14:21.370 Uttam: Yeah, about how to do it.
254 00:14:21.600 ⇒ 00:14:28.700 Jakob Kagel: No, that’s fine. I mean, we’ll definitely take the video. I was just gonna say, Nico, I mean, can we maybe set up a call with us 3 with me, you and Patrick.
255 00:14:28.700 ⇒ 00:14:29.560 Nicolas Sucari: Yeah, I am.
256 00:14:30.220 ⇒ 00:14:30.660 Jakob Kagel: That they will.
257 00:14:30.660 ⇒ 00:14:37.190 Uttam: Yeah, all this stuff we should just send right through Patrick, because this is like this. I mean again.
258 00:14:37.760 ⇒ 00:14:38.869 Jakob Kagel: Sorry you’re breaking something over.
259 00:14:38.870 ⇒ 00:14:40.380 Uttam: He knows exactly how to do this.
260 00:14:40.750 ⇒ 00:14:41.629 Jakob Kagel: Okay, yeah, like.
261 00:14:41.630 ⇒ 00:14:42.480 Nicolas Sucari: And yeah.
262 00:14:42.480 ⇒ 00:14:44.690 Uttam: I said, Yeah, I said, Go ahead and do that. Yeah.
263 00:14:45.230 ⇒ 00:14:45.650 Jakob Kagel: Cool.
264 00:14:45.650 ⇒ 00:14:46.810 Nicolas Sucari: Perfect. Yeah. Yes.
265 00:14:46.810 ⇒ 00:14:49.389 Jakob Kagel: Yeah, nico, yeah, that sounds good. Yeah.
266 00:14:49.500 ⇒ 00:14:50.220 Jakob Kagel: Okay.
267 00:14:50.640 ⇒ 00:14:51.440 Jakob Kagel: Okay.
268 00:14:51.620 ⇒ 00:15:00.080 Uttam: Yeah, these are so. Yeah, the only thing again, on anything connection, wise or like these sorts of github issues. I don’t want to spin wheels on like
269 00:15:00.100 ⇒ 00:15:03.819 Uttam: again. These are, it’s gonna be new concepts, everybody. And it may seem like
270 00:15:03.880 ⇒ 00:15:09.020 Uttam: these are like massive issues, but these they all take like 30 min or an hour to just like get through.
271 00:15:09.160 ⇒ 00:15:12.389 Uttam: Anything on the Dd side needs to run through Patrick.
272 00:15:12.420 ⇒ 00:15:14.510 Uttam: So let’s just run it through him
273 00:15:16.120 ⇒ 00:15:20.689 Uttam: and like he he is, gonna have the procedure of like how to fix all these so
274 00:15:20.820 ⇒ 00:15:21.500 Uttam: flower.
275 00:15:21.500 ⇒ 00:15:30.660 Jakob Kagel: Okay? Great? Well, yeah, I’m I’m with that. Let’s yeah. Cause yeah, I don’t wanna spend time on it. So let’s meet with him and.
276 00:15:30.660 ⇒ 00:15:31.270 Uttam: Yeah.
277 00:15:31.980 ⇒ 00:15:33.329 Jakob Kagel: Get it figured out. Yeah.
278 00:15:34.260 ⇒ 00:15:35.010 Jakob Kagel: yep.
279 00:15:35.500 ⇒ 00:15:40.989 Nicolas Sucari: Perfect. Yeah, we’re just trying to understand what was the error we seen that that
280 00:15:41.260 ⇒ 00:15:46.310 Nicolas Sucari: table wasn’t there. And probably yeah, we need to understand that of the M file.
281 00:15:46.320 ⇒ 00:15:58.910 Nicolas Sucari: so that we can have everything running for everyone, because actually was like getting the same stuff, the same error last week. So probably we should get all of us on a call with Patrick and figure that out for everyone. Okay.
282 00:15:59.790 ⇒ 00:16:01.170 Jakob Kagel: Sounds good. Yeah, like I said, I mean.
283 00:16:01.170 ⇒ 00:16:04.150 Uttam: Yeah, I, I just like, we’ve been having github issues.
284 00:16:05.760 ⇒ 00:16:09.500 Uttam: Yeah, we just been having Github issues related to this. And every time I
285 00:16:09.830 ⇒ 00:16:10.890 Uttam: just need to meet with
286 00:16:10.950 ⇒ 00:16:12.140 Uttam: like. And again.
287 00:16:12.670 ⇒ 00:16:24.079 Uttam: my availability is is kind of fucked, so everything on the de side it relates to the structure of the warehouse or accessing, or these types of problems. Right? Patrick.
288 00:16:24.220 ⇒ 00:16:26.550 Uttam: he’s really smart going
289 00:16:26.560 ⇒ 00:16:28.179 Uttam: all this? Yeah, easily.
290 00:16:29.680 ⇒ 00:16:30.730 Nicolas Sucari: Course, right?
291 00:16:31.330 ⇒ 00:16:36.220 Nicolas Sucari: Perfect. Okay, so that was that. Let’s move into our
292 00:16:36.770 ⇒ 00:16:44.320 Nicolas Sucari: high priority stuff that we need to be working on this week and see if we can get them done by the end of the week.
293 00:16:44.699 ⇒ 00:16:51.620 Nicolas Sucari: We need to set up the evidence page. I know that. Obviously, these issues were getting in the middle of stuff.
294 00:16:51.690 ⇒ 00:17:03.889 Nicolas Sucari: But I don’t know, you guys. If you Brice, were working on the weather stuff on already started creating the evidence stuff. And I know, Jacob, you were trying to work on the pro versus consumer right.
295 00:17:04.410 ⇒ 00:17:20.709 Jakob Kagel: Yeah, I mean, obviously, yeah, this is just like a blocker, because I can’t see anything, basically that I’m working. But I mean, if we can get this resolved, I think I can turn around really pretty quick. I mean, I have all the ideas of you know, and everything basically written. That’s like.
296 00:17:21.160 ⇒ 00:17:21.990 Jakob Kagel: you know
297 00:17:22.180 ⇒ 00:17:28.090 Jakob Kagel: what we need. So yeah, I think I can turn around pretty quick as long as it’s like we can get it working. You know.
298 00:17:28.860 ⇒ 00:17:33.009 Nicolas Sucari: Perfect and the center of gravity. One. We said that we just
299 00:17:33.190 ⇒ 00:17:42.520 Nicolas Sucari: copy what we have their notion, and paste it into one of these pages, and that will be ready. So I think once we unblock these stuff from evidence, we can get them both ready.
300 00:17:43.450 ⇒ 00:17:44.939 Jakob Kagel: Yeah, I agree.
301 00:17:45.770 ⇒ 00:17:51.300 Nicolas Sucari: Perfect. Yep, Bryce. Anything on the weather stuff you’ve been working on.
302 00:17:52.310 ⇒ 00:17:54.270 Bryce Codell: Yeah. So
303 00:17:55.079 ⇒ 00:17:58.370 Bryce Codell: Utam, or Patrick, some of you set me up with
304 00:17:58.920 ⇒ 00:18:03.000 Bryce Codell: So set up access to weather data from
305 00:18:03.436 ⇒ 00:18:13.213 Bryce Codell: sorry series getting in my way set up access in Snowflake to a data share that contains a whole bunch of historical weather data.
306 00:18:14.171 ⇒ 00:18:16.889 Bryce Codell: And so I’ve been playing around with that this weekend
307 00:18:17.110 ⇒ 00:18:23.309 Bryce Codell: to try to figure out how much coverage that data provides us to be able to do
308 00:18:23.410 ⇒ 00:18:33.619 Bryce Codell: a bit of like a time series analysis around like weather trends and order and and pull parts order data. And basically, what I saw is that
309 00:18:33.690 ⇒ 00:18:36.400 Bryce Codell: about 70 to 75% of
310 00:18:36.430 ⇒ 00:18:39.480 Bryce Codell: orders. And when we map. So when we map
311 00:18:40.150 ⇒ 00:18:47.379 Bryce Codell: order data to weather data using like zip code and time and like order, timestamp, or like weather timestamp.
312 00:18:47.900 ⇒ 00:18:49.340 Bryce Codell: we have like.
313 00:18:49.610 ⇒ 00:18:53.829 Bryce Codell: look like we have the data that we want, which is basically like
314 00:18:53.900 ⇒ 00:19:04.675 Bryce Codell: weather records, like for a few days before and a few days after each order for about 70 ish percent like of our 160 K order records.
315 00:19:05.416 ⇒ 00:19:17.510 Bryce Codell: There’s some things I can do to increase that coverage, but that should give us a big enough sample size to be able to move forward and do some actual analysis, like figuring out things like.
316 00:19:17.670 ⇒ 00:19:19.140 Bryce Codell: what are the like?
317 00:19:19.740 ⇒ 00:19:20.890 Bryce Codell: Like? What
318 00:19:21.020 ⇒ 00:19:28.809 Bryce Codell: products see increased demand with different types of weather, like rain and snow, and like temperature increases and things like that
319 00:19:30.200 ⇒ 00:19:31.510 Bryce Codell: and
320 00:19:31.580 ⇒ 00:19:39.799 Bryce Codell: like being able to then use those types of insights to get recommendations to like build visualizations and corresponding recommendations to the pool party.
321 00:19:39.800 ⇒ 00:19:40.220 Uttam: Bryce.
322 00:19:40.220 ⇒ 00:19:41.770 Bryce Codell: Around, like, yeah.
323 00:19:42.440 ⇒ 00:19:44.270 Uttam: Is the is the
324 00:19:44.340 ⇒ 00:19:46.359 Uttam: the lack and overlap is that
325 00:19:46.760 ⇒ 00:19:49.559 Uttam: is, that like geographically concentrated
326 00:19:50.130 ⇒ 00:19:53.070 Uttam: or like, where is that coming from?
327 00:19:54.905 ⇒ 00:19:55.670 Bryce Codell: So
328 00:19:55.950 ⇒ 00:20:06.750 Bryce Codell: I have not dug into the specifics around. What like? Why, those records are missing. My, yeah, my hunch is that
329 00:20:06.800 ⇒ 00:20:10.400 Bryce Codell: it like it probably has something to do with
330 00:20:10.840 ⇒ 00:20:17.579 Bryce Codell: like imperfect data quality in the weather data itself, just like missing certain zip codes or things like that.
331 00:20:17.590 ⇒ 00:20:19.209 Bryce Codell: And so, if that is the.
332 00:20:19.210 ⇒ 00:20:20.872 Uttam: To give it to you. Like,
333 00:20:23.100 ⇒ 00:20:33.469 Uttam: yeah, just to get to give you like a sense of like, probably a decision you could make there. If you find that that’s the case. Most of their sales are California, Texas, New York.
334 00:20:33.510 ⇒ 00:20:35.860 Uttam: Arizona, Florida.
335 00:20:36.590 ⇒ 00:20:37.100 Bryce Codell: It is.
336 00:20:37.100 ⇒ 00:20:42.760 Uttam: So those are going to be really the places that people care about additionally.
337 00:20:43.210 ⇒ 00:20:48.959 Uttam: just as like just thinking out loud, it’s probably gonna be the places where there are changes in weather.
338 00:20:49.070 ⇒ 00:20:50.000 Uttam: So like.
339 00:20:50.450 ⇒ 00:20:58.320 Uttam: you know, if there’s places where it’s just this kind of same weather, they don’t see really crazy weather patterns. It’s pro. So there’s probably some decisions you can make on
340 00:20:58.620 ⇒ 00:21:06.099 Uttam: getting that up. But again, the big things they’re gonna wanna see stuff on is in that in the northeast, in Florida.
341 00:21:06.390 ⇒ 00:21:10.739 Uttam: probably in Texas. But I would say Texas is more concerned with, like
342 00:21:10.860 ⇒ 00:21:14.029 Uttam: Houston in the coast, and then California
343 00:21:14.160 ⇒ 00:21:15.979 Uttam: so ideally that
344 00:21:16.630 ⇒ 00:21:19.899 Uttam: if you’re able to filter to that, maybe that gives more
345 00:21:20.050 ⇒ 00:21:25.319 Uttam: that just shortens a data set or or allows you to just focus on a few areas, because the rest of the country
346 00:21:25.390 ⇒ 00:21:28.689 Uttam: it’s it diminishes really quickly the impact on
347 00:21:29.500 ⇒ 00:21:35.610 Uttam: sales. So if it gives you something to start with and then we can expand to the other stuff later. That may be helpful.
348 00:21:37.438 ⇒ 00:21:41.759 Bryce Codell: yeah, I can, definitely, that’s really helpful. So hold on. Give me one second
349 00:21:43.280 ⇒ 00:21:44.070 Bryce Codell: just to make sure.
350 00:21:44.070 ⇒ 00:21:46.270 Uttam: All that, all that sales
351 00:21:47.140 ⇒ 00:21:55.200 Uttam: the the sales like. What’s I can? It’s in real. I can also make sure you have access to that. But yeah, it’s Florida.
352 00:21:55.320 ⇒ 00:21:57.990 Uttam: the northeast, like, you know, New York.
353 00:21:58.585 ⇒ 00:21:59.140 Uttam: Mainly.
354 00:21:59.140 ⇒ 00:21:59.820 Bryce Codell: Yet.
355 00:21:59.820 ⇒ 00:22:00.560 Uttam: And then
356 00:22:01.060 ⇒ 00:22:01.790 Uttam: California.
357 00:22:01.790 ⇒ 00:22:02.279 Bryce Codell: Morning, like.
358 00:22:02.280 ⇒ 00:22:03.340 Uttam: This Arizona.
359 00:22:03.340 ⇒ 00:22:05.850 Bryce Codell: And like Houston, okay? And Arizona as well.
360 00:22:05.850 ⇒ 00:22:06.410 Uttam: Yeah.
361 00:22:07.950 ⇒ 00:22:08.720 Bryce Codell: Okay.
362 00:22:08.720 ⇒ 00:22:12.769 Uttam: Those will be like, probably like 70% of sales, if not more. I think.
363 00:22:13.550 ⇒ 00:22:17.970 Bryce Codell: Yeah. Okay, cool. I’ll do one more spot check to make sure that we have
364 00:22:18.210 ⇒ 00:22:21.230 Bryce Codell: solid coverage in those States in particular.
365 00:22:21.830 ⇒ 00:22:22.560 Uttam: Yeah.
366 00:22:23.140 ⇒ 00:22:23.860 Bryce Codell: Yabb.
367 00:22:23.860 ⇒ 00:22:31.850 Uttam: And whatever that number is, we can just note down cause it will put that in the analysis. But that doesn’t. We’re going for
368 00:22:31.960 ⇒ 00:22:36.286 Uttam: speed over like having everything buttoned up. So yeah, you know.
369 00:22:37.850 ⇒ 00:22:46.320 Bryce Codell: Yeah, totally yeah. Prioritize a compelling proof of concept over like a super polished solution. Yeah.
370 00:22:47.179 ⇒ 00:22:49.700 Bryce Codell: Cool. Yeah. That makes sense to me.
371 00:22:54.510 ⇒ 00:22:55.180 Nicolas Sucari: Okay.
372 00:22:56.930 ⇒ 00:23:02.720 Nicolas Sucari: I don’t. I? Okay, everything’s okay on that one. So I don’t. I don’t think we need to.
373 00:23:03.121 ⇒ 00:23:08.720 Nicolas Sucari: We will have that ready this week in evidence. What do you think, Bryce? It’s kind of like.
374 00:23:09.030 ⇒ 00:23:11.910 Nicolas Sucari: difficult to think. We’ll have that page set up. Okay.
375 00:23:13.090 ⇒ 00:23:22.339 Bryce Codell: Yeah. So let can we clarify like the like, the work that needs to be done in the handoff and like the handoff piece. So
376 00:23:22.970 ⇒ 00:23:41.520 Bryce Codell: does like what is actually being handed over to the client like at the end of the day on Friday? Is it expected to be like an evidence dashboard, or like or presentation? Or is it sufficient to produce a handful of like static screenshots and like, send them an email.
377 00:23:42.090 ⇒ 00:23:45.959 Uttam: The final state would be would be would be evidence.
378 00:23:46.110 ⇒ 00:23:57.540 Uttam: Because so they give you a sense of like where this is all going. They’re in some M and a activity right now. And so they’re prioritizing, like flashy stuff that looks like they’re really sophisticated on the data side.
379 00:23:58.500 ⇒ 00:23:59.320 Uttam: So
380 00:23:59.920 ⇒ 00:24:05.649 Uttam: like ideally, this ends up in evidence with some sort of dynamic
381 00:24:05.940 ⇒ 00:24:08.499 Uttam: charts, ideally a map
382 00:24:09.135 ⇒ 00:24:15.040 Uttam: and then basically like, let’s work back for backwards from there. And take that as a fixed out. But.
383 00:24:15.810 ⇒ 00:24:16.530 Bryce Codell: Okay?
384 00:24:18.980 ⇒ 00:24:20.620 Bryce Codell: okay, I
385 00:24:22.600 ⇒ 00:24:31.380 Bryce Codell: what like my biggest step free. And then so like, this is a you’re saying, by the end of the day Friday. Like that, content and evidence needs to exist.
386 00:24:32.190 ⇒ 00:24:38.920 Uttam: Yeah, but I would think of it. Less of like the evidence piece, of course, is is probably the piece that you’re most
387 00:24:39.100 ⇒ 00:24:42.549 Uttam: you’re most nervous about. I would think it more as like.
388 00:24:42.740 ⇒ 00:24:53.429 Uttam: think about the model output that you want, which is like whatever the data set is. And then, like, I’m happy, or we’re happy to work towards the evidence thing at the end.
389 00:24:53.630 ⇒ 00:24:59.489 Uttam: So basically like, it’s gonna be less about words on this one, more about like visualization.
390 00:24:59.630 ⇒ 00:25:01.880 Uttam: But that, again, is all hinged on
391 00:25:02.630 ⇒ 00:25:11.959 Uttam: the out. The the data set that you produce in terms of analysis being clean, and then evidence the evidence piece. We’ll just have to figure out when we get there.
392 00:25:12.200 ⇒ 00:25:17.659 Uttam: The data being clean on, like what you can run queries on to then answer these questions.
393 00:25:17.830 ⇒ 00:25:25.410 Uttam: I think that a great middle ground to drive towards and then getting things in an evidence, map and stuff, we’ll just have to.
394 00:25:25.620 ⇒ 00:25:28.366 Uttam: We’ll figure out as we figure that out.
395 00:25:29.370 ⇒ 00:25:32.960 Uttam: but I’m gonna sub in and help on that, too. So don’t worry.
396 00:25:33.820 ⇒ 00:25:35.849 Bryce Codell: Okay, okay, that sounds good.
397 00:25:36.703 ⇒ 00:25:38.210 Bryce Codell: Yeah. I’ll.
398 00:25:38.520 ⇒ 00:25:41.520 Uttam: That was my assumption. By the way, that’s that’s what I thought was like.
399 00:25:41.550 ⇒ 00:25:43.980 Uttam: Probably that’s probably the scariest part of this.
400 00:25:44.510 ⇒ 00:25:45.073 Bryce Codell: Yeah,
401 00:25:46.520 ⇒ 00:25:49.619 Bryce Codell: I don’t know if I would use the word scary.
402 00:25:49.930 ⇒ 00:25:50.576 Uttam: Scary.
403 00:25:51.870 ⇒ 00:25:54.169 Bryce Codell: I’m I’m very at a very age.
404 00:25:54.170 ⇒ 00:25:56.720 Uttam: I’m not saying you can’t figure it out. You know what I mean.
405 00:25:56.720 ⇒ 00:25:57.940 Bryce Codell: But no, that’s.
406 00:25:57.940 ⇒ 00:25:58.290 Uttam: That’s.
407 00:25:58.290 ⇒ 00:26:07.979 Bryce Codell: That’s the part that’s the part with the most uncertainty, for sure, because I’ve never used evidence before. So there’s actually going to be a learning curve. But yeah, but I can
408 00:26:07.990 ⇒ 00:26:10.210 Bryce Codell: do my best to
409 00:26:10.350 ⇒ 00:26:16.120 Bryce Codell: spike on getting like data output first, st and then we can figure it out from there.
410 00:26:16.170 ⇒ 00:26:17.629 Bryce Codell: The one thing I will
411 00:26:17.700 ⇒ 00:26:20.130 Bryce Codell: call out is, I
412 00:26:20.710 ⇒ 00:26:31.810 Bryce Codell: am moving this week so my, I have a shit ton of stuff. I gotta back up. I probably won’t be sleeping much, but I will try to out my game plan is to have
413 00:26:33.110 ⇒ 00:26:50.850 Bryce Codell: some like. Have the data output in place by like 1st thing Thursday morning, and then I’ll be. I won’t really have laptop great laptop access, because I’ll be driving all day Thursday, but I’ll be able to like reply to slack messages, email and stuff
414 00:26:51.273 ⇒ 00:26:57.226 Bryce Codell: on Thursday, and can like when I’m not the driver, I can jump on calls and talk through things.
415 00:26:59.390 ⇒ 00:27:04.169 Uttam: Cool. Yeah, I think ideally, by. Just let us know where what you’re feeling by
416 00:27:04.730 ⇒ 00:27:10.669 Uttam: like Thursday or Wednesday evening. That way, we have like a couple of day heads up. I think that’s the biggest thing
417 00:27:11.377 ⇒ 00:27:11.880 Bryce Codell: Yeah, I’ll just.
418 00:27:11.880 ⇒ 00:27:12.230 Uttam: And then.
419 00:27:12.230 ⇒ 00:27:19.329 Bryce Codell: I’ll be communicative, as like throughout like throughout the week as site. As I make incremental progress, so that everyone has a.
420 00:27:19.330 ⇒ 00:27:20.120 Uttam: So I’m like, yeah.
421 00:27:20.495 ⇒ 00:27:20.870 Bryce Codell: Name.
422 00:27:21.270 ⇒ 00:27:24.420 Uttam: Basically because we have, we have a lot of stuff going into evidence.
423 00:27:24.776 ⇒ 00:27:28.039 Uttam: That’s why we wanted to clear up all of the
424 00:27:28.210 ⇒ 00:27:33.710 Uttam: roles and things last week, because this will I’ll any technical time I have. This week is going to be spent
425 00:27:33.870 ⇒ 00:27:35.909 Uttam: on evidence stuff. So
426 00:27:36.240 ⇒ 00:27:40.299 Uttam: especially towards the latter end of the week I’ll have a little bit more time.
427 00:27:40.400 ⇒ 00:27:41.110 Uttam: and.
428 00:27:41.110 ⇒ 00:27:41.880 Bryce Codell: Yeah, like.
429 00:27:41.880 ⇒ 00:27:43.819 Uttam: Bus through these like smaller issues.
430 00:27:44.570 ⇒ 00:27:45.130 Bryce Codell: Yeah.
431 00:27:45.130 ⇒ 00:27:45.780 Uttam: So
432 00:27:46.050 ⇒ 00:27:49.200 Uttam: yeah, we can make it happen. And then their their meeting is on the 10.th
433 00:27:49.400 ⇒ 00:27:51.740 Uttam: This is like kind of a light deadline.
434 00:27:51.770 ⇒ 00:27:58.130 Uttam: and that way. It gives me some time to send it to Ben on Friday. He’s gonna have a bunch of like changes change this.
435 00:27:58.140 ⇒ 00:28:02.910 Uttam: We’ll get another version of them by the following Wednesday, and then we’ll be
436 00:28:03.180 ⇒ 00:28:07.770 Uttam: will be good. And then, Bryce, I’m also gonna talk to Ben a little bit about
437 00:28:07.820 ⇒ 00:28:11.339 Uttam: putting more resources on analysis. So this all goes into like
438 00:28:11.900 ⇒ 00:28:14.169 Uttam: that like pitch. Basically. So.
439 00:28:14.490 ⇒ 00:28:16.193 Bryce Codell: Yeah. Okay. Cool. Awesome.
440 00:28:18.100 ⇒ 00:28:40.020 Nicolas Sucari: Yeah. And even if we are not able to make it with evidence by the end of the week, having the all of the data output would be great. So probably you time we can share that with Ben to let us know what what he think about that, and see if we need to do any change before jumping into evidence. That will take a little bit of time. And yeah, having everything ready before that it should be, should be good.
441 00:28:40.490 ⇒ 00:28:47.660 Uttam: I mean, you guys know, as soon as it gets a visualization, there’s gonna be opinions. Until that point. It’s there’s not gonna be.
442 00:28:48.100 ⇒ 00:28:50.820 Uttam: They’re just not gonna really be able to digest.
443 00:28:51.000 ⇒ 00:28:53.470 Uttam: So ideally, we get to that point, and then
444 00:28:53.820 ⇒ 00:28:57.560 Uttam: we’ll spend the rest of time just like fetzing around in evidence.
445 00:28:57.750 ⇒ 00:29:04.119 Uttam: The nice thing is, evidence looks really good, and they’ve been really impressed with what we have so far, which is the only reason why I’m like
446 00:29:04.490 ⇒ 00:29:09.486 Uttam: a little bit adamant that we use it because the output looks really really nice.
447 00:29:09.980 ⇒ 00:29:16.640 Uttam: and in particular, like this is a little bit. There’s a like a vanity component to this project for this like deliverable. So
448 00:29:17.870 ⇒ 00:29:19.990 Uttam: I just wanna make sure that we can do that for them.
449 00:29:22.000 ⇒ 00:29:22.610 Nicolas Sucari: Okay?
450 00:29:23.500 ⇒ 00:29:28.599 Nicolas Sucari: Great but yeah, I’m gonna try to get Patrick to
451 00:29:28.710 ⇒ 00:29:33.880 Nicolas Sucari: help us with that issues that we’re having with the tables.
452 00:29:34.239 ⇒ 00:29:43.529 Nicolas Sucari: So let’s see if we can figure that out that we can get also what we already have in evidence working again. Because, as as for now is broken, I think.
453 00:29:45.232 ⇒ 00:29:47.769 Nicolas Sucari: then, yeah, probably, Jacob, we can.
454 00:29:47.890 ⇒ 00:29:56.040 Nicolas Sucari: checking again on Wednesday, Thursday to see any any progress, and we can work together on anything so that we can
455 00:29:56.110 ⇒ 00:30:00.769 Nicolas Sucari: start setting up that evidence page with pro and consumers and the center of gravity. One. Okay.
456 00:30:01.070 ⇒ 00:30:11.373 Jakob Kagel: Yeah, sounds good. I mean, yeah, I’m I’m ready. I mean, I’m like, I said me, I’ve pretty much have a good availability this afternoon, so if we can just jump on and get us sorted out
457 00:30:11.930 ⇒ 00:30:12.510 Nicolas Sucari: Perfect.
458 00:30:13.210 ⇒ 00:30:13.909 Jakob Kagel: For me.
459 00:30:15.324 ⇒ 00:30:19.970 Nicolas Sucari: Also, Utam actually wasn’t joining, because I think he started
460 00:30:20.020 ⇒ 00:30:22.150 Nicolas Sucari: these classes again.
461 00:30:23.970 ⇒ 00:30:34.159 Nicolas Sucari: yeah, I’m not sure. But yeah, probably I’m I’m gonna try to catch up with him tomorrow, I think to see how how he’s working on the
462 00:30:34.400 ⇒ 00:30:36.570 Nicolas Sucari: on the geographic stuff right.
463 00:30:36.570 ⇒ 00:30:37.710 Uttam: Okay. You’ll take it.
464 00:30:37.710 ⇒ 00:30:38.340 Nicolas Sucari: And that
465 00:30:38.910 ⇒ 00:30:39.980 Nicolas Sucari: cool, perfect
466 00:30:40.783 ⇒ 00:30:53.699 Nicolas Sucari: and I think that’s all that we have for this week, guys. It’s a lot, obviously. But yeah, if we can nail down the evidence stuff and we can start sharing that with pull parts. I think it would be great.
467 00:30:56.940 ⇒ 00:30:57.940 Nicolas Sucari: great thumbball.
468 00:30:58.590 ⇒ 00:30:59.420 Bryce Codell: Sounds good.
469 00:31:00.560 ⇒ 00:31:03.999 Nicolas Sucari: Excellent. Okay, so let’s talk soon. Guys.
470 00:31:04.520 ⇒ 00:31:05.520 Nicolas Sucari: Thank you.
471 00:31:05.520 ⇒ 00:31:06.330 Bryce Codell: Thanks. Everyone.
472 00:31:07.140 ⇒ 00:31:07.750 Nicolas Sucari: And bye
473 00:31:08.380 ⇒ 00:31:09.050 Nicolas Sucari: late.