vw_iot_connector_fhir_destinations
Creates, updates, deletes, gets or lists a vw_iot_connector_fhir_destinations resource.
Overview
| Name | vw_iot_connector_fhir_destinations |
| Type | View |
| Id | azure_extras.healthcare.vw_iot_connector_fhir_destinations |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
location as location,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.resourceIdentityResolutionType') as "resource_identity_resolution_type",
JSON_EXTRACT(properties, '$.fhirServiceResourceId') as "fhir_service_resource_id",
JSON_EXTRACT(properties, '$.fhirMapping') as "fhir_mapping",
subscriptionId,
resourceGroupName,
workspaceName,
iotConnectorName,
fhirDestinationName
FROM azure_extras.healthcare.iot_connector_fhir_destinations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me' AND iotConnectorName = 'replace-me' AND fhirDestinationName = 'replace-me';
SELECT
location as location,
systemData as system_data,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.resourceIdentityResolutionType') as "resource_identity_resolution_type",
json_extract_path_text(properties, '$.fhirServiceResourceId') as "fhir_service_resource_id",
json_extract_path_text(properties, '$.fhirMapping') as "fhir_mapping",
subscriptionId,
resourceGroupName,
workspaceName,
iotConnectorName,
fhirDestinationName
FROM azure_extras.healthcare.iot_connector_fhir_destinations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me' AND iotConnectorName = 'replace-me' AND fhirDestinationName = 'replace-me';