Jordan T.

Commented on Feedback on Custom SQL Function Blocks with AI for...·Posted inShow And Tell

This is really cool. Thanks for sharing!

Introducing Our New Remote MCP Server for Self-Service Analytics

Hey all, we just released our "answer machine" remote MCP server. We've been duckfooding for the last week and it feels like the closest thing to true "self-service" analytics that I've seen in my career. I wrote about this in a release blog and would love for you to try it out (feedback welcome!). Just add the mcp url as a connector in your favorite ai chatbot and you can query away from directly within Claude, Gemini or ChatGPT. blog: https://motherduck.com/blog/analytics-agents/ docs: https://motherduck.com/docs/sql-reference/mcp/

0Comments

Commented on Support for Azure Blob Storage in Motherduck Duckl...·Posted inGeneral

Jordan T.

Just wanted to chime in and say that yes, Azure blob storage support is coming to DuckDB, but also, if your query engine and your storage are in different clouds, you’re going to have a bad time. Egress costs are ~80/TB. This is probably an order of magnitude higher than you’d spend on processing. (consider BigQuery is $6/TB). This can be reasonable for one time data movement, but not recommended for your main data lake. The exception if CloudFlare R2, you can store in R2 without egress costs.

Commented on Switching from US-East-1 to EU Region: Best Practi...·Posted inGeneral

Jordan T.

Hi Timo... just wanted to chime in and say that we prioritized getting the EU region up and running first and didn't have time to build migration tooling; we also weren't certain how many people would want to migrate. We have written this doc which should hopefully help by going in a bit more detail.

Commented on Understanding MotherDuck's Position on DuckLake Sp...·Posted inGeneral

Jordan T.

Also if you're interested in DuckLake, I'm giving a talk today in Andy Pavlo's seminar series "Future Data Systems" More info here

Commented on Understanding MotherDuck's Position on DuckLake Sp...·Posted inGeneral

Jordan T.

Hi Lars! MotherDuck is very excited about DuckLake, and our goals are primarily:

1.
Help make DuckLake successful as a standard, ensure it has broad support in the industry
2.
Build the best hosted DuckLake solution, which includes adding data management, security, and governance features.
3.
Make MotherDuck the best place to run queries that are stored in DuckLake.

Some key things that are in the upcoming roadmap:

Credential Vending: Being able to provide authorized scoped access to underlying S3 files to other tools outside of MotherDuck.
File-grained Access Control: Providing row-and-column-level access control so that different users see different slices of the data.
Muti-Writer. MotherDuck users who store data in DuckLake will be able to write to the same database from multiple different user accounts (& ducklings) concurrently.
Streaming ingestion support and automatic background maintenance.

If you have more specific questions happy to answer.

Commented on Our Orchestra and motherduck launch!!!·Posted inShow And Tell

Jordan T.

Awesome, great to hear!

Commented on What's the easiest way to truncate all tables and...·Posted inAsk AI

Jordan T.

One option is to use the COPY FROM DATABASE (SCHEMA) command COPY FROM DATABASE db1 TO db2 (SCHEMA); which will copy only the schema and not the data. (not sure if this works in place or not, or whether you’d need to copy to a dummy database first)

Commented on Draft Report on Business Plan Evaluation with Clic...·Posted inGeneral

Jordan T.

Awesome, looking forward to seeing the differences. We have reshaped the instances a bit, but also duckdb has made some improvements, so it will be interesting to see the outcomes. (also IIRC we had you on XL instances most of last year which had a bit more memory than our current jumbos)

Commented on Draft Report on Business Plan Evaluation with Clic...·Posted inGeneral

Jordan T.

Hey John … this is really thorough, useful stuff. Concurrency with the tpc-ds queries was better than I had expected 🙂

About

Start Date
Title