SQL snippets - get data from another project
Hi everyone,
I'm wondering if there's a way to run snippets from one project to another.
Basically I have ProjectA in prod, and have other data that I have uploaded in ProjectB that are on a different schema (and split in a differnt way of organizing tables) so will need some transformation to populate this data into ProjectA.
So is there a way to work cross-project in the SQL Editor in my dashboard? As in duplicate a table, or fill some rows?
Or would the way to go be to either:
- replicate my ProjectB tables into ProjectA and run the SQL queries there
- or build a simple Node App that would fetch data from ProjectB, do the transformation in the app and then write into ProjectA ?
thanks !
1 Reply
One project on Supabase can't get to another as far as the sql editor goes.
You probably should consider a 3rd party database tool. This is one I use https://www.jetbrains.com/help/datagrip/exporting-and-importing-data.html but there are others.
DataGrip Help
Export and import data | DataGrip