DuckDB Tutorial For Beginners

Подписаться 3,9 тыс.

Просмотров 29 тыс.

50% 1

In this video,‪@mehdio‬ will cover all the basics to get you up and running with DuckDB by ‪@duckdb‬! Enjoy
Check out a fully production-ready end-to-end data engineering project with DuckDB!
🎥 Part 1 : • DuckDB & Python | End-...
📓 Resources
Github Repo of the tutorial : github.com/mehd-io/duckdb-pla...
DuckDB extension template (WIP) : github.com/duckdb/extension-t...
Blogs about DuckDB's file format :
duckdb.org/2022/10/28/lightwe...
duckdb.org/2022/07/27/art-sto...
➡️ Follow Us
Blog: motherduck.com/blog/
LinkedIn: h / motherduck
Twitter : / motherduck
0:00 Intro
0:19 What is DuckDB ?
0:40 Installation & Workflow
1:59 Exploring DuckDB CLI
7:20 DuckDB extensions
9:00 First analytics project
10:49 Wrap-up
#duckDB #data #dataengineering #duckdbtutorial

Опубликовано:

9 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@StasPakhomov-wj1nn 8 месяцев назад

perfect video, answered all my questions in the order I had them

@DataManMarcel Год назад

Thank you for sharing!

@cotneit Год назад

Thanks for that VSCode shortcut! Super useful!

@oleslav07 10 месяцев назад

Amazing video, it's actually helps. Thank you a lot!

@romainjouhameau2764 Год назад

I learned a lot, thanks !

@CaribouDataScience Год назад

Thanks that was helpful!

@ManticoreRoko 4 месяца назад

nice video, good job. Thank you! Let more video with DuckDB

@kresnadev Месяц назад

Thank you for the video, it's definitely helps me understand faster for duckdb

@andfanilo Год назад

Love the vibe of the tutorial, and also very insightful :D time to build the data edutainment RU-vid!

@aflous Год назад

Waiting for a Ducky Streamlit tutorial on this matter 😁😁

@alexzir Год назад

Thanks!

@robb7148 9 месяцев назад

As a VIM and TMUX nerd I feel seen 🥰

@markkinuthia6178 10 месяцев назад

How can I setup in Windows, I downloaded the .zip, only challenge is I can't use it in the cli

@valthonisprime Месяц назад

Does anyone know how to connect to SSMS using a linked server? Is it even possible? I'm trying to use duckdb as an in-between for csv files and then move them to SQL Server.

@MarcLamberti Год назад

Awesome tutorial Mehdi! ❤ (PS: You need to help me learning your video editing skills)

@mehdio Год назад

Thanks! Of course, my only condition is that it has to be done at the beach, on Mauritius Island.

@ryguyrg Год назад

@@mehdio um, this sounds like a class worth attending in person. can i join too?!?!?

@MarcLamberti Год назад

@@ryguyrg you're all welcome ❤

@U-Trance Год назад

Cant edit the preferences file for the keyboard shortcut. Stuck in read only mode

@U-Trance Год назад

I was in the default file, you need the other one

@offthepathworks9171 8 месяцев назад

Great stuff, but your tutorial (as well as duckdb website) suffers from a chicken-or-the-egg (or duck??) problem. Let's say I have a .csv file, I install duckdb on Windows. I can load a .csv file quite easily, but how do I persist it to a .db file? Most of your intro stuff doesn't mention it at all. How do I create a motherduckin' .duckdb file? Thanks!

@motherduckdb 8 месяцев назад

Hey there! We actually covered this at 2:42 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZX5FdqzGT1E.html To persist the data through a .db file, you simply need to pass a path while launching DuckDB CLI. So "duckdb mydb.db". You can then load your csv into a table. If you mention that path again, it will load the database if it exists. Hope it helps!

@offthepathworks9171 8 месяцев назад

@@motherduckdb Thanks! Sorry for my duck** yelling. So let's say I use 'duckdb' , create a table, load up my csv, use .open "sample_duck.db", that table is from then on persisted in my "sample_duck.db" file?

@motherduckdb 8 месяцев назад

@@offthepathworks9171 in order to persist the data, you should .open "sample_duck.db" before creating your table and loading your csv.

@offthepathworks9171 8 месяцев назад

@@motherduckdb Yes, that was my original point, if I just open duckdb (maybe as a naive first time user) or just wanting to get a quick check, and I load up an csv and convert it to a table I have no way to persist that data to a duck db database from within that session?

@motherduckdb 8 месяцев назад

@@offthepathworks9171 sorry, was trying to advise on best practices. yes, you can persist in-memory tables after creating them by using the 'ATTACH' syntax. Simply "ATTACH 'mydb.ddb' AS mydb" and then "CREATE TABLE mydb.mytable AS SELECT * FROM memory.mytable"