Skip to main content

profiles

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

Overview

Nameprofiles
TypeResource
Idazure_extras.customer_insights.profiles

Fields

The following fields are returned by SELECT queries:

OK. Successfully get the profile.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
propertiesobjectThe profile type definition.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, hubName, profileName, subscriptionIdlocale-codeGets information about the specified profile.
list_by_hubselectresourceGroupName, hubName, subscriptionIdlocale-codeGets all profile in the hub.
create_or_updateinsertresourceGroupName, hubName, profileName, subscriptionIdCreates a profile within a Hub, or updates an existing profile.
deletedeleteresourceGroupName, hubName, profileName, subscriptionIdlocale-codeDeletes a profile within a hub

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
hubNamestringThe name of the hub.
profileNamestringThe name of the profile.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
locale-codestringLocale of profile to retrieve, default is en-us.

SELECT examples

Gets information about the specified profile.

SELECT
id,
name,
properties,
type
FROM azure_extras.customer_insights.profiles
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND hubName = '{{ hubName }}' -- required
AND profileName = '{{ profileName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND locale-code = '{{ locale-code }}'
;

INSERT examples

Creates a profile within a Hub, or updates an existing profile.

INSERT INTO azure_extras.customer_insights.profiles (
data__properties,
resourceGroupName,
hubName,
profileName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ hubName }}',
'{{ profileName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

Deletes a profile within a hub

DELETE FROM azure_extras.customer_insights.profiles
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND hubName = '{{ hubName }}' --required
AND profileName = '{{ profileName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND locale-code = '{{ locale-code }}'
;