0
$\begingroup$

I have a table of around 1700 source id's from gaiadr2 (in csv format). I would like to see the data that Gaia has for each star in a new table. I'm really struggling to figure out how to do this query, any help would be very much appreciated!

I do know that I can upload my table user_name.table1 to the Gaia archive, but how I access this in the query for crossmatching... can't seem to figure it out.

$\endgroup$
1
  • $\begingroup$ My response to this question may be of help. I literally just posted it and not going to repeat it here. $\endgroup$ Sep 30 at 18:35
0
$\begingroup$

Something along these lines might work:

select *
from gaiadr2.gaia_source as gaia
join user_name.table1 as user
  on gaia.source_id = user.source_id
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.