Information on resource 'system/tap'

PVOL EPN-TAP's Table Access Protocol (TAP) service with table metadata.

Services defined within this resource descriptor

PVOL EPN-TAP TAP service
The PVOL EPN-TAP's TAP end point. The Table Access Protocol (TAP) lets you execute queries against our database tables, inspect various metadata, and upload your own data. It is thus the VO's premier way to access public data holdings.

Tables exposed through this endpoint include: columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, emptyobscore, obscore from the ivoa schema, epn_core from the pvol schema.

tap_schema.columns – queriable through TAP and ADQL
Columns in tables available for ADQL querying.
tap_schema.groups – queriable through TAP and ADQL
Columns that are part of groups within tables available for ADQL querying.
tap_schema.key_columns – queriable through TAP and ADQL
Columns participating in foreign key relationships between tables available for ADQL querying.
tap_schema.keys – queriable through TAP and ADQL
Foreign key relationships between tables available for ADQL querying.
tap_schema.schemas – queriable through TAP and ADQL
Schemas containing tables available for ADQL querying.
tap_schema.supportedmodels
Standard data models supported by this service.

This is a non-standard tap_schema table used by DaCHS in the creation of registry records. It is manipulated through gavo imp on tables with supportsModel and supportsModelURI properties.
tap_schema.tables – queriable through TAP and ADQL
Tables available for ADQL querying.
tap_schema.tapjobs
A non-standard (and not tap-accessible) table used for managing asynchronous TAP jobs. It is manipulated through TAP job creation and destruction internally. Under very special circumstances, operators can use the gavo admin cleantap command to purge jobs from this table.

Note that such jobs have corresponding directories in $STATEDIR/uwsjobs, which will be orphaned if this table is manipulated through SQL.