Skip to main content

vw_contacts

Creates, updates, deletes, gets or lists a vw_contacts resource.

Overview​

Namevw_contacts
TypeView
Idazure.orbital.vw_contacts

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.reservationStartTime') as "reservation_start_time",
JSON_EXTRACT(properties, '$.reservationEndTime') as "reservation_end_time",
JSON_EXTRACT(properties, '$.rxStartTime') as "rx_start_time",
JSON_EXTRACT(properties, '$.rxEndTime') as "rx_end_time",
JSON_EXTRACT(properties, '$.txStartTime') as "tx_start_time",
JSON_EXTRACT(properties, '$.txEndTime') as "tx_end_time",
JSON_EXTRACT(properties, '$.errorMessage') as "error_message",
JSON_EXTRACT(properties, '$.maximumElevationDegrees') as "maximum_elevation_degrees",
JSON_EXTRACT(properties, '$.startAzimuthDegrees') as "start_azimuth_degrees",
JSON_EXTRACT(properties, '$.endAzimuthDegrees') as "end_azimuth_degrees",
JSON_EXTRACT(properties, '$.groundStationName') as "ground_station_name",
JSON_EXTRACT(properties, '$.startElevationDegrees') as "start_elevation_degrees",
JSON_EXTRACT(properties, '$.endElevationDegrees') as "end_elevation_degrees",
JSON_EXTRACT(properties, '$.antennaConfiguration') as "antenna_configuration",
JSON_EXTRACT(properties, '$.contactProfile') as "contact_profile",
subscriptionId,
resourceGroupName,
spacecraftName,
contactName
FROM azure.orbital.contacts
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND spacecraftName = 'replace-me';