Meeting Title: Patrick <> Akshay - Evidence-set-up Date: 2024-06-26 Meeting participants: Nicolas Sucari, Patricktrainer
WEBVTT
1 00:01:20.360 ⇒ 00:01:21.340 Nicolas Sucari: Hi x 8.
2 00:01:23.630 ⇒ 00:01:24.440 Akshay kumar.G: Yeah. Hello.
3 00:01:27.940 ⇒ 00:01:28.870 Nicolas Sucari: How are you?
4 00:01:30.150 ⇒ 00:01:31.439 Akshay kumar.G: Yeah, I’m fine, all good.
5 00:01:31.600 ⇒ 00:01:32.520 Akshay kumar.G: What about you?
6 00:01:34.030 ⇒ 00:01:35.399 Nicolas Sucari: Everything fine! Here!
7 00:01:50.510 ⇒ 00:01:51.490 Nicolas Sucari: Hey? Patrick?
8 00:01:54.005 ⇒ 00:01:54.440 patricktrainer: Hey!
9 00:01:57.730 ⇒ 00:01:58.630 Nicolas Sucari: How are you?
10 00:01:59.610 ⇒ 00:02:00.800 patricktrainer: One, second.
11 00:02:01.720 ⇒ 00:02:02.520 patricktrainer: yeah.
12 00:02:03.410 ⇒ 00:02:04.780 Nicolas Sucari: You’re not in your
13 00:02:06.600 ⇒ 00:02:08.100 Nicolas Sucari: normal desk right?
14 00:02:13.540 ⇒ 00:02:15.448 patricktrainer: No, I’ve been moving around
15 00:02:16.010 ⇒ 00:02:17.799 patricktrainer: in a different part of the house.
16 00:02:19.060 ⇒ 00:02:20.419 Nicolas Sucari: Yeah, I’m fine.
17 00:02:21.040 ⇒ 00:02:22.590 patricktrainer: Getting stale.
18 00:02:25.750 ⇒ 00:02:31.657 Nicolas Sucari: Perfect. Okay, let’s get right into it. If you want actually,
19 00:02:32.230 ⇒ 00:02:44.440 Nicolas Sucari: So actually, he’s gonna start working with Jacob, actually, on setting up some some pages about sales informations in evidence.
20 00:02:44.490 ⇒ 00:02:50.589 Nicolas Sucari: So I think, Patrick, what you can do is help actually like set up evidence like more on the
21 00:02:51.630 ⇒ 00:02:58.850 Nicolas Sucari: I don’t know what we need to do to set up evidence locally, probably for him, so that then he can start working and creating that dashboard right.
22 00:02:59.220 ⇒ 00:02:59.595 patricktrainer: Right?
23 00:03:00.913 ⇒ 00:03:03.530 patricktrainer: So I guess, like the
24 00:03:03.540 ⇒ 00:03:07.010 patricktrainer: 1st step that we’re gonna wanna do is
25 00:03:07.100 ⇒ 00:03:09.640 patricktrainer: clone the the ports repo
26 00:03:10.790 ⇒ 00:03:12.049 patricktrainer: and then
27 00:03:12.060 ⇒ 00:03:15.857 patricktrainer: the easiest way to set up evidence is through
28 00:03:19.281 ⇒ 00:03:22.065 patricktrainer: through versus code. The Vs code
29 00:03:22.590 ⇒ 00:03:23.760 patricktrainer: extension
30 00:03:24.299 ⇒ 00:03:28.769 patricktrainer: just makes it super easy and super easy to to run and to stop
31 00:03:29.170 ⇒ 00:03:30.570 patricktrainer: etc.
32 00:03:31.186 ⇒ 00:03:32.399 patricktrainer: and then
33 00:03:33.460 ⇒ 00:03:36.429 patricktrainer: creating I’ll say a
34 00:03:36.620 ⇒ 00:03:38.090 patricktrainer: user on snowflake
35 00:03:38.400 ⇒ 00:03:40.219 patricktrainer: password. All that
36 00:03:40.400 ⇒ 00:03:40.890 patricktrainer: bye.
37 00:03:40.890 ⇒ 00:03:43.140 Nicolas Sucari: I think he already has users. Snowflake? Yeah.
38 00:03:43.300 ⇒ 00:03:49.409 Nicolas Sucari: But yeah, okay, that’s fine, I think. Yes, I think we created users on Snowflake for all
39 00:03:49.820 ⇒ 00:03:53.010 Nicolas Sucari: of the interns the.
40 00:03:53.010 ⇒ 00:03:53.410 patricktrainer: Story.
41 00:03:53.410 ⇒ 00:03:55.009 Nicolas Sucari: Brain forge account. I think.
42 00:03:55.820 ⇒ 00:03:57.040 patricktrainer: Okay, I chase.
43 00:03:57.336 ⇒ 00:03:59.710 Nicolas Sucari: Any other. So you wanna ask, talk about.
44 00:03:59.710 ⇒ 00:04:04.420 patricktrainer: Yeah, this this would have to be on the full parts side.
45 00:04:04.730 ⇒ 00:04:05.940 Nicolas Sucari: Okay. Okay.
46 00:04:06.170 ⇒ 00:04:08.670 patricktrainer: Okay. So yeah, he doesn’t have a user.
47 00:04:10.340 ⇒ 00:04:10.860 Nicolas Sucari: Okay.
48 00:04:10.860 ⇒ 00:04:12.920 patricktrainer: So I can create that.
49 00:04:14.250 ⇒ 00:04:17.239 Nicolas Sucari: Okay. But 1st he’s cloning the repo. Right?
50 00:04:17.560 ⇒ 00:04:18.450 Nicolas Sucari: Yep.
51 00:04:22.870 ⇒ 00:04:23.880 Nicolas Sucari: Locally.
52 00:04:23.990 ⇒ 00:04:25.570 Nicolas Sucari: Okay, actually.
53 00:04:27.310 ⇒ 00:04:31.530 Nicolas Sucari: What have you? What did you talk with Utam? Have you like.
54 00:04:31.890 ⇒ 00:04:39.020 Nicolas Sucari: Has he given you any introduction on how to start with that, or anything, or or just he. He just assign you to that ticket, and
55 00:04:39.310 ⇒ 00:04:44.020 Nicolas Sucari: told told you to connect with with us Patrick and Jacob.
56 00:04:44.580 ⇒ 00:04:50.704 Akshay kumar.G: I don’t know, like he just assigned the work like he didn’t say give any details or something like he just gave what the task is.
57 00:04:50.940 ⇒ 00:04:52.420 Nicolas Sucari: Okay, okay.
58 00:04:52.530 ⇒ 00:05:13.390 Nicolas Sucari: he just defined the tax. And yeah, like, told us, okay, go ahead. Excellent. Okay. How do you wanna like Patrick, show us how to clone the the ripple do you wanna like screen share, or actually do you wanna screen share? And we can. And yeah, Patrick, you can guide him on how to do that.
59 00:05:14.436 ⇒ 00:05:15.419 patricktrainer: What do you think?
60 00:05:15.940 ⇒ 00:05:25.049 Akshay kumar.G: Yeah, I guess better if I screenshot like I actually tried using the Vs for, or something like, I guess 1st I should be starting with signing of the credentials, or something.
61 00:05:25.860 ⇒ 00:05:27.200 patricktrainer: Right? Right? Right?
62 00:05:27.710 ⇒ 00:05:30.026 patricktrainer: Yeah, that’s just what’s not
63 00:05:32.074 ⇒ 00:05:33.899 patricktrainer: set up for you yet. So
64 00:05:36.648 ⇒ 00:05:40.280 patricktrainer: what we’re going to be doing is
65 00:05:40.430 ⇒ 00:05:41.870 patricktrainer: so we’ve got this
66 00:05:43.060 ⇒ 00:05:45.240 patricktrainer: full parts repo here.
67 00:05:45.976 ⇒ 00:05:48.510 patricktrainer: You’re going to want to come in here
68 00:05:48.550 ⇒ 00:05:49.870 patricktrainer: and
69 00:05:50.250 ⇒ 00:05:53.469 patricktrainer: you’re gonna want to clone the repository.
70 00:05:53.610 ⇒ 00:05:55.470 patricktrainer: You can like click it here
71 00:05:56.130 ⇒ 00:05:58.169 patricktrainer: and then you’re gonna want to
72 00:05:58.730 ⇒ 00:06:00.619 patricktrainer: open up your terminal
73 00:06:01.320 ⇒ 00:06:04.580 patricktrainer: and you’re going to want to get Clone.
74 00:06:07.240 ⇒ 00:06:08.839 patricktrainer: the repo there.
75 00:06:09.620 ⇒ 00:06:11.800 patricktrainer: and that will clone the repo.
76 00:06:12.270 ⇒ 00:06:16.770 patricktrainer: and you can see that we’ve got cool parts to go right here.
77 00:06:17.170 ⇒ 00:06:19.349 patricktrainer: So if we want to go in there.
78 00:06:21.890 ⇒ 00:06:23.790 patricktrainer: that’s going to show
79 00:06:24.350 ⇒ 00:06:25.230 patricktrainer: a
80 00:06:25.780 ⇒ 00:06:28.020 patricktrainer: that now we have our repo
81 00:06:28.765 ⇒ 00:06:32.119 patricktrainer: and so like, if we wanted to see what’s inside
82 00:06:32.460 ⇒ 00:06:34.500 patricktrainer: relevant evidence.
83 00:06:37.250 ⇒ 00:06:39.100 patricktrainer: we have all of our stuff here
84 00:06:39.967 ⇒ 00:06:47.352 patricktrainer: and then the last part is going to be like setting up this
85 00:06:50.300 ⇒ 00:06:51.140 patricktrainer: of.
86 00:06:51.510 ⇒ 00:06:52.740 patricktrainer: or suits
87 00:06:52.930 ⇒ 00:06:53.720 patricktrainer: like
88 00:06:53.970 ⇒ 00:06:54.830 patricktrainer: here.
89 00:06:55.030 ⇒ 00:06:57.709 patricktrainer: we’ve got this like template connection.
90 00:06:58.620 ⇒ 00:07:00.540 patricktrainer: And so
91 00:07:02.580 ⇒ 00:07:04.550 patricktrainer: what you’re going to want to do?
92 00:07:08.780 ⇒ 00:07:12.620 patricktrainer: template connection. We’ve got the this connection here.
93 00:07:13.294 ⇒ 00:07:18.270 patricktrainer: You’re just gonna want to fill out your username and your password.
94 00:07:18.960 ⇒ 00:07:22.200 patricktrainer: which I can create for you
95 00:07:22.520 ⇒ 00:07:24.250 patricktrainer: right now.
96 00:07:24.310 ⇒ 00:07:26.810 patricktrainer: I actually went ahead and
97 00:07:27.320 ⇒ 00:07:28.310 patricktrainer: already
98 00:07:28.870 ⇒ 00:07:30.259 patricktrainer: set this stuff up.
99 00:07:30.680 ⇒ 00:07:33.960 patricktrainer: So I’m gonna set the sysadmin
100 00:07:34.550 ⇒ 00:07:37.170 patricktrainer: going to create you a user.
101 00:07:51.140 ⇒ 00:07:53.569 patricktrainer: So we’ve got you a user.
102 00:07:55.090 ⇒ 00:07:56.610 patricktrainer: Go into.
103 00:08:04.540 ⇒ 00:08:06.730 patricktrainer: Okay. Now you have the role.
104 00:08:07.570 ⇒ 00:08:10.049 patricktrainer: I’ll send you this password
105 00:08:11.630 ⇒ 00:08:13.310 patricktrainer: and
106 00:08:13.590 ⇒ 00:08:15.069 patricktrainer: let the zoom thing. Go
107 00:08:18.020 ⇒ 00:08:20.430 patricktrainer: send this in the Chat
108 00:08:21.550 ⇒ 00:08:22.560 patricktrainer: Akshay.
109 00:08:22.910 ⇒ 00:08:24.420 patricktrainer: and
110 00:08:24.430 ⇒ 00:08:28.390 patricktrainer: this is going to. Once you sign in with this.
111 00:08:29.060 ⇒ 00:08:34.320 patricktrainer: It’s going to prompt you to change your password, so just be sure to use
112 00:08:34.450 ⇒ 00:08:35.245 patricktrainer: a
113 00:08:36.070 ⇒ 00:08:39.150 patricktrainer: secure password. And your user
114 00:08:39.330 ⇒ 00:08:42.230 patricktrainer: is your name with no spaces.
115 00:08:49.720 ⇒ 00:08:56.179 Nicolas Sucari: I think we can. We need to share also the link to the snowflake environment of pullpars. Right?
116 00:08:56.500 ⇒ 00:08:56.920 patricktrainer: Okay.
117 00:08:56.920 ⇒ 00:09:01.610 Nicolas Sucari: Going for each account. Yeah, do you have the link there? You can. Yeah, paste it on the chat. Yeah.
118 00:09:01.610 ⇒ 00:09:03.490 patricktrainer: Yeah, yeah. One. Sec
119 00:09:04.430 ⇒ 00:09:05.160 patricktrainer: that.
120 00:09:09.620 ⇒ 00:09:11.160 patricktrainer: And then the chat.
121 00:09:13.340 ⇒ 00:09:15.139 patricktrainer: the chat. Yeah, there it is.
122 00:09:15.460 ⇒ 00:09:18.109 patricktrainer: And then here is the link.
123 00:09:21.140 ⇒ 00:09:21.950 Nicolas Sucari: Perfect.
124 00:09:32.430 ⇒ 00:09:33.880 patricktrainer: And that’s perfect.
125 00:09:34.220 ⇒ 00:09:41.509 Nicolas Sucari: I’m I’m gonna try to do the same. Actually, so then, probably later, I will ask you to create some user to me, too.
126 00:09:41.790 ⇒ 00:09:48.987 patricktrainer: Cool cool. Yeah, yeah, yeah. I think you already have a user and so after that, we’re going to.
127 00:09:51.006 ⇒ 00:09:52.939 patricktrainer: What am I doing? Okay?
128 00:09:54.820 ⇒ 00:09:56.820 patricktrainer: like, you’re going to come in here?
129 00:09:57.130 ⇒ 00:09:58.869 patricktrainer: Yeah. Open Bs code.
130 00:10:00.950 ⇒ 00:10:06.070 patricktrainer: And then what you’re going to want to do now is you’re going to come up
131 00:10:06.520 ⇒ 00:10:08.579 patricktrainer: into extensions.
132 00:10:10.260 ⇒ 00:10:14.410 patricktrainer: and you’re going to look for this evidence extension
133 00:10:15.040 ⇒ 00:10:19.110 patricktrainer: and you’re going to install it. It should be here.
134 00:10:19.310 ⇒ 00:10:21.799 patricktrainer: I already have it. But I’ve got disabled.
135 00:10:21.870 ⇒ 00:10:24.340 patricktrainer: but that’s what they’ll do.
136 00:10:24.510 ⇒ 00:10:26.059 patricktrainer: And then you can like
137 00:10:27.850 ⇒ 00:10:33.700 patricktrainer: you have, like all these commands, to like, create a new project or start and stop
138 00:10:33.930 ⇒ 00:10:35.860 patricktrainer: development server
139 00:10:36.000 ⇒ 00:10:38.420 patricktrainer: and all that stuff
140 00:10:38.890 ⇒ 00:10:40.790 patricktrainer: you’re going to be
141 00:10:42.070 ⇒ 00:10:45.229 patricktrainer: working in like this directory here
142 00:10:45.330 ⇒ 00:10:49.470 patricktrainer: and like, I said, going to want to come into sources.
143 00:10:49.780 ⇒ 00:10:52.369 patricktrainer: And we have this template connection.
144 00:10:52.570 ⇒ 00:10:54.339 patricktrainer: What you’re going to want to do.
145 00:10:54.450 ⇒ 00:10:57.020 patricktrainer: So like copy, these values
146 00:10:58.910 ⇒ 00:11:00.560 patricktrainer: create a new file
147 00:11:00.660 ⇒ 00:11:01.720 patricktrainer: called
148 00:11:02.470 ⇒ 00:11:04.710 patricktrainer: Connection Dot Yaml.
149 00:11:06.250 ⇒ 00:11:08.440 patricktrainer: And then you’re just going to
150 00:11:09.400 ⇒ 00:11:10.450 patricktrainer: input
151 00:11:10.720 ⇒ 00:11:12.290 patricktrainer: like your username
152 00:11:12.540 ⇒ 00:11:14.630 patricktrainer: and then your password.
153 00:11:16.950 ⇒ 00:11:18.310 patricktrainer: and then
154 00:11:19.600 ⇒ 00:11:21.700 patricktrainer: you should be able to to.
155 00:11:21.800 ⇒ 00:11:25.069 patricktrainer: Then you can start evidence. It should connect to Snowflake.
156 00:11:25.430 ⇒ 00:11:29.170 patricktrainer: and then you’ll be able to to get your own.
157 00:11:39.930 ⇒ 00:11:40.870 patricktrainer: Make sense.
158 00:11:43.560 ⇒ 00:11:46.290 Nicolas Sucari: Yeah, actually, okay, any questions.
159 00:11:47.140 ⇒ 00:11:47.870 Nicolas Sucari: Yeah, so.
160 00:11:47.870 ⇒ 00:11:48.670 Akshay kumar.G: Stace.
161 00:11:48.960 ⇒ 00:11:56.689 Akshay kumar.G: like, basically with the code you send, like the particular co code format like, will it be directly connecting the data which is from Snowflake. Right? That’s what you’re right.
162 00:11:56.690 ⇒ 00:11:57.340 patricktrainer: Yes.
163 00:11:57.720 ⇒ 00:11:58.194 patricktrainer: yes.
164 00:12:00.320 ⇒ 00:12:01.550 Akshay kumar.G: Yeah, okay, yeah, that’s fine.
165 00:12:01.840 ⇒ 00:12:06.489 Akshay kumar.G: Okay? Like, I had that the trouble with like how to connect data. So actually, like, how files will be connected.
166 00:12:06.490 ⇒ 00:12:07.210 patricktrainer: Yeah.
167 00:12:07.710 ⇒ 00:12:12.729 patricktrainer: yeah, yeah, you just didn’t have a user setup. And so you weren’t able to connect directly
168 00:12:13.261 ⇒ 00:12:17.379 patricktrainer: or at least on this network instance, but we are
169 00:12:21.273 ⇒ 00:12:22.700 patricktrainer: We are
170 00:12:24.030 ⇒ 00:12:29.610 patricktrainer: set up with you on the user password there now, so you should be good to go.
171 00:12:33.970 ⇒ 00:12:34.680 Akshay kumar.G: Yeah, fine.
172 00:12:35.650 ⇒ 00:12:39.868 Nicolas Sucari: And then building. The report is kind of creating a new dashboard
173 00:12:40.260 ⇒ 00:12:45.339 Nicolas Sucari: and then we can like preview it with the local host, or there from the code right?
174 00:12:45.560 ⇒ 00:12:46.300 patricktrainer: Right.
175 00:12:47.830 ⇒ 00:12:48.630 Nicolas Sucari: Excellent.
176 00:12:49.040 ⇒ 00:12:51.760 Nicolas Sucari: I think that’s super useful. Actually. What do you think.
177 00:12:53.550 ⇒ 00:12:55.579 Akshay kumar.G: Yeah, like, for now, like, it’s fine.
178 00:12:55.940 ⇒ 00:13:05.639 Akshay kumar.G: I tried like doing things like, I just set up using Vs code and started a new project, or something like I was finding difficulties and connecting the database datas actually so like.
179 00:13:06.130 ⇒ 00:13:18.530 patricktrainer: Yeah. Yeah. Like one thing that you could do. Well, yeah, it was just the the connection. It was probably denying you there. But like setting it up locally, you can run
180 00:13:18.730 ⇒ 00:13:21.540 patricktrainer: like either sqlite or like Duct Tb
181 00:13:21.790 ⇒ 00:13:26.119 patricktrainer: as a back end. If you just wanna like play around in practice.
182 00:13:26.851 ⇒ 00:13:31.059 patricktrainer: I would definitely suggest, getting familiar
183 00:13:31.530 ⇒ 00:13:32.490 patricktrainer: with
184 00:13:33.270 ⇒ 00:13:36.260 patricktrainer: evidence documentation.
185 00:13:36.290 ⇒ 00:13:38.250 patricktrainer: Everything’s in there. And
186 00:13:38.420 ⇒ 00:13:39.460 patricktrainer: it’s
187 00:13:39.580 ⇒ 00:13:43.979 patricktrainer: found. It’s it’s decent docs, and so
188 00:13:44.460 ⇒ 00:13:49.150 patricktrainer: any like specific questions that you have should be able to be answered through. There.
189 00:13:52.425 ⇒ 00:13:59.329 Akshay kumar.G: Now, for now, like I found difficulties in setting up like I will try to set up on like after then, like how it should be like
190 00:13:59.720 ⇒ 00:14:05.120 Akshay kumar.G: how we should. What type of visualization are you doing so? Based on the task? Like, if I have something, I will contact.
191 00:14:07.020 ⇒ 00:14:08.610 patricktrainer: Right, right, right, right.
192 00:14:10.090 ⇒ 00:14:32.060 Nicolas Sucari: Try try setting up evidence actually. And if you have any blocker or anything that’s not letting you connect, let us know. And we can. Yeah, figure out how to solve it. And once that is ready, I think we need a meeting with Jacob, and so that he can help you start creating the dashboard start doing like the analysis and how to yeah, create those views. Right?
193 00:14:33.150 ⇒ 00:14:34.470 Akshay kumar.G: Yeah, sure, that sounds good.
194 00:14:35.710 ⇒ 00:14:46.980 Nicolas Sucari: Excellent perfect. This meeting is recorded so I can share you the recording so that you can follow the steps. And this is great, because I can then, create like a
195 00:14:47.140 ⇒ 00:14:52.250 Nicolas Sucari: step by step, guide on how to clone the repo and start evidence on each of
196 00:14:52.580 ⇒ 00:14:53.370 Nicolas Sucari: of the.
197 00:14:53.370 ⇒ 00:14:53.740 Akshay kumar.G: Yeah.
198 00:14:53.740 ⇒ 00:15:00.150 Nicolas Sucari: The ripples for everyone. So I’m I’m gonna be working on that. But I’ll share the recording once it’s ready. Okay.
199 00:15:00.870 ⇒ 00:15:02.290 Akshay kumar.G: Yeah, it will be a good question.
200 00:15:03.930 ⇒ 00:15:05.554 Nicolas Sucari: Okay, thank you. Guys,
201 00:15:05.960 ⇒ 00:15:06.280 patricktrainer: Yeah.
202 00:15:06.280 ⇒ 00:15:08.009 Nicolas Sucari: I don’t know if there is anything else.
203 00:15:09.070 ⇒ 00:15:09.949 patricktrainer: Think that’s it.
204 00:15:12.380 ⇒ 00:15:15.868 Nicolas Sucari: Perfect. Thank you very much, Patrick.
205 00:15:16.670 ⇒ 00:15:18.300 patricktrainer: Yeah, you’re welcome. See? Y’all.
206 00:15:19.180 ⇒ 00:15:19.780 Nicolas Sucari: By night.