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:
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 ?
