Skip to main content

projects

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

Overview​

Nameprojects
TypeResource
Idazure.discovery.projects

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
foundryProjectEndpointstringFoundry project endpoint URI.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringThe status of the last operation. Known values are: "Succeeded", "Failed", "Canceled", "Accepted", "Provisioning", "Updating", and "Deleting". (Succeeded, Failed, Canceled, Accepted, Provisioning, Updating, Deleting)
settingsobjectSettings for the project.
storageContainerIdsarrayAllowed StorageContainers (Control plane resource references).
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, workspace_name, project_name, subscription_idGet a Project.
list_by_workspaceselectresource_group_name, workspace_name, subscription_idList Project resources by Workspace.
create_or_updateinsertresource_group_name, workspace_name, project_name, subscription_id, locationCreate a Project.
updateupdateresource_group_name, workspace_name, project_name, subscription_id, locationUpdate a Project.
create_or_updatereplaceresource_group_name, workspace_name, project_name, subscription_id, locationCreate a Project.
deletedeleteresource_group_name, workspace_name, project_name, subscription_idDelete a Project.

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
project_namestringThe name of the Project. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
workspace_namestringThe name of the Workspace. Required.

SELECT examples​

Get a Project.

SELECT
id,
name,
foundryProjectEndpoint,
location,
provisioningState,
settings,
storageContainerIds,
systemData,
tags,
type
FROM azure.discovery.projects
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples​

Create a Project.

INSERT INTO azure.discovery.projects (
tags,
location,
properties,
resource_group_name,
workspace_name,
project_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ workspace_name }}',
'{{ project_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples​

Update a Project.

UPDATE azure.discovery.projects
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples​

Create a Project.

REPLACE azure.discovery.projects
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples​

Delete a Project.

DELETE FROM azure.discovery.projects
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;