vw_solutions_discoverabilities

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

Overview

Name	vw_solutions_discoverabilities
Type	View
Id	azure_extras.ag_food_platform.vw_solutions_discoverabilities

Fields

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

SQL Definition

Sqlite3

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.partnerId') as "partner_id",
JSON_EXTRACT(properties, '$.partnerTenantId') as "partner_tenant_id",
JSON_EXTRACT(properties, '$.dataAccessScopes') as "data_access_scopes",
JSON_EXTRACT(properties, '$.marketplaceOfferDetails') as "marketplace_offer_details",
JSON_EXTRACT(properties, '$.openApiSpecsDictionary') as "open_api_specs_dictionary",
JSON_EXTRACT(properties, '$.accessFBApplicationId') as "access_fb_application_id",
JSON_EXTRACT(properties, '$.saaSApplicationId') as "saa_s_application_id",
JSON_EXTRACT(properties, '$.actionIds') as "action_ids",
JSON_EXTRACT(properties, '$.roleId') as "role_id",
JSON_EXTRACT(properties, '$.roleName') as "role_name",
JSON_EXTRACT(properties, '$.accessFBApplicationName') as "access_fb_application_name",
dataManagerForAgricultureSolutionId
FROM azure_extras.ag_food_platform.solutions_discoverabilities
WHERE dataManagerForAgricultureSolutionId = 'replace-me';

Postgres

SELECT
systemData as system_data,
json_extract_path_text(properties, '$.partnerId') as "partner_id",
json_extract_path_text(properties, '$.partnerTenantId') as "partner_tenant_id",
json_extract_path_text(properties, '$.dataAccessScopes') as "data_access_scopes",
json_extract_path_text(properties, '$.marketplaceOfferDetails') as "marketplace_offer_details",
json_extract_path_text(properties, '$.openApiSpecsDictionary') as "open_api_specs_dictionary",
json_extract_path_text(properties, '$.accessFBApplicationId') as "access_fb_application_id",
json_extract_path_text(properties, '$.saaSApplicationId') as "saa_s_application_id",
json_extract_path_text(properties, '$.actionIds') as "action_ids",
json_extract_path_text(properties, '$.roleId') as "role_id",
json_extract_path_text(properties, '$.roleName') as "role_name",
json_extract_path_text(properties, '$.accessFBApplicationName') as "access_fb_application_name",
dataManagerForAgricultureSolutionId
FROM azure_extras.ag_food_platform.solutions_discoverabilities
WHERE dataManagerForAgricultureSolutionId = 'replace-me';