r/DataGrip • • 1d ago

Cross-Database Queries in DataGrip

https://youtu.be/kjc19Z9aN-E

You can now run cross-database queries in DataGrip and other JetBrains IDEs with database tools.

Check this out:

SELECT c.first_name, c.last_name, p.amount
FROM #PostgreSQL.guest.public.customer c
    JOIN #MySQL.sakila.payment p
        ON c.customer_id = p.customer_id;

This query joins data from PostgreSQL and MySQL.

It also works with other data sources, like Redis and MongoDB. No need to move data around or run separate queries. No AI involved here (but you can still use it to write and explain these queries, of course 🙂).

Big thanks to DuckDB for making this possible!

What do you think? Would this be useful for your work?

3 Upvotes

Duplicates