vw_fhir_services
Creates, updates, deletes, gets or lists a vw_fhir_services
resource.
Overview
Name | vw_fhir_services |
Type | View |
Id | azure_extras.healthcare.vw_fhir_services |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
identity as identity,
kind as kind,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.acrConfiguration') as "acr_configuration",
JSON_EXTRACT(properties, '$.authenticationConfiguration') as "authentication_configuration",
JSON_EXTRACT(properties, '$.corsConfiguration') as "cors_configuration",
JSON_EXTRACT(properties, '$.exportConfiguration') as "export_configuration",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.eventState') as "event_state",
JSON_EXTRACT(properties, '$.resourceVersionPolicyConfiguration') as "resource_version_policy_configuration",
JSON_EXTRACT(properties, '$.importConfiguration') as "import_configuration",
JSON_EXTRACT(properties, '$.implementationGuidesConfiguration') as "implementation_guides_configuration",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
subscriptionId,
resourceGroupName,
workspaceName,
fhirServiceName
FROM azure_extras.healthcare.fhir_services
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';
SELECT
identity as identity,
kind as kind,
systemData as system_data,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.acrConfiguration') as "acr_configuration",
json_extract_path_text(properties, '$.authenticationConfiguration') as "authentication_configuration",
json_extract_path_text(properties, '$.corsConfiguration') as "cors_configuration",
json_extract_path_text(properties, '$.exportConfiguration') as "export_configuration",
json_extract_path_text(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
json_extract_path_text(properties, '$.publicNetworkAccess') as "public_network_access",
json_extract_path_text(properties, '$.eventState') as "event_state",
json_extract_path_text(properties, '$.resourceVersionPolicyConfiguration') as "resource_version_policy_configuration",
json_extract_path_text(properties, '$.importConfiguration') as "import_configuration",
json_extract_path_text(properties, '$.implementationGuidesConfiguration') as "implementation_guides_configuration",
json_extract_path_text(properties, '$.encryption') as "encryption",
subscriptionId,
resourceGroupName,
workspaceName,
fhirServiceName
FROM azure_extras.healthcare.fhir_services
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';