Meeting Title: SQL-Fluff Date: 2024-07-31 Meeting participants: Atharv Gudi, Nicolas Sucari
WEBVTT
1 00:01:32.870 ⇒ 00:01:33.769 Nicolas Sucari: Hey, Anton.
2 00:01:36.880 ⇒ 00:01:38.830 Atharv Gudi: Hey, Nico! How’s it going.
3 00:01:39.700 ⇒ 00:01:41.409 Nicolas Sucari: How are you all good here.
4 00:01:42.340 ⇒ 00:01:43.539 Atharv Gudi: Good, good.
5 00:01:44.990 ⇒ 00:01:46.080 Nicolas Sucari: Excellent.
6 00:01:46.370 ⇒ 00:01:49.469 Atharv Gudi: Shall I jump right into the documentation.
7 00:01:49.640 ⇒ 00:01:50.950 Nicolas Sucari: Yeah. Let’s go.
8 00:01:51.230 ⇒ 00:01:55.468 Atharv Gudi: I will send you the documentation first, st I think.
9 00:01:56.950 ⇒ 00:01:57.690 Nicolas Sucari: But effect.
10 00:02:00.340 ⇒ 00:02:00.970 Atharv Gudi: Yeah.
11 00:02:10.220 ⇒ 00:02:12.420 Atharv Gudi: okay, I think you should have received it.
12 00:02:15.209 ⇒ 00:02:16.469 Nicolas Sucari: By email, right?
13 00:02:22.450 ⇒ 00:02:23.010 Atharv Gudi: She’s cool.
14 00:02:23.565 ⇒ 00:02:24.120 Nicolas Sucari: Hope!
15 00:02:29.280 ⇒ 00:02:31.020 Nicolas Sucari: Perfect! Excellent!
16 00:02:32.710 ⇒ 00:02:33.516 Atharv Gudi: Okay, I’m
17 00:02:35.410 ⇒ 00:02:41.490 Atharv Gudi: just let me know how it looks. Want me to demonstrate anything. I’m happy to share my screen and show it.
18 00:02:43.140 ⇒ 00:02:43.910 Nicolas Sucari: Okay.
19 00:02:44.060 ⇒ 00:02:47.188 Nicolas Sucari: So okay, this is good.
20 00:02:48.480 ⇒ 00:02:54.722 Nicolas Sucari: Do you want me to share and like, go through the doc and see if I I can manage everything. Okay.
21 00:02:55.770 ⇒ 00:02:57.409 Nicolas Sucari: okay, let me
22 00:02:57.660 ⇒ 00:02:59.350 Nicolas Sucari: do you like these?
23 00:03:00.918 ⇒ 00:03:05.319 Nicolas Sucari: Let me bring up here this code.
24 00:03:08.760 ⇒ 00:03:09.610 Nicolas Sucari: Let’s see.
25 00:03:15.970 ⇒ 00:03:24.839 Nicolas Sucari: Just a minute. Do you want me to run it on vs. Go terminal or on my like personal like on my terminal. My machine.
26 00:03:24.840 ⇒ 00:03:26.949 Atharv Gudi: Vs. Code terminal should be fine.
27 00:03:27.910 ⇒ 00:03:28.500 Nicolas Sucari: Okay.
28 00:03:30.080 ⇒ 00:03:31.160 Nicolas Sucari: there.
29 00:03:32.030 ⇒ 00:03:33.160 Nicolas Sucari: me share.
30 00:03:34.850 ⇒ 00:03:38.780 Nicolas Sucari: I’m gonna move you to these screens and share.
31 00:03:41.160 ⇒ 00:03:41.870 Nicolas Sucari: Okay.
32 00:03:42.650 ⇒ 00:03:45.149 Nicolas Sucari: let me know if you’re seeing
33 00:03:45.890 ⇒ 00:03:47.810 Nicolas Sucari: SQL. Stuff. And
34 00:03:48.220 ⇒ 00:03:48.710 Nicolas Sucari: yes.
35 00:03:48.710 ⇒ 00:03:49.260 Atharv Gudi: Canceled.
36 00:03:49.260 ⇒ 00:03:49.980 Nicolas Sucari: Perfect.
37 00:03:50.590 ⇒ 00:03:53.900 Nicolas Sucari: So I’m on my, I’m on my term, you know. Wait
38 00:03:54.230 ⇒ 00:03:56.369 Nicolas Sucari: for this. I should
39 00:03:58.530 ⇒ 00:04:01.139 Nicolas Sucari: origin again just in case
40 00:04:08.650 ⇒ 00:04:09.620 Nicolas Sucari: splitting.
41 00:04:15.030 ⇒ 00:04:20.109 Nicolas Sucari: Let’s see, yeah, perfect. Okay? So 1st of all, I should run. PBX, okay.
42 00:04:25.780 ⇒ 00:04:27.410 Nicolas Sucari: command no. Found tip.
43 00:04:27.530 ⇒ 00:04:30.199 Nicolas Sucari: Okay, what is peep instead.
44 00:04:30.800 ⇒ 00:04:32.680 Nicolas Sucari: Like? What should I run before.
45 00:04:32.890 ⇒ 00:04:40.403 Atharv Gudi: Okay. A pip is supposed to be when you’re you should be able to run python. Are you able to run python.
46 00:04:41.730 ⇒ 00:04:44.039 Nicolas Sucari: I don’t think I’ve ever run python.
47 00:04:44.200 ⇒ 00:04:44.930 Nicolas Sucari: Okay.
48 00:04:45.274 ⇒ 00:04:48.369 Atharv Gudi: Do you have a terminal where you run anything.
49 00:04:54.075 ⇒ 00:04:55.619 Nicolas Sucari: Okay, go ahead.
50 00:04:58.880 ⇒ 00:04:59.480 Nicolas Sucari: Wait and.
51 00:04:59.480 ⇒ 00:05:03.320 Atharv Gudi: Question would be to install python. If you haven’t.
52 00:05:05.420 ⇒ 00:05:06.860 Nicolas Sucari: How can I install it?
53 00:05:07.320 ⇒ 00:05:12.260 Atharv Gudi: Oh, python is. I think you have to install it directly from the website. You go to
54 00:05:12.929 ⇒ 00:05:13.280 Atharv Gudi: the
55 00:05:14.050 ⇒ 00:05:16.439 Atharv Gudi: python.org, I think is.
56 00:05:19.140 ⇒ 00:05:21.050 Atharv Gudi: yeah, 500 odd.
57 00:05:26.340 ⇒ 00:05:26.880 Nicolas Sucari: Loads.
58 00:05:26.880 ⇒ 00:05:27.860 Atharv Gudi: Road
59 00:05:28.210 ⇒ 00:05:31.810 Atharv Gudi: download Python 3.12. The big
60 00:05:32.840 ⇒ 00:05:35.029 Atharv Gudi: yellow button that you have.
61 00:05:35.720 ⇒ 00:05:36.579 Nicolas Sucari: Sorry. Yeah.
62 00:05:39.620 ⇒ 00:05:40.709 Nicolas Sucari: see it?
63 00:05:45.680 ⇒ 00:05:49.869 Nicolas Sucari: That’s the installer. Okay, continue. Read me.
64 00:05:49.940 ⇒ 00:05:53.210 Nicolas Sucari: continue. I’m here. I’m gonna join show you
65 00:05:54.320 ⇒ 00:05:55.590 Nicolas Sucari: what I’m doing
66 00:05:56.680 ⇒ 00:05:57.510 Nicolas Sucari: here.
67 00:05:58.320 ⇒ 00:05:59.090 Atharv Gudi: Yeah.
68 00:05:59.090 ⇒ 00:06:01.919 Nicolas Sucari: License. Okay, continue.
69 00:06:02.370 ⇒ 00:06:03.420 Nicolas Sucari: agree.
70 00:06:05.100 ⇒ 00:06:08.489 Nicolas Sucari: wait, destination celebrities. I can just wait.
71 00:06:22.350 ⇒ 00:06:24.949 Nicolas Sucari: So I think we should add that, like as a
72 00:06:25.349 ⇒ 00:06:28.939 Nicolas Sucari: something that you need to have on your computer, I guess. Yeah, practice it.
73 00:06:29.595 ⇒ 00:06:29.890 Nicolas Sucari: That.
74 00:06:29.890 ⇒ 00:06:30.889 Atharv Gudi: Yeah, keep pipe.
75 00:06:31.299 ⇒ 00:06:31.709 Nicolas Sucari: Bay!
76 00:06:33.830 ⇒ 00:06:35.609 Nicolas Sucari: Have it here perfect.
77 00:06:37.010 ⇒ 00:06:40.090 Nicolas Sucari: still running some scripts, unless I have it here.
78 00:06:45.370 ⇒ 00:06:50.270 Atharv Gudi: Okay. If it’s installed, then you should be able to run pep on the Ps code itself.
79 00:06:52.930 ⇒ 00:06:54.360 Nicolas Sucari: Okay? Oh.
80 00:06:54.940 ⇒ 00:06:56.800 Nicolas Sucari: probably I should.
81 00:06:57.796 ⇒ 00:06:59.680 Nicolas Sucari: Okay, let me try again.
82 00:07:00.880 ⇒ 00:07:05.439 Nicolas Sucari: No. I think I need to like Reboot this call, probably right?
83 00:07:05.440 ⇒ 00:07:06.080 Atharv Gudi: Yeah.
84 00:07:06.660 ⇒ 00:07:15.089 Atharv Gudi: side of that. I remember I had to do an engineering onboarding where I had to create a shell as well to put into Vs code. I don’t know if that’s gonna be.
85 00:07:16.970 ⇒ 00:07:18.050 Nicolas Sucari: Oh, what’s free!
86 00:07:18.590 ⇒ 00:07:21.340 Atharv Gudi: I had to do an engineering onboarding
87 00:07:21.950 ⇒ 00:07:24.660 Atharv Gudi: that I don’t know if that might have.
88 00:07:28.600 ⇒ 00:07:29.699 Nicolas Sucari: Yeah, probably
89 00:07:29.860 ⇒ 00:07:32.300 Nicolas Sucari: I need that one. No, no one found it.
90 00:07:32.607 ⇒ 00:07:35.070 Atharv Gudi: Can you try to run this? Yeah.
91 00:07:44.610 ⇒ 00:07:45.580 Nicolas Sucari: No.
92 00:07:45.580 ⇒ 00:07:46.720 Atharv Gudi: Hmm! Alright!
93 00:07:46.720 ⇒ 00:07:48.460 Nicolas Sucari: So let’s go to.
94 00:08:09.000 ⇒ 00:08:10.529 Nicolas Sucari: We’re using this one right?
95 00:08:10.880 ⇒ 00:08:11.740 Atharv Gudi: Yes.
96 00:08:22.970 ⇒ 00:08:28.369 Atharv Gudi: Okay. So Pip is a package or manager. Let me just see if I can get any data on that.
97 00:08:29.250 ⇒ 00:08:30.390 Nicolas Sucari: Yeah, exactly.
98 00:08:36.400 ⇒ 00:08:37.929 Nicolas Sucari: Okay. Installing python.
99 00:08:38.240 ⇒ 00:08:42.849 Nicolas Sucari: How to install python and piv depends on what operating system you’re using any case. But with your product.
100 00:08:50.080 ⇒ 00:08:53.050 Atharv Gudi: Oh, pipe pip is another separate thing to install.
101 00:08:55.079 ⇒ 00:08:55.510 Atharv Gudi: Yeah.
102 00:08:55.510 ⇒ 00:08:56.500 Nicolas Sucari: I think
103 00:08:56.990 ⇒ 00:09:00.020 Nicolas Sucari: I’m gonna check if I have python
104 00:09:01.540 ⇒ 00:09:03.369 Nicolas Sucari: item version.
105 00:09:04.500 ⇒ 00:09:05.375 Nicolas Sucari: No,
106 00:09:17.610 ⇒ 00:09:21.160 Atharv Gudi: I will add the all of this stuff in the
107 00:09:23.760 ⇒ 00:09:25.329 Atharv Gudi: in the document, while you
108 00:09:25.340 ⇒ 00:09:26.519 Atharv Gudi: get that set up.
109 00:09:29.200 ⇒ 00:09:30.100 Nicolas Sucari: Bay.
110 00:09:54.560 ⇒ 00:09:57.440 Nicolas Sucari: Well, probably what we can do with this. Let’s see.
111 00:10:11.110 ⇒ 00:10:12.679 Nicolas Sucari: Try asking the AI.
112 00:10:13.400 ⇒ 00:10:14.210 Atharv Gudi: Okay, I’m
113 00:10:20.410 ⇒ 00:10:24.109 Atharv Gudi: so that those are all the instructions that I’ve already put in the
114 00:10:24.610 ⇒ 00:10:32.190 Atharv Gudi: document. It’s just the pip part that I think is a problem on your machines right now, and the pip is another package that you’d have to.
115 00:10:53.380 ⇒ 00:10:55.249 Nicolas Sucari: Okay, bye, it’s on.
116 00:10:58.600 ⇒ 00:11:02.140 Nicolas Sucari: You don’t have python installed, but I just installed it right
117 00:11:02.260 ⇒ 00:11:03.070 Nicolas Sucari: like
118 00:11:03.420 ⇒ 00:11:04.470 Nicolas Sucari: I was here.
119 00:11:07.870 ⇒ 00:11:10.240 Atharv Gudi: Can you run the python?
120 00:11:10.300 ⇒ 00:11:11.829 Atharv Gudi: Dash, dash, version.
121 00:11:12.620 ⇒ 00:11:14.690 Nicolas Sucari: Yeah, I’m I just ran that.
122 00:11:15.420 ⇒ 00:11:18.950 Nicolas Sucari: and I didn’t find it. I don’t know what’s.
123 00:11:20.890 ⇒ 00:11:23.680 Atharv Gudi: Have you moved it to the applications folder.
124 00:11:25.750 ⇒ 00:11:27.419 Nicolas Sucari: Yeah, I have it here in applications.
125 00:11:27.630 ⇒ 00:11:31.024 Nicolas Sucari: So if I go here no
126 00:11:32.500 ⇒ 00:11:34.540 Nicolas Sucari: how can I go here?
127 00:11:35.890 ⇒ 00:11:38.390 Nicolas Sucari: I have python launcher here.
128 00:11:43.940 ⇒ 00:11:48.150 Nicolas Sucari: so I’m looking at this. See? Python, python, python.
129 00:11:54.110 ⇒ 00:11:54.830 Atharv Gudi: We need it.
130 00:11:55.710 ⇒ 00:11:57.609 Atharv Gudi: Can you click on idle? Yeah.
131 00:12:09.790 ⇒ 00:12:11.480 Atharv Gudi: Okay, can you just
132 00:12:12.270 ⇒ 00:12:16.419 Atharv Gudi: type anything 2 plus 2
133 00:12:17.070 ⇒ 00:12:19.140 Atharv Gudi: and then press. Enter on the
134 00:12:19.970 ⇒ 00:12:20.859 Atharv Gudi: wait. Wait, wait.
135 00:12:21.175 ⇒ 00:12:21.490 Nicolas Sucari: Yeah.
136 00:12:22.500 ⇒ 00:12:25.109 Atharv Gudi: Oh, can you try the python
137 00:12:25.220 ⇒ 00:12:26.350 Atharv Gudi: version.
138 00:12:26.350 ⇒ 00:12:27.040 Nicolas Sucari: Don’t try.
139 00:12:27.890 ⇒ 00:12:28.660 Nicolas Sucari: Yeah.
140 00:12:31.300 ⇒ 00:12:33.689 Nicolas Sucari: It doesn’t sound like one item.
141 00:12:33.690 ⇒ 00:12:34.490 Atharv Gudi: Okay. I’m.
142 00:12:34.880 ⇒ 00:12:38.069 Nicolas Sucari: Let’s let’s relaunch the obligation and see what happens.
143 00:12:39.620 ⇒ 00:12:41.050 Nicolas Sucari: Python. 3.
144 00:12:47.100 ⇒ 00:12:47.900 Nicolas Sucari: Okay.
145 00:12:56.990 ⇒ 00:12:59.290 Nicolas Sucari: yeah. I have. Python 3. Okay.
146 00:12:59.740 ⇒ 00:13:01.960 Nicolas Sucari: Python, 3.9 point 6.
147 00:13:01.960 ⇒ 00:13:03.500 Atharv Gudi: We okay, cool?
148 00:13:04.436 ⇒ 00:13:05.620 Atharv Gudi: Now that you have
149 00:13:05.830 ⇒ 00:13:11.440 Atharv Gudi: that installed, you, wanna make sure Pip is installed. So can you type in Pip and then version
150 00:13:11.620 ⇒ 00:13:13.029 Atharv Gudi: in the same, yeah.
151 00:13:15.050 ⇒ 00:13:16.560 Nicolas Sucari: I don’t have Peep installed. Yeah.
152 00:13:16.560 ⇒ 00:13:18.950 Atharv Gudi: Haven’t installed with yet. Let me try to find the.
153 00:13:21.050 ⇒ 00:13:22.350 Nicolas Sucari: I can go to.
154 00:13:24.240 ⇒ 00:13:24.819 Atharv Gudi: Where.
155 00:13:29.270 ⇒ 00:13:33.860 Nicolas Sucari: So I don’t have. Python is installed. I have this one. Okay, let me try this.
156 00:13:38.370 ⇒ 00:13:40.440 Nicolas Sucari: Wait. Item 3.
157 00:13:48.000 ⇒ 00:13:50.310 Nicolas Sucari: Okay, it’s downloading everything. I think.
158 00:13:50.310 ⇒ 00:13:53.349 Atharv Gudi: Alright. It will take a minute. I’ll just be back one moment.
159 00:14:09.150 ⇒ 00:14:09.660 Atharv Gudi: Okay.
160 00:14:10.190 ⇒ 00:14:11.220 Atharv Gudi: did it
161 00:14:12.030 ⇒ 00:14:14.229 Atharv Gudi: say that it might have worked or not?
162 00:14:15.240 ⇒ 00:14:17.810 Nicolas Sucari: I think. Yes, let’s try deep version.
163 00:14:18.720 ⇒ 00:14:19.780 Nicolas Sucari: No.
164 00:14:20.310 ⇒ 00:14:21.639 Nicolas Sucari: Why not?
165 00:14:22.930 ⇒ 00:14:25.170 Nicolas Sucari: I installed this, and it went, okay.
166 00:14:25.600 ⇒ 00:14:29.820 Atharv Gudi: Oh, you’ve used that to install SQL. Fluff. I think.
167 00:14:30.410 ⇒ 00:14:31.600 Nicolas Sucari: Yeah, I use this one.
168 00:14:31.760 ⇒ 00:14:34.770 Atharv Gudi: Yeah, if it hasn’t worked, then I mean
169 00:14:36.140 ⇒ 00:14:36.900 Atharv Gudi: the.
170 00:14:36.900 ⇒ 00:14:39.210 Nicolas Sucari: No, I think it worked. I don’t have
171 00:14:39.350 ⇒ 00:14:41.689 Nicolas Sucari: peep. That’s the only stuff.
172 00:14:42.300 ⇒ 00:14:44.060 Atharv Gudi: Then could you?
173 00:14:44.210 ⇒ 00:14:48.989 Atharv Gudi: Just for good measure on the curl that particular line?
174 00:14:49.270 ⇒ 00:14:49.980 Atharv Gudi: Yeah.
175 00:14:51.120 ⇒ 00:14:51.700 Nicolas Sucari: Wait!
176 00:14:54.650 ⇒ 00:14:55.770 Nicolas Sucari: This one right.
177 00:14:55.770 ⇒ 00:14:56.450 Atharv Gudi: Yeah.
178 00:14:59.630 ⇒ 00:15:00.260 Nicolas Sucari: Bay.
179 00:15:00.520 ⇒ 00:15:01.970 Atharv Gudi: Python. 3.
180 00:15:03.130 ⇒ 00:15:03.850 Atharv Gudi: Oh.
181 00:15:04.195 ⇒ 00:15:06.270 Nicolas Sucari: Not from python. Okay, yeah, exactly.
182 00:15:07.190 ⇒ 00:15:09.910 Nicolas Sucari: Call python 3.
183 00:15:10.360 ⇒ 00:15:11.679 Nicolas Sucari: That’s it. Yeah.
184 00:15:14.100 ⇒ 00:15:14.850 Nicolas Sucari: Yeah.
185 00:15:15.530 ⇒ 00:15:18.630 Nicolas Sucari: Okay, okay. So let’s try. Now, paid version.
186 00:15:20.420 ⇒ 00:15:21.214 Nicolas Sucari: no.
187 00:15:26.960 ⇒ 00:15:27.730 Atharv Gudi: can you agree?
188 00:15:27.730 ⇒ 00:15:29.070 Nicolas Sucari: To add file.
189 00:15:37.000 ⇒ 00:15:40.640 Nicolas Sucari: Let’s try this. Let’s try following these steps. Wait.
190 00:15:56.560 ⇒ 00:15:59.030 Atharv Gudi: We’re not using Home Rule.
191 00:15:59.030 ⇒ 00:16:01.040 Nicolas Sucari: No, no, I’m not using combo.
192 00:16:01.040 ⇒ 00:16:05.500 Atharv Gudi: Yeah, so we can just now. Can you try it? Paper? Now.
193 00:16:07.420 ⇒ 00:16:08.130 Atharv Gudi: skip.
194 00:16:10.730 ⇒ 00:16:11.470 Nicolas Sucari: No.
195 00:16:16.840 ⇒ 00:16:17.690 Nicolas Sucari: Sask.
196 00:16:41.160 ⇒ 00:16:43.660 Atharv Gudi: User. Local bin python. 3.
197 00:16:51.630 ⇒ 00:16:54.390 Nicolas Sucari: Okay, keep 24.
198 00:16:54.550 ⇒ 00:16:56.180 Nicolas Sucari: That’s okay. I think right?
199 00:16:57.110 ⇒ 00:16:58.500 Atharv Gudi: Should be
200 00:17:01.690 ⇒ 00:17:02.690 Atharv Gudi: okay. I’m.
201 00:17:05.109 ⇒ 00:17:08.229 Nicolas Sucari: Let’s try to install Pd. Directly. Let’s try this one.
202 00:17:08.770 ⇒ 00:17:09.540 Atharv Gudi: You know.
203 00:17:16.630 ⇒ 00:17:19.279 Atharv Gudi: Okay. So it’s re downloaded something.
204 00:17:20.089 ⇒ 00:17:26.629 Nicolas Sucari: Yeah. And it installed. It says here, successfully installed beep 24.2. Right? So if I tried the version.
205 00:17:28.999 ⇒ 00:17:31.029 Nicolas Sucari: why, he doesn’t find the common people.
206 00:17:31.342 ⇒ 00:17:33.840 Atharv Gudi: Have you put that in the source file?
207 00:17:34.960 ⇒ 00:17:37.189 Atharv Gudi: Yeah. The echo export path.
208 00:17:38.250 ⇒ 00:17:39.800 Nicolas Sucari: Which 1? 0, no!
209 00:17:40.280 ⇒ 00:17:42.649 Nicolas Sucari: Let’s copy this one. Run this.
210 00:17:45.940 ⇒ 00:17:46.600 Atharv Gudi: Oh,
211 00:17:48.650 ⇒ 00:17:53.369 Atharv Gudi: okay. Can you try Pip version? If not, I can see where it might be going wrong?
212 00:17:54.430 ⇒ 00:17:54.940 Nicolas Sucari: No.
213 00:17:54.940 ⇒ 00:18:00.150 Atharv Gudi: I’m in the ZH. Rc. Part of whatever it’s showing.
214 00:18:00.150 ⇒ 00:18:00.780 Nicolas Sucari: Yeah.
215 00:18:00.780 ⇒ 00:18:03.839 Atharv Gudi: Can you try replacing that with Zsh.
216 00:18:04.290 ⇒ 00:18:06.110 Atharv Gudi: and just forget the Rc.
217 00:18:08.880 ⇒ 00:18:09.480 Nicolas Sucari: Sorry
218 00:18:11.530 ⇒ 00:18:13.640 Nicolas Sucari: here, too. Yeah. Like that.
219 00:18:13.640 ⇒ 00:18:14.190 Atharv Gudi: Yeah.
220 00:18:17.320 ⇒ 00:18:18.000 Nicolas Sucari: Okay.
221 00:18:18.140 ⇒ 00:18:21.189 Atharv Gudi: Now, can you try to see if there’s a pip version?
222 00:18:22.770 ⇒ 00:18:23.610 Atharv Gudi: Nope.
223 00:18:24.240 ⇒ 00:18:24.950 Atharv Gudi: hmm!
224 00:18:48.200 ⇒ 00:18:50.440 Nicolas Sucari: He’s answered. These
225 00:18:50.900 ⇒ 00:18:52.520 Nicolas Sucari: I’m using, Mac.
226 00:18:53.830 ⇒ 00:18:55.870 Nicolas Sucari: Let’s see, and.
227 00:19:19.490 ⇒ 00:19:23.179 Atharv Gudi: I’ve just put in something in the chat, can you? I mean.
228 00:19:25.560 ⇒ 00:19:26.140 Nicolas Sucari: H.
229 00:20:01.620 ⇒ 00:20:03.010 Nicolas Sucari: Let me check the chat.
230 00:20:05.840 ⇒ 00:20:06.180 Atharv Gudi: But in.
231 00:20:06.180 ⇒ 00:20:07.450 Nicolas Sucari: Oh, interesting limits!
232 00:20:07.450 ⇒ 00:20:09.140 Atharv Gudi: Don’t chat. Sorry. Yeah.
233 00:20:10.730 ⇒ 00:20:13.810 Nicolas Sucari: A great beep. Okay, try that one.
234 00:20:26.970 ⇒ 00:20:27.860 Nicolas Sucari: Wait.
235 00:20:28.550 ⇒ 00:20:30.309 Nicolas Sucari: Copied something wrong.
236 00:20:30.900 ⇒ 00:20:32.152 Nicolas Sucari: Let’s try Jess.
237 00:20:32.570 ⇒ 00:20:33.610 Atharv Gudi: Right.
238 00:20:44.310 ⇒ 00:20:45.560 Nicolas Sucari: Yeah. But this is like.
239 00:20:45.570 ⇒ 00:20:48.969 Nicolas Sucari: first, st it’s gonna try to install. And it’s gonna fail, I think.
240 00:20:49.190 ⇒ 00:20:50.710 Nicolas Sucari: Oh, no, okay.
241 00:20:51.430 ⇒ 00:20:52.470 Nicolas Sucari: It upgraded.
242 00:20:52.470 ⇒ 00:20:54.830 Atharv Gudi: Requirement already satisfied.
243 00:20:55.610 ⇒ 00:20:58.150 Atharv Gudi: Okay, so Pip is in
244 00:20:59.190 ⇒ 00:21:00.820 Atharv Gudi: library. Right? Library.
245 00:21:01.540 ⇒ 00:21:02.260 Nicolas Sucari: Frameworks.
246 00:21:03.370 ⇒ 00:21:05.620 Nicolas Sucari: I can find that. Let me see.
247 00:21:15.750 ⇒ 00:21:16.410 Nicolas Sucari: Painter.
248 00:21:18.770 ⇒ 00:21:21.440 Nicolas Sucari: that’s okay. And let’s see
249 00:21:22.460 ⇒ 00:21:24.519 Nicolas Sucari: if now Peep install
250 00:21:27.810 ⇒ 00:21:28.830 Nicolas Sucari: good version.
251 00:21:32.220 ⇒ 00:21:35.330 Nicolas Sucari: not sure what we need to do here.
252 00:21:35.330 ⇒ 00:21:36.100 Atharv Gudi: Okay, I’m
253 00:21:36.860 ⇒ 00:21:39.019 Atharv Gudi: if Pip is not.
254 00:21:40.630 ⇒ 00:21:41.460 Atharv Gudi: let’s try.
255 00:21:41.460 ⇒ 00:21:42.010 Nicolas Sucari: 53.
256 00:21:42.010 ⇒ 00:21:43.800 Atharv Gudi: Yeah, 100?
257 00:21:47.690 ⇒ 00:21:49.579 Nicolas Sucari: Okay, tip 3 is okay.
258 00:21:49.770 ⇒ 00:21:51.809 Nicolas Sucari: So 5, th 3 is okay.
259 00:21:52.920 ⇒ 00:21:53.670 Atharv Gudi: Hmm.
260 00:21:56.550 ⇒ 00:21:58.740 Nicolas Sucari: Step 3 install. Let’s see.
261 00:21:59.990 ⇒ 00:22:00.640 Nicolas Sucari: So cool.
262 00:22:00.640 ⇒ 00:22:01.840 Atharv Gudi: And up with 3.
263 00:22:03.100 ⇒ 00:22:05.409 Nicolas Sucari: Yeah. Pip, 3 is okay. It’s Pip 3.
264 00:22:07.290 ⇒ 00:22:08.248 Atharv Gudi: Okay. And now, can you.
265 00:22:08.440 ⇒ 00:22:10.469 Nicolas Sucari: I think I already installed SQL. Soft.
266 00:22:10.570 ⇒ 00:22:13.299 Nicolas Sucari: I can route with 3 version. If you want.
267 00:22:13.300 ⇒ 00:22:14.090 Atharv Gudi: Yeah.
268 00:22:14.090 ⇒ 00:22:14.670 Nicolas Sucari: Or
269 00:22:15.480 ⇒ 00:22:19.079 Nicolas Sucari: like Pip version, is as found. But Pip 3 version.
270 00:22:20.300 ⇒ 00:22:22.390 Nicolas Sucari: it fouls. It’s okay.
271 00:22:22.390 ⇒ 00:22:25.519 Atharv Gudi: So you’ve run Pip 3 install SQL. Fluff.
272 00:22:26.560 ⇒ 00:22:27.290 Nicolas Sucari: Yeah.
273 00:22:27.290 ⇒ 00:22:32.389 Atharv Gudi: Okay. Now that you have sequel, Fluff, what’s next in the instructions.
274 00:22:34.040 ⇒ 00:22:34.810 Nicolas Sucari: Let’s go.
275 00:22:36.895 ⇒ 00:22:38.050 Nicolas Sucari: Let’s go back.
276 00:22:48.950 ⇒ 00:22:53.399 Nicolas Sucari: So s, equals. Okay, where should I found this? Yeah.
277 00:22:53.400 ⇒ 00:22:57.819 Atharv Gudi: So I this is one of the files that has to be already uploaded
278 00:22:59.090 ⇒ 00:23:08.919 Atharv Gudi: on to the to go repository. I could. I haven’t uploaded it because I installed the pre commit hook. It was
279 00:23:08.970 ⇒ 00:23:10.522 Atharv Gudi: some nuance. But
280 00:23:12.708 ⇒ 00:23:15.971 Atharv Gudi: I don’t think I’ll maybe I will commit
281 00:23:16.810 ⇒ 00:23:18.960 Atharv Gudi: I’ll just make a separate branch. And
282 00:23:24.120 ⇒ 00:23:25.300 Atharv Gudi: while they heard.
283 00:23:28.370 ⇒ 00:23:30.349 Atharv Gudi: okay, just a minute.
284 00:23:40.220 ⇒ 00:23:41.200 Atharv Gudi: Okay.
285 00:23:57.450 ⇒ 00:23:59.410 Atharv Gudi: I’m gonna create
286 00:23:59.690 ⇒ 00:24:01.050 Atharv Gudi: to. Okay,
287 00:24:01.760 ⇒ 00:24:03.559 Atharv Gudi: can you create a new
288 00:24:05.030 ⇒ 00:24:06.000 Atharv Gudi: pile
289 00:24:06.340 ⇒ 00:24:08.859 Atharv Gudi: in in the pool parts to go?
290 00:24:16.160 ⇒ 00:24:16.780 Nicolas Sucari: 8, perfect.
291 00:24:16.780 ⇒ 00:24:17.780 Atharv Gudi: One of them is this.
292 00:24:18.156 ⇒ 00:24:22.669 Nicolas Sucari: I’m gonna check out on Main again. Let me see something. Sorry.
293 00:24:23.220 ⇒ 00:24:27.830 Nicolas Sucari: Yeah. Okay. Now, sorry I should create a new file where.
294 00:24:30.700 ⇒ 00:24:36.160 Atharv Gudi: Yeah. In the pool parts of the repository. So if you just double, click and create new file.
295 00:24:38.680 ⇒ 00:24:40.899 Nicolas Sucari: Okay, and what the file needs to be.
296 00:24:41.490 ⇒ 00:24:42.300 Atharv Gudi: Tart
297 00:24:44.100 ⇒ 00:24:45.550 Nicolas Sucari: Is it called love, this one.
298 00:24:45.550 ⇒ 00:24:46.240 Atharv Gudi: Yes.
299 00:24:48.110 ⇒ 00:24:49.510 Atharv Gudi: I’ll just let you know what.
300 00:24:49.510 ⇒ 00:24:50.010 Nicolas Sucari: New.
301 00:24:50.010 ⇒ 00:24:51.700 Atharv Gudi: The content should be.
302 00:24:52.290 ⇒ 00:24:56.769 Atharv Gudi: Maybe I’ll just do a screenshot of this on slack. So you know
303 00:24:56.910 ⇒ 00:24:58.573 Atharv Gudi: what it looks like.
304 00:25:05.360 ⇒ 00:25:06.460 Atharv Gudi: it’s a
305 00:25:07.790 ⇒ 00:25:09.080 Atharv Gudi: 3 liner.
306 00:25:10.140 ⇒ 00:25:16.059 Atharv Gudi: So far, so this is basically the folder that dictates all the rules with which.
307 00:25:16.060 ⇒ 00:25:16.759 Nicolas Sucari: So guy.
308 00:25:16.760 ⇒ 00:25:18.209 Atharv Gudi: But supposed to have
309 00:25:19.910 ⇒ 00:25:25.420 Atharv Gudi: SQL or not the way that Dbt is supposed snowflake is supposed to be written.
310 00:25:27.950 ⇒ 00:25:29.780 Atharv Gudi: let me go. Yeah.
311 00:25:35.240 ⇒ 00:25:38.260 Atharv Gudi: Think I did. I just send it to you.
312 00:25:40.070 ⇒ 00:25:41.360 Atharv Gudi: I don’t think I did.
313 00:25:42.700 ⇒ 00:25:44.180 Nicolas Sucari: Nope, not yet.
314 00:25:55.110 ⇒ 00:25:56.480 Atharv Gudi: Now I do.
315 00:25:59.470 ⇒ 00:26:07.400 Nicolas Sucari: Oh, I’m I was looking at actually. Conversation. Sorry. Okay, i i i should copy this here.
316 00:26:07.400 ⇒ 00:26:08.180 Atharv Gudi: Yeah.
317 00:26:09.630 ⇒ 00:26:10.310 Atharv Gudi: ready.
318 00:26:11.230 ⇒ 00:26:25.039 Atharv Gudi: So ess ideally, I haven’t. I haven’t uploaded this. This is not merged into the autism yet. It still has to go through Patrick’s checks. It has to go through a lot of stuff. But this is essentially the rule book, according to which
319 00:26:25.600 ⇒ 00:26:26.560 Atharv Gudi: oh.
320 00:26:27.590 ⇒ 00:26:29.349 Atharv Gudi: all the repository is gonna have.
321 00:26:29.695 ⇒ 00:26:30.040 Nicolas Sucari: Bay.
322 00:26:30.450 ⇒ 00:26:32.289 Atharv Gudi: C. Dbt. Standard
323 00:26:32.930 ⇒ 00:26:34.250 Atharv Gudi: annotation.
324 00:26:34.250 ⇒ 00:26:35.010 Nicolas Sucari: Perfect.
325 00:26:48.760 ⇒ 00:26:50.170 Atharv Gudi: I think it’s
326 00:27:04.160 ⇒ 00:27:08.050 Atharv Gudi: yeah. Just change that to SQL, Fluff. I think the 3rd ones.
327 00:27:08.560 ⇒ 00:27:09.270 Atharv Gudi: yeah.
328 00:27:11.820 ⇒ 00:27:12.490 Nicolas Sucari: There!
329 00:27:12.860 ⇒ 00:27:13.830 Atharv Gudi: Equal Fluff.
330 00:27:15.780 ⇒ 00:27:16.350 Atharv Gudi: Some hope.
331 00:27:16.880 ⇒ 00:27:17.410 Nicolas Sucari: Okay.
332 00:27:18.100 ⇒ 00:27:18.710 Atharv Gudi: But fact.
333 00:27:18.710 ⇒ 00:27:19.110 Nicolas Sucari: There!
334 00:27:19.110 ⇒ 00:27:25.350 Atharv Gudi: If you just save it, that part should be, you should be over there. Now.
335 00:27:25.470 ⇒ 00:27:30.410 Atharv Gudi: I think there will be one more step for you. We’ll get to that
336 00:27:30.540 ⇒ 00:27:32.099 Atharv Gudi: in a few minutes.
337 00:27:35.690 ⇒ 00:27:37.930 Atharv Gudi: yeah. So now that you’ve that
338 00:27:38.170 ⇒ 00:27:39.380 Atharv Gudi: the next step.
339 00:27:42.350 ⇒ 00:27:43.680 Nicolas Sucari: She used to run winter.
340 00:27:44.020 ⇒ 00:27:49.600 Atharv Gudi: Yeah, if you wanna lend it. So the difference between lending and fixing is that
341 00:27:49.660 ⇒ 00:28:01.449 Atharv Gudi: it? So once you run SQL Fluff, it’s gonna find all the errors. If it is linked, then it’s gonna just show you all of the errors. You’ve done everything from a capitalization error to a tab error.
342 00:28:03.030 ⇒ 00:28:06.439 Atharv Gudi: fixing errors if you choose to fix the errors.
343 00:28:06.440 ⇒ 00:28:07.840 Nicolas Sucari: Let me try.
344 00:28:09.760 ⇒ 00:28:14.569 Nicolas Sucari: I’ve been working on something here, let’s see.
345 00:28:15.640 ⇒ 00:28:17.349 Nicolas Sucari: Sorry it’s not a main.
346 00:28:17.780 ⇒ 00:28:18.240 Atharv Gudi: Don’t worry.
347 00:28:18.240 ⇒ 00:28:20.460 Nicolas Sucari: He’s middle branch.
348 00:28:20.960 ⇒ 00:28:21.710 Nicolas Sucari: Okay?
349 00:28:22.180 ⇒ 00:28:24.069 Nicolas Sucari: So I have. DC profile.
350 00:28:24.070 ⇒ 00:28:24.460 Atharv Gudi: Okay.
351 00:28:24.460 ⇒ 00:28:26.760 Nicolas Sucari: Let’s say I made a mistake here.
352 00:28:26.960 ⇒ 00:28:27.967 Atharv Gudi: Yeah, so for example.
353 00:28:28.220 ⇒ 00:28:29.070 Nicolas Sucari: Like that.
354 00:28:29.890 ⇒ 00:28:30.320 Atharv Gudi: Yeah.
355 00:28:32.420 ⇒ 00:28:34.470 Nicolas Sucari: Should I copy paths.
356 00:28:34.620 ⇒ 00:28:35.130 Atharv Gudi: Yes.
357 00:28:35.130 ⇒ 00:28:35.860 Nicolas Sucari: Right.
358 00:28:35.860 ⇒ 00:28:36.256 Atharv Gudi: Yes,
359 00:28:37.050 ⇒ 00:28:41.080 Nicolas Sucari: Now here I should do sequel. Love right.
360 00:28:41.490 ⇒ 00:28:45.540 Atharv Gudi: Yeah, you wanna copy the not just the relative path.
361 00:28:46.550 ⇒ 00:28:47.250 Nicolas Sucari: Okay.
362 00:28:48.100 ⇒ 00:28:56.159 Atharv Gudi: Maybe that’s something I’ll add in. Because sequel, Fluff, the configuration file is in the Root Directory. So you want the whole path from the root till
363 00:28:56.730 ⇒ 00:28:57.400 Atharv Gudi: yeah.
364 00:28:57.400 ⇒ 00:28:59.539 Nicolas Sucari: Okay, that one. Should I run.
365 00:29:00.220 ⇒ 00:29:01.120 Atharv Gudi: Yes.
366 00:29:02.250 ⇒ 00:29:03.460 Atharv Gudi: Oh, yeah, perfect
367 00:29:03.790 ⇒ 00:29:05.880 Atharv Gudi: interact. Now you have
368 00:29:07.290 ⇒ 00:29:08.210 Atharv Gudi: fame.
369 00:29:08.210 ⇒ 00:29:10.410 Nicolas Sucari: Keywords must be lower case.
370 00:29:11.670 ⇒ 00:29:12.240 Atharv Gudi: Line.
371 00:29:12.650 ⇒ 00:29:13.060 Nicolas Sucari: Very.
372 00:29:13.060 ⇒ 00:29:16.619 Atharv Gudi: Part one. So that means your select is not lower. Case.
373 00:29:18.790 ⇒ 00:29:19.280 Atharv Gudi: Okay?
374 00:29:19.280 ⇒ 00:29:24.020 Nicolas Sucari: Okay. And let’s do. Let’s fix this one. Okay, let’s say, let’s leave this one.
375 00:29:25.540 ⇒ 00:29:26.320 Nicolas Sucari: Sorry.
376 00:29:27.490 ⇒ 00:29:30.300 Nicolas Sucari: Let’s run it again and see what happens. Right.
377 00:29:30.300 ⇒ 00:29:30.940 Atharv Gudi: Yep.
378 00:29:36.980 ⇒ 00:29:42.259 Nicolas Sucari: Okay, select target should be on a new line unless there is only one select target.
379 00:29:42.520 ⇒ 00:29:43.310 Nicolas Sucari: Okay? So.
380 00:29:43.310 ⇒ 00:29:45.880 Atharv Gudi: It’s the same name should also be under users.
381 00:29:45.880 ⇒ 00:29:46.650 Nicolas Sucari: Rag.
382 00:29:48.540 ⇒ 00:29:54.339 Atharv Gudi: So Nico, if you don’t wanna go through every single thing, and just do all of that, you can just do sequel. Fix.
383 00:29:54.340 ⇒ 00:29:55.460 Nicolas Sucari: I’m just.
384 00:29:55.460 ⇒ 00:29:55.900 Atharv Gudi: Okay.
385 00:29:55.900 ⇒ 00:30:06.309 Nicolas Sucari: Yeah, perfect. Yeah, I I’m just, I was just fixing it so I can see how it changed these messages. But that’s okay. So now, instead of linked, I can use single fix right.
386 00:30:06.310 ⇒ 00:30:07.409 Atharv Gudi: Yeah. Oh.
387 00:30:08.810 ⇒ 00:30:15.249 Atharv Gudi: the thing about sequel is that there are a bunch of it can fix only so many issues.
388 00:30:15.570 ⇒ 00:30:16.580 Atharv Gudi: I’ll get to that part.
389 00:30:16.580 ⇒ 00:30:17.200 Nicolas Sucari: Okay.
390 00:30:17.200 ⇒ 00:30:19.139 Atharv Gudi: I do see, once you do the SQL. Fix.
391 00:30:20.165 ⇒ 00:30:21.030 Atharv Gudi: Yeah.
392 00:30:21.030 ⇒ 00:30:22.149 Nicolas Sucari: Should I run this one.
393 00:30:22.380 ⇒ 00:30:24.171 Atharv Gudi: It’s back to lent
394 00:30:26.160 ⇒ 00:30:28.579 Nicolas Sucari: It it limited? Oh, sorry
395 00:30:33.400 ⇒ 00:30:34.180 Nicolas Sucari: there.
396 00:30:34.410 ⇒ 00:30:35.140 Atharv Gudi: And okay.
397 00:30:36.540 ⇒ 00:30:37.140 Atharv Gudi: yeah.
398 00:30:37.140 ⇒ 00:30:38.360 Nicolas Sucari: Simple fix.
399 00:30:39.670 ⇒ 00:30:41.290 Nicolas Sucari: Okay, that’s it.
400 00:30:41.970 ⇒ 00:30:45.140 Atharv Gudi: Yes. So it’s fixed. Where? Okay?
401 00:30:46.300 ⇒ 00:30:52.589 Nicolas Sucari: Okay, still giving me this, but it added like an indentation here, okay, that’s fine.
402 00:30:52.590 ⇒ 00:30:53.757 Atharv Gudi: It’s added the indentations.
403 00:30:54.050 ⇒ 00:30:54.670 Nicolas Sucari: Changed.
404 00:30:57.220 ⇒ 00:30:59.379 Nicolas Sucari: That’s good. Yeah, perfect.
405 00:30:59.380 ⇒ 00:31:04.469 Atharv Gudi: One thing that it hasn’t done is, you can see it’s considered those semicolons to be a part of the entire.
406 00:31:04.470 ⇒ 00:31:05.130 Nicolas Sucari: Yeah.
407 00:31:05.790 ⇒ 00:31:10.229 Atharv Gudi: So those kind of those are the errors that we’re gonna have to fix on our own and not just
408 00:31:10.700 ⇒ 00:31:13.110 Atharv Gudi: these kind of errors. Sometimes
409 00:31:13.929 ⇒ 00:31:21.709 Atharv Gudi: I don’t remember what the standard was. I think it’s there should be a line at the beginning and a line, the end of the program, or something like that.
410 00:31:25.320 ⇒ 00:31:26.470 Atharv Gudi: fixable.
411 00:31:28.260 ⇒ 00:31:28.840 Nicolas Sucari: Yeah.
412 00:31:29.274 ⇒ 00:31:31.919 Nicolas Sucari: don’t worry. But I think this is great. I mean.
413 00:31:31.920 ⇒ 00:31:32.630 Atharv Gudi: Okay.
414 00:31:32.830 ⇒ 00:31:36.560 Nicolas Sucari: That’s perfect. It made it like prettier. And let’s see.
415 00:31:37.490 ⇒ 00:31:39.670 Nicolas Sucari: let’s go with a harder one, probably
416 00:31:39.760 ⇒ 00:31:41.369 Nicolas Sucari: not like these ones.
417 00:31:41.600 ⇒ 00:31:43.059 Nicolas Sucari: Okay, I like these ones.
418 00:31:43.380 ⇒ 00:31:44.699 Nicolas Sucari: Let’s see if these.
419 00:31:44.700 ⇒ 00:31:47.919 Atharv Gudi: You could run it on those harder ones, it should be able to.
420 00:31:48.350 ⇒ 00:31:53.809 Nicolas Sucari: Yeah, yeah, I know. But I don’t want, because I this one, this one is easy to to check.
421 00:31:54.140 ⇒ 00:31:56.000 Nicolas Sucari: Sequel, laugh.
422 00:31:56.670 ⇒ 00:31:57.670 Nicolas Sucari: fix
423 00:31:58.955 ⇒ 00:31:59.739 Nicolas Sucari: right.
424 00:31:59.740 ⇒ 00:32:00.310 Atharv Gudi: Yeah.
425 00:32:02.840 ⇒ 00:32:03.670 Nicolas Sucari: Nice
426 00:32:04.010 ⇒ 00:32:04.710 Nicolas Sucari: yep.
427 00:32:05.650 ⇒ 00:32:07.780 Atharv Gudi: Cool. You wanna try one of the bigger ones.
428 00:32:09.560 ⇒ 00:32:10.990 Nicolas Sucari: I’m not gonna
429 00:32:12.120 ⇒ 00:32:15.370 Nicolas Sucari: commit those changes. Yeah, my idea.
430 00:32:15.370 ⇒ 00:32:21.750 Atharv Gudi: I don’t want any of these changes to be committed just yet, cause I think Patrick and I have to go through a bunch also. These are.
431 00:32:21.750 ⇒ 00:32:22.230 Nicolas Sucari: Yeah.
432 00:32:22.230 ⇒ 00:32:25.350 Atharv Gudi: I think it can go through these. These are pretty easy. I think.
433 00:32:25.730 ⇒ 00:32:27.600 Nicolas Sucari: Yeah, let’s go with this one.
434 00:32:27.600 ⇒ 00:32:28.080 Atharv Gudi: Yeah.
435 00:32:28.080 ⇒ 00:32:31.879 Nicolas Sucari: Stay sales month. Okay, let’s go in sequel.
436 00:32:32.070 ⇒ 00:32:32.940 Nicolas Sucari: Love
437 00:32:33.680 ⇒ 00:32:34.610 Nicolas Sucari: fakes.
438 00:32:36.170 ⇒ 00:32:37.699 Atharv Gudi: I hope it works.
439 00:32:38.990 ⇒ 00:32:39.690 Nicolas Sucari: Yeah.
440 00:32:39.690 ⇒ 00:32:40.270 Atharv Gudi: That’s cool.
441 00:32:40.270 ⇒ 00:32:40.890 Nicolas Sucari: Nice.
442 00:32:42.530 ⇒ 00:32:47.060 Nicolas Sucari: Yes, this is nice. Okay, so this is line.
443 00:32:47.150 ⇒ 00:32:50.379 Nicolas Sucari: It’s telling us which line is fixing right.
444 00:32:50.380 ⇒ 00:32:50.960 Atharv Gudi: Yes.
445 00:32:50.960 ⇒ 00:32:53.030 Nicolas Sucari: 9. 1. What is p.
446 00:32:53.691 ⇒ 00:32:57.380 Atharv Gudi: I think it’s part of the word one.
447 00:32:57.510 ⇒ 00:32:59.030 Nicolas Sucari: Yeah. Word. Okay.
448 00:32:59.030 ⇒ 00:33:02.899 Atharv Gudi: The funky thing about the lines in SQL. Are it? They don’t.
449 00:33:02.920 ⇒ 00:33:10.720 Atharv Gudi: It’s not the same as the lines in versus code. So the width top states all the way to limit 10, and the close bracket is considered one line.
450 00:33:11.610 ⇒ 00:33:12.240 Nicolas Sucari: Okay.
451 00:33:12.530 ⇒ 00:33:15.920 Atharv Gudi: And then you have a select and then a union, and then a select.
452 00:33:15.990 ⇒ 00:33:17.950 Atharv Gudi: Those are 4 different lines.
453 00:33:19.670 ⇒ 00:33:20.320 Nicolas Sucari: Okay.
454 00:33:21.120 ⇒ 00:33:23.410 Nicolas Sucari: that’s fine. Yeah, this is.
455 00:33:24.600 ⇒ 00:33:25.980 Nicolas Sucari: this is nice.
456 00:33:27.980 ⇒ 00:33:28.960 Nicolas Sucari: perfect.
457 00:33:29.110 ⇒ 00:33:32.130 Nicolas Sucari: So I’m I’m done with single flag. I think right.
458 00:33:32.530 ⇒ 00:33:38.070 Atharv Gudi: Yes. So this is about how to use just the basic of SQL fluff.
459 00:33:38.560 ⇒ 00:33:41.710 Atharv Gudi: The pre-commit is a little
460 00:33:41.730 ⇒ 00:33:48.030 Atharv Gudi: trickier to tackle, because the pre-commit part is, it’s very, very nitpicking.
461 00:33:48.250 ⇒ 00:33:57.189 Atharv Gudi: You need to make sure single one of. If you want, you can install it right now. It’s it takes like 5 min to finish the whole installation and everything
462 00:33:57.230 ⇒ 00:34:01.500 Atharv Gudi: but once you engage it, it will not let you commit until you’ve.
463 00:34:02.360 ⇒ 00:34:03.160 Nicolas Sucari: Hmm.
464 00:34:03.160 ⇒ 00:34:04.969 Atharv Gudi: Done every last.
465 00:34:05.890 ⇒ 00:34:06.510 Atharv Gudi: Thank you.
466 00:34:06.780 ⇒ 00:34:11.459 Nicolas Sucari: Okay, so it won’t let you commit unless everything is fixed right.
467 00:34:11.850 ⇒ 00:34:12.260 Atharv Gudi: Yeah.
468 00:34:12.260 ⇒ 00:34:14.250 Nicolas Sucari: Configuration that we are using.
469 00:34:14.250 ⇒ 00:34:28.784 Atharv Gudi: Yes, so it’s if you so you can see in the pay on the document. So you’ve got the pip install. Pre-commit the that just installs the framework from the website. It installs it from 2 python. So it’ll be on your local machine.
470 00:34:29.380 ⇒ 00:34:39.220 Atharv Gudi: The pre-commit install engages the hope. So once you type in, pre commit install, and then you press, enter it’ll basically
471 00:34:39.280 ⇒ 00:34:48.070 Atharv Gudi: say it. It engages the pre-competence. Also, once you try to commit on Github. It will run the Linker and show you the results before committing.
472 00:34:48.310 ⇒ 00:34:56.250 Atharv Gudi: I tried it, and there were just way, too many errors in the entire pool, part super repository, and I could not fix them.
473 00:34:56.780 ⇒ 00:34:59.070 Atharv Gudi: Cause there’s also
474 00:34:59.400 ⇒ 00:35:04.625 Atharv Gudi: non fixable error so far the quote that you’ve shown me those are all errors that can be fixed.
475 00:35:04.900 ⇒ 00:35:05.850 Nicolas Sucari: Yeah, yeah, I know
476 00:35:06.160 ⇒ 00:35:08.470 Nicolas Sucari: they were easy ones. Yeah.
477 00:35:08.470 ⇒ 00:35:10.420 Atharv Gudi: The more complicated ones.
478 00:35:10.770 ⇒ 00:35:19.649 Atharv Gudi: The even fix the SQL. Fluff fix cannot fix on its own, otherwise it it makes the file unreadable for the lender for the rest of time.
479 00:35:20.630 ⇒ 00:35:21.620 Atharv Gudi: Slave.
480 00:35:21.990 ⇒ 00:35:23.900 Atharv Gudi: leave some errors
481 00:35:24.490 ⇒ 00:35:27.480 Atharv Gudi: for you to fix, but it shows you which ones they are.
482 00:35:27.730 ⇒ 00:35:30.509 Nicolas Sucari: Oh, yeah, yeah, that’s fine. That’s fine. Okay.
483 00:35:32.130 ⇒ 00:35:34.779 Atharv Gudi: So if you type in pre-commit install
484 00:35:34.950 ⇒ 00:35:38.000 Atharv Gudi: after installing the pre-commit part.
485 00:35:38.705 ⇒ 00:35:39.410 Atharv Gudi: we’ll just type.
486 00:35:39.410 ⇒ 00:35:40.510 Nicolas Sucari: Let’s go.
487 00:35:41.050 ⇒ 00:35:47.009 Nicolas Sucari: Yeah, but I think I will need to use Pip 3 install. Pre commit right.
488 00:35:47.010 ⇒ 00:35:47.610 Atharv Gudi: Yeah.
489 00:35:49.850 ⇒ 00:35:50.560 Atharv Gudi: Yep.
490 00:35:51.040 ⇒ 00:36:00.329 Atharv Gudi: okay, this. And after this, I think you can forget the terminal. You wanna run the pre commitments around the Vs code terminal.
491 00:36:00.610 ⇒ 00:36:01.360 Nicolas Sucari: Gray.
492 00:36:01.360 ⇒ 00:36:02.940 Atharv Gudi: Pre-commit install.
493 00:36:03.260 ⇒ 00:36:11.329 Atharv Gudi: Oh, wait! No, no, no, no, no! This requires another file. The pre dot pre commit config. Yaml file
494 00:36:12.930 ⇒ 00:36:13.810 Atharv Gudi: here.
495 00:36:15.080 ⇒ 00:36:18.410 Atharv Gudi: Yeah, let me just see what I’ve written in it. If it’s a bit too
496 00:36:18.660 ⇒ 00:36:20.229 Atharv Gudi: complicated. Okay.
497 00:36:21.250 ⇒ 00:36:23.409 Atharv Gudi: it’s not. I will just
498 00:36:24.550 ⇒ 00:36:25.200 Atharv Gudi: hmm.
499 00:36:25.200 ⇒ 00:36:28.709 Nicolas Sucari: Just copy, copy the text and send it through slack. I can paste it here.
500 00:36:29.080 ⇒ 00:36:29.820 Atharv Gudi: Okay.
501 00:36:30.840 ⇒ 00:36:31.680 Atharv Gudi: the.
502 00:36:42.440 ⇒ 00:36:49.319 Atharv Gudi: I think it would be. So I’ve I’ve put in Rev. And then the version of
503 00:36:52.376 ⇒ 00:36:53.570 Atharv Gudi: SQL. Fluff.
504 00:36:54.050 ⇒ 00:36:54.990 Atharv Gudi: So
505 00:36:55.980 ⇒ 00:37:03.200 Atharv Gudi: can you just check which version it is using the SQL fluff dot slash version. You can do it in Vs code as well if you want.
506 00:37:06.100 ⇒ 00:37:06.970 Atharv Gudi: yet
507 00:37:07.260 ⇒ 00:37:08.180 Atharv Gudi: you can.
508 00:37:09.410 ⇒ 00:37:09.890 Atharv Gudi: Hmm!
509 00:37:16.870 ⇒ 00:37:17.980 Atharv Gudi: There you go. It’s good.
510 00:37:17.980 ⇒ 00:37:19.349 Nicolas Sucari: Point 1.0.
511 00:37:19.730 ⇒ 00:37:20.540 Atharv Gudi: Okay.
512 00:37:20.540 ⇒ 00:37:21.120 Nicolas Sucari: Nice.
513 00:37:21.863 ⇒ 00:37:24.780 Atharv Gudi: E pre-commit config. The entire.
514 00:37:28.080 ⇒ 00:37:29.540 Nicolas Sucari: The title, yeah.
515 00:37:32.160 ⇒ 00:37:35.350 Nicolas Sucari: we commit config like that. Yeah.
516 00:37:35.590 ⇒ 00:37:36.330 Atharv Gudi: Perfect.
517 00:37:36.480 ⇒ 00:37:38.600 Atharv Gudi: Okay. Now.
518 00:37:39.350 ⇒ 00:37:40.890 Atharv Gudi: now, you can
519 00:37:41.280 ⇒ 00:37:42.790 Atharv Gudi: pre-commit install.
520 00:37:51.270 ⇒ 00:37:51.960 Nicolas Sucari: Okay.
521 00:37:52.220 ⇒ 00:37:56.030 Atharv Gudi: This, I think, okay. Now that you’re done
522 00:37:56.825 ⇒ 00:37:59.099 Atharv Gudi: can you go to Github?
523 00:38:01.100 ⇒ 00:38:01.969 Atharv Gudi: So you’re doing the.
524 00:38:01.970 ⇒ 00:38:03.150 Nicolas Sucari: And there’s then.
525 00:38:03.150 ⇒ 00:38:04.270 Atharv Gudi: Branch, right.
526 00:38:05.530 ⇒ 00:38:08.669 Nicolas Sucari: In. Yeah, I’m doing it in A, in a, in a, in a branch.
527 00:38:09.120 ⇒ 00:38:12.010 Atharv Gudi: Okay. Can you try to commit this branch.
528 00:38:13.890 ⇒ 00:38:15.650 Nicolas Sucari: Okay.
529 00:38:15.730 ⇒ 00:38:19.299 Nicolas Sucari: let me see, because I was using this for something else.
530 00:38:19.330 ⇒ 00:38:19.860 Atharv Gudi: No.
531 00:38:19.860 ⇒ 00:38:21.310 Nicolas Sucari: Let’s create a new branch. Sorry.
532 00:38:21.310 ⇒ 00:38:21.645 Atharv Gudi: Yeah.
533 00:38:24.880 ⇒ 00:38:27.980 Nicolas Sucari: And this is SQL.
534 00:38:28.320 ⇒ 00:38:31.030 Nicolas Sucari: Nichols equals
535 00:38:31.680 ⇒ 00:38:32.580 Nicolas Sucari: testing.
536 00:38:33.650 ⇒ 00:38:41.060 Nicolas Sucari: Okay, let’s go and see. Okay, per house. Okay, let’s start these ones.
537 00:38:42.040 ⇒ 00:38:43.610 Nicolas Sucari: Discard these ones.
538 00:38:44.770 ⇒ 00:38:50.460 Nicolas Sucari: So I have the sequel to one, the Pre. Commit one on this one. It’s okay. But.
539 00:38:50.460 ⇒ 00:38:54.159 Atharv Gudi: I think most definitely you’ll find an error. So you wouldn’t have to
540 00:38:54.200 ⇒ 00:38:56.059 Atharv Gudi: worry about the committing beam.
541 00:38:57.350 ⇒ 00:38:58.150 Atharv Gudi: Hmm.
542 00:38:59.180 ⇒ 00:38:59.940 Atharv Gudi: okay.
543 00:39:01.970 ⇒ 00:39:07.969 Nicolas Sucari: No, yeah, this is because I don’t have like the branch published, or anything that I didn’t stage the changes before.
544 00:39:09.520 ⇒ 00:39:10.869 Nicolas Sucari: So let’s see.
545 00:39:11.430 ⇒ 00:39:12.490 Nicolas Sucari: it’s committing.
546 00:39:12.910 ⇒ 00:39:14.980 Atharv Gudi: Pre-commit installs. Run
547 00:39:17.780 ⇒ 00:39:18.470 Atharv Gudi: yep.
548 00:39:19.050 ⇒ 00:39:19.749 Nicolas Sucari: And we go.
549 00:39:19.750 ⇒ 00:39:20.430 Atharv Gudi: Nished.
550 00:39:22.350 ⇒ 00:39:26.779 Nicolas Sucari: I didn’t publish the branch, I mean i i i just have it here, but it committed everything.
551 00:39:27.080 ⇒ 00:39:27.960 Atharv Gudi: Okay.
552 00:39:29.290 ⇒ 00:39:30.150 Atharv Gudi: Hmm.
553 00:39:31.640 ⇒ 00:39:34.390 Nicolas Sucari: That’s fine, or should happen something different.
554 00:39:34.390 ⇒ 00:39:37.220 Atharv Gudi: We think if you’ve everything else is like
555 00:39:37.700 ⇒ 00:39:39.659 Atharv Gudi: done flawlessly, then.
556 00:39:40.920 ⇒ 00:39:41.499 Nicolas Sucari: If you need.
557 00:39:41.500 ⇒ 00:39:43.860 Atharv Gudi: To check any of the
558 00:39:46.330 ⇒ 00:39:47.430 Atharv Gudi: huh? Pretty common.
559 00:39:47.430 ⇒ 00:39:49.140 Nicolas Sucari: Any of the other files.
560 00:39:50.040 ⇒ 00:39:50.790 Atharv Gudi: Yeah.
561 00:39:52.180 ⇒ 00:39:54.000 Atharv Gudi: okay. So it shouldn’t have
562 00:39:54.380 ⇒ 00:39:55.529 Atharv Gudi: unless it’s already.
563 00:39:55.530 ⇒ 00:39:59.809 Nicolas Sucari: It. It did. Yeah, no, it didn’t change anything, I think, because this one is not like.
564 00:40:00.130 ⇒ 00:40:02.690 Atharv Gudi: Can you go to the pre-commit Yaml file?
565 00:40:03.720 ⇒ 00:40:04.440 Atharv Gudi: Yep.
566 00:40:05.080 ⇒ 00:40:07.740 Atharv Gudi: yeah. Oh, the pre-commit config.
567 00:40:09.360 ⇒ 00:40:10.130 Nicolas Sucari: Yes, ma’am.
568 00:40:10.400 ⇒ 00:40:13.750 Atharv Gudi: Yeah. Thanks.
569 00:40:14.350 ⇒ 00:40:16.460 Atharv Gudi: Which dialect is it on?
570 00:40:23.980 ⇒ 00:40:26.759 Atharv Gudi: Just a minute? I think I it’s out.
571 00:40:40.730 ⇒ 00:40:41.580 Atharv Gudi: Hmm.
572 00:40:43.660 ⇒ 00:40:44.700 Atharv Gudi: okay,
573 00:40:55.670 ⇒ 00:40:56.380 Nicolas Sucari: Ray.
574 00:40:57.830 ⇒ 00:40:58.910 Atharv Gudi: We commit.
575 00:40:58.910 ⇒ 00:41:00.939 Nicolas Sucari: What, what, what should I do?
576 00:41:02.085 ⇒ 00:41:03.059 Atharv Gudi: Let me just
577 00:41:03.280 ⇒ 00:41:04.140 Atharv Gudi: check.
578 00:41:05.140 ⇒ 00:41:07.810 Atharv Gudi: What does say? Here?
579 00:41:19.770 ⇒ 00:41:21.039 Atharv Gudi: I’m just gonna
580 00:41:23.880 ⇒ 00:41:25.240 Atharv Gudi: pilots.
581 00:41:44.580 ⇒ 00:41:46.289 Atharv Gudi: Could you go back to the
582 00:41:46.420 ⇒ 00:41:48.120 Atharv Gudi: Vs code for a minute
583 00:41:50.790 ⇒ 00:41:52.939 Atharv Gudi: 3.1 point. O,
584 00:41:57.400 ⇒ 00:41:58.070 Atharv Gudi: hmm.
585 00:42:27.587 ⇒ 00:42:30.530 Atharv Gudi: can you try to run the pre-commit install again?
586 00:42:32.110 ⇒ 00:42:32.720 Nicolas Sucari: Yep.
587 00:42:41.940 ⇒ 00:42:42.840 Nicolas Sucari: the grain.
588 00:42:42.840 ⇒ 00:42:43.885 Atharv Gudi: Okay.
589 00:42:47.940 ⇒ 00:42:51.569 Nicolas Sucari: Should I try committing something else with an error? If you want.
590 00:42:52.350 ⇒ 00:42:53.190 Atharv Gudi: Because when I was.
591 00:42:53.190 ⇒ 00:42:54.790 Nicolas Sucari: Oh, probably. Okay.
592 00:42:55.633 ⇒ 00:43:00.159 Nicolas Sucari: I think I know what happened. I committed something that was already run by
593 00:43:00.280 ⇒ 00:43:05.740 Nicolas Sucari: as equals. So it has no errors. What I committed. So let’s try something different.
594 00:43:07.060 ⇒ 00:43:14.280 Nicolas Sucari: Let me go here. Go to Warehouse. And this what I’m trying to do. Select warehouse name. Let’s do
595 00:43:14.390 ⇒ 00:43:15.800 Nicolas Sucari: example. That’s
596 00:43:16.360 ⇒ 00:43:17.120 Nicolas Sucari: this
597 00:43:18.750 ⇒ 00:43:19.600 Nicolas Sucari: grey.
598 00:43:19.860 ⇒ 00:43:20.446 Atharv Gudi: Okay. I’ll.
599 00:43:21.560 ⇒ 00:43:23.829 Nicolas Sucari: Let me try committing this way.
600 00:43:32.830 ⇒ 00:43:34.620 Nicolas Sucari: Why change stage
601 00:43:36.070 ⇒ 00:43:37.170 Nicolas Sucari: change sheets.
602 00:43:41.880 ⇒ 00:43:43.630 Nicolas Sucari: social changes. Come.
603 00:43:46.160 ⇒ 00:43:47.780 Nicolas Sucari: okay, here we go.
604 00:43:48.210 ⇒ 00:43:52.689 Atharv Gudi: Okay, open oh, no! No, no, no, no.
605 00:43:53.150 ⇒ 00:43:56.060 Nicolas Sucari: Oh, sorry, do you? Wanna if I do, you want me.
606 00:43:56.357 ⇒ 00:44:00.520 Atharv Gudi: Output. Yeah, I wanted to see the command output. I think that was about
607 00:44:00.530 ⇒ 00:44:04.205 Atharv Gudi: cause it usually automatically shows you don’t have to. I mean
608 00:44:05.190 ⇒ 00:44:06.350 Atharv Gudi: I
609 00:44:07.200 ⇒ 00:44:08.310 Atharv Gudi: use
610 00:44:08.620 ⇒ 00:44:10.610 Atharv Gudi: the desktop app.
611 00:44:10.690 ⇒ 00:44:16.016 Atharv Gudi: and when I do it I just have to click on the buttons, and it just shows a message in between for you. I think.
612 00:44:16.230 ⇒ 00:44:17.619 Nicolas Sucari: Which desktop app.
613 00:44:17.890 ⇒ 00:44:19.190 Atharv Gudi: The Github desktops.
614 00:44:20.557 ⇒ 00:44:22.160 Nicolas Sucari: Okay. I have it here. Sorry.
615 00:44:22.160 ⇒ 00:44:25.309 Atharv Gudi: But even if you don’t use it, I don’t think you should.
616 00:44:26.280 ⇒ 00:44:34.342 Atharv Gudi: being convenient by that. I think if you’re if you use Github, the the Esc code. It should still work. I think you just have to use the
617 00:44:37.690 ⇒ 00:44:39.410 Atharv Gudi: Can you just try pushing it again?
618 00:44:39.530 ⇒ 00:44:40.410 Atharv Gudi: Oh, it’s.
619 00:44:41.230 ⇒ 00:44:42.240 Nicolas Sucari: Yes. Sorry.
620 00:44:42.240 ⇒ 00:44:42.850 Atharv Gudi: It auto.
621 00:44:42.850 ⇒ 00:44:44.830 Nicolas Sucari: But I need to change this one.
622 00:44:45.000 ⇒ 00:44:47.039 Atharv Gudi: Yeah, it’s that, yeah.
623 00:44:48.790 ⇒ 00:44:50.890 Nicolas Sucari: Okay, let’s do this. Let’s do these.
624 00:44:52.030 ⇒ 00:44:53.130 Nicolas Sucari: Let’s connect.
625 00:44:55.810 ⇒ 00:44:57.079 Nicolas Sucari: show, command, output.
626 00:44:57.080 ⇒ 00:44:59.350 Atharv Gudi: Open Command! Output.
627 00:45:00.790 ⇒ 00:45:02.450 Nicolas Sucari: Let’s see here if you want.
628 00:45:05.090 ⇒ 00:45:06.170 Nicolas Sucari: I don’t know.
629 00:45:06.680 ⇒ 00:45:12.170 Atharv Gudi: It won’t show it that if you haven’t, I mean, if you’ve done it on Vs code, it would have run and stopped on versus code.
630 00:45:12.170 ⇒ 00:45:13.050 Nicolas Sucari: Oh, great.
631 00:45:14.330 ⇒ 00:45:16.650 Nicolas Sucari: Okay, this is the command, output.
632 00:45:16.650 ⇒ 00:45:19.610 Atharv Gudi: Yeah, that’s the SQL Fluff
633 00:45:20.490 ⇒ 00:45:21.410 Atharv Gudi: data. So.
634 00:45:21.410 ⇒ 00:45:24.119 Nicolas Sucari: Perfect. Yeah. And it it fixed this stuff.
635 00:45:24.633 ⇒ 00:45:31.300 Atharv Gudi: It did a lot of the times. It doesn’t so I think the 3rd page of the document
636 00:45:31.600 ⇒ 00:45:35.929 Atharv Gudi: I’ve given what have I given. I think I’ve given a whole table of
637 00:45:36.170 ⇒ 00:45:38.681 Atharv Gudi: fixes how to read. So your L.
638 00:45:39.110 ⇒ 00:45:41.249 Atharv Gudi: Golden one, P.
639 00:45:41.400 ⇒ 00:45:42.740 Atharv Gudi: Blah! Blah! Blah! Blah blah!
640 00:45:43.370 ⇒ 00:45:45.229 Atharv Gudi: I’ve left it empty, cause. I’m
641 00:45:46.770 ⇒ 00:45:53.479 Atharv Gudi: i i i tried to run sequ the sequel, Fluff, on the whole pool parts to go
642 00:45:53.860 ⇒ 00:45:58.349 Atharv Gudi: repository, and it was a nightmare. It took 5 min to run, and then
643 00:45:58.800 ⇒ 00:45:59.780 Atharv Gudi: everything was an.
644 00:45:59.780 ⇒ 00:46:00.410 Nicolas Sucari: Faith.
645 00:46:01.670 ⇒ 00:46:09.449 Nicolas Sucari: Yeah, but it it was, only it was only like reviewing the sequel files, or it was reviewing everything. Probably
646 00:46:09.970 ⇒ 00:46:10.979 Nicolas Sucari: I don’t know.
647 00:46:11.580 ⇒ 00:46:13.600 Atharv Gudi: Can you repeat that I didn’t get that.
648 00:46:13.840 ⇒ 00:46:18.300 Nicolas Sucari: Like you. You run it for all of these report right.
649 00:46:18.300 ⇒ 00:46:18.960 Atharv Gudi: Yeah.
650 00:46:19.980 ⇒ 00:46:26.249 Nicolas Sucari: But it it went like SQL. Sleuth only checks the sequel files, or it checks everything.
651 00:46:26.330 ⇒ 00:46:27.930 Nicolas Sucari: Only a SQL. File, right?
652 00:46:28.190 ⇒ 00:46:34.979 Atharv Gudi: It checks whichever path you’ve given. If you want to go, do the whole repository, you can just put SQL. Fix and then pull parts to go.
653 00:46:35.220 ⇒ 00:46:36.060 Atharv Gudi: that works.
654 00:46:36.060 ⇒ 00:46:36.660 Nicolas Sucari: Okay.
655 00:46:37.030 ⇒ 00:46:37.603 Atharv Gudi: And it.
656 00:46:37.890 ⇒ 00:46:38.460 Nicolas Sucari: People.
657 00:46:38.460 ⇒ 00:46:40.500 Atharv Gudi: Every single SQL. File.
658 00:46:41.140 ⇒ 00:46:46.600 Nicolas Sucari: Okay, everything was Qfi, that’s fine. Okay, yeah, probably because we have a bunch of them that are big.
659 00:46:46.850 ⇒ 00:46:47.830 Nicolas Sucari: I don’t know.
660 00:46:50.210 ⇒ 00:46:56.169 Nicolas Sucari: Yeah, not here, but in Dbt, I think here models march, and still.
661 00:46:56.170 ⇒ 00:46:57.180 Atharv Gudi: Appreciate.
662 00:46:57.180 ⇒ 00:46:58.200 Nicolas Sucari: For this year we have.
663 00:46:58.200 ⇒ 00:46:58.870 Atharv Gudi: Adam.
664 00:46:59.090 ⇒ 00:47:01.339 Nicolas Sucari: You see here we have huge ones.
665 00:47:04.780 ⇒ 00:47:05.439 Nicolas Sucari: I don’t know.
666 00:47:05.776 ⇒ 00:47:08.800 Atharv Gudi: I didn’t get what you hang on a minute.
667 00:47:09.230 ⇒ 00:47:18.490 Nicolas Sucari: That that that probably take so long. It took so long to check all of the files, because we have, like a lot of sequel files everywhere here.
668 00:47:22.000 ⇒ 00:47:23.109 Nicolas Sucari: But that’s okay.
669 00:47:28.740 ⇒ 00:47:29.770 Nicolas Sucari: Can you hear me?
670 00:47:30.030 ⇒ 00:47:30.830 Nicolas Sucari: Hi Taylor?
671 00:47:59.440 ⇒ 00:48:01.690 Atharv Gudi: I think you should. Nico. Can you hear me?
672 00:48:02.068 ⇒ 00:48:04.719 Nicolas Sucari: Yeah. Can I hear you now? Perfect.
673 00:48:04.720 ⇒ 00:48:05.210 Atharv Gudi: Yeah.
674 00:48:06.370 ⇒ 00:48:08.309 Atharv Gudi: you were saying.
675 00:48:10.340 ⇒ 00:48:19.872 Nicolas Sucari: Yeah, don’t worry. It’s that you told me that it took so long to run it through all of the repo, and it didn’t fix everything. That’s probably because
676 00:48:20.700 ⇒ 00:48:22.639 Nicolas Sucari: we have like a lot of
677 00:48:23.030 ⇒ 00:48:33.450 Nicolas Sucari: big sequel files here in Dbt and everywhere in the in the repo. So don’t worry. I think it’s it’s it’s working. I mean, I have it. I I have it working for me right.
678 00:48:33.650 ⇒ 00:48:34.360 Atharv Gudi: Yeah.
679 00:48:35.355 ⇒ 00:48:42.520 Atharv Gudi: it’s working fine. So at this point of time, if we want to fix the bigger ones. Cause this is a pretty
680 00:48:42.650 ⇒ 00:48:46.690 Atharv Gudi: hardcore machine, and that’s being used in a lot of places.
681 00:48:46.710 ⇒ 00:48:47.790 Atharv Gudi: One.
682 00:48:47.790 ⇒ 00:48:48.130 Nicolas Sucari: Yeah.
683 00:48:48.130 ⇒ 00:48:49.529 Atharv Gudi: Way that I think
684 00:48:49.680 ⇒ 00:48:51.539 Atharv Gudi: I I could
685 00:48:51.850 ⇒ 00:49:02.419 Atharv Gudi: one way in which we need to probably expand me and Patrick and decide on it is the dot Sequ file. Currently, it has very basic, just the tab space.
686 00:49:02.420 ⇒ 00:49:03.559 Nicolas Sucari: Yeah, yeah.
687 00:49:03.560 ⇒ 00:49:05.459 Atharv Gudi: Legislation. So we wanna
688 00:49:06.030 ⇒ 00:49:07.619 Atharv Gudi: maybe amp that up a bit.
689 00:49:07.620 ⇒ 00:49:08.340 Nicolas Sucari: Useful.
690 00:49:08.630 ⇒ 00:49:09.320 Atharv Gudi: Yeah.
691 00:49:09.891 ⇒ 00:49:19.460 Atharv Gudi: and then there’s the pre commit config file that is going to be standard as long as we have the version up to date at all times and.
692 00:49:19.690 ⇒ 00:49:20.500 Nicolas Sucari: Yep.
693 00:49:21.790 ⇒ 00:49:22.510 Atharv Gudi: That the.
694 00:49:22.510 ⇒ 00:49:31.659 Nicolas Sucari: Yeah, I think that’s fine. I I totally get it. I think if we use like these, and we can add here more options and see how we want to
695 00:49:31.680 ⇒ 00:49:38.240 Nicolas Sucari: like style all of the sequel files we can keep adding here stuff. And it will.
696 00:49:38.330 ⇒ 00:49:41.159 Nicolas Sucari: it will. It will do it. Yeah, it’s great.
697 00:49:41.160 ⇒ 00:49:46.759 Atharv Gudi: And so the only 2 things are that the this dot SQL. Fluff and the dot pre commit config.
698 00:49:46.810 ⇒ 00:49:52.759 Atharv Gudi: They basically need to be copied and pasted in every single repository here and after, with, for whichever project.
699 00:49:54.010 ⇒ 00:50:03.190 Nicolas Sucari: Yeah, I think we can like if you review it with Patrick. I think we can just like add them to the repo. And then everyone has them there.
700 00:50:03.190 ⇒ 00:50:07.650 Atharv Gudi: Yeah. So once it’s added to the report, everyone has it. That’s gonna be like, fine.
701 00:50:08.375 ⇒ 00:50:08.810 Atharv Gudi: Yeah.
702 00:50:09.030 ⇒ 00:50:14.256 Atharv Gudi: Aside from that, if you don’t wanna use the. So currently with the.
703 00:50:14.630 ⇒ 00:50:15.740 Nicolas Sucari: Comedy. Yeah.
704 00:50:16.070 ⇒ 00:50:16.760 Atharv Gudi: If you don’t.
705 00:50:16.760 ⇒ 00:50:18.480 Nicolas Sucari: I know I should run this one
706 00:50:18.870 ⇒ 00:50:19.620 Nicolas Sucari: right.
707 00:50:19.870 ⇒ 00:50:20.490 Atharv Gudi: Yep.
708 00:50:24.030 ⇒ 00:50:24.540 Atharv Gudi: Okay.
709 00:50:24.540 ⇒ 00:50:26.999 Nicolas Sucari: Becoming soon installed, and this file.
710 00:50:27.410 ⇒ 00:50:31.369 Atharv Gudi: Now, if you commit, it’s gone, it’s not gonna run SQL soft. So.
711 00:50:32.790 ⇒ 00:50:33.769 Nicolas Sucari: And stride.
712 00:50:34.680 ⇒ 00:50:37.819 Nicolas Sucari: Let’s go with the one that we are using.
713 00:50:42.680 ⇒ 00:50:45.089 Nicolas Sucari: I’m doing this change because it’s pretty easy.
714 00:50:45.230 ⇒ 00:50:46.390 Nicolas Sucari: Okay, yeah.
715 00:50:47.080 ⇒ 00:50:50.150 Nicolas Sucari: do like the business code. Here.
716 00:50:50.420 ⇒ 00:50:53.950 Nicolas Sucari: let’s commit this change. Okay, you got committed. That’s fine.
717 00:50:55.860 ⇒ 00:50:57.109 Atharv Gudi: Good work. Yeah.
718 00:50:58.490 ⇒ 00:50:59.110 Nicolas Sucari: Yep.
719 00:50:59.620 ⇒ 00:51:00.420 Nicolas Sucari: okay.
720 00:51:01.580 ⇒ 00:51:03.430 Nicolas Sucari: perfect. But this is
721 00:51:03.760 ⇒ 00:51:05.009 Nicolas Sucari: this is great.
722 00:51:07.070 ⇒ 00:51:08.649 Nicolas Sucari: let me try something else.
723 00:51:08.910 ⇒ 00:51:10.979 Nicolas Sucari: Gonna start dividends here
724 00:51:13.230 ⇒ 00:51:16.169 Nicolas Sucari: just to see if everything that we did
725 00:51:16.300 ⇒ 00:51:17.749 Nicolas Sucari: doesn’t mess up
726 00:51:18.130 ⇒ 00:51:20.169 Nicolas Sucari: with what I have here.
727 00:51:28.810 ⇒ 00:51:33.110 Nicolas Sucari: I created the center of gravity reports and evidence I am. I’m seeing
728 00:51:33.120 ⇒ 00:51:37.220 Nicolas Sucari: how it looks. A table warehouse does not exist.
729 00:51:37.370 ⇒ 00:51:39.879 Nicolas Sucari: This is because I changed the name.
730 00:51:39.910 ⇒ 00:51:41.120 Nicolas Sucari: And
731 00:51:42.090 ⇒ 00:51:45.250 Nicolas Sucari: I need to run sources again. Okay.
732 00:51:45.850 ⇒ 00:51:49.620 Nicolas Sucari: okay, that’s fine. I created this map component.
733 00:51:49.620 ⇒ 00:51:52.770 Atharv Gudi: Yeah, is that an issue with the sequel Fluff or.
734 00:51:53.210 ⇒ 00:52:01.489 Nicolas Sucari: No, no, no, no, not the issue from Sequoia. And these, okay, probably this is an issue with the sequel, Fluff, because it’s changing me the name to like
735 00:52:01.670 ⇒ 00:52:04.929 Nicolas Sucari: these on caps and my source.
736 00:52:05.200 ⇒ 00:52:08.519 Nicolas Sucari: It doesn’t have caps. You see, it’s this one.
737 00:52:08.520 ⇒ 00:52:09.200 Atharv Gudi: Adam.
738 00:52:10.460 ⇒ 00:52:11.130 Atharv Gudi: so.
739 00:52:11.130 ⇒ 00:52:14.229 Nicolas Sucari: May. I don’t know if okay, let me try something
740 00:52:14.510 ⇒ 00:52:16.099 Nicolas Sucari: something different. First.st
741 00:52:16.300 ⇒ 00:52:16.830 Atharv Gudi: Practically.
742 00:52:16.830 ⇒ 00:52:17.830 Nicolas Sucari: And.
743 00:52:18.330 ⇒ 00:52:18.830 Atharv Gudi: See?
744 00:52:18.830 ⇒ 00:52:19.940 Nicolas Sucari: Non sources.
745 00:52:20.560 ⇒ 00:52:24.780 Atharv Gudi: Because we’re using Snowflake. It shouldn’t be case sensitive.
746 00:52:25.360 ⇒ 00:52:36.829 Nicolas Sucari: Yeah, yeah, that’s why i i i’m trying to see if it was an issue of physical flavor, or because I changed the name these yesterday I needed to run the sources again and let me see if these processes okay, I think we’re fine.
747 00:52:39.920 ⇒ 00:52:41.309 Nicolas Sucari: These will take like
748 00:52:41.570 ⇒ 00:52:42.910 Nicolas Sucari: 3 min. I think
749 00:52:43.320 ⇒ 00:52:44.640 Nicolas Sucari: something like that.
750 00:52:45.470 ⇒ 00:52:48.129 Nicolas Sucari: Yeah. Imagine it’s running
751 00:52:48.660 ⇒ 00:52:51.130 Nicolas Sucari: like he’s processing all of these tables.
752 00:52:51.290 ⇒ 00:52:53.040 Nicolas Sucari: All of these tables
753 00:52:53.270 ⇒ 00:52:55.480 Nicolas Sucari: we have here from Snowflake.
754 00:52:57.910 ⇒ 00:53:00.059 Nicolas Sucari: Sometimes it gets stocked.
755 00:53:01.640 ⇒ 00:53:02.940 Nicolas Sucari: Let’s hope
756 00:53:03.100 ⇒ 00:53:04.200 Nicolas Sucari: it works.
757 00:53:04.510 ⇒ 00:53:05.210 Atharv Gudi: Yeah.
758 00:53:19.690 ⇒ 00:53:21.999 Nicolas Sucari: Finished. Okay, it’s gone.
759 00:53:23.920 ⇒ 00:53:24.590 Atharv Gudi: Hmm.
760 00:53:27.940 ⇒ 00:53:29.770 Nicolas Sucari: Refund by state.
761 00:53:30.020 ⇒ 00:53:32.490 Nicolas Sucari: Okay, something is breaking here.
762 00:53:55.520 ⇒ 00:53:59.279 Nicolas Sucari: Okay, so where? How’s that? Is the one that I created. It went, okay.
763 00:54:20.460 ⇒ 00:54:25.009 Nicolas Sucari: okay, done. So this is okay. Let me just do this.
764 00:54:28.680 ⇒ 00:54:31.229 Nicolas Sucari: Okay, let’s try. Now.
765 00:54:35.360 ⇒ 00:54:36.770 Nicolas Sucari: sporting evidence.
766 00:55:11.800 ⇒ 00:55:12.460 Nicolas Sucari: Okay.
767 00:55:12.980 ⇒ 00:55:14.330 Nicolas Sucari: alert us.
768 00:55:36.850 ⇒ 00:55:45.030 Nicolas Sucari: Oh, I know what this is. Don’t worry. This has nothing to do with tickle Fluff. And this is working fine. Now I can see you see the data points here
769 00:55:45.370 ⇒ 00:55:48.040 Nicolas Sucari: that I have so perfect.
770 00:55:48.290 ⇒ 00:55:49.470 Nicolas Sucari: It’s working.
771 00:55:50.600 ⇒ 00:55:52.600 Atharv Gudi: It was the SQL. Fluff part
772 00:55:52.680 ⇒ 00:55:55.360 Atharv Gudi: is not interfering with the
773 00:55:56.260 ⇒ 00:55:58.040 Atharv Gudi: actual Dvt. Part.
774 00:55:59.480 ⇒ 00:56:00.740 Nicolas Sucari: Perfect. Now it’s
775 00:56:00.930 ⇒ 00:56:12.590 Nicolas Sucari: well, not with Dbt, neither dbt, or snowflake, or evidence, or anything. So that’s fine. It’s just like working here. So that’s how supposed to work, I think. But this is perfect.
776 00:56:12.630 ⇒ 00:56:18.700 Nicolas Sucari: Thank you, atar. I think what we need to do now like to close these SQL. Fluff.
777 00:56:19.000 ⇒ 00:56:20.420 Nicolas Sucari: A part.
778 00:56:21.313 ⇒ 00:56:22.140 Nicolas Sucari: Is like.
779 00:56:22.450 ⇒ 00:56:26.020 Nicolas Sucari: try finishing up the this document.
780 00:56:26.230 ⇒ 00:56:27.160 Atharv Gudi: Yeah.
781 00:56:27.160 ⇒ 00:56:33.510 Nicolas Sucari: With the actual, with the, with the actual steps. Try adding the 3 stuff and the python. 3. If you want.
782 00:56:33.890 ⇒ 00:56:39.650 Nicolas Sucari: Yeah. And apart from that. I think it’s pretty simple, and it’s great. So
783 00:56:39.820 ⇒ 00:56:47.539 Nicolas Sucari: probably I should. I think we should add like something that you need to have on your machine pre-installed. That is python
784 00:56:48.448 ⇒ 00:56:52.710 Nicolas Sucari: just in case. Probably it was only me, because I’ve never used python, but
785 00:56:52.760 ⇒ 00:56:55.529 Nicolas Sucari: probably it was only me. But just in case.
786 00:56:55.530 ⇒ 00:56:58.080 Atharv Gudi: Less than like an hour, so I think it should be fine.
787 00:56:58.080 ⇒ 00:56:58.520 Nicolas Sucari: A.
788 00:56:58.520 ⇒ 00:56:59.889 Atharv Gudi: Just add it.
789 00:57:00.080 ⇒ 00:57:18.070 Atharv Gudi: I think it should be fine. One thing that I think I possibly will do. I’m gonna stop the pre commit hook on my machine as well, for now. And I’m just gonna I’m not gonna edit anything. I’m not gonna try to run the Lent or anything. But I will upload the dot SQL. Fluff and the dot precon pre commit config
790 00:57:18.768 ⇒ 00:57:27.379 Atharv Gudi: for the pool part, so go repository, so the others other people can use it if they are using the linker at any given point of time.
791 00:57:28.080 ⇒ 00:57:29.350 Atharv Gudi: Perfect? Yeah.
792 00:57:29.400 ⇒ 00:57:34.580 Nicolas Sucari: And check that with Patrick. If you want. If you want to add something else there
793 00:57:35.190 ⇒ 00:57:47.609 Atharv Gudi: Need to add a lot more. I think the sequel stuff. So Patrick mentioned that I should just push it, for now keep it in the origin. I mean, it’s not gonna merge just yet, cause he needs to review it. But we all can just keep adding
794 00:57:48.150 ⇒ 00:57:54.039 Atharv Gudi: more bells and whistles onto the SQL fluff dot SQL, fluff file as and when we need them later on.
795 00:57:55.480 ⇒ 00:57:59.100 Nicolas Sucari: Okay, perfect. That’s great. I think
796 00:57:59.160 ⇒ 00:58:03.040 Nicolas Sucari: you’re okay with this one. And once we have that document with the
797 00:58:03.340 ⇒ 00:58:08.166 Nicolas Sucari: the stuff that we just discussed. I think it’s ready to show it to everyone.
798 00:58:09.380 ⇒ 00:58:14.800 Nicolas Sucari: I’m recording this meeting so I can send you the recording links if you want to review it, or anything.
799 00:58:14.800 ⇒ 00:58:19.900 Atharv Gudi: Ideally. Yes, so that I can see where what went wrong, and I can add to the document. But I think.
800 00:58:19.900 ⇒ 00:58:20.230 Nicolas Sucari: Perfect.
801 00:58:20.230 ⇒ 00:58:23.639 Atharv Gudi: If you are able to send it to me by tonight, I think I can
802 00:58:24.980 ⇒ 00:58:29.700 Atharv Gudi: pretty much finish the document tomorrow, cause there’s not much to push aside from the
803 00:58:29.800 ⇒ 00:58:32.030 Atharv Gudi: SQL. Soft and very young config.
804 00:58:32.030 ⇒ 00:58:32.940 Nicolas Sucari: Yeah, yeah, yeah.
805 00:58:33.430 ⇒ 00:58:38.430 Nicolas Sucari: But I think it will. It will give us. Yeah, it will help us a lot to have everything really
806 00:58:38.520 ⇒ 00:58:39.530 Nicolas Sucari: 3 T.
807 00:58:40.122 ⇒ 00:58:45.119 Nicolas Sucari: And organize there on the repo. So they. This is great. Thank you. Great job.
808 00:58:45.120 ⇒ 00:58:50.820 Atharv Gudi: Thing I think, that we could possibly like. Talk about on we’re meeting on Friday, right for the retro.
809 00:58:50.820 ⇒ 00:58:51.470 Nicolas Sucari: Yes.
810 00:58:51.720 ⇒ 00:59:00.320 Atharv Gudi: Yeah, maybe one interesting topic could be what we should keep as a standards, cause I know half the people use upper case. Half the people use lower case.
811 00:59:00.390 ⇒ 00:59:01.910 Atharv Gudi: It’s all here and there.
812 00:59:02.550 ⇒ 00:59:07.240 Nicolas Sucari: I mean, if everyone is using SQL soft after you finish this.
813 00:59:07.240 ⇒ 00:59:07.570 Atharv Gudi: Doesn’t.
814 00:59:07.570 ⇒ 00:59:11.010 Nicolas Sucari: Matter what everyone does, because equals Fluff will fix it right.
815 00:59:11.010 ⇒ 00:59:12.860 Atharv Gudi: Yeah, it’ll choose it.
816 00:59:12.860 ⇒ 00:59:13.580 Nicolas Sucari: So.
817 00:59:13.580 ⇒ 00:59:14.950 Atharv Gudi: Case yeah.
818 00:59:15.210 ⇒ 00:59:16.379 Atharv Gudi: should be fine.
819 00:59:16.380 ⇒ 00:59:17.060 Nicolas Sucari: But yeah.
820 00:59:17.510 ⇒ 00:59:19.210 Nicolas Sucari: got it. Okay, perfect.
821 00:59:19.210 ⇒ 00:59:20.186 Atharv Gudi: Perfect. Well, I’ll just.
822 00:59:20.991 ⇒ 00:59:38.109 Nicolas Sucari: This was. This was great. Let me know if you need something else with the dogs after you finish this dog it will, I will, I think I will send it to notion, so that we can have it there too, and we can also have it in the repo if you want, or in brain force, repo internally.
823 00:59:38.420 ⇒ 00:59:39.770 Atharv Gudi: Yes, alright!
824 00:59:40.150 ⇒ 00:59:42.869 Atharv Gudi: Alright! Bye, bye, I’ll see you on. Thanks.
825 00:59:42.870 ⇒ 00:59:43.660 Nicolas Sucari: Yeah, Darren.
826 00:59:44.200 ⇒ 00:59:45.060 Nicolas Sucari: bye-bye.