Meeting Title: Eden Task Snapshot Creation Sync Date: 2026-02-11 Meeting participants: Ashwini Sharma, Demilade Agboola
WEBVTT
1 00:00:50.850 ⇒ 00:00:51.910 Ashwini Sharma: Hey, Dami.
2 00:00:57.190 ⇒ 00:00:58.180 Ashwini Sharma: Hello.
3 00:00:59.910 ⇒ 00:01:01.370 Ashwini Sharma: Hey, am I audible?
4 00:01:02.120 ⇒ 00:01:03.300 Demilade Agboola: Yes, yes, you are.
5 00:01:03.830 ⇒ 00:01:04.780 Ashwini Sharma: Okay, cool.
6 00:01:05.550 ⇒ 00:01:13.220 Ashwini Sharma: Hey, just wanted to run, through that previous eating task that, we were discussing. Let me share my screen.
7 00:01:20.030 ⇒ 00:01:24.659 Ashwini Sharma: Alright, so we were talking about creating a snapshot for this table, right?
8 00:01:25.920 ⇒ 00:01:32.839 Ashwini Sharma: uplifts, campaign… campaign contribution, so… and it’s only for this table, right? Not for any other table?
9 00:01:33.760 ⇒ 00:01:45.000 Demilade Agboola: I mean, we can do for other tables if we want to just kind of see the delta and how things are changing, but this table is the most important because that’s how we will calculate, you know, how much…
10 00:01:45.310 ⇒ 00:01:51.570 Demilade Agboola: Each, influencer was paid on… each, campaign.
11 00:01:51.800 ⇒ 00:02:03.430 Demilade Agboola: Because we can then see… do the disparity between, you know, over time, and say, oh, between, you know, the 7th of February and the 1st of March, the delta was, say, you know.
12 00:02:03.750 ⇒ 00:02:07.320 Demilade Agboola: 10,000.
13 00:02:08.250 ⇒ 00:02:18.249 Ashwini Sharma: And when should it capture the snapshot, right? When these change? I think I forgot what column names were.
14 00:02:18.680 ⇒ 00:02:20.340 Ashwini Sharma: The ones that we sent to you?
15 00:02:20.340 ⇒ 00:02:24.689 Demilade Agboola: Let’s just ensure that… let’s just do, like… the distinct slug.
16 00:02:25.350 ⇒ 00:02:29.920 Demilade Agboola: And can we do, like, a count of slogs, like, the campaign slogs?
17 00:02:30.150 ⇒ 00:02:36.020 Ashwini Sharma: Slug, I know there’s a…
18 00:02:36.020 ⇒ 00:02:42.360 Demilade Agboola: There’s a campaign slash… There’s a slog, though. There’s a campaign on…
19 00:02:43.060 ⇒ 00:02:45.830 Ashwini Sharma: Contributor name, like, the influencer name.
20 00:02:46.700 ⇒ 00:02:50.459 Ashwini Sharma: Yeah, it’s there, but I’m not… okay, Slug is there, yeah, right over here.
21 00:02:50.460 ⇒ 00:02:53.430 Demilade Agboola: Alright, so let’s do… let’s do this thing, let’s no… let’s just do…
22 00:02:53.910 ⇒ 00:02:57.359 Demilade Agboola: do a con… like, do slug count by. Select.
23 00:02:58.150 ⇒ 00:03:03.760 Ashwini Sharma: Okay, let’s do a count of the entire thing first, and then we can see a count of distinct.
24 00:03:05.000 ⇒ 00:03:10.549 Demilade Agboola: No, you can just do, select slog comma, count.
25 00:03:13.490 ⇒ 00:03:20.609 Ashwini Sharma: Very less records, 558, okay. What does that select? Don’t starve this one.
26 00:03:20.720 ⇒ 00:03:22.280 Demilade Agboola: From this, yeah…
27 00:03:26.510 ⇒ 00:03:28.230 Demilade Agboola: Group by one, having…
28 00:03:28.240 ⇒ 00:03:29.209 Ashwini Sharma: You can just…
29 00:03:30.200 ⇒ 00:03:35.390 Demilade Agboola: You can just do having counts greater than 1, yeah, so you just will…
30 00:03:38.470 ⇒ 00:03:39.859 Demilade Agboola: Alright, so it’s located here.
31 00:03:39.860 ⇒ 00:03:40.830 Ashwini Sharma: unique, yeah.
32 00:03:41.360 ⇒ 00:03:47.050 Demilade Agboola: Alright, so since we know slugs are unique, what we can use is that we can use slugs as the…
33 00:03:47.510 ⇒ 00:03:48.970 Demilade Agboola: Unique field.
34 00:03:49.450 ⇒ 00:03:52.439 Demilade Agboola: And then we can snapshot any change.
35 00:03:52.620 ⇒ 00:03:54.569 Demilade Agboola: That occurs on that slope.
36 00:03:55.920 ⇒ 00:04:03.819 Demilade Agboola: if we want to be specific, we can make it certain columns, like the contribution columns, but I think the only things that we’ll be changing are the…
37 00:04:03.940 ⇒ 00:04:11.390 Demilade Agboola: Numerical, like, the actual… financial values.
38 00:04:13.080 ⇒ 00:04:17.420 Demilade Agboola: I don’t think Company ID will change. I don’t think code profile will change.
39 00:04:17.870 ⇒ 00:04:22.830 Demilade Agboola: So it’ll be things like commission rates, maybe they change rates, maybe they’ve increased rates, whatever.
40 00:04:23.100 ⇒ 00:04:26.229 Demilade Agboola: But I think we can just make it on… just make the unique…
41 00:04:27.210 ⇒ 00:04:28.929 Ashwini Sharma: Field, that value.
42 00:04:30.000 ⇒ 00:04:32.990 Ashwini Sharma: Yeah, slug is going to be the unique field, right? And then.
43 00:04:32.990 ⇒ 00:04:41.169 Demilade Agboola: So, with dbt, you can just do any… every column, anytime a column changes, take a snapshot, like, put the snapshot there. So you don’t have to really specify.
44 00:04:41.310 ⇒ 00:04:47.640 Ashwini Sharma: Okay, do we want to do that? Like, any column changes, we want to capture a snapshot, or…
45 00:04:48.630 ⇒ 00:04:54.090 Ashwini Sharma: Do you… do we want to… okay, I think status is also there, yeah. Okay, that makes sense, yeah, any column change here.
46 00:04:59.200 ⇒ 00:05:04.880 Ashwini Sharma: Alright, worded. What else is there?
47 00:05:05.790 ⇒ 00:05:12.549 Ashwini Sharma: I think that should give us, and what were the columns that were of importance over here?
48 00:05:14.560 ⇒ 00:05:18.410 Demilade Agboola: Hmm, give me one second, I cannot remember. It’s right now.
49 00:05:18.680 ⇒ 00:05:24.779 Demilade Agboola: I think we talked about it in the huddle.
50 00:05:25.190 ⇒ 00:05:28.250 Ashwini Sharma: So, commission rate was definitely important, right?
51 00:05:28.530 ⇒ 00:05:30.600 Demilade Agboola: Yeah, commission rates.
52 00:05:32.070 ⇒ 00:05:38.090 Ashwini Sharma: This is, yeah, $50 per transaction, per order. What else.
53 00:05:38.090 ⇒ 00:05:42.870 Demilade Agboola: Do you think there’s some amounts above pending something, something, something? Give me one second.
54 00:05:46.220 ⇒ 00:05:48.069 Demilade Agboola: Influencer price is important.
55 00:05:48.460 ⇒ 00:05:50.150 Ashwini Sharma: Influencer price, yes.
56 00:05:53.550 ⇒ 00:05:54.490 Ashwini Sharma: Okay.
57 00:05:55.210 ⇒ 00:05:57.159 Demilade Agboola: Can you keep scrolling, please?
58 00:06:02.300 ⇒ 00:06:07.879 Demilade Agboola: Yeah, payments re- no, no, payment request, I think, paid amount? Yeah, it was also important.
59 00:06:10.080 ⇒ 00:06:12.949 Demilade Agboola: So all the payment request columns, basically, are important.
60 00:06:13.500 ⇒ 00:06:14.110 Ashwini Sharma: Imrant.
61 00:06:14.110 ⇒ 00:06:15.040 Demilade Agboola: The number of them.
62 00:06:16.860 ⇒ 00:06:17.550 Ashwini Sharma: Okay.
63 00:06:19.410 ⇒ 00:06:20.110 Demilade Agboola: Oh…
64 00:06:21.630 ⇒ 00:06:22.830 Ashwini Sharma: Breed account.
65 00:06:23.990 ⇒ 00:06:25.650 Ashwini Sharma: Pending amount here.
66 00:06:26.100 ⇒ 00:06:26.770 Demilade Agboola: Yeah.
67 00:06:29.670 ⇒ 00:06:31.520 Demilade Agboola: And then…
68 00:06:32.660 ⇒ 00:06:33.440 Ashwini Sharma: Price.
69 00:06:33.940 ⇒ 00:06:35.289 Demilade Agboola: Price is also important.
70 00:06:36.430 ⇒ 00:06:38.199 Demilade Agboola: So, price is how much…
71 00:06:38.410 ⇒ 00:06:43.049 Demilade Agboola: Yeah, price is important. So price is how much they offered them. Influencer price is how much was renegotiated.
72 00:06:43.180 ⇒ 00:06:45.620 Ashwini Sharma: And so if they, if they don’t renegotiate.
73 00:06:45.820 ⇒ 00:06:47.710 Demilade Agboola: Then, influencer price would be known.
74 00:06:48.010 ⇒ 00:06:51.170 Demilade Agboola: I think. You might need to confirm that, but I think that’s what’s going on.
75 00:06:57.350 ⇒ 00:07:00.669 Demilade Agboola: Then influencer price would be no. North price. Influencer price.
76 00:07:01.670 ⇒ 00:07:07.119 Ashwini Sharma: Influencer price, okay, I think I put a price… then influencer price will be now, okay.
77 00:07:11.550 ⇒ 00:07:13.350 Demilade Agboola: Ben…
78 00:07:17.200 ⇒ 00:07:20.450 Demilade Agboola: I think that’s… those are the important things, to be honest.
79 00:07:21.020 ⇒ 00:07:28.930 Demilade Agboola: we just really care about… I think… oh yeah, total affiliation… total sales generated would also be helpful, and total affiliate commission would also be helpful as well.
80 00:07:29.100 ⇒ 00:07:30.890 Ashwini Sharma: To all the affiliated commission, yeah.
81 00:07:40.520 ⇒ 00:07:43.959 Ashwini Sharma: total sales generated, this also might be important, right?
82 00:07:45.180 ⇒ 00:07:47.739 Demilade Agboola: Yes, the throat sales generative can also be very important as well.
83 00:07:50.230 ⇒ 00:07:52.409 Demilade Agboola: And I think user ID will be static.
84 00:07:53.690 ⇒ 00:07:57.409 Demilade Agboola: They shouldn’t… that shouldn’t change, and these are… that’s metadata, so…
85 00:07:57.410 ⇒ 00:08:07.399 Ashwini Sharma: All right. I’ll create a snapshot of this table, and then we’ll circle back again on, you know, how to use it in order to derive the data that we want to send to Polytomic.
86 00:08:07.580 ⇒ 00:08:11.060 Ashwini Sharma: Sorry, North Polytang, to, to North Beam.
87 00:08:11.830 ⇒ 00:08:18.220 Demilade Agboola: Okay, that’s fine, yeah, we’re just flatten it. But yeah, that’s fine. We’ll definitely…
88 00:08:18.220 ⇒ 00:08:20.599 Ashwini Sharma: All right, okay, cool. Thanks, Demi.
89 00:08:20.600 ⇒ 00:08:22.950 Demilade Agboola: Alright then, no problem. Take care, have a great day.
90 00:08:23.150 ⇒ 00:08:24.100 Ashwini Sharma: You too.
91 00:08:24.100 ⇒ 00:08:24.670 Demilade Agboola: Bye.
92 00:08:24.990 ⇒ 00:08:25.810 Ashwini Sharma: But…