|
|
1 - Instructor introduction.mp4
|
MP4
|
34.2 MB
|
|
|
10 - dbt Core vs dbt Cloud.mp4
|
MP4
|
23.2 MB
|
|
|
11 - Section overview.mp4
|
MP4
|
8.2 MB
|
|
|
12 - Creating a Gmail account.mp4
|
MP4
|
7.9 MB
|
|
|
12 - Link to Google signup page.txt
|
TXT
|
0 B
|
|
|
13 - Link to Google BigQuery.txt
|
TXT
|
0 B
|
|
|
13 - Setting up a BigQuery project with billing.mp4
|
MP4
|
19.5 MB
|
|
|
14 - Link to BigQuery UI.txt
|
TXT
|
0 B
|
|
|
14 - Link to Google Cloud Billing.txt
|
TXT
|
0 B
|
|
|
14 - Optional If you have issues with BigQuery billing.mp4
|
MP4
|
11.9 MB
|
|
|
15 - Link to BigQuery UI.txt
|
TXT
|
0 B
|
|
|
15 - The BigQuery UI.mp4
|
MP4
|
35.4 MB
|
|
|
16 - Link to the dataset well be using.txt
|
TXT
|
102.4 B
|
|
|
16 - The dataset youll be using.mp4
|
MP4
|
32.2 MB
|
|
|
17 - Link to Python 310 download page.txt
|
TXT
|
102.4 B
|
|
|
17 - Mac Installing Python 310.mp4
|
MP4
|
13.2 MB
|
|
|
18 - Link to Python 310 download page.txt
|
TXT
|
102.4 B
|
|
|
18 - Windows Installing Python 310.mp4
|
MP4
|
15.3 MB
|
|
|
18 - Windows Python install instructions.txt
|
TXT
|
102.4 B
|
|
|
19 - Downloading VSCode and setting up shortcuts.mp4
|
MP4
|
43.1 MB
|
|
|
19 - Link to VSCode download page.txt
|
TXT
|
0 B
|
|
|
19 - keybindings.json
|
JSON
|
512 B
|
|
|
19 - keyboard-shortcuts-macos.pdf
|
PDF
|
202.4 KB
|
|
|
19 - keyboard-shortcuts-windows.pdf
|
PDF
|
142.3 KB
|
|
|
2 - 1b-c.Course-outline-introduction.pdf
|
PDF
|
35.5 KB
|
|
|
2 - Course outline.mp4
|
MP4
|
30.1 MB
|
|
|
20 - Creating a GitHub account.mp4
|
MP4
|
17 MB
|
|
|
20 - Link to GitHub account creation page.txt
|
TXT
|
0 B
|
|
|
21 - 2i.Forking-vs.cloning.pdf
|
PDF
|
157.6 KB
|
|
|
21 - Forking vs cloning.mp4
|
MP4
|
22.2 MB
|
|
|
22 - Forking the repository.mp4
|
MP4
|
16.2 MB
|
|
|
22 - Link to the repository well be using for this course.txt
|
TXT
|
102.4 B
|
|
|
23 - Optional If you have issues syncing your forked repository.mp4
|
MP4
|
59.8 MB
|
|
|
24 - Installing the recommended extensions in VSCode.mp4
|
MP4
|
3.5 MB
|
|
|
25 - 2m.Whats-a-venv.pdf
|
PDF
|
124.7 KB
|
|
|
25 - Whats a virtual environment venv.mp4
|
MP4
|
25.3 MB
|
|
|
26 - Adding Python to path in Windows.txt
|
TXT
|
102.4 B
|
|
|
26 - Python guide for Windows.txt
|
TXT
|
0 B
|
|
|
26 - Setting up our virtual environment and installing packages.mp4
|
MP4
|
22.5 MB
|
|
|
27 - Link to dbt docs on BigQuery setup.txt
|
TXT
|
102.4 B
|
|
|
27 - Link to gcloud install page.txt
|
TXT
|
0 B
|
|
|
27 - Setting up dbt for BigQuery.mp4
|
MP4
|
21.6 MB
|
|
|
28 - Lesson-notes-trialling-the-model-project.pdf
|
PDF
|
70.8 KB
|
|
|
28 - Trialling our model dbt project.mp4
|
MP4
|
46.4 MB
|
|
|
29 - Link to the autocomplete repository.txt
|
TXT
|
0 B
|
|
|
29 - Setting up dbt autocomplete.mp4
|
MP4
|
22.7 MB
|
|
|
3 - Course introduction.mp4
|
MP4
|
38.5 MB
|
|
|
30 - Run through of how our final project will look.mp4
|
MP4
|
66.1 MB
|
|
|
31 - Lesson-notes-dbt-init.pdf
|
PDF
|
26.7 KB
|
|
|
31 - The dbt init command.mp4
|
MP4
|
29 MB
|
|
|
32 - Version control with GitHub.mp4
|
MP4
|
69.8 MB
|
|
|
33 - Debugging-dbt-Power-User.pdf
|
PDF
|
135.8 KB
|
|
|
33 - Setting up dbt Power User.mp4
|
MP4
|
84.5 MB
|
|
|
33 - keybindings.json
|
JSON
|
512 B
|
|
|
33 - settings.json
|
JSON
|
1.3 KB
|
|
|
34 - How well structure our project.mp4
|
MP4
|
56.1 MB
|
|
|
35 - Creating our first source src yml file.mp4
|
MP4
|
48.2 MB
|
|
|
35 - Lesson-notes-sources.pdf
|
PDF
|
39.6 KB
|
|
|
35 - Link to dbt documentation on version 2.txt
|
TXT
|
0 B
|
|
|
36 - Creating our first staging stg SQL model.mp4
|
MP4
|
73.2 MB
|
|
|
36 - Lesson-notes-our-first-SQL-model.pdf
|
PDF
|
40.8 KB
|
|
|
37 - Lesson-notes-running-our-first-SQL-file.pdf
|
PDF
|
32.3 KB
|
|
|
37 - Running our first staging stg SQL model.mp4
|
MP4
|
41.3 MB
|
|
|
38 - Creating our first model yml file.mp4
|
MP4
|
24.1 MB
|
|
|
38 - Lesson-notes-generating-our-first-model-yml-file.pdf
|
PDF
|
33.7 KB
|
|
|
39 - Adding tests to our first model yml file.mp4
|
MP4
|
79.5 MB
|
|
|
39 - Lesson-notes-adding-tests-to-our-first-model-yml-file.pdf
|
PDF
|
27 KB
|
|
|
4 - A brief history of the data stack.mp4
|
MP4
|
33.7 MB
|
|
|
40 - Lesson-notes-default-materialisation.pdf
|
PDF
|
26.2 KB
|
|
|
40 - Setting up our models to materialise as tables instead of views.mp4
|
MP4
|
48.4 MB
|
|
|
41 - Getting the rest of our staging stg SQL models set up.mp4
|
MP4
|
34.2 MB
|
|
|
42 - Link the dbt clean command.txt
|
TXT
|
0 B
|
|
|
42 - Using dbt clean to get table materialisation working.mp4
|
MP4
|
16.6 MB
|
|
|
43 - Getting the rest of the staging stg yml files set up.mp4
|
MP4
|
77.8 MB
|
|
|
43 - Lesson-notes-other-staging-yml-files.pdf
|
PDF
|
37.5 KB
|
|
|
44 - Taking stock of our staging stg data models.mp4
|
MP4
|
43 MB
|
|
|
45 - The target folder.mp4
|
MP4
|
66.3 MB
|
|
|
46 - Getting our first intermediate int SQL model set up.mp4
|
MP4
|
55 MB
|
|
|
46 - Lesson-notes-first-int-SQL-model.pdf
|
PDF
|
41.8 KB
|
|
|
47 - Getting our first intermediate int yml file set up.mp4
|
MP4
|
91.6 MB
|
|
|
47 - Lesson-notes-first-int-yml-file.pdf
|
PDF
|
34.8 KB
|
|
|
48 - Getting our mart SQL model set up.mp4
|
MP4
|
88.8 MB
|
|
|
48 - Lesson-notes-first-mart-SQL-model.pdf
|
PDF
|
55.4 KB
|
|
|
49 - Getting our mart yml file set up.mp4
|
MP4
|
56.6 MB
|
|
|
49 - Lesson-notes-first-mart-yml-file.pdf
|
PDF
|
30.2 KB
|
|
|
5 - Benefits of dbt inferring dependencies.mp4
|
MP4
|
54.5 MB
|
|
|
50 - Lesson-notes-basic-project-complete.pdf
|
PDF
|
50.1 KB
|
|
|
50 - Our basic dbt project is now complete.mp4
|
MP4
|
20.2 MB
|
|
|
51 - Lesson-notes-default-severity.pdf
|
PDF
|
30.2 KB
|
|
|
51 - Setting default test severity in dbtprojectyml.mp4
|
MP4
|
49.6 MB
|
|
|
52 - Link to dbt documentation on severity.txt
|
TXT
|
102.4 B
|
|
|
52 - Setting test severity and thresholds.mp4
|
MP4
|
107.4 MB
|
|
|
53 - Link to dbt codegen repo.txt
|
TXT
|
0 B
|
|
|
53 - Link to dbt expectations repo.txt
|
TXT
|
0 B
|
|
|
53 - Link to dbt utils repo.txt
|
TXT
|
0 B
|
|
|
53 - The external dbt packages well be using.mp4
|
MP4
|
95.8 MB
|
|
|
54 - Lesson-notes-dbt-utils-expectations.pdf
|
PDF
|
28.4 KB
|
|
|
54 - dbtutils and dbtexpectations.mp4
|
MP4
|
92.1 MB
|
|
|
55 - Custom singular tests.mp4
|
MP4
|
72.2 MB
|
|
|
55 - Lesson-notes-custom-singular-tests.pdf
|
PDF
|
35.8 KB
|
|
|
55 - Link to dbt documentation on tests.txt
|
TXT
|
0 B
|
|
|
56 - Custom generic tests.mp4
|
MP4
|
99.6 MB
|
|
|
56 - Lesson-notes-custom-generic-tests.pdf
|
PDF
|
46.2 KB
|
|
|
56 - Link to dbt documentation on custom generic tests.txt
|
TXT
|
102.4 B
|
|
|
57 - Applying advanced tests to our whole project.mp4
|
MP4
|
45.7 MB
|
|
|
57 - Lesson-notes-applying-advanced-tests-to-our-whole-project.pdf
|
PDF
|
50.5 KB
|
|
|
58 - Lesson-notes-source-freshness.pdf
|
PDF
|
27.5 KB
|
|
|
58 - Link to dbt documentation on source freshness.txt
|
TXT
|
102.4 B
|
|
|
58 - Source freshness tests.mp4
|
MP4
|
41.8 MB
|
|
|
59 - Lesson-notes-the-doc-function.pdf
|
PDF
|
34.3 KB
|
|
|
59 - Link to dbt documentation on the doc function.txt
|
TXT
|
102.4 B
|
|
|
59 - The doc function.mp4
|
MP4
|
69.4 MB
|
|
|
6 - Benefits of dbt documentation testing.mp4
|
MP4
|
52.8 MB
|
|
|
60 - Lesson-notes-seeds.pdf
|
PDF
|
33.1 KB
|
|
|
60 - Link to dbt documentation on seeds.txt
|
TXT
|
0 B
|
|
|
60 - Seed files.mp4
|
MP4
|
51.4 MB
|
|
|
61 - Lesson-notes-snapshots.pdf
|
PDF
|
37.4 KB
|
|
|
61 - Link to dbt documentation on snapshots.txt
|
TXT
|
0 B
|
|
|
61 - dbt snapshots.mp4
|
MP4
|
106 MB
|
|
|
62 - 5d.Materialisation-strategies.pdf
|
PDF
|
358.9 KB
|
|
|
62 - Link to dbt documentation on materialisations.txt
|
TXT
|
0 B
|
|
|
62 - Materialisation types.mp4
|
MP4
|
30.9 MB
|
|
|
63 - Lesson-notes-ephemeral-models.pdf
|
PDF
|
49.2 KB
|
|
|
63 - Materialisation ephemeral models.mp4
|
MP4
|
104.8 MB
|
|
|
64 - Lesson-notes-incremental-models.pdf
|
PDF
|
42.6 KB
|
|
|
64 - Link to dbt documentation on incremental models.txt
|
TXT
|
102.4 B
|
|
|
64 - Link to dbt documentation on the this function.txt
|
TXT
|
102.4 B
|
|
|
64 - Materialisation incremental models.mp4
|
MP4
|
139.1 MB
|
|
|
65 - Lesson-notes-partitioned-tables.pdf
|
PDF
|
36.4 KB
|
|
|
65 - More information on BigQuery partitioned tables.txt
|
TXT
|
102.4 B
|
|
|
65 - Optional Partitioning a table in BigQuery.mp4
|
MP4
|
43 MB
|
|
|
66 - Commands for a clean dbt run.mp4
|
MP4
|
29.4 MB
|
|
|
67 - Lesson-notes-using-different-profiles.pdf
|
PDF
|
64.3 KB
|
|
|
67 - Link to dbt documentation on profiles.txt
|
TXT
|
102.4 B
|
|
|
67 - Using different dbt profiles.mp4
|
MP4
|
39.4 MB
|
|
|
68 - Lesson-notes-selectors.pdf
|
PDF
|
40.1 KB
|
|
|
68 - Link to dbt documentation on graph operators.txt
|
TXT
|
102.4 B
|
|
|
68 - Selectors.mp4
|
MP4
|
54.9 MB
|
|
|
69 - Lesson-notes-tags.pdf
|
PDF
|
28.8 KB
|
|
|
69 - Link to dbt documentation on tags.txt
|
TXT
|
102.4 B
|
|
|
69 - Tags.mp4
|
MP4
|
22.8 MB
|
|
|
7 - Benefits of dbt Pythonlike functionality.mp4
|
MP4
|
61.3 MB
|
|
|
70 - Indirect test selection.mp4
|
MP4
|
75.1 MB
|
|
|
70 - Lesson-notes-indirect-selection.pdf
|
PDF
|
30 KB
|
|
|
70 - Link to dbt documentation on test selection.txt
|
TXT
|
102.4 B
|
|
|
71 - dbt test with warnerror.mp4
|
MP4
|
29.1 MB
|
|
|
72 - Lesson-notes-dbt-build.pdf
|
PDF
|
27.2 KB
|
|
|
72 - Link to dbt documentation on the build command.txt
|
TXT
|
0 B
|
|
|
72 - dbt build.mp4
|
MP4
|
18.7 MB
|
|
|
73 - Link to dbt documentation on docs generate serve.txt
|
TXT
|
0 B
|
|
|
73 - dbt docs generate serve.mp4
|
MP4
|
32.3 MB
|
|
|
74 - Jinja comments statements and expressions.mp4
|
MP4
|
32.3 MB
|
|
|
74 - Lesson-notes-jinja.pdf
|
PDF
|
33.1 KB
|
|
|
74 - Link to dbt documentation on jinja macros.txt
|
TXT
|
0 B
|
|
|
75 - The 3 types of macro functions hooks operations.mp4
|
MP4
|
42.8 MB
|
|
|
75 - macro-details.md
|
MD
|
1.6 KB
|
|
|
76 - Lesson-notes-jinja-function-reference.pdf
|
PDF
|
30.7 KB
|
|
|
76 - Link to inbuilt dbt jinja functions.txt
|
TXT
|
102.4 B
|
|
|
76 - Optional dbt Jinja function reference.mp4
|
MP4
|
38.6 MB
|
|
|
77 - Lesson-notes-operations.pdf
|
PDF
|
37.4 KB
|
|
|
77 - Link to dbt documentation on operations.txt
|
TXT
|
0 B
|
|
|
77 - Macros operations.mp4
|
MP4
|
104.7 MB
|
|
|
78 - Lesson-notes-functions.pdf
|
PDF
|
52.2 KB
|
|
|
78 - Link to dbt documentation on why not to nest curly brackets.txt
|
TXT
|
102.4 B
|
|
|
78 - Link to dbt documentation on why you quote column names in Jinja.txt
|
TXT
|
102.4 B
|
|
|
78 - Macros functions building a basic macro.mp4
|
MP4
|
48.8 MB
|
|
|
79 - Lesson-notes-hooks.pdf
|
PDF
|
41.1 KB
|
|
|
79 - Link to dbt documentation on hooks.txt
|
TXT
|
102.4 B
|
|
|
79 - Macros hooks.mp4
|
MP4
|
69.4 MB
|
|
|
8 - How dbt has solved a lot of problems in the data stack.mp4
|
MP4
|
24.8 MB
|
|
|
80 - Jinja statements for loops and setting variables.mp4
|
MP4
|
50.5 MB
|
|
|
80 - Lesson-notes-for-loops-and-setting-variables.pdf
|
PDF
|
38 KB
|
|
|
81 - Lesson-notes-the-target-function.pdf
|
PDF
|
49.3 KB
|
|
|
81 - Link to dbt documentation on custom schemas.txt
|
TXT
|
0 B
|
|
|
81 - Link to dbt documentation on the target function.txt
|
TXT
|
102.4 B
|
|
|
81 - Optional Jinja using the target function.mp4
|
MP4
|
47.1 MB
|
|
|
82 - Creating a dbt Cloud account.mp4
|
MP4
|
3.8 MB
|
|
|
82 - Link to dbt Cloud setup.txt
|
TXT
|
0 B
|
|
|
83 - Link to dbt documentation on BigQuery connections.txt
|
TXT
|
102.4 B
|
|
|
83 - Setting up a service account.mp4
|
MP4
|
31.9 MB
|
|
|
84 - Connecting GitHub to dbt Cloud.mp4
|
MP4
|
10.7 MB
|
|
|
85 - The dbt Cloud IDE.mp4
|
MP4
|
46.5 MB
|
|
|
86 - Deploying jobs on dbt Cloud.mp4
|
MP4
|
78.9 MB
|
|
|
86 - Link to dbt documentation on deployments.txt
|
TXT
|
0 B
|
|
|
86 - Link to dbt documentation on environment variables.txt
|
TXT
|
102.4 B
|
|
|
9 - 1d-i.Introduction-to-dbt.pdf
|
PDF
|
1.2 MB
|
|
|
9 - How dbt fits in the data stack.mp4
|
MP4
|
52.5 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
