MotherDuck GA Produck Tour

0:00big data is dead we might have a lot of data but more often than not we're only using a small fraction of it just a couple terabytes no dashboard should have to read pedabytes of data performance isn't the time between hitting enter and getting query results what matters is the time between formulating a question and getting an

0:25answer what if we had a cloud data warehouse purpose-built for getting answers fast not for processing data we don't actually use that's why we built mother duck the ducking simple cloud data warehouse for analytics mother duck is now generally available let's look at this query where I'm aggregating across millions of rows to find the average distance of an Uber trip in New York

0:53City mother duck is powered by Duck DB so I get results back from the cloud in no time now I want to better understand the data in this table of Taxi [Music] rides I can profile the results in seconds using mother Duck's column Explorer here I can see the distribution of Passenger counts in the results follow-up questions are answered fast

1:20thanks to Mother Duck's dual query execution query's repurpose unused compute on my laptop to improve efficiency and performance instead of always always making a round trip to the cloud by sharing data processing between local machines and the cloud mother duck enables fast workflows and insanely interactive analytics dashboards components and applications dual execution isn't only in the browser it

1:48works anywhere I'm using

2:00questions completely free taking a look at the semantics of these queries I was able to use Easy SQL mother duck uses the world leading duck DB SQL dialect so I can skip a select statement Group by all my selected non-aggregate columns and leave my commas trailing let's use that trailing comma to add in another column here

2:30ah looks like I mistyped thankfully fix it mother Duck's AI powered SQL fixer has a suggestion for me that's what I was looking for so let's accept the change and here's my answer I can even head here to Pivot the table to split this out by

2:52date mother duck makes data easy so I can run queries wherever my data lives let's run this query to grab some context from more current data I have stored in S3 mother duck already works with all your favorite data tools from the modern duck stack making getting started a breeze mother duck is now generally available with a forever free

3:15plan and efficient compute pricing where you only pay for the CPU time you actually use down to the second check out motherducker warehouse for free

3:32what