Need an Alternative for cross database insert into temp tables

Hello all,

Hope you are doing good!

I work in a cross-functional team where we often deal with multiple databases to gather data, store them in a temporary table, and make the manipulations according to our business needs. When I try to do cross-database insert it fails with the following error.

Feature ‘Cross database insert select into temporary tables’ is not supported by MemSQL Distributed.

It will be really helpful if anyone can suggest a workaround/alternative for the cross-database insert.


Could you use global temporary tables? Those should allow cross-database insert…selects. They aren’t scoped to a session like a normal temporary table (so other users could query them), but they aren’t persisted just like local temp tables so you can use them to avoid that cost still.