Meeting Title: Triaden Cloudflare Worker Implementation Sync Date: 2025-09-29 Meeting participants: Fireflies.ai Notetaker Tigran, Tigran Sahakyan, Henry Zhao, Zoran Selinger
WEBVTT
1 00:04:18.649 ⇒ 00:04:19.790 Henry Zhao: Hi, Tigran.
2 00:04:21.000 ⇒ 00:04:21.870 Tigran Sahakyan: Hey, guys.
3 00:04:27.440 ⇒ 00:04:30.449 Tigran Sahakyan: Oh, I thought… You were too, man.
4 00:04:32.750 ⇒ 00:04:34.120 Tigran Sahakyan: It’s fireflies.
5 00:06:22.140 ⇒ 00:06:22.900 Zoran Selinger: Hello.
6 00:06:25.360 ⇒ 00:06:25.870 Tigran Sahakyan: Cool.
7 00:06:26.960 ⇒ 00:06:28.919 Zoran Selinger: Hi, Tigra, nice to e-meet you.
8 00:06:30.150 ⇒ 00:06:31.560 Tigran Sahakyan: Yeah, nice to meet you, man.
9 00:06:34.240 ⇒ 00:06:40.720 Zoran Selinger: Yeah, I understand you’ve been off for a while, so you’re probably catching up with a lot of different things.
10 00:06:41.180 ⇒ 00:06:41.850 Tigran Sahakyan: Yeah.
11 00:06:42.530 ⇒ 00:06:50.819 Zoran Selinger: Yeah, so maybe, yeah, not sure, how fast we can do this. We don’t want to overwhelm you.
12 00:06:52.020 ⇒ 00:06:59.029 Tigran Sahakyan: Yeah, man, that’s… if needed, then we can… we can think once again, but… yeah, I think that would be… that would be okay.
13 00:06:59.280 ⇒ 00:07:04.849 Zoran Selinger: Sure. Have you had a chance… do you know what we’re trying to do?
14 00:07:05.520 ⇒ 00:07:09.130 Tigran Sahakyan: Not actually. Need more clarification on this.
15 00:07:09.130 ⇒ 00:07:12.230 Zoran Selinger: Okay, I’ll let you know.
16 00:07:12.550 ⇒ 00:07:17.239 Zoran Selinger: Actually, should I just show you? Maybe I should just show you.
17 00:07:18.870 ⇒ 00:07:20.149 Zoran Selinger: Let me just show you.
18 00:07:20.780 ⇒ 00:07:28.769 Zoran Selinger: So what we’re trying to do, basically what’s happening, we are dropping a lot of, campaign…
19 00:07:28.870 ⇒ 00:07:38.410 Zoran Selinger: related UTMs, you know, query parameters in the URL, because of all these prevention… tracking prevention methods that are happening today, right?
20 00:07:39.090 ⇒ 00:07:41.730 Zoran Selinger: So we’re trying to get ahead of that.
21 00:07:41.870 ⇒ 00:07:50.800 Zoran Selinger: And save them before, even before the page loads. The way to do it, one of the ways to do it, is to do this edge
22 00:07:50.800 ⇒ 00:08:02.729 Zoran Selinger: Edge basically do it on the edge. So, Cloudflare workers, to use them, when we’re trying to load a page, we check if, you know, parameters are there and all that.
23 00:08:02.790 ⇒ 00:08:14.279 Zoran Selinger: And if they are, we are going to save them. We’re going to let the page load normally, but in the background, asynchronously, we are going to save this data into a
24 00:08:14.510 ⇒ 00:08:29.000 Zoran Selinger: a BigQuery table. And then Henry and other analysts will basically do the modeling and all that, in terms of, like, stitching orders to the initial, you know, campaign and all that. So,
25 00:08:29.460 ⇒ 00:08:40.270 Zoran Selinger: So basically, what we are doing is, so I have this on my own, website.
26 00:08:40.630 ⇒ 00:08:46.159 Zoran Selinger: just enabled for one of the… one of the pages. Let me share my screen.
27 00:08:46.400 ⇒ 00:08:48.080 Zoran Selinger: All the tab by top.
28 00:08:48.880 ⇒ 00:08:59.840 Zoran Selinger: So I’ll just clue you in, and then basically you, you, you can let, let us know, what you think about, what you think about that.
29 00:09:00.480 ⇒ 00:09:02.930 Zoran Selinger: Let me see… okay, here we are.
30 00:09:06.830 ⇒ 00:09:14.680 Zoran Selinger: Cool, so setup is… fairly simple, okay? So, this is, like, a worker on Cloudflare.
31 00:09:15.070 ⇒ 00:09:19.390 Zoran Selinger: I only have it enabled for one of my blog posts, just
32 00:09:19.500 ⇒ 00:09:27.789 Zoran Selinger: for testing, right? So, we… we got, 3 or 4 landing pages, on Triaden, that…
33 00:09:28.030 ⇒ 00:09:30.030 Zoran Selinger: We should test it on. Yeah.
34 00:09:30.510 ⇒ 00:09:36.550 Zoran Selinger: I said, it’d probably be good to do it on one, but it’s fine if you want to do multiple.
35 00:09:37.180 ⇒ 00:09:55.210 Zoran Selinger: Out of the setup, we need a few secrets and a few, few, kind of variables, in there. So, session timeout is basically when the session, ID will expire, right? And the user cookie will, you know.
36 00:09:55.470 ⇒ 00:09:58.589 Zoran Selinger: Same thing, gets a little bit more.
37 00:09:58.760 ⇒ 00:10:12.410 Zoran Selinger: This is something, we are also… so when we are forwarding, when we are forwarding the request, we are adding this user cook… user ID into a cookie.
38 00:10:13.350 ⇒ 00:10:29.450 Zoran Selinger: That is not HTTP only, so it can be read by Google Tag Manager and put into different tags that we have on there. So we will be able to… basically, we are deciding what the user identifier for… for a segment
39 00:10:29.450 ⇒ 00:10:36.419 Zoran Selinger: for NordBeam is, for Google Analytics 4 with this. We are deciding what it is.
40 00:10:36.480 ⇒ 00:10:43.190 Zoran Selinger: Code itself is very simple. We have, what, 400 lines.
41 00:10:44.230 ⇒ 00:10:51.570 Zoran Selinger: So this is… this is what it’s doing, you know, it’s just checking if it’s the first page, basically, if,
42 00:10:51.900 ⇒ 00:11:11.019 Zoran Selinger: the naming is not, really, really, accurate here. Really, what it’s checking is if the session already started. Do we have a current session in progress, right? If we do, just do nothing, just forward it and load the page normally. If
43 00:11:11.020 ⇒ 00:11:15.990 Zoran Selinger: If we don’t, then we check, do we have UTM parameters or click IDs?
44 00:11:16.360 ⇒ 00:11:17.470 Zoran Selinger: If you do.
45 00:11:18.000 ⇒ 00:11:31.740 Zoran Selinger: we wanna, we wanna, you know, initialize a few things, like those, session IDs and, and, and user IDs, and we also, basically, that’s what we, what we forward.
46 00:11:31.740 ⇒ 00:11:34.790 Tigran Sahakyan: We forward this, modified request.
47 00:11:34.830 ⇒ 00:11:50.100 Zoran Selinger: Basically, modified request is just… the way it’s modified, we’re just adding these, these two things into cookies. So, session ID and user ID end up in a cookie. And everything else,
48 00:11:50.110 ⇒ 00:11:56.540 Zoran Selinger: So, then, if there are any UTM or click parameters, we are actually going to save it into a table.
49 00:11:57.290 ⇒ 00:12:03.620 Zoran Selinger: And only in those two cases. So that gets… sent into a BigQuery table.
50 00:12:04.960 ⇒ 00:12:21.719 Zoran Selinger: And that is really it. At the end, modified, response gets sent, and that is… that’s it. That’s everything. We have no impact on… on user experience, pages load, everything is… is done asynchronously there. So that’s… that’s good.
51 00:12:23.240 ⇒ 00:12:31.580 Zoran Selinger: And yeah, that’s, for now, a very simple, use case. We… we might add more features to this.
52 00:12:31.910 ⇒ 00:12:39.499 Zoran Selinger: But for now, this is everything that we want to do. This is how it looks like. It’s a very simple
53 00:12:40.020 ⇒ 00:12:47.230 Zoran Selinger: Very simple table. We got a timestamp, hashed type P, since we cannot save unhashed in BigQuery.
54 00:12:47.560 ⇒ 00:12:53.440 Zoran Selinger: we have the actual page URL with all the, you know, relevant query parameters, and then
55 00:12:54.130 ⇒ 00:13:07.789 Zoran Selinger: we just populate the fields. These are our session ID and user ID, and that’s it. Then Henry will be able to take these tables and, you know, merge with everything else that he has on the orders and everything.
56 00:13:08.120 ⇒ 00:13:13.310 Zoran Selinger: And this will be very helpful because this is the information we are actually losing.
57 00:13:13.570 ⇒ 00:13:32.500 Zoran Selinger: When we try to attribute. We cannot attribute that first session, first campaign, you know, first medium, first affiliate. We are losing a lot of that, so this is going to fix that. So that’s what we’re trying to do. I have the code that’s ready, ready for you.
58 00:13:32.650 ⇒ 00:13:38.970 Zoran Selinger: you know, setup is, like I said, pretty simple in terms of… in terms of these, these settings.
59 00:13:39.650 ⇒ 00:13:42.800 Zoran Selinger: That can be done manually, or through the CLI, whatever.
60 00:13:43.200 ⇒ 00:13:45.749 Zoran Selinger: Whatever you’re comfortable with,
61 00:13:47.530 ⇒ 00:13:51.920 Zoran Selinger: Yes, so that’s basically… that’s it.
62 00:13:52.580 ⇒ 00:13:55.999 Zoran Selinger: We would love to do it as soon as possible.
63 00:13:57.620 ⇒ 00:13:58.440 Tigran Sahakyan: L.
64 00:13:58.440 ⇒ 00:14:00.889 Zoran Selinger: We’re gonna start collecting some data, you know.
65 00:14:02.000 ⇒ 00:14:10.220 Tigran Sahakyan: Yeah, no, like, even… even, like, if you… if you can just help me now to do that, I can share my screen and we do that together.
66 00:14:11.160 ⇒ 00:14:12.719 Tigran Sahakyan: If you want. Sure.
67 00:14:12.720 ⇒ 00:14:20.500 Zoran Selinger: Sure. Let’s… We will need a… Mmm, actually…
68 00:14:26.480 ⇒ 00:14:28.280 Zoran Selinger: Henry, are you here?
69 00:14:29.860 ⇒ 00:14:30.880 Henry Zhao: Yes, I am.
70 00:14:31.360 ⇒ 00:14:35.549 Zoran Selinger: We want to do this in our project that we have access to, right?
71 00:14:36.080 ⇒ 00:14:36.990 Henry Zhao: Yeah.
72 00:14:37.380 ⇒ 00:14:44.570 Zoran Selinger: Okay, so we need, we need to set up, you know, have the service account, key.
73 00:14:44.570 ⇒ 00:14:46.330 Henry Zhao: And we need a…
74 00:14:46.330 ⇒ 00:14:48.610 Zoran Selinger: a BigQuery table for it.
75 00:14:49.790 ⇒ 00:14:50.460 Henry Zhao: Okay.
76 00:14:50.940 ⇒ 00:14:54.489 Zoran Selinger: Because this is now on my personal project, right?
77 00:14:55.280 ⇒ 00:14:58.470 Zoran Selinger: So we need… we need that. Let me send you the schema.
78 00:14:58.470 ⇒ 00:15:00.740 Henry Zhao: Should I create a separate service key for this?
79 00:15:02.060 ⇒ 00:15:05.089 Zoran Selinger: I mean, whatever service key you have.
80 00:15:06.510 ⇒ 00:15:11.819 Zoran Selinger: If you have a certain… so, I mean, that could be useful, right? Because you can…
81 00:15:11.820 ⇒ 00:15:13.640 Henry Zhao: Put it in the attribution data sets.
82 00:15:16.300 ⇒ 00:15:25.310 Zoran Selinger: Sure, I mean, I don’t know, like, I’m new, so I’m not sure… I don’t have a view of what we exactly have in BigQuery.
83 00:15:25.410 ⇒ 00:15:31.900 Zoran Selinger: So whatever table you give me, and the service account key, let’s use that.
84 00:15:32.820 ⇒ 00:15:44.469 Zoran Selinger: So, Tigran, if you want, yeah, let’s log in, and let’s start creating this age worker. In the meantime, we’ll get the secrets for you.
85 00:15:44.700 ⇒ 00:15:47.760 Zoran Selinger: So, the pages that we got.
86 00:15:57.340 ⇒ 00:16:02.159 Tigran Sahakyan: Cool, man, do you want me to share the screen, and you kind of coordinate?
87 00:16:02.160 ⇒ 00:16:03.550 Zoran Selinger: Sure, let’s, let’s do that.
88 00:16:04.490 ⇒ 00:16:05.430 Tigran Sahakyan: Oh.
89 00:16:06.320 ⇒ 00:16:12.240 Tigran Sahakyan: Okay, if you can give me… Permission to share the screen.
90 00:16:12.480 ⇒ 00:16:13.120 Henry Zhao: But…
91 00:16:15.330 ⇒ 00:16:17.279 Zoran Selinger: I’ll stop my sharing.
92 00:16:19.530 ⇒ 00:16:20.410 Zoran Selinger: All right.
93 00:16:20.410 ⇒ 00:16:22.249 Henry Zhao: What permissions do I need to give the service key?
94 00:16:24.510 ⇒ 00:16:26.489 Zoran Selinger: Sorry, Annie, say again?
95 00:16:26.490 ⇒ 00:16:29.070 Henry Zhao: The service key, what permissions do I need to give it?
96 00:16:29.590 ⇒ 00:16:37.060 Zoran Selinger: So the only thing that we are doing with it is, we are, saving data into BigQuery.
97 00:16:37.330 ⇒ 00:16:44.880 Zoran Selinger: To keep it simple, you can do the BigQuery admin, who do the job,
98 00:16:44.880 ⇒ 00:16:48.270 Henry Zhao: Let’s see what I… I mean, I can tell you exactly what I have.
99 00:16:48.940 ⇒ 00:16:51.929 Zoran Selinger: I probably gave it to BigQuery admin.
100 00:16:53.210 ⇒ 00:16:54.260 Zoran Selinger: permissions.
101 00:16:57.530 ⇒ 00:16:59.109 Henry Zhao: But editors should be okay, right?
102 00:17:00.080 ⇒ 00:17:02.229 Zoran Selinger: Should be okay as well, yes.
103 00:17:04.280 ⇒ 00:17:04.939 Henry Zhao: I’ll give you the.
104 00:17:04.940 ⇒ 00:17:10.690 Zoran Selinger: sending you a, a schema, SQL query for…
105 00:17:12.310 ⇒ 00:17:19.099 Zoran Selinger: the schema that we have. I’ve just, changed the… the…
106 00:17:20.829 ⇒ 00:17:23.730 Zoran Selinger: dataset ID on the first line.
107 00:17:27.280 ⇒ 00:17:34.170 Zoran Selinger: And if you see anything there that needs change, if you think that partitioning and clustering and options are not,
108 00:17:35.660 ⇒ 00:17:37.380 Zoran Selinger: Are not needed.
109 00:17:38.970 ⇒ 00:17:40.230 Zoran Selinger: It’s up to you.
110 00:17:50.560 ⇒ 00:17:58.620 Zoran Selinger: So we should, say, send the service key to… to Tigran.
111 00:18:02.340 ⇒ 00:18:09.349 Tigran Sahakyan: And do we need this to-do on some particular domain, or just on the general account?
112 00:18:10.330 ⇒ 00:18:12.260 Tigran Sahakyan: Cloudflare, on Cloudflare.
113 00:18:12.540 ⇒ 00:18:16.550 Zoran Selinger: Oh, sorry, let me give you the pages that we got for this.
114 00:18:18.570 ⇒ 00:18:23.699 Zoran Selinger: So, you can, you can read it from there.
115 00:18:24.200 ⇒ 00:18:27.110 Zoran Selinger: you are more familiar than I am.
116 00:18:27.300 ⇒ 00:18:31.910 Zoran Selinger: Let me just find it.
117 00:18:32.710 ⇒ 00:18:33.690 Zoran Selinger: Okay…
118 00:18:37.730 ⇒ 00:18:41.029 Zoran Selinger: you have access to… to Slack, right?
119 00:18:41.530 ⇒ 00:18:44.000 Zoran Selinger: Yeah. I’m just sending you a,
120 00:18:52.090 ⇒ 00:18:54.340 Zoran Selinger: Actually, let me just do this.
121 00:18:58.230 ⇒ 00:19:05.070 Zoran Selinger: In the chat, this is the message, and then Danny… replied with the following.
122 00:19:08.700 ⇒ 00:19:10.349 Zoran Selinger: So these are the pages.
123 00:19:15.020 ⇒ 00:19:16.380 Tigran Sahakyan: Were you sharing?
124 00:19:17.370 ⇒ 00:19:19.589 Tigran Sahakyan: It’s in our chat, okay.
125 00:19:19.590 ⇒ 00:19:21.669 Zoran Selinger: Yeah, yeah, it’s… it’s in…
126 00:19:23.170 ⇒ 00:19:24.100 Tigran Sahakyan: Okay.
127 00:19:25.590 ⇒ 00:19:30.519 Tigran Sahakyan: Okay, so all three are under… Trade and dot com.
128 00:19:42.790 ⇒ 00:19:46.420 Tigran Sahakyan: Is this that workers’ routes, or…
129 00:19:47.960 ⇒ 00:19:48.690 Zoran Selinger: Sorry?
130 00:19:49.940 ⇒ 00:19:59.709 Tigran Sahakyan: When I go to the domain page, like, here I see that Compute Workers, which you have built.
131 00:19:59.840 ⇒ 00:20:02.149 Tigran Sahakyan: those ones, right? But this is on the general…
132 00:20:02.150 ⇒ 00:20:05.819 Zoran Selinger: No, no, no, so I’ve done nothing on your account.
133 00:20:08.230 ⇒ 00:20:18.699 Tigran Sahakyan: and… So, we are not doing this on Cloudflare, or…
134 00:20:20.040 ⇒ 00:20:21.090 Zoran Selinger: Sorry, second?
135 00:20:22.180 ⇒ 00:20:27.000 Tigran Sahakyan: Okay, so this is Adam’s… Trident Comm account, where… Okay.
136 00:20:27.000 ⇒ 00:20:30.309 Zoran Selinger: all our domains and etc, so everything is here.
137 00:20:30.390 ⇒ 00:20:34.570 Tigran Sahakyan: I have access here. So, whatever we are going to do.
138 00:20:34.740 ⇒ 00:20:41.990 Tigran Sahakyan: We gonna do on the general account, or just on… this Trident.com domain.
139 00:20:45.840 ⇒ 00:20:51.859 Zoran Selinger: So, for now, for sure, Henry, and I think we’re just doing it for Trident right now, right?
140 00:20:53.300 ⇒ 00:20:54.030 Henry Zhao: Yeah.
141 00:20:56.690 ⇒ 00:21:00.379 Zoran Selinger: Yeah, we… I don’t think we… we talked about, expanding this.
142 00:21:01.390 ⇒ 00:21:02.430 Tigran Sahakyan: Okay, okay.
143 00:21:02.700 ⇒ 00:21:05.519 Tigran Sahakyan: You just need, guys, to help me.
144 00:21:05.760 ⇒ 00:21:10.989 Tigran Sahakyan: figure out, like, where to go, because I’m not pro… In all this, and…
145 00:21:11.100 ⇒ 00:21:14.239 Tigran Sahakyan: Yeah, definitely need your… your help.
146 00:21:16.190 ⇒ 00:21:28.000 Zoran Selinger: okay, so let’s, let’s… Go to, to work… to workers…
147 00:21:28.670 ⇒ 00:21:29.529 Tigran Sahakyan: This one?
148 00:21:29.690 ⇒ 00:21:30.340 Zoran Selinger: Yep.
149 00:21:32.210 ⇒ 00:21:33.100 Tigran Sahakyan: Okay.
150 00:21:36.610 ⇒ 00:21:44.700 Zoran Selinger: Let’s go… let’s go to Manage Workers, then we will attach to a… Yeah.
151 00:21:44.950 ⇒ 00:21:50.499 Zoran Selinger: create application. I do… I did this through CLI.
152 00:21:54.210 ⇒ 00:21:57.950 Zoran Selinger: So go with, Stargate Hello World, I think.
153 00:21:58.290 ⇒ 00:21:59.569 Zoran Selinger: Yeah, yeah, yeah.
154 00:22:02.500 ⇒ 00:22:10.279 Zoran Selinger: Alright… Yeah, you can give it a descriptive name, so you know what it is.
155 00:22:10.410 ⇒ 00:22:16.229 Zoran Selinger: So that would be… I don’t know, what’s… what would be, a descriptive name.
156 00:22:16.230 ⇒ 00:22:21.490 Tigran Sahakyan: So, for each of these URLs, we are making single… War.
157 00:22:21.490 ⇒ 00:22:28.549 Zoran Selinger: Yes, we will, yeah, yes. URL won’t matter, we will add routes in the settings.
158 00:22:28.920 ⇒ 00:22:32.080 Zoran Selinger: After we create it, we will add a.
159 00:22:32.080 ⇒ 00:22:32.480 Tigran Sahakyan: I see.
160 00:22:32.480 ⇒ 00:22:33.210 Zoran Selinger: seconds.
161 00:22:33.210 ⇒ 00:22:37.340 Tigran Sahakyan: Ofer, so more lean… the world.
162 00:22:37.680 ⇒ 00:22:42.070 Tigran Sahakyan: 6. I’m putting almost the same name as on the URL.
163 00:22:42.740 ⇒ 00:22:52.600 Zoran Selinger: Hmm… I wouldn’t… so this is not the description, because this is gonna be… this is gonna be rolled out to a whole website.
164 00:22:53.800 ⇒ 00:22:54.610 Tigran Sahakyan: Oh.
165 00:22:55.370 ⇒ 00:22:58.220 Zoran Selinger: Eventually. We just want to test it first.
166 00:22:58.540 ⇒ 00:23:08.590 Zoran Selinger: So, I think it’s better if we, if we give it a functional name, so what it’s actually doing. So, something like,
167 00:23:08.690 ⇒ 00:23:17.319 Zoran Selinger: like, first campaign… First Dash campaign.
168 00:23:17.450 ⇒ 00:23:26.110 Zoran Selinger: preserver or something like that. So, English, not my, not my first language, but I think, that.
169 00:23:26.110 ⇒ 00:23:30.400 Tigran Sahakyan: Mine as well. Yeah. Okay, yeah, let’s… let’s try.
170 00:23:30.400 ⇒ 00:23:40.729 Zoran Selinger: That, yeah, that… I think that makes sense. I think it’s possible to rename it later if you need to. Let’s go to deploy it, and I’m sending you the code.
171 00:23:42.770 ⇒ 00:23:47.620 Tigran Sahakyan: Should I put any code here before deploying, or just need to.
172 00:23:47.620 ⇒ 00:23:52.449 Zoran Selinger: No, you can just deploy, we will rewrite it in the next version.
173 00:23:53.300 ⇒ 00:23:54.120 Tigran Sahakyan: Okay.
174 00:23:54.130 ⇒ 00:23:59.980 Zoran Selinger: So I’m sending it to you in a private message on Slack.
175 00:24:28.070 ⇒ 00:24:31.039 Zoran Selinger: So we need to just be very, very careful.
176 00:24:36.350 ⇒ 00:24:42.689 Zoran Selinger: Looks like my… Okay, let me just… I’ll send you a file, actually.
177 00:24:43.180 ⇒ 00:24:48.329 Zoran Selinger: Not just pasted in a message.
178 00:24:48.790 ⇒ 00:24:51.579 Zoran Selinger: Just directly send you a file.
179 00:25:18.810 ⇒ 00:25:20.499 Zoran Selinger: No, that’s not the one.
180 00:25:24.720 ⇒ 00:25:25.959 Zoran Selinger: Yes, that’s the word.
181 00:25:42.420 ⇒ 00:25:44.410 Zoran Selinger: File like this cannot be shared.
182 00:25:44.720 ⇒ 00:25:46.079 Zoran Selinger: What does that mean?
183 00:25:47.820 ⇒ 00:25:49.830 Zoran Selinger: Let me try to zip it.
184 00:25:52.400 ⇒ 00:25:53.220 Tigran Sahakyan: Maybe.
185 00:26:18.140 ⇒ 00:26:19.970 Zoran Selinger: It wants to send a zip.
186 00:26:35.550 ⇒ 00:26:39.130 Zoran Selinger: So you should receive… you should have received a message on Slack?
187 00:26:39.790 ⇒ 00:26:40.790 Zoran Selinger: With a zip file.
188 00:26:40.790 ⇒ 00:26:42.710 Tigran Sahakyan: Yeah, I mean, yeah, obviously.
189 00:26:44.500 ⇒ 00:26:45.510 Tigran Sahakyan: Okay…
190 00:26:51.330 ⇒ 00:26:52.189 Tigran Sahakyan: Thanks for that.
191 00:26:58.590 ⇒ 00:27:01.100 Tigran Sahakyan: Okay, that’s that index.jess.
192 00:27:02.260 ⇒ 00:27:08.109 Zoran Selinger: Yeah, that’s… that’s everything. That’s… all the… all 400 lines are there.
193 00:27:09.780 ⇒ 00:27:13.420 Tigran Sahakyan: Okay… Let me see a link…
194 00:27:18.530 ⇒ 00:27:20.710 Tigran Sahakyan: Script host dedicated.
195 00:27:27.880 ⇒ 00:27:30.410 Tigran Sahakyan: Can I open it with Notepad, just?
196 00:27:31.570 ⇒ 00:27:40.710 Zoran Selinger: Yeah, just make sure it’s an, you’re opening, in it with something that’s not formatting. So, if you’re… are… you’re a Windows?
197 00:27:40.710 ⇒ 00:27:43.730 Tigran Sahakyan: Yeah, yeah, just the notepad would be perfect.
198 00:27:44.960 ⇒ 00:27:47.400 Tigran Sahakyan: Okay, here, here it is.
199 00:27:49.420 ⇒ 00:27:55.760 Zoran Selinger: Yeah, just CTRL-A, CTRL-C, and paste it into a worker.
200 00:27:59.820 ⇒ 00:28:02.360 Tigran Sahakyan: Okay, and edit code.
201 00:28:02.680 ⇒ 00:28:03.280 Zoran Selinger: Yep.
202 00:28:06.740 ⇒ 00:28:07.300 Tigran Sahakyan: Yep.
203 00:28:20.580 ⇒ 00:28:22.670 Tigran Sahakyan: Okay, I am passing it here.
204 00:28:23.100 ⇒ 00:28:24.839 Tigran Sahakyan: Instead of this, right?
205 00:28:25.860 ⇒ 00:28:29.900 Zoran Selinger: Yeah, just to get rid of everything and just paste what I have there.
206 00:28:30.190 ⇒ 00:28:31.020 Tigran Sahakyan: Wow.
207 00:28:32.810 ⇒ 00:28:33.780 Tigran Sahakyan: Okay.
208 00:28:34.000 ⇒ 00:28:34.380 Zoran Selinger: Excellent.
209 00:28:34.380 ⇒ 00:28:35.740 Tigran Sahakyan: Deployd.
210 00:28:36.220 ⇒ 00:28:36.800 Zoran Selinger: Yeah.
211 00:28:44.050 ⇒ 00:28:45.590 Tigran Sahakyan: Okay, that’s safe.
212 00:28:53.010 ⇒ 00:29:00.070 Zoran Selinger: That is it. Okay, cool. Let’s… Okay, let’s add the…
213 00:29:02.950 ⇒ 00:29:07.849 Zoran Selinger: The parameters now to the settings, so you can go out of that.
214 00:29:08.200 ⇒ 00:29:10.009 Zoran Selinger: Go back… yeah.
215 00:29:10.980 ⇒ 00:29:12.990 Zoran Selinger: That’s good, go to the settings.
216 00:29:15.660 ⇒ 00:29:21.009 Zoran Selinger: And where you see variables and secrets, let’s… let’s add some.
217 00:29:21.250 ⇒ 00:29:24.680 Zoran Selinger: Okay, I have the information here.
218 00:29:38.940 ⇒ 00:29:43.480 Zoran Selinger: I have the info here, let me just, oh, my…
219 00:29:46.180 ⇒ 00:29:50.329 Zoran Selinger: My battery’s gonna go… just see what I can do.
220 00:29:53.300 ⇒ 00:29:57.320 Zoran Selinger: Let me just plug in my… My Mac…
221 00:30:53.730 ⇒ 00:30:54.720 Zoran Selinger: first…
222 00:30:59.480 ⇒ 00:31:00.410 Zoran Selinger: Oh, sorry.
223 00:31:00.410 ⇒ 00:31:00.890 Henry Zhao: I’m here.
224 00:31:00.890 ⇒ 00:31:01.850 Zoran Selinger: It was me?
225 00:31:01.970 ⇒ 00:31:03.320 Zoran Selinger: Okay, Anthony?
226 00:31:03.520 ⇒ 00:31:04.520 Henry Zhao: Yeah.
227 00:31:05.020 ⇒ 00:31:12.560 Zoran Selinger: Can you give us the… so the first thing that we need to do… is,
228 00:31:12.900 ⇒ 00:31:17.059 Zoran Selinger: Tigran, I’m pasting into… where’s the most convenient for you?
229 00:31:18.210 ⇒ 00:31:20.310 Tigran Sahakyan: I… nothing slag.
230 00:31:21.980 ⇒ 00:31:26.090 Tigran Sahakyan: Or whatever you want, man. Both are okay.
231 00:31:28.490 ⇒ 00:31:29.300 Zoran Selinger: Hmm…
232 00:31:30.080 ⇒ 00:31:36.920 Zoran Selinger: So I’m pasting it on Slack, so this… just the names of the… of the variables, that we need.
233 00:31:37.270 ⇒ 00:31:37.900 Zoran Selinger: So this is.
234 00:31:37.900 ⇒ 00:31:38.280 Tigran Sahakyan: space.
235 00:31:38.280 ⇒ 00:31:41.060 Zoran Selinger: secret. First thing is a secret.
236 00:31:41.250 ⇒ 00:31:48.169 Zoran Selinger: So that’s the name, and the value of the secret is, dataset ID, Henry.
237 00:31:51.100 ⇒ 00:31:52.040 Henry Zhao: Can you…
238 00:31:52.040 ⇒ 00:31:53.969 Zoran Selinger: Give it to… to Tigrant?
239 00:31:54.670 ⇒ 00:31:57.390 Henry Zhao: Should be… just attribution.
240 00:31:59.560 ⇒ 00:32:03.089 Zoran Selinger: Just a… It’s just attribution, okay?
241 00:32:03.550 ⇒ 00:32:04.640 Zoran Selinger: Mmm…
242 00:32:17.750 ⇒ 00:32:22.499 Zoran Selinger: Yeah, so Tigran just, yeah, you just write attribution there.
243 00:32:22.610 ⇒ 00:32:25.430 Zoran Selinger: Then next is BigQuery Project ID.
244 00:32:26.990 ⇒ 00:32:28.960 Tigran Sahakyan: I’m deploying this one, right?
245 00:32:30.410 ⇒ 00:32:32.590 Tigran Sahakyan: Or… Oh, I know.
246 00:32:33.240 ⇒ 00:32:37.240 Tigran Sahakyan: Yeah, yes, the other one is another secret. Okay, okay, I got it.
247 00:32:37.780 ⇒ 00:32:39.239 Tigran Sahakyan: Okay, this one is… Yes.
248 00:32:39.240 ⇒ 00:32:41.710 Zoran Selinger: We will have several.
249 00:32:43.090 ⇒ 00:32:43.830 Tigran Sahakyan: Okay
250 00:32:50.280 ⇒ 00:32:56.469 Tigran Sahakyan: It’s going to be a secret value name… Okay, and value.
251 00:32:59.940 ⇒ 00:33:00.600 Zoran Selinger: Anthony?
252 00:33:04.210 ⇒ 00:33:06.719 Henry Zhao: I sent it to you in my email’s around, if you can get it from there.
253 00:33:12.850 ⇒ 00:33:14.080 Henry Zhao: Super nice.
254 00:33:18.860 ⇒ 00:33:21.560 Henry Zhao: I’ll send it in the Zoom, because it’s probably more secure.
255 00:33:31.580 ⇒ 00:33:35.160 Zoran Selinger: So, the project… IDEs…
256 00:33:35.380 ⇒ 00:33:36.409 Henry Zhao: And in Slack.
257 00:33:44.360 ⇒ 00:33:45.570 Tigran Sahakyan: It’s big.
258 00:33:46.580 ⇒ 00:33:47.239 Henry Zhao: Alright, there it is.
259 00:33:47.240 ⇒ 00:33:47.980 Tigran Sahakyan: Okay…
260 00:33:51.440 ⇒ 00:33:56.920 Zoran Selinger: And then we have the… table ID?
261 00:33:57.870 ⇒ 00:34:04.049 Tigran Sahakyan: So… all this code, Henry, I’m passing on the value here.
262 00:34:07.000 ⇒ 00:34:17.139 Zoran Selinger: No, no, just the project ID, just Eden Data Warehouse here. But, okay, leave it there, leave it there, leave the value there, just change the,
263 00:34:17.340 ⇒ 00:34:28.259 Zoran Selinger: Change the variable name, Into, because we need to do that as well. Just change it to this.
264 00:34:35.670 ⇒ 00:34:40.330 Zoran Selinger: Just change it to this, and… Should be good.
265 00:34:40.690 ⇒ 00:34:41.600 Zoran Selinger: Because that’s the…
266 00:34:41.600 ⇒ 00:34:42.500 Tigran Sahakyan: Oh, okay, man.
267 00:34:42.500 ⇒ 00:34:44.519 Zoran Selinger: That’s the variable that we need.
268 00:34:44.750 ⇒ 00:34:45.630 Zoran Selinger: Anyway…
269 00:34:45.630 ⇒ 00:34:46.370 Tigran Sahakyan: I’m good.
270 00:34:51.360 ⇒ 00:34:51.909 Zoran Selinger: Yeah.
271 00:34:52.040 ⇒ 00:34:59.270 Zoran Selinger: deploy this, then go back to the BigQuery project ID and paste this Eden data warehouse.
272 00:34:59.470 ⇒ 00:35:00.030 Tigran Sahakyan: Okay.
273 00:35:00.030 ⇒ 00:35:00.720 Zoran Selinger: Hmm.
274 00:35:29.030 ⇒ 00:35:31.720 Zoran Selinger: And then the last thing, table ID.
275 00:35:32.550 ⇒ 00:35:35.230 Zoran Selinger: Henry, do you have a table ID for us?
276 00:35:35.450 ⇒ 00:35:38.259 Henry Zhao: No, I’m gonna create one. What should I call the table?
277 00:35:39.780 ⇒ 00:35:43.850 Zoran Selinger: Oh, I called it, you see in the schema that I sent you.
278 00:35:44.230 ⇒ 00:35:49.210 Zoran Selinger: On the top. I just called it the UTM… something?
279 00:35:49.570 ⇒ 00:35:52.319 Henry Zhao: I’m tracking, but I already have that. Are we putting it in that table?
280 00:35:54.800 ⇒ 00:36:04.380 Zoran Selinger: I would create a new table. Name it anything you want, really, because you’re the one that’s going to work with it. So, just name it whatever makes sense to you.
281 00:36:05.030 ⇒ 00:36:06.519 Henry Zhao: That’s very okay.
282 00:36:07.550 ⇒ 00:36:08.350 Zoran Selinger: Sorry?
283 00:36:08.350 ⇒ 00:36:10.009 Henry Zhao: Edge layer raw data, maybe?
284 00:36:10.830 ⇒ 00:36:12.059 Zoran Selinger: Yeah, true.
285 00:36:12.910 ⇒ 00:36:14.290 Henry Zhao: That makes sense.
286 00:36:14.380 ⇒ 00:36:15.130 Zoran Selinger: Yep.
287 00:36:15.810 ⇒ 00:36:18.200 Zoran Selinger: You can just paste it here as well, so…
288 00:36:21.080 ⇒ 00:36:22.899 Zoran Selinger: Lotigran can take it.
289 00:36:23.100 ⇒ 00:36:24.010 Zoran Selinger: Okay.
290 00:36:31.340 ⇒ 00:36:34.279 Zoran Selinger: Oh, excellent. So we have,
291 00:36:34.480 ⇒ 00:36:43.979 Zoran Selinger: four secrets, and now we just have two, variables. They call… they are called… what do they call it?
292 00:36:45.280 ⇒ 00:36:50.519 Zoran Selinger: Plain text, just plain text, and the value is 30.
293 00:36:50.740 ⇒ 00:36:51.470 Zoran Selinger: Here.
294 00:36:51.470 ⇒ 00:36:54.090 Tigran Sahakyan: So this is not a secret, this is just a text.
295 00:36:54.090 ⇒ 00:36:57.090 Zoran Selinger: This is not a secret, yeah, this is just plain text, yeah.
296 00:36:57.450 ⇒ 00:36:58.200 Tigran Sahakyan: Okay.
297 00:36:58.540 ⇒ 00:37:00.929 Tigran Sahakyan: Basically, an environment variable.
298 00:37:04.480 ⇒ 00:37:05.740 Tigran Sahakyan: Okay…
299 00:37:14.950 ⇒ 00:37:15.900 Zoran Selinger: Exactly.
300 00:37:16.340 ⇒ 00:37:18.520 Zoran Selinger: That’s it, and you have another one.
301 00:37:34.880 ⇒ 00:37:39.680 Zoran Selinger: Henry, is the table ready for us?
302 00:37:40.550 ⇒ 00:37:41.430 Henry Zhao: This is an empty table.
303 00:37:41.430 ⇒ 00:37:42.120 Zoran Selinger: It is?
304 00:37:42.470 ⇒ 00:37:47.820 Zoran Selinger: Okay, cool, cool. So now, let’s try to test it.
305 00:37:50.130 ⇒ 00:37:53.049 Zoran Selinger: Let’s go to,
306 00:37:53.290 ⇒ 00:38:05.239 Zoran Selinger: So, Tigran, you see on the top right, you have, like, the code icon, yeah, the middle one, the middle one. Let’s go with the middle one. That opens the code, and opens this little preview.
307 00:38:07.540 ⇒ 00:38:08.030 Tigran Sahakyan: At this point.
308 00:38:08.770 ⇒ 00:38:10.879 Zoran Selinger: Yeah, let’s wait it to load.
309 00:38:12.970 ⇒ 00:38:19.490 Zoran Selinger: I’m not sure if… We are going to be able to test it with this particular
310 00:38:19.770 ⇒ 00:38:23.889 Zoran Selinger: One, but let’s, all… let’s add…
311 00:38:24.100 ⇒ 00:38:28.410 Zoran Selinger: I’ll just add this. I’m sending… it to you.
312 00:38:29.680 ⇒ 00:38:32.720 Zoran Selinger: UTM source equals test.
313 00:38:33.640 ⇒ 00:38:40.479 Zoran Selinger: Just add that to the end of… of the URL, and reload.
314 00:38:45.100 ⇒ 00:38:46.230 Zoran Selinger: Let’s go.
315 00:38:46.480 ⇒ 00:38:47.779 Zoran Selinger: What do we see?
316 00:38:49.700 ⇒ 00:38:54.480 Tigran Sahakyan: Error getting Google Access Token. Error getting Google Access Token.
317 00:38:54.830 ⇒ 00:38:56.290 Tigran Sahakyan: Dome exception.
318 00:38:57.840 ⇒ 00:38:59.380 Tigran Sahakyan: Invalid ID chart.
319 00:38:59.380 ⇒ 00:38:59.750 Zoran Selinger: Yeah.
320 00:38:59.750 ⇒ 00:39:00.540 Tigran Sahakyan: That’s…
321 00:39:00.780 ⇒ 00:39:08.199 Zoran Selinger: Let’s expand it, let’s see what we are… Actually, let me,
322 00:39:09.370 ⇒ 00:39:13.420 Zoran Selinger: So, Henry, let me just check…
323 00:39:16.820 ⇒ 00:39:22.789 Zoran Selinger: what permissions I actually have on this service account. Maybe we needed something else.
324 00:39:26.460 ⇒ 00:39:27.900 Zoran Selinger: Let me just confirm…
325 00:40:12.710 ⇒ 00:40:16.250 Zoran Selinger: Yeah, just a BigQuery admin, and it worked.
326 00:40:17.310 ⇒ 00:40:18.510 Zoran Selinger: for us?
327 00:40:20.440 ⇒ 00:40:21.720 Henry Zhao: Let me…
328 00:40:22.230 ⇒ 00:40:24.990 Zoran Selinger: Invalid character error. Oh, okay.
329 00:40:27.760 ⇒ 00:40:28.550 Henry Zhao: What does that mean?
330 00:40:42.000 ⇒ 00:40:45.869 Zoran Selinger: Let me, have a quick look into something.
331 00:41:13.580 ⇒ 00:41:21.590 Zoran Selinger: Tigran, let’s make sure that we add the… the service key.
332 00:41:21.810 ⇒ 00:41:26.939 Zoran Selinger: without, white spaces. So, for example, the last line.
333 00:41:27.540 ⇒ 00:41:33.450 Zoran Selinger: Let’s not have the empty line at the end, or anything like that.
334 00:41:34.430 ⇒ 00:41:35.659 Zoran Selinger: If we do.
335 00:41:35.980 ⇒ 00:41:38.089 Zoran Selinger: So you can edit the secret.
336 00:41:40.510 ⇒ 00:41:41.380 Tigran Sahakyan: -Oh.
337 00:41:42.990 ⇒ 00:41:45.990 Tigran Sahakyan: I’ll go back and edit the secret.
338 00:41:48.750 ⇒ 00:41:49.700 Tigran Sahakyan: Or…
339 00:41:49.700 ⇒ 00:41:51.450 Zoran Selinger: Hmm… Second?
340 00:41:52.480 ⇒ 00:41:54.710 Tigran Sahakyan: You need me to go back?
341 00:41:55.830 ⇒ 00:41:58.799 Zoran Selinger: Yes, let’s, let’s go back,
342 00:41:59.600 ⇒ 00:42:02.480 Zoran Selinger: We’ll just make sure that we edit that.
343 00:42:02.650 ⇒ 00:42:04.430 Zoran Selinger: And those secrets.
344 00:42:05.050 ⇒ 00:42:06.320 Zoran Selinger: Correctly.
345 00:42:12.390 ⇒ 00:42:13.000 Tigran Sahakyan: Hmm.
346 00:42:13.270 ⇒ 00:42:14.760 Zoran Selinger: Trying to remember…
347 00:42:30.920 ⇒ 00:42:32.569 Tigran Sahakyan: Could I hit rotate?
348 00:42:43.530 ⇒ 00:42:45.210 Zoran Selinger: What does it say?
349 00:42:51.300 ⇒ 00:42:57.119 Zoran Selinger: It’s no longer viewable. To update the value, you’ll need to rotate the secret. Okay, let’s do that.
350 00:42:59.860 ⇒ 00:43:00.770 Tigran Sahakyan: Oh, okay.
351 00:43:01.120 ⇒ 00:43:07.390 Tigran Sahakyan: I went to plastic once again, I was so… This is BigQuery datasets.
352 00:43:07.640 ⇒ 00:43:09.630 Zoran Selinger: No, no, no, sorry, sorry.
353 00:43:09.980 ⇒ 00:43:15.080 Zoran Selinger: We are changing the Google service account key. That’s what,
354 00:43:15.400 ⇒ 00:43:18.010 Zoran Selinger: what we are… what I’m aiming for.
355 00:43:22.820 ⇒ 00:43:24.449 Tigran Sahakyan: Oh, okay, this one.
356 00:43:24.910 ⇒ 00:43:25.470 Zoran Selinger: Yep.
357 00:43:27.810 ⇒ 00:43:29.180 Tigran Sahakyan: Late…
358 00:43:30.700 ⇒ 00:43:32.080 Zoran Selinger: That’s the long one.
359 00:43:35.470 ⇒ 00:43:38.169 Tigran Sahakyan: Okay, let me go to Slack…
360 00:43:59.940 ⇒ 00:44:03.500 Tigran Sahakyan: I think it’s… Let’s past it here.
361 00:44:04.780 ⇒ 00:44:07.300 Tigran Sahakyan: the same which Henry sent me.
362 00:44:26.130 ⇒ 00:44:29.390 Zoran Selinger: Hmm… Just trying to get,
363 00:44:32.750 ⇒ 00:44:34.190 Zoran Selinger: Should be okay.
364 00:44:42.240 ⇒ 00:44:44.719 Zoran Selinger: So, no empty spaces…
365 00:44:47.880 ⇒ 00:44:48.840 Zoran Selinger: Scroll up.
366 00:44:55.690 ⇒ 00:44:57.360 Zoran Selinger: That should be okay.
367 00:45:18.980 ⇒ 00:45:20.300 Zoran Selinger: Take them out of here.
368 00:45:22.330 ⇒ 00:45:23.230 Zoran Selinger: Square.
369 00:45:24.210 ⇒ 00:45:27.779 Zoran Selinger: Let’s save it, let’s deploy it and try again.
370 00:45:28.960 ⇒ 00:45:33.169 Zoran Selinger: You just have to chase what this arrays just looks like.
371 00:45:33.960 ⇒ 00:45:35.830 Zoran Selinger: It doesn’t recognize?
372 00:45:39.680 ⇒ 00:45:45.640 Tigran Sahakyan: Okay, now… We go to… Here.
373 00:45:56.890 ⇒ 00:45:59.150 Tigran Sahakyan: Do you need me again to add the UTM?
374 00:45:59.150 ⇒ 00:46:00.880 Zoran Selinger: Yeah. Yeah. Yeah.
375 00:46:05.250 ⇒ 00:46:16.019 Zoran Selinger: Because if there’s no any UTMs, basically, the worker does basically nothing, so… To chase it.
376 00:46:18.040 ⇒ 00:46:21.920 Zoran Selinger: Error, getting Google access token, invalid character error.
377 00:46:26.790 ⇒ 00:46:29.019 Tigran Sahakyan: Do you want me to send you this error?
378 00:46:31.300 ⇒ 00:46:32.090 Zoran Selinger: Sure.
379 00:46:34.080 ⇒ 00:46:41.589 Zoran Selinger: Problem is, it’s… it’s very late here. I’m not gonna be able to debug it much here.
380 00:46:48.480 ⇒ 00:46:50.400 Tigran Sahakyan: And it’s added one more.
381 00:46:52.290 ⇒ 00:46:53.760 Tigran Sahakyan: It seems the same.
382 00:46:56.850 ⇒ 00:47:05.200 Zoran Selinger: Can you, so… Can you click the… the line of the error?
383 00:47:05.540 ⇒ 00:47:07.689 Zoran Selinger: On the right-hand side.
384 00:47:08.050 ⇒ 00:47:10.380 Tigran Sahakyan: Is this the line?
385 00:47:10.780 ⇒ 00:47:12.459 Zoran Selinger: Yeah, that should be the line, yes.
386 00:47:13.000 ⇒ 00:47:15.680 Zoran Selinger: Will he take us? Will he show it to us?
387 00:47:18.760 ⇒ 00:47:20.510 Zoran Selinger: So, token…
388 00:47:26.480 ⇒ 00:47:32.639 Zoran Selinger: So, this is where it’s trying to get a new user token, right? Can you scroll up a bit?
389 00:47:36.470 ⇒ 00:47:39.259 Zoran Selinger: So this is the GetGoogle access token.
390 00:47:39.570 ⇒ 00:47:42.749 Zoran Selinger: And we have the service account key.
391 00:47:52.780 ⇒ 00:47:55.789 Zoran Selinger: We are trying to JSON parse it.
392 00:48:04.200 ⇒ 00:48:07.680 Zoran Selinger: Jason Parsit… Mmm…
393 00:48:13.820 ⇒ 00:48:14.720 Zoran Selinger: Hmm…
394 00:48:18.160 ⇒ 00:48:21.890 Zoran Selinger: Can you… can you paste what the error was exactly?
395 00:48:22.300 ⇒ 00:48:24.600 Zoran Selinger: I just googled it quickly.
396 00:48:31.610 ⇒ 00:48:34.199 Zoran Selinger: I was expecting something like that to my side.
397 00:48:34.320 ⇒ 00:48:36.300 Zoran Selinger: I see that often.
398 00:48:38.360 ⇒ 00:48:45.280 Zoran Selinger: Like, different formatting issues with, with those things, but,
399 00:48:57.360 ⇒ 00:49:03.880 Zoran Selinger: Yeah, can’t give me the whole thing, but let me just…
400 00:49:05.480 ⇒ 00:49:07.040 Tigran Sahakyan: Do you need the whole Coke?
401 00:49:12.550 ⇒ 00:49:14.609 Zoran Selinger: Yeah,
402 00:49:29.990 ⇒ 00:49:39.570 Zoran Selinger: I’m thinking about, we should… I’m thinking, let me just confirm this.
403 00:49:41.070 ⇒ 00:49:43.250 Zoran Selinger: I remember…
404 00:49:43.610 ⇒ 00:49:51.969 Zoran Selinger: like, I was base encoding something in this process. I think that should… we should base encode something.
405 00:49:52.120 ⇒ 00:49:54.720 Zoran Selinger: Let me just check my history here.
406 00:49:56.870 ⇒ 00:50:03.359 Tigran Sahakyan: Just… you know, guys, I… I will need to leave in 14 minutes.
407 00:50:03.680 ⇒ 00:50:06.980 Tigran Sahakyan: So, I still have… 14 minutes. Cool.
408 00:50:08.310 ⇒ 00:50:18.240 Zoran Selinger: Yeah, okay. We definitely need to base and code this first, and that’s the value we put in the
409 00:50:19.300 ⇒ 00:50:22.360 Zoran Selinger: In the secret. In the value.
410 00:50:22.820 ⇒ 00:50:29.310 Zoran Selinger: And I’m gonna do that on my, on my, on my side now, and I’m gonna send you that value, okay?
411 00:50:30.010 ⇒ 00:50:30.649 Zoran Selinger: So, mine…
412 00:50:30.650 ⇒ 00:50:31.110 Tigran Sahakyan: Okay.
413 00:50:32.530 ⇒ 00:50:36.060 Zoran Selinger: I forgot that that’s the step,
414 00:50:38.590 ⇒ 00:50:44.360 Zoran Selinger: So, I think we’re going to have to pick it up tomorrow, but we can definitely finish it tomorrow.
415 00:50:46.340 ⇒ 00:50:47.669 Tigran Sahakyan: Yeah, mate.
416 00:50:47.670 ⇒ 00:50:54.629 Zoran Selinger: We have to go, we are pretty busy, I don’t want to publish it today, because I can’t return to my computer to
417 00:50:54.750 ⇒ 00:50:58.760 Zoran Selinger: Again, for the… You know, 12 hours.
418 00:50:58.760 ⇒ 00:51:01.320 Tigran Sahakyan: Which time zone you are in?
419 00:51:01.850 ⇒ 00:51:05.690 Zoran Selinger: I’m in Croatia. I’m Central Europe. European.
420 00:51:05.690 ⇒ 00:51:10.320 Tigran Sahakyan: Alright, cool. Yeah, I think we can meet earlier, and Henry, you are also…
421 00:51:11.220 ⇒ 00:51:14.530 Tigran Sahakyan: You, which, which time zone you are?
422 00:51:14.530 ⇒ 00:51:17.370 Henry Zhao: Pretty much work 24-7, so you guys can schedule what works for you guys.
423 00:51:17.370 ⇒ 00:51:19.779 Tigran Sahakyan: Oh. Cool.
424 00:51:21.950 ⇒ 00:51:30.880 Zoran Selinger: Okay, so, Tigran, I’m sending it to you on Slack. I’ll… I will put it as a code, so it’s not for…
425 00:51:31.130 ⇒ 00:51:32.930 Zoran Selinger: Formatted or anything.
426 00:51:33.420 ⇒ 00:51:34.480 Tigran Sahakyan: Okay.
427 00:51:35.920 ⇒ 00:51:39.059 Zoran Selinger: So… That’s actually the value that needs to be there.
428 00:51:40.070 ⇒ 00:51:43.709 Zoran Selinger: So this is the base64 encoded, the whole file.
429 00:51:47.890 ⇒ 00:51:51.999 Tigran Sahakyan: So, where I’m passing this to… to a secret.
430 00:51:53.280 ⇒ 00:51:54.829 Zoran Selinger: To the secret, yes.
431 00:51:55.000 ⇒ 00:52:00.530 Zoran Selinger: Google service account key, secret, that’s actually the value that needs to be there.
432 00:52:01.630 ⇒ 00:52:08.530 Tigran Sahakyan: Okay, good service account key… Update… Passed.
433 00:52:09.670 ⇒ 00:52:11.950 Tigran Sahakyan: So with no comments.
434 00:52:12.690 ⇒ 00:52:13.810 Zoran Selinger: Yeah, so now.
435 00:52:13.810 ⇒ 00:52:14.260 Tigran Sahakyan: Okay.
436 00:52:14.260 ⇒ 00:52:14.920 Zoran Selinger: Employee?
437 00:52:15.680 ⇒ 00:52:18.270 Zoran Selinger: Let’s try again. If that succeeds.
438 00:52:18.800 ⇒ 00:52:23.119 Zoran Selinger: immediately, I think that we should, we should,
439 00:52:23.350 ⇒ 00:52:28.770 Zoran Selinger: End it for today, and pick it up as early as possible tomorrow,
440 00:52:30.640 ⇒ 00:52:34.539 Zoran Selinger: Let’s, let… we’ll find some time, let’s just try.
441 00:52:43.300 ⇒ 00:52:45.610 Tigran Sahakyan: Now it says BigQuery in the.
442 00:52:45.610 ⇒ 00:52:48.379 Zoran Selinger: The destination table has no schema.
443 00:52:51.690 ⇒ 00:52:52.840 Zoran Selinger: Henry?
444 00:52:52.970 ⇒ 00:52:54.090 Zoran Selinger: Yeah.
445 00:52:54.570 ⇒ 00:53:01.029 Zoran Selinger: did you create a table with the schema that I showed you, or did you just create a table without schema?
446 00:53:01.360 ⇒ 00:53:05.729 Henry Zhao: That’s team schema, but I can, I can just,
447 00:53:10.440 ⇒ 00:53:12.730 Henry Zhao: I’ll do this really quickly, Angela, Dana.
448 00:53:12.730 ⇒ 00:53:13.340 Zoran Selinger: Okay.
449 00:53:14.500 ⇒ 00:53:20.520 Zoran Selinger: I mean, you can just run the code that I sent you, just change the first line, and it creates a table with schema ready.
450 00:53:23.780 ⇒ 00:53:25.369 Henry Zhao: One second, it’ll be fast.
451 00:53:25.940 ⇒ 00:53:26.530 Zoran Selinger: Sure.
452 00:53:29.840 ⇒ 00:53:31.380 Henry Zhao: Same partitions and stuff like that.
453 00:53:32.590 ⇒ 00:53:40.010 Zoran Selinger: Yeah, yeah. But, like, that’s completely up to you. The schema is what’s important to me right now.
454 00:53:40.330 ⇒ 00:53:44.940 Zoran Selinger: If you think there’s other optimization things that we could do there.
455 00:53:46.300 ⇒ 00:53:48.849 Zoran Selinger: Feel free to do them. That’s all fine.
456 00:53:49.390 ⇒ 00:53:54.420 Henry Zhao: Okay, attribution.edgelayer…
457 00:53:58.870 ⇒ 00:53:59.979 Henry Zhao: Okay, now try.
458 00:54:05.740 ⇒ 00:54:07.479 Zoran Selinger: Okay, let’s refresh.
459 00:54:15.990 ⇒ 00:54:17.590 Zoran Selinger: Yeah, okay.
460 00:54:19.000 ⇒ 00:54:21.160 Tigran Sahakyan: Maybe I go back and…
461 00:54:21.870 ⇒ 00:54:26.179 Zoran Selinger: Yeah, maybe, maybe, yeah. It just doesn’t work perfectly.
462 00:54:46.810 ⇒ 00:54:49.650 Tigran Sahakyan: successfully sent data to BigQuilly.
463 00:54:51.730 ⇒ 00:54:52.880 Zoran Selinger: Excellent.
464 00:54:53.480 ⇒ 00:54:55.660 Zoran Selinger: Henry, let’s check it out.
465 00:54:55.980 ⇒ 00:54:58.300 Henry Zhao: Alright, let me check it on my end now.
466 00:55:01.460 ⇒ 00:55:03.490 Henry Zhao: Yep, looks good. I got 2 rows.
467 00:55:04.420 ⇒ 00:55:05.330 Zoran Selinger: Excellent.
468 00:55:05.840 ⇒ 00:55:13.369 Zoran Selinger: All right, Tigran, let’s agree on when to meet tomorrow, and we are actually going to map this
469 00:55:13.570 ⇒ 00:55:22.490 Zoran Selinger: to landing pages. That’s even better, because we are going to do it outside of… of the high traffic,
470 00:55:23.570 ⇒ 00:55:35.459 Zoran Selinger: time of the day, so we are going to have a little bit of time to catch it if something’s not working pretty early, where the traffic is not as high and all that. So, let’s meet as early as possible tomorrow.
471 00:55:35.670 ⇒ 00:55:36.500 Zoran Selinger: If you can.
472 00:55:36.500 ⇒ 00:55:39.479 Tigran Sahakyan: Cool, man. So, you are GMT plus 2?
473 00:55:40.030 ⇒ 00:55:43.629 Zoran Selinger: Yes, exactly, exactly, plus two, yeah.
474 00:55:43.630 ⇒ 00:55:50.560 Tigran Sahakyan: Plus two, okay, I don’t know, maybe… maybe we meet at 1PM your time?
475 00:55:52.110 ⇒ 00:55:57.899 Zoran Selinger: Oh, let me check… Yes, perfect. That’s fine. Yeah.
476 00:55:59.290 ⇒ 00:56:01.020 Tigran Sahakyan: Okay, man, and…
477 00:56:02.500 ⇒ 00:56:05.489 Zoran Selinger: Will you send an invite? Do, my…
478 00:56:05.490 ⇒ 00:56:07.080 Tigran Sahakyan: Yeah, yeah.
479 00:56:08.000 ⇒ 00:56:10.459 Tigran Sahakyan: Wow. Do you have an Eden email, or…
480 00:56:11.590 ⇒ 00:56:14.059 Tigran Sahakyan: Or, never mind, I have it here.
481 00:56:14.760 ⇒ 00:56:15.460 Zoran Selinger: Yeah, yeah.
482 00:56:16.710 ⇒ 00:56:20.040 Zoran Selinger: So let’s do, let’s do that. Excellent.
483 00:56:23.300 ⇒ 00:56:24.070 Tigran Sahakyan: Goodbye.
484 00:56:33.000 ⇒ 00:56:35.480 Tigran Sahakyan: And also… Henry.
485 00:56:39.940 ⇒ 00:56:44.040 Tigran Sahakyan: Okay… Is it okay if we meet with Google?
486 00:56:46.530 ⇒ 00:56:48.820 Zoran Selinger: Can you do have a…
487 00:56:49.680 ⇒ 00:56:50.839 Henry Zhao: For me, it’s fine.
488 00:56:50.840 ⇒ 00:56:53.750 Zoran Selinger: Can you in there? Okay, cool. Fun with me, yes.
489 00:56:55.810 ⇒ 00:56:56.750 Tigran Sahakyan: Okay.
490 00:56:57.050 ⇒ 00:56:58.250 Tigran Sahakyan: Oh, yes.
491 00:56:58.740 ⇒ 00:57:00.840 Tigran Sahakyan: Meeting is set for tomorrow.
492 00:57:01.860 ⇒ 00:57:02.750 Zoran Selinger: Excellent.
493 00:57:03.270 ⇒ 00:57:04.660 Zoran Selinger: Good work.
494 00:57:05.280 ⇒ 00:57:12.249 Zoran Selinger: Today, that’s going pretty quickly, especially since you just got back. Thanks a lot.
495 00:57:12.370 ⇒ 00:57:13.230 Zoran Selinger: And…
496 00:57:13.230 ⇒ 00:57:14.390 Tigran Sahakyan: Yeah, it’ll come back.
497 00:57:14.390 ⇒ 00:57:14.760 Zoran Selinger: tomorrow.
498 00:57:15.600 ⇒ 00:57:16.800 Tigran Sahakyan: Cool. Congrats.
499 00:57:16.960 ⇒ 00:57:17.699 Zoran Selinger: I appreciate it.
500 00:57:17.700 ⇒ 00:57:18.260 Tigran Sahakyan: tomorrow.
501 00:57:18.510 ⇒ 00:57:19.539 Henry Zhao: Thank you, guys. Bye-bye.
502 00:57:20.230 ⇒ 00:57:20.750 Tigran Sahakyan: Right.