TOPCAT - CSA Guide
TOPCAT - Tool for OPerations on Catalogues And Tables
The TOPCAT program can be used to probe the tables and views - the table names, the columns, and can also be used to run ADQL queries.
It's available at http://www.star.bris.ac.uk/~mbt/topcat/ and once installed and opened, the initial window is shown in the screenshot below:
The icon for the ADQL queries is:
and that leads to the following window where the TAP service for CSA can be entered into the text box at the bottom: https://csa.esac.esa.int/csa-sl-tap/tap
Press the 'Use Service' button to load the tables, and you will be taken to the Use Service tab:
where three sections have been highlighted:
1. the names of the tables and views - csa.v_dataset has been selected
2. the columns view will show the columns in that selected table
3. ADQL queries can be entered (note: without URL padding or encoding) into the text box - press Run Query and a table will be loaded in a separate window for viewing.