Meeting Title: Evidence-env-variables-set-up Date: 2024-07-30 Meeting participants: Patrick Trainer, Jakob Kagel, Nicolas Sucari
WEBVTT
1 00:01:25.670 ⇒ 00:01:26.660 Jakob Kagel: Yo!
2 00:01:30.660 ⇒ 00:01:31.930 Jakob Kagel: Hi! Can you hear me?
3 00:01:32.470 ⇒ 00:01:33.812 Nicolas Sucari: Hey, Jacob, it’s
4 00:01:34.460 ⇒ 00:01:35.580 Nicolas Sucari: can you hear me?
5 00:01:36.220 ⇒ 00:01:38.180 Jakob Kagel: You can sure can.
6 00:01:38.920 ⇒ 00:01:39.800 Nicolas Sucari: Why you.
7 00:01:40.240 ⇒ 00:01:42.170 Jakob Kagel: Doing well doing? Well, how about yourself?
8 00:01:44.610 ⇒ 00:01:45.540 Nicolas Sucari: Well, good
9 00:01:46.090 ⇒ 00:01:46.980 Nicolas Sucari: here.
10 00:01:49.060 ⇒ 00:01:52.064 Nicolas Sucari: nice nice shirt. I like that brand on.
11 00:01:52.440 ⇒ 00:01:53.782 Jakob Kagel: Long. Cloud. Yeah.
12 00:01:54.230 ⇒ 00:01:54.890 Nicolas Sucari: Fair.
13 00:01:55.160 ⇒ 00:01:55.799 Jakob Kagel: I don’t have any.
14 00:01:55.800 ⇒ 00:01:56.510 Nicolas Sucari: Cameron.
15 00:01:56.510 ⇒ 00:01:59.799 Jakob Kagel: But the shirt is actually great. Yeah, I have to say.
16 00:02:00.220 ⇒ 00:02:03.449 Nicolas Sucari: You have 1, 1 pair of shoes. Yeah, really.
17 00:02:03.890 ⇒ 00:02:06.870 Nicolas Sucari: really lightweight. And yeah.
18 00:02:07.280 ⇒ 00:02:08.360 Nicolas Sucari: fact. Yes, this is.
19 00:02:08.360 ⇒ 00:02:10.580 Jakob Kagel: It’s a Swiss brand, I think right.
20 00:02:11.180 ⇒ 00:02:11.860 Nicolas Sucari: Yeah.
21 00:02:12.330 ⇒ 00:02:13.749 Nicolas Sucari: it’s good. What’s up y’all?
22 00:02:13.910 ⇒ 00:02:14.610 Nicolas Sucari: Hi, Pat.
23 00:02:14.610 ⇒ 00:02:15.779 Jakob Kagel: And that’s what things.
24 00:02:19.000 ⇒ 00:02:23.030 Nicolas Sucari: Okay, I don’t think actually is gonna join. Actually, I’m not sure.
25 00:02:23.684 ⇒ 00:02:25.660 Nicolas Sucari: And we can start.
26 00:02:26.050 ⇒ 00:02:37.659 Nicolas Sucari: What I’ve worked yesterday with Tom is in order to set up evidence, Jacob, to work locally, you can. If you want to share, just run your versus code.
27 00:02:37.990 ⇒ 00:02:40.489 Nicolas Sucari: and then you need to go to settings and
28 00:02:41.360 ⇒ 00:02:44.530 Nicolas Sucari: add these stuff that I’m gonna send.
29 00:02:44.530 ⇒ 00:02:46.130 Jakob Kagel: So settings here
30 00:02:46.910 ⇒ 00:02:48.979 Jakob Kagel: or no. Where’s settings.
31 00:02:49.620 ⇒ 00:02:54.919 Nicolas Sucari: You already. Is okay. Go to your local host web
32 00:02:55.020 ⇒ 00:02:56.390 Nicolas Sucari: in in the browser.
33 00:02:57.380 ⇒ 00:02:59.689 Jakob Kagel: Oh, like launch the evidence server.
34 00:02:59.980 ⇒ 00:03:02.720 Nicolas Sucari: Yeah, launch the evidence server and go into.
35 00:03:04.300 ⇒ 00:03:08.910 Jakob Kagel: Okay. One second, it just launched over here. Okay.
36 00:03:09.130 ⇒ 00:03:10.250 Jakob Kagel: Local host.
37 00:03:10.250 ⇒ 00:03:11.080 Nicolas Sucari: So
38 00:03:11.230 ⇒ 00:03:12.620 Nicolas Sucari: yeah. So
39 00:03:12.880 ⇒ 00:03:17.250 Nicolas Sucari: go to the URL and delete refunds and add settings. There.
40 00:03:18.500 ⇒ 00:03:19.300 Jakob Kagel: The eyes.
41 00:03:22.600 ⇒ 00:03:23.710 Jakob Kagel: Okay.
42 00:03:24.250 ⇒ 00:03:32.730 Nicolas Sucari: So here, where it says that the sources just click edit. There. This is how we do it yesterday. But if you’re if you don’t think this is the right way.
43 00:03:33.010 ⇒ 00:03:35.279 Nicolas Sucari: let me know. But I think this is
44 00:03:35.870 ⇒ 00:03:37.720 Nicolas Sucari: what we did yesterday, and
45 00:03:39.090 ⇒ 00:03:40.509 Nicolas Sucari: in the account here
46 00:03:40.640 ⇒ 00:03:42.640 Nicolas Sucari: you will need to add.
47 00:03:43.900 ⇒ 00:03:46.070 Jakob Kagel: Just my name right, my account, name.
48 00:03:46.560 ⇒ 00:03:47.575 Nicolas Sucari: No
49 00:03:48.870 ⇒ 00:03:50.920 Nicolas Sucari: Give me a minute. I will send it to.
50 00:03:50.920 ⇒ 00:03:51.640 Jakob Kagel: Okay.
51 00:03:51.640 ⇒ 00:03:52.410 Nicolas Sucari: Slack.
52 00:03:56.850 ⇒ 00:03:58.990 Patrick Trainer: Nika sounds like you’ve got this.
53 00:03:59.960 ⇒ 00:04:05.409 Nicolas Sucari: Yeah, I mean, we’ve we’ve got this just to run it locally once we.
54 00:04:05.410 ⇒ 00:04:15.439 Patrick Trainer: Yeah, that’s that’s all. It needs to be done just to run it locally, because, like netlify hosts, this and all of these environment variables are stored in netlify.
55 00:04:15.780 ⇒ 00:04:16.320 Patrick Trainer: So this.
56 00:04:16.329 ⇒ 00:04:16.699 Nicolas Sucari: Yeah.
57 00:04:16.700 ⇒ 00:04:18.600 Patrick Trainer: For like local development.
58 00:04:19.095 ⇒ 00:04:25.269 Patrick Trainer: I just went through like the same kind of like off flow that you’re describing now.
59 00:04:26.081 ⇒ 00:04:29.140 Patrick Trainer: And it it works. So
60 00:04:29.150 ⇒ 00:04:31.530 Patrick Trainer: yeah, you’re on the you’re on the right track.
61 00:04:31.770 ⇒ 00:04:39.387 Nicolas Sucari: Yeah, yeah, I I think this works. But my only question that I I asked with some yesterday, and I think we need to work on something is
62 00:04:39.720 ⇒ 00:04:52.009 Nicolas Sucari: once we change this and we start evidence again, the connection file on the code changes and like, if we need to, then push some code into
63 00:04:52.120 ⇒ 00:04:57.400 Nicolas Sucari: production like that won’t change anything on the setup that we were
64 00:04:57.470 ⇒ 00:04:59.920 Nicolas Sucari: using to deploy and notify.
65 00:05:00.800 ⇒ 00:05:02.780 Patrick Trainer: Correct. So just like.
66 00:05:03.210 ⇒ 00:05:04.370 Patrick Trainer: do not
67 00:05:04.830 ⇒ 00:05:07.270 Patrick Trainer: like, cannot stress more.
68 00:05:07.320 ⇒ 00:05:08.960 Patrick Trainer: do not commit
69 00:05:09.320 ⇒ 00:05:10.130 Patrick Trainer: the.
70 00:05:10.640 ⇒ 00:05:11.629 Nicolas Sucari: And connections, fast.
71 00:05:12.170 ⇒ 00:05:13.300 Patrick Trainer: Kyle like
72 00:05:13.830 ⇒ 00:05:14.650 Patrick Trainer: ever.
73 00:05:16.355 ⇒ 00:05:17.050 Nicolas Sucari: Okay.
74 00:05:17.050 ⇒ 00:05:18.310 Patrick Trainer: Yeah, like, yeah.
75 00:05:18.730 ⇒ 00:05:19.400 Nicolas Sucari: So e.
76 00:05:19.400 ⇒ 00:05:21.240 Patrick Trainer: That’ll compromise that. And it’s like.
77 00:05:21.240 ⇒ 00:05:21.590 Nicolas Sucari: Exactly.
78 00:05:21.590 ⇒ 00:05:26.229 Patrick Trainer: History is immutable. And so it’s like, if you do that, then
79 00:05:26.460 ⇒ 00:05:28.009 Patrick Trainer: like it’s gonna be
80 00:05:28.480 ⇒ 00:05:29.990 Patrick Trainer: on git forever.
81 00:05:30.430 ⇒ 00:05:32.329 Nicolas Sucari: Yeah, that’s what we figured out yesterday.
82 00:05:32.330 ⇒ 00:05:34.850 Patrick Trainer: Compromise systems and all of that.
83 00:05:34.940 ⇒ 00:05:38.080 Patrick Trainer: And so like, like, I said, this is just
84 00:05:38.110 ⇒ 00:05:39.560 Patrick Trainer: local development
85 00:05:40.036 ⇒ 00:05:44.549 Patrick Trainer: the changes that you push up are the changes to the sequel.
86 00:05:45.403 ⇒ 00:05:48.790 Patrick Trainer: And then netlify, takes care of the rest.
87 00:05:49.800 ⇒ 00:05:50.610 Jakob Kagel: Okay.
88 00:05:53.230 ⇒ 00:05:53.880 Patrick Trainer: Cool.
89 00:05:55.040 ⇒ 00:05:55.830 Patrick Trainer: Okay.
90 00:05:55.830 ⇒ 00:06:03.570 Nicolas Sucari: That’s it. Jacob, I’m sending in slack. What do you need to add on each of those fields?
91 00:06:04.926 ⇒ 00:06:06.880 Nicolas Sucari: Account! Database.
92 00:06:08.100 ⇒ 00:06:09.260 Jakob Kagel: Got it. Okay.
93 00:06:09.260 ⇒ 00:06:10.870 Nicolas Sucari: Warehouse, and everything.
94 00:06:11.940 ⇒ 00:06:14.199 Patrick Trainer: But yeah, Nika sounds like you got this. So I’m gonna.
95 00:06:14.200 ⇒ 00:06:14.930 Nicolas Sucari: Yeah. Yeah.
96 00:06:15.550 ⇒ 00:06:16.720 Nicolas Sucari: Yep, perfect.
97 00:06:17.310 ⇒ 00:06:18.300 Nicolas Sucari: See? All. Thank you.
98 00:06:19.300 ⇒ 00:06:20.370 Jakob Kagel: Home.
99 00:06:20.650 ⇒ 00:06:26.520 Nicolas Sucari: For username and password. Just give me a minute. I’m gonna take it from the from one password.
100 00:06:28.860 ⇒ 00:06:30.130 Nicolas Sucari: I want to check this.
101 00:06:38.370 ⇒ 00:06:38.955 Jakob Kagel: Her.
102 00:06:40.960 ⇒ 00:06:43.300 Nicolas Sucari: Username just type evidence.
103 00:06:45.080 ⇒ 00:06:46.330 Jakob Kagel: All caps. Yeah.
104 00:06:46.820 ⇒ 00:06:49.420 Nicolas Sucari: No, yeah, no, don’t work out.
105 00:06:49.760 ⇒ 00:06:51.170 Jakob Kagel: A load of.
106 00:06:52.576 ⇒ 00:06:57.690 Nicolas Sucari: And for the password I need to go to one password here.
107 00:07:04.240 ⇒ 00:07:09.969 Nicolas Sucari: or if you want to go to one password under the pool of parts to go vault
108 00:07:11.000 ⇒ 00:07:12.520 Nicolas Sucari: in evidence.
109 00:07:21.250 ⇒ 00:07:24.259 Nicolas Sucari: If you where it says all items there on the top.
110 00:07:24.680 ⇒ 00:07:25.460 Jakob Kagel: Yeah.
111 00:07:25.610 ⇒ 00:07:27.429 Nicolas Sucari: Click there and go to.
112 00:07:27.630 ⇒ 00:07:32.380 Nicolas Sucari: Oh, no, you can. No, no sorry on the right where it says Brain Forge. And the 2
113 00:07:32.940 ⇒ 00:07:34.040 Nicolas Sucari: yeah, there.
114 00:07:34.890 ⇒ 00:07:38.159 Nicolas Sucari: No, we’re just praying for it. There. Click, yeah, there.
115 00:07:38.260 ⇒ 00:07:39.410 Nicolas Sucari: yeah, it’s kind of
116 00:07:39.450 ⇒ 00:07:40.759 Nicolas Sucari: you’re gonna click that.
117 00:07:41.440 ⇒ 00:07:45.379 Jakob Kagel: Not one to pop out. Here, I’ll just go to the website.
118 00:07:45.380 ⇒ 00:07:47.739 Nicolas Sucari: Yeah, yeah, it’s easy in the website.
119 00:08:00.760 ⇒ 00:08:01.940 Jakob Kagel: Intro.
120 00:08:02.380 ⇒ 00:08:03.060 Jakob Kagel: so.
121 00:08:03.467 ⇒ 00:08:08.359 Nicolas Sucari: Yeah, that one type evidence on the search bar, if you want.
122 00:08:09.520 ⇒ 00:08:10.710 Nicolas Sucari: And the second one.
123 00:08:12.040 ⇒ 00:08:13.980 Nicolas Sucari: yeah, copy that password.
124 00:08:14.050 ⇒ 00:08:15.530 Nicolas Sucari: That’s the password.
125 00:08:17.210 ⇒ 00:08:18.710 Jakob Kagel: Got it? Oh, it’s 9.
126 00:08:23.560 ⇒ 00:08:24.520 Jakob Kagel: Okay.
127 00:08:24.890 ⇒ 00:08:28.190 Nicolas Sucari: Perfect and I think
128 00:08:28.580 ⇒ 00:08:29.960 Nicolas Sucari: that’s it.
129 00:08:30.600 ⇒ 00:08:32.730 Jakob Kagel: I just do. I hit test? Should I hit test, connect.
130 00:08:32.730 ⇒ 00:08:34.929 Nicolas Sucari: Yeah. Test test connection. Yeah.
131 00:08:36.400 ⇒ 00:08:38.360 Nicolas Sucari: encourage username, a password.
132 00:08:39.059 ⇒ 00:08:40.490 Nicolas Sucari: What’s going on now?
133 00:08:47.410 ⇒ 00:08:50.789 Nicolas Sucari: Warehouse. Let me see if you have like, the same as me
134 00:08:51.370 ⇒ 00:08:52.710 Nicolas Sucari: holiday digs.
135 00:08:54.440 ⇒ 00:08:56.000 Nicolas Sucari: Can you scroll up a little bit.
136 00:08:58.481 ⇒ 00:09:00.539 Jakob Kagel: Yeah, sure sorry. One second.
137 00:09:05.530 ⇒ 00:09:09.519 Jakob Kagel: I mean, the only thing I didn’t change. Oh, no, we did change username. Yeah.
138 00:09:12.290 ⇒ 00:09:19.940 Jakob Kagel: Database analytics. Warehouse warehouse report. Authenticator is user pass. Yeah, that’s what we have
139 00:09:20.590 ⇒ 00:09:22.320 Jakob Kagel: role report.
140 00:09:24.830 ⇒ 00:09:27.719 Nicolas Sucari: Hmm! Problem is that it’s giving me
141 00:09:28.230 ⇒ 00:09:30.259 Nicolas Sucari: wrong connection to me, too.
142 00:09:31.160 ⇒ 00:09:32.359 Nicolas Sucari: This is weird.
143 00:09:32.730 ⇒ 00:09:35.719 Nicolas Sucari: Probably something happened with that password on Netflix.
144 00:09:37.860 ⇒ 00:09:38.939 Nicolas Sucari: Or let me see.
145 00:09:43.800 ⇒ 00:09:48.160 Nicolas Sucari: No sorry my mistake. It was on the one password stuff. It was the other one.
146 00:09:48.320 ⇒ 00:09:50.230 Nicolas Sucari: the one that says snowflake evidence.
147 00:09:50.990 ⇒ 00:09:51.860 Jakob Kagel: Okay.
148 00:09:52.400 ⇒ 00:09:53.010 Jakob Kagel: so.
149 00:09:53.010 ⇒ 00:09:54.890 Nicolas Sucari: You there? Yeah.
150 00:09:55.100 ⇒ 00:09:56.300 Nicolas Sucari: Sorry. That one.
151 00:09:56.810 ⇒ 00:09:58.250 Jakob Kagel: Yeah, data, okay.
152 00:09:59.236 ⇒ 00:10:00.699 Nicolas Sucari: Go with that one.
153 00:10:01.330 ⇒ 00:10:03.040 Nicolas Sucari: and disconnection.
154 00:10:05.850 ⇒ 00:10:06.730 Jakob Kagel: So.
155 00:10:08.640 ⇒ 00:10:09.880 Jakob Kagel: yeah, perfect.
156 00:10:10.460 ⇒ 00:10:11.690 Nicolas Sucari: Confirm changes.
157 00:10:13.420 ⇒ 00:10:14.430 Jakob Kagel: We did it
158 00:10:14.640 ⇒ 00:10:15.525 Jakob Kagel: hopefully.
159 00:10:16.870 ⇒ 00:10:19.370 Nicolas Sucari: Anything. Yes, yeah, that’s done.
160 00:10:19.370 ⇒ 00:10:20.450 Jakob Kagel: Well, it’s confirmed.
161 00:10:20.450 ⇒ 00:10:26.760 Nicolas Sucari: And I think if you go now to local host like, or go to the refunds report.
162 00:10:29.820 ⇒ 00:10:30.700 Nicolas Sucari: let’s see.
163 00:10:36.810 ⇒ 00:10:37.920 Jakob Kagel: Hmm.
164 00:10:38.960 ⇒ 00:10:41.390 Jakob Kagel: Start. Try restarting the server.
165 00:10:42.590 ⇒ 00:10:43.809 Nicolas Sucari: Yeah, I think you
166 00:10:43.850 ⇒ 00:10:45.510 Nicolas Sucari: hopefully restarting.
167 00:10:45.730 ⇒ 00:10:46.540 Jakob Kagel: Not bad.
168 00:10:47.220 ⇒ 00:10:48.879 Jakob Kagel: Alright, let’s see.
169 00:10:48.880 ⇒ 00:10:52.470 Nicolas Sucari: Yeah, I go to this code and stop it. And okay, it’s processing.
170 00:10:53.270 ⇒ 00:10:54.430 Nicolas Sucari: I’m sorry again.
171 00:10:54.720 ⇒ 00:10:55.410 Jakob Kagel: Oh!
172 00:10:57.140 ⇒ 00:10:59.040 Nicolas Sucari: Oh, that’s fine! Just wait!
173 00:10:59.340 ⇒ 00:11:00.950 Jakob Kagel: It should pop up here.
174 00:11:10.150 ⇒ 00:11:16.589 Nicolas Sucari: We need. We? Yeah, just wait. Wait go to the go to the Vs code. Tab. So let’s see the terminal.
175 00:11:18.930 ⇒ 00:11:20.640 Nicolas Sucari: Can you scroll up a little bit.
176 00:11:26.910 ⇒ 00:11:27.820 Nicolas Sucari: Hmm.
177 00:11:28.910 ⇒ 00:11:31.820 Nicolas Sucari: okay, let’s do the following stop evidence.
178 00:11:33.580 ⇒ 00:11:38.669 Nicolas Sucari: Go to the evidence connection file. Let me see what you have there on this code.
179 00:11:39.600 ⇒ 00:11:40.770 Jakob Kagel: Sure.
180 00:11:43.940 ⇒ 00:11:46.080 Jakob Kagel: that is under.
181 00:11:46.230 ⇒ 00:11:47.190 Nicolas Sucari: Sorritis.
182 00:11:47.650 ⇒ 00:11:49.439 Jakob Kagel: Sources. Right? Okay, yeah.
183 00:11:52.200 ⇒ 00:11:55.710 Nicolas Sucari: Yeah, that one. You have connections. You have 2 things there.
184 00:11:55.790 ⇒ 00:11:57.679 Nicolas Sucari: that’s kind of weird.
185 00:11:57.830 ⇒ 00:11:58.780 Nicolas Sucari: You see.
186 00:11:59.170 ⇒ 00:11:59.970 Jakob Kagel: Yeah.
187 00:12:00.450 ⇒ 00:12:03.119 Nicolas Sucari: I don’t know. What is that, M. With the
188 00:12:03.820 ⇒ 00:12:05.929 Nicolas Sucari: arrow down arrow.
189 00:12:07.470 ⇒ 00:12:11.830 Jakob Kagel: Yeah, I mean, I think, use just like, save it. It will.
190 00:12:13.110 ⇒ 00:12:17.660 Nicolas Sucari: Can you? Can you fetch a main again, I mean like, bring all.
191 00:12:23.430 ⇒ 00:12:24.140 Jakob Kagel: But then.
192 00:12:25.020 ⇒ 00:12:26.040 Nicolas Sucari: What is this?
193 00:12:27.880 ⇒ 00:12:30.250 Nicolas Sucari: Clean your repository working tree?
194 00:12:31.970 ⇒ 00:12:34.099 Nicolas Sucari: Okay, I don’t know what this is.
195 00:12:34.110 ⇒ 00:12:35.659 Nicolas Sucari: 1st time I’ve seen this.
196 00:12:39.420 ⇒ 00:12:40.300 Jakob Kagel: Okay.
197 00:12:41.180 ⇒ 00:12:46.699 Nicolas Sucari: Have you did? Did you write any code that you have there like new code that you need to save? No.
198 00:12:46.850 ⇒ 00:12:47.650 Jakob Kagel: Nothing.
199 00:12:48.220 ⇒ 00:12:49.980 Nicolas Sucari: Okay, try, canceling this.
200 00:12:51.440 ⇒ 00:12:52.090 Jakob Kagel: I mean.
201 00:12:53.610 ⇒ 00:12:57.440 Nicolas Sucari: go to the where you see on the left, where it says like one.
202 00:12:58.570 ⇒ 00:13:00.990 Nicolas Sucari: the on the icon on the left top.
203 00:13:01.320 ⇒ 00:13:03.269 Nicolas Sucari: under the search Icon.
204 00:13:04.480 ⇒ 00:13:05.210 Jakob Kagel: Here.
205 00:13:05.450 ⇒ 00:13:06.519 Nicolas Sucari: No, no, on the left.
206 00:13:07.331 ⇒ 00:13:09.980 Nicolas Sucari: How is it called easy source control. Yeah.
207 00:13:12.620 ⇒ 00:13:16.510 Nicolas Sucari: click here. Yeah. Revert any change there. If you want.
208 00:13:17.480 ⇒ 00:13:18.030 Jakob Kagel: Discard.
209 00:13:18.030 ⇒ 00:13:19.780 Nicolas Sucari: Discard. Yeah, discard
210 00:13:20.360 ⇒ 00:13:21.550 Nicolas Sucari: Scott changes.
211 00:13:22.240 ⇒ 00:13:23.690 Nicolas Sucari: Okay? And now
212 00:13:23.750 ⇒ 00:13:25.349 Nicolas Sucari: for main again.
213 00:13:30.100 ⇒ 00:13:30.890 Nicolas Sucari: Okay.
214 00:13:35.060 ⇒ 00:13:37.580 Nicolas Sucari: we should be okay. Now, if you
215 00:13:40.320 ⇒ 00:13:42.910 Nicolas Sucari: start every, let’s see if you start evidence. Now.
216 00:13:56.360 ⇒ 00:13:59.119 Nicolas Sucari: these don’t work, we need to run sources. Probably.
217 00:14:03.390 ⇒ 00:14:05.080 Jakob Kagel: Hmm, yeah.
218 00:14:09.490 ⇒ 00:14:10.959 Nicolas Sucari: Okay, go to this code
219 00:14:11.470 ⇒ 00:14:16.910 Nicolas Sucari: or wait here. Go to settings again. Let’s see if that’s still what we left there.
220 00:14:19.110 ⇒ 00:14:21.110 Nicolas Sucari: Go to edit these data source.
221 00:14:21.420 ⇒ 00:14:22.932 Jakob Kagel: This one, right? Yeah.
222 00:14:23.890 ⇒ 00:14:24.930 Nicolas Sucari: Or flag.
223 00:14:26.130 ⇒ 00:14:28.030 Jakob Kagel: See it reverted.
224 00:14:28.030 ⇒ 00:14:31.730 Nicolas Sucari: Yeah, and reverted. Change the account. One.
225 00:14:33.330 ⇒ 00:14:34.250 Jakob Kagel: Okay.
226 00:14:37.100 ⇒ 00:14:37.780 Jakob Kagel: Good.
227 00:14:40.270 ⇒ 00:14:43.890 Nicolas Sucari: Change. Well, change everything to what we need to add here.
228 00:14:46.740 ⇒ 00:14:50.530 Nicolas Sucari: username is okay, because you have that connections options.
229 00:14:51.530 ⇒ 00:14:52.410 Nicolas Sucari: I think.
230 00:15:07.640 ⇒ 00:15:10.590 Jakob Kagel: Okay, and then user pass.
231 00:15:11.310 ⇒ 00:15:12.610 Jakob Kagel: And then
232 00:15:16.080 ⇒ 00:15:17.280 Jakob Kagel: and then
233 00:15:17.320 ⇒ 00:15:18.700 Jakob Kagel: this connection request.
234 00:15:18.880 ⇒ 00:15:19.590 Nicolas Sucari: Yeah, yeah.
235 00:15:21.090 ⇒ 00:15:22.950 Nicolas Sucari: okay, click on test.
236 00:15:23.000 ⇒ 00:15:24.520 Nicolas Sucari: affirm changes.
237 00:15:26.780 ⇒ 00:15:27.450 Jakob Kagel: Perfect.
238 00:15:28.600 ⇒ 00:15:31.400 Nicolas Sucari: Yeah, no. Let’s go again. Go to Vs code.
239 00:15:33.434 ⇒ 00:15:36.910 Nicolas Sucari: Okay, it’s processing. We should wait here. Probably.
240 00:15:37.370 ⇒ 00:15:37.900 Jakob Kagel: Okay.
241 00:15:37.900 ⇒ 00:15:41.620 Nicolas Sucari: Basically process the queries and resources.
242 00:15:42.520 ⇒ 00:15:45.559 Jakob Kagel: Okay. I see, I see, okay, okay.
243 00:15:49.340 ⇒ 00:15:50.760 Nicolas Sucari: Yeah, there it goes.
244 00:15:53.420 ⇒ 00:15:59.550 Nicolas Sucari: Shopify customers and shopify orders will fail because it’s empty.
245 00:15:59.610 ⇒ 00:16:01.929 Nicolas Sucari: Those are the files you created. Yeah.
246 00:16:01.930 ⇒ 00:16:03.050 Jakob Kagel: And no worries.
247 00:16:05.880 ⇒ 00:16:08.450 Jakob Kagel: Okay, I think it’s still processing right?
248 00:16:08.820 ⇒ 00:16:10.240 Nicolas Sucari: Yeah. Yeah. Still processing.
249 00:16:11.160 ⇒ 00:16:14.600 Nicolas Sucari: because all other items, it’s kind of really big.
250 00:16:15.580 ⇒ 00:16:16.859 Nicolas Sucari: So that’s why.
251 00:16:18.250 ⇒ 00:16:22.109 Nicolas Sucari: because it’s sometimes it gets stuck there. But
252 00:16:22.300 ⇒ 00:16:24.590 Nicolas Sucari: yeah, it should work after some minutes
253 00:16:35.600 ⇒ 00:16:43.210 Nicolas Sucari: and refund. Go to to local host on the browser and see if you can. If if the
254 00:16:43.300 ⇒ 00:16:47.589 Nicolas Sucari: you can refresh and see how refunds probably refunds work.
255 00:16:51.110 ⇒ 00:16:51.980 Nicolas Sucari: Hmm.
256 00:16:52.300 ⇒ 00:16:56.460 Nicolas Sucari: try hitting common shift. R, so that we can
257 00:16:56.700 ⇒ 00:16:58.669 Nicolas Sucari: like hard refresh one.
258 00:16:59.130 ⇒ 00:17:00.400 Nicolas Sucari: Yeah, just a bit.
259 00:17:03.240 ⇒ 00:17:05.159 Nicolas Sucari: No, probably we need to wait
260 00:17:05.369 ⇒ 00:17:07.109 Nicolas Sucari: until everything loads
261 00:17:07.990 ⇒ 00:17:09.140 Nicolas Sucari: these code.
262 00:17:34.820 ⇒ 00:17:40.819 Nicolas Sucari: It’s weird because it’s working for me like I’m seeing it’s it has to be that stuff about the
263 00:17:42.000 ⇒ 00:17:45.699 Nicolas Sucari: the processing data because I’m seeing it. And it’s working perfectly
264 00:17:45.910 ⇒ 00:17:47.269 Nicolas Sucari: on my local host.
265 00:17:47.750 ⇒ 00:17:48.620 Jakob Kagel: Yeah.
266 00:17:51.560 ⇒ 00:17:54.656 Jakob Kagel: man, yeah, I don’t. I don’t know. I mean
267 00:17:55.690 ⇒ 00:18:00.299 Jakob Kagel: But yeah, I don’t know. Do we need to jump back on with Patrick, or something I mean.
268 00:18:00.640 ⇒ 00:18:03.280 Nicolas Sucari: No, no, just wait. Probably.
269 00:18:03.760 ⇒ 00:18:08.439 Nicolas Sucari: Okay. Maybe we can do do this. Stop the terminal, stop evidence. Sorry?
270 00:18:09.240 ⇒ 00:18:10.030 Jakob Kagel: Sure.
271 00:18:11.290 ⇒ 00:18:14.680 Nicolas Sucari: And now click, command, shift. P,
272 00:18:16.830 ⇒ 00:18:17.870 Nicolas Sucari: yeah, I’m
273 00:18:17.890 ⇒ 00:18:20.119 Nicolas Sucari: hit. That event run sources.
274 00:18:29.620 ⇒ 00:18:31.310 Nicolas Sucari: Let’s hope this works.
275 00:18:46.900 ⇒ 00:18:48.970 Jakob Kagel: Okay. Now. It finally went through.
276 00:18:48.970 ⇒ 00:18:49.870 Nicolas Sucari: Yeah, yeah.
277 00:18:50.830 ⇒ 00:18:58.490 Nicolas Sucari: I know. All other items. I think, yeah, once all orders is done, I think it will be working.
278 00:18:59.700 ⇒ 00:19:00.750 Nicolas Sucari: Just wait.
279 00:19:01.880 ⇒ 00:19:02.359 Jakob Kagel: That’s cool.
280 00:19:02.360 ⇒ 00:19:05.660 Nicolas Sucari: Please let’s throw it done perfect. Now start evidence.
281 00:19:09.940 ⇒ 00:19:12.640 Nicolas Sucari: and let’s hope everything goes okay.
282 00:19:18.150 ⇒ 00:19:18.480 Jakob Kagel: Wow!
283 00:19:18.480 ⇒ 00:19:19.760 Nicolas Sucari: Yeah.
284 00:19:20.640 ⇒ 00:19:30.110 Jakob Kagel: So okay, let’s talk about the connection file real quick. So I’m obviously like, I’m in the main branch right now. So
285 00:19:30.300 ⇒ 00:19:32.040 Jakob Kagel: basically, like.
286 00:19:32.410 ⇒ 00:19:35.840 Jakob Kagel: how do I like? Okay? Cause I just wanna see.
287 00:19:37.760 ⇒ 00:19:40.918 Jakob Kagel: So I have a change here. Right.
288 00:19:41.370 ⇒ 00:19:42.370 Nicolas Sucari: Changes, yeah.
289 00:19:42.370 ⇒ 00:19:43.680 Jakob Kagel: And talk to it.
290 00:19:43.820 ⇒ 00:19:45.370 Jakob Kagel: Right? Okay.
291 00:19:45.706 ⇒ 00:19:49.443 Nicolas Sucari: So what we need to do, I think what we need to do is
292 00:19:50.010 ⇒ 00:20:03.059 Nicolas Sucari: just work it locally, work it locally. Try to check how everything is going locally while you’re doing like the new page with the new queries and everything you need. Once you’re ready in order to push that code.
293 00:20:03.450 ⇒ 00:20:14.430 Nicolas Sucari: I think we will need to hop like on a quick call with Patrick or Utam, and see what we, what we need to delete, and how we need to create that pull request so that we don’t mess up this stuff. Okay.
294 00:20:14.430 ⇒ 00:20:25.600 Jakob Kagel: Okay, so this is what I’m gonna do. Yes, I’m gonna create a new branch like I did previously. And I’m gonna commit all this to that branch? And then, yeah, exactly before.
295 00:20:25.920 ⇒ 00:20:42.129 Nicolas Sucari: It’s I. I think, that’s like the right process before creating the pull request to to main. We need to like Delete on that branch, the connection file, or any stuff regarding that, and just leave the pages and sources and queries that you were working on.
296 00:20:42.660 ⇒ 00:20:48.020 Jakob Kagel: So when I create a new branch, I’ll have to. Also, like I’ll have to update the connection again right.
297 00:20:50.185 ⇒ 00:20:52.209 Nicolas Sucari: Probably. Yes, probably.
298 00:20:52.210 ⇒ 00:20:59.500 Jakob Kagel: I have 10 min here before that call. Let me just do it real quick. So 1st I’m gonna go here and
299 00:20:59.570 ⇒ 00:21:03.369 Jakob Kagel: I’m just gonna do. I’m gonna I’m gonna revert these changes first.st
300 00:21:03.370 ⇒ 00:21:06.969 Nicolas Sucari: So you you’re gonna okay. Stop evidence. First, st if you want.
301 00:21:07.210 ⇒ 00:21:08.909 Jakob Kagel: Right, optional.
302 00:21:08.910 ⇒ 00:21:13.079 Nicolas Sucari: So what you want to do is like, go back to main as as like your
303 00:21:13.260 ⇒ 00:21:15.250 Nicolas Sucari: yeah. Checking out from May right?
304 00:21:15.410 ⇒ 00:21:23.369 Jakob Kagel: Right? Well, I’m in Maine. Yes, I’m saying so. I’m just gonna revert these changes first, st right? Just to make sure
305 00:21:23.952 ⇒ 00:21:25.249 Jakob Kagel: there’s no right
306 00:21:25.780 ⇒ 00:21:26.670 Jakob Kagel: right.
307 00:21:27.800 ⇒ 00:21:35.300 Nicolas Sucari: Yeah, I think. Yes, I think, yeah. You will need to then go back to the local host settings and do it that again. But that’s fine.
308 00:21:35.300 ⇒ 00:21:39.849 Jakob Kagel: Right? Okay, that’s fine. Okay. So here, I’m just gonna do this. I’m just gonna
309 00:21:40.600 ⇒ 00:21:42.600 Jakob Kagel: delete this. This is fine.
310 00:21:42.600 ⇒ 00:21:44.049 Nicolas Sucari: Yeah, yeah, that’s fine.
311 00:21:44.420 ⇒ 00:21:48.659 Jakob Kagel: Okay. So now create a new branch.
312 00:21:49.100 ⇒ 00:21:51.850 Jakob Kagel: And I’m just gonna call it pro consumer.
313 00:21:53.760 ⇒ 00:21:54.790 Jakob Kagel: It is
314 00:21:55.420 ⇒ 00:21:58.590 Jakob Kagel: okay. So I’m gonna create this new branch. Right?
315 00:21:59.010 ⇒ 00:22:01.020 Jakob Kagel: Okay, so again. So now.
316 00:22:01.303 ⇒ 00:22:01.870 Nicolas Sucari: You know.
317 00:22:02.170 ⇒ 00:22:04.739 Jakob Kagel: Very great. So now
318 00:22:04.920 ⇒ 00:22:11.069 Jakob Kagel: I’m gonna see, I’m just gonna start evidence. It’s probably gonna I mean, it’s gonna give me the error. Probably.
319 00:22:11.640 ⇒ 00:22:14.859 Jakob Kagel: And then I’m gonna go into settings here.
320 00:22:15.490 ⇒ 00:22:20.120 Nicolas Sucari: Yeah, okay, snow. Not not giving, not giving any error, probably.
321 00:22:21.106 ⇒ 00:22:22.339 Nicolas Sucari: Go to.
322 00:22:22.470 ⇒ 00:22:28.170 Nicolas Sucari: Yeah. Because you know why. It’s not giving any error, because it it already run the sources before I think.
323 00:22:28.170 ⇒ 00:22:28.740 Jakob Kagel: Bye.
324 00:22:29.530 ⇒ 00:22:30.420 Jakob Kagel: okay.
325 00:22:30.420 ⇒ 00:22:33.140 Nicolas Sucari: And go go to settings and check what we have there.
326 00:22:33.570 ⇒ 00:22:34.230 Jakob Kagel: Yeah.
327 00:22:34.650 ⇒ 00:22:39.590 Nicolas Sucari: I think you will see like the account name. That’s wrong. But the
328 00:22:40.360 ⇒ 00:22:41.480 Nicolas Sucari: yeah, you see.
329 00:22:41.950 ⇒ 00:22:42.450 Jakob Kagel: Okay.
330 00:22:42.450 ⇒ 00:22:53.490 Nicolas Sucari: Why you’re seeing the username evidence is because you have on this code. If you go to the file that says connection options, I think that one is being set there
331 00:22:53.880 ⇒ 00:22:58.580 Nicolas Sucari: like username and pass. We are setting it with, it’s within the file. But that’s okay.
332 00:22:58.910 ⇒ 00:23:03.209 Jakob Kagel: Okay. Alright. Well, then, this should work, I guess. Right like.
333 00:23:03.600 ⇒ 00:23:13.909 Nicolas Sucari: I I think it worked for now, because we run sources before. But if you create a new source that you want like to use for the pro versus consumer. It will break again, I think.
334 00:23:14.280 ⇒ 00:23:16.059 Jakob Kagel: Okay. Okay. Okay.
335 00:23:16.060 ⇒ 00:23:25.229 Nicolas Sucari: But don’t worry. Just if if this is working, and if you don’t need like any new source, you just need probably create some queries and use those queries. Probably it will work.
336 00:23:25.770 ⇒ 00:23:41.240 Jakob Kagel: Okay, I mean, i i i don’t know. Cause I don’t know. Let me see what exactly all like got committed in the sources, cause they I don’t have shopify. So you don’t have anything in here. So I’m gonna have to modify. I think I have to create one more source.
337 00:23:44.206 ⇒ 00:23:49.339 Jakob Kagel: apply order items. But this should be fine, right? I mean, I don’t know.
338 00:23:49.980 ⇒ 00:23:51.990 Jakob Kagel: Like, if I do select
339 00:23:52.330 ⇒ 00:23:56.179 Jakob Kagel: star from, and it would be analytics now, right.
340 00:23:56.180 ⇒ 00:23:58.050 Nicolas Sucari: Yeah, it will be analytics.
341 00:23:58.380 ⇒ 00:24:02.079 Jakob Kagel: Okay. So I’m gonna do. Yes, shopify customers. I mean, that’s
342 00:24:02.090 ⇒ 00:24:04.570 Jakob Kagel: but it’s analytics. It’s Dbt.
343 00:24:04.960 ⇒ 00:24:05.490 Nicolas Sucari: DVD.
344 00:24:05.490 ⇒ 00:24:05.880 Jakob Kagel: And.
345 00:24:05.880 ⇒ 00:24:07.750 Nicolas Sucari: No analytics dot mart.
346 00:24:08.310 ⇒ 00:24:08.720 Jakob Kagel: Omar.
347 00:24:08.720 ⇒ 00:24:10.440 Nicolas Sucari: Just smart. Yeah, there.
348 00:24:10.590 ⇒ 00:24:13.559 Nicolas Sucari: let’s see. Let me check Snowflake a minute.
349 00:24:13.980 ⇒ 00:24:15.429 Jakob Kagel: Check exactly.
350 00:24:16.610 ⇒ 00:24:19.099 Jakob Kagel: just to make sure that that can run. Yeah.
351 00:24:20.520 ⇒ 00:24:22.810 Nicolas Sucari: Oh, you check Snowflake from there. Nice.
352 00:24:23.230 ⇒ 00:24:27.349 Jakob Kagel: Yeah, I mean, it’s yeah, okay. I don’t think it’s Martin. Oh, no, I don’t have it.
353 00:24:27.350 ⇒ 00:24:28.140 Nicolas Sucari: Yeah.
354 00:24:28.540 ⇒ 00:24:31.750 Nicolas Sucari: let me gonna send the push.
355 00:24:32.280 ⇒ 00:24:35.410 Jakob Kagel: It says I’m it says I’m logged in
356 00:24:36.520 ⇒ 00:24:41.100 Jakob Kagel: it. Says the role activated in this session no longer exists.
357 00:24:41.290 ⇒ 00:24:47.199 Nicolas Sucari: Yeah, because they they change all of the roles. We need to use role transform. Now.
358 00:24:48.330 ⇒ 00:24:50.059 Jakob Kagel: Okay. So instead of.
359 00:24:50.690 ⇒ 00:24:55.840 Nicolas Sucari: Instead of Dvt roll change. It’s role underscore transform.
360 00:24:56.320 ⇒ 00:24:58.729 Jakob Kagel: Okay. So here, I’m gonna sign out.
361 00:24:58.960 ⇒ 00:25:00.370 Nicolas Sucari: Yeah, signing again.
362 00:25:00.750 ⇒ 00:25:05.669 Nicolas Sucari: you will be in as public role, I think. And you need to change to role transform. Probably.
363 00:25:07.170 ⇒ 00:25:07.550 Jakob Kagel: We’re not.
364 00:25:07.550 ⇒ 00:25:09.520 Nicolas Sucari: Oh, yeah, they push one.
365 00:25:20.070 ⇒ 00:25:24.719 Nicolas Sucari: Yeah. There, you see, public, you need to change that public into role, transform.
366 00:25:25.290 ⇒ 00:25:26.449 Jakob Kagel: Okay. Yep.
367 00:25:26.960 ⇒ 00:25:27.470 Jakob Kagel: Got it.
368 00:25:27.470 ⇒ 00:25:31.349 Nicolas Sucari: There you go, analytics, and I think if you run that one, it should work.
369 00:25:31.720 ⇒ 00:25:36.760 Jakob Kagel: No active warehouse in the current session. Select an active warehouse.
370 00:25:37.020 ⇒ 00:25:38.380 Jakob Kagel: Okay.
371 00:25:38.940 ⇒ 00:25:40.429 Jakob Kagel: that’s weird.
372 00:25:41.663 ⇒ 00:25:44.279 Jakob Kagel: Why should I have to do that?
373 00:25:49.480 ⇒ 00:25:50.580 Jakob Kagel: okay.
374 00:25:53.360 ⇒ 00:25:56.560 Nicolas Sucari: No, I think there’s a problem. I think there’s a problem with the role
375 00:25:56.630 ⇒ 00:26:00.650 Nicolas Sucari: because I’m in role transform. And I cannot see the databases, too.
376 00:26:01.890 ⇒ 00:26:03.330 Nicolas Sucari: Let me see if I can.
377 00:26:03.330 ⇒ 00:26:06.799 Jakob Kagel: The basis here. But I don’t know about warehouse. Yeah.
378 00:26:11.050 ⇒ 00:26:12.789 Nicolas Sucari: Oh, yeah, I think we need
379 00:27:03.800 ⇒ 00:27:09.909 Nicolas Sucari: just sent a message to Pat. But I’m positive that it’s something regarding the role.
380 00:27:11.010 ⇒ 00:27:11.940 Jakob Kagel: Okay.
381 00:27:12.550 ⇒ 00:27:25.819 Jakob Kagel: yeah, I mean, I don’t know. This is like, yeah, I mean, I I need to be able to do the queries like in Snowflake, too, like I can’t really build stuff in evidence. If I can’t see what the data output is of what I’m building.
382 00:27:25.820 ⇒ 00:27:26.699 Nicolas Sucari: Yeah, I know.
383 00:27:26.980 ⇒ 00:27:28.069 Jakob Kagel: You know so.
384 00:27:28.600 ⇒ 00:27:33.070 Nicolas Sucari: I know, I know. And they yeah, they change the rows and.
385 00:27:33.380 ⇒ 00:27:36.660 Jakob Kagel: I’m not saying you did anything or anything I’m just saying, yes, I mean.
386 00:27:36.880 ⇒ 00:27:38.090 Jakob Kagel: yeah, we.
387 00:27:38.090 ⇒ 00:27:40.989 Nicolas Sucari: It’s frustrating. It’s frustrating to me, too, because
388 00:27:41.210 ⇒ 00:27:49.559 Nicolas Sucari: what I mean is asking me for deadlines. But like we’re blocked on some stuff, and we cannot know like the right way, and how we need to
389 00:27:49.740 ⇒ 00:27:55.069 Nicolas Sucari: work on stuff if they if some, if if something is changing and we are not getting noticed
390 00:27:55.130 ⇒ 00:27:58.509 Nicolas Sucari: about like it’s impossible for me to understand everything.
391 00:27:59.000 ⇒ 00:28:08.279 Jakob Kagel: Right? And yeah, no, we’re building like some some serious tech debt here. I mean, okay, well, I have to jump. I may have to get on another call here.
392 00:28:08.570 ⇒ 00:28:16.449 Nicolas Sucari: That’s fine. Let’s see what? Patrick answers I, yeah, I just I message him through internal engineering. So everyone is aware.
393 00:28:16.460 ⇒ 00:28:37.540 Nicolas Sucari: But yeah, that’s fine. I think that’s working now. So I can send you a picture on how we can. We need to set that local host stuff on settings, so that if you just in case need that, and I also have, like the connection, file without being moni modified. So if we need to go back to that one, too. We can just copy paste if you want.
394 00:28:37.880 ⇒ 00:28:46.194 Jakob Kagel: Okay, great sounds good. Well, thanks. I appreciate your help. And yeah, hopefully, we’ll get this figured out. Awesome. Thanks.
395 00:28:46.750 ⇒ 00:28:47.420 Nicolas Sucari: Hey Mike.