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.
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!
Hey there! We actually covered this at 2:42 th-cam.com/video/ZX5FdqzGT1E/w-d-xo.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!
@@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 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?
@@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"
perfect video, answered all my questions in the order I had them
When you referred to the descriptions below at about 9 minutes into the video, I burst into laughter 😂 (the content is also great by the way)
nice video, good job. Thank you! Let more video with DuckDB
Thanks for that VSCode shortcut! Super useful!
Love the vibe of the tutorial, and also very insightful :D time to build the data edutainment TH-cam!
Waiting for a Ducky Streamlit tutorial on this matter 😁😁
Amazing video, it's actually helps. Thank you a lot!
Perfect video for beginners.
Thank you for sharing!
Thank you for the video, it's definitely helps me understand faster for duckdb
What an insanely great tutorial
I learned a lot, thanks !
Thanks that was helpful!
How much time does it take to load a db from disk ?
As a VIM and TMUX nerd I feel seen 🥰
how to interage the duckdb sql and cmd line?
Thanks!
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.
Great technology
Cant edit the preferences file for the keyboard shortcut. Stuck in read only mode
I was in the default file, you need the other one
Is xml files can be used?
Thank you!
sadly not, but some people are already requesting this here : github.com/duckdb/duckdb/discussions/9547
Give your vote! :)
Awesome tutorial Mehdi! ❤ (PS: You need to help me learning your video editing skills)
Thanks! Of course, my only condition is that it has to be done at the beach, on Mauritius Island.
@@mehdio um, this sounds like a class worth attending in person. can i join too?!?!?
@@ryguyrg you're all welcome ❤
How can I setup in Windows, I downloaded the .zip, only challenge is I can't use it in the cli
If you have docker installed. You can pull duckdb and you can use it inside the container.
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!
Hey there! We actually covered this at 2:42 th-cam.com/video/ZX5FdqzGT1E/w-d-xo.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!
@@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?
@@offthepathworks9171 in order to persist the data, you should .open "sample_duck.db" before creating your table and loading your csv.
@@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?
@@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"
How to Install duckdb on a Chromebook ? I did't succeed.
None of the whatnow?? 😂
*Promosm*