synapsedatabase EntityType
This entity represents an external Synapse database and its associated datalake folder link.
- Entity set path:
- [organization URI]/api/data/v9.2/synapsedatabases
- Base type:
- crmbaseentity
- Display name:
- Synapse Database
- Primary key:
- synapsedatabaseid
- Primary name column:
- name
- Operations supported:
- POST GET PATCH DELETE
Properties
Properties represent fields of data stored in the entity. Some properties are read-only.
| Name | Type | Details | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| componentidunique | Edm.Guid |
For internal use only. Display name: Row id unique Read only
|
||||||||||
| componentstate | Edm.Int32 |
For internal use only. Display name: Component State Read only
Default options
|
||||||||||
| createdon | Edm.DateTimeOffset |
Date and time when the record was created. Display name: Created On Read only
|
||||||||||
| databasename | Edm.String |
Name of the Synapse database. Display name: Database Name |
||||||||||
| developmentendpoint | Edm.String |
The development endpoint for this Synapse database. Display name: DevelopmentEndpoint |
||||||||||
| importsequencenumber | Edm.Int32 |
Sequence number of the import that created this record. Display name: Import Sequence Number |
||||||||||
| iscustomizable | BooleanManagedProperty |
For internal use only. Display name: Is Customizable |
||||||||||
| ismanaged | Edm.Boolean |
Indicates whether the solution component is part of a managed solution. Display name: Is Managed Read only
Default options
|
||||||||||
| lakehouseconnectionid | Edm.Guid |
Connection Id for the Lakehouse that contains shortcuts to the table. Display name: Lakehouse Connection Id |
||||||||||
| lakehouseid | Edm.Guid |
Id for the Lakehouse that contains shortcuts to the table. Display name: Lakehouse Id |
||||||||||
| lakehouseworkspaceid | Edm.Guid |
Id for the Power BI workspace that contains the Lakehouse Display name: Lakehouse Workspace Id |
||||||||||
| modifiedon | Edm.DateTimeOffset |
Date and time when the record was modified. Display name: Modified On Read only
|
||||||||||
| name | Edm.String |
The name of the custom entity. Display name: Name |
||||||||||
| overriddencreatedon | Edm.DateTimeOffset |
Date and time that the record was migrated. Display name: Record Created On |
||||||||||
| overwritetime | Edm.DateTimeOffset |
For internal use only. Display name: Record Overwrite Time Read only
|
||||||||||
| resourcegroup | Edm.String |
Azure resource group of the Synapse database. Display name: ResourceGroup |
||||||||||
| schemaprefix | Edm.String |
Schema prefix to use for the table names Display name: Schema Prefix |
||||||||||
| serverlesssqlendpoint | Edm.String |
Serverless Sql Endpoint of the Synapse database. Display name: Serverless Sql Endpoint |
||||||||||
| solutionid | Edm.Guid |
Unique identifier of the associated solution. Display name: Solution Read only
|
||||||||||
| sparkpoolconfig | Edm.String |
Spark pool configuration Display name: Spark Pool Configuration |
||||||||||
| statecode | Edm.Int32 |
Status of the Synapse Database Display name: Status
Default options
|
||||||||||
| statuscode | Edm.Int32 |
Reason for the status of the Synapse Database Display name: Status Reason
Default options
|
||||||||||
| subscription | Edm.String |
Azure subscription for the Synapse database Display name: Subscription |
||||||||||
| synapsedatabaseid | Edm.Guid |
Unique identifier for entity instances Display name: Synapse Database |
||||||||||
| tenant | Edm.String |
Azure tenant of the Synapse database Display name: Tenant |
||||||||||
| timezoneruleversionnumber | Edm.Int32 |
For internal use only. Display name: Time Zone Rule Version Number |
||||||||||
| uniquename | Edm.String |
Unique Name for the entity. Display name: Unique Name |
||||||||||
| utcconversiontimezonecode | Edm.Int32 |
Time zone code that was in use when the record was created. Display name: UTC Conversion Time Zone Code |
||||||||||
| versionnumber | Edm.Int64 |
Version Number Display name: Version Number Read only
|
||||||||||
| workspacename | Edm.String |
Workspace name of the Synapse database. Display name: Workspace Name |
Lookup properties
Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Lookup property data.
| Name | Single-valued navigation property | Description |
|---|---|---|
| _createdby_value | createdby |
Unique identifier of the user who created the record. |
| _createdonbehalfby_value | createdonbehalfby |
Unique identifier of the delegate user who created the record. |
| _datalakefolder_value | datalakefolder |
Unique identifier for Data Lake Folder associated with Synapse Database. |
| _modifiedby_value | modifiedby |
Unique identifier of the user who modified the record. |
| _modifiedonbehalfby_value | modifiedonbehalfby |
Unique identifier of the delegate user who modified the record. |
| _ownerid_value | ownerid |
Owner Id |
| _owningbusinessunit_value | owningbusinessunit |
Unique identifier for the business unit that owns the record |
| _owningteam_value | owningteam |
Unique identifier for the team that owns the record. |
| _owninguser_value | owninguser |
Unique identifier for the user that owns the record. |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.
| Name | Type | Partner |
|---|---|---|
| createdby | systemuser | lk_synapsedatabase_createdby |
| createdonbehalfby | systemuser | lk_synapsedatabase_createdonbehalfby |
| datalakefolder | datalakefolder | synapsedatabases |
| modifiedby | systemuser | lk_synapsedatabase_modifiedby |
| modifiedonbehalfby | systemuser | lk_synapsedatabase_modifiedonbehalfby |
| ownerid | principal | owner_synapsedatabase |
| owningbusinessunit | businessunit | business_unit_synapsedatabase |
| owningteam | team | team_synapsedatabase |
| owninguser | systemuser | user_synapsedatabase |
Collection-valued navigation properties
Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.
| Name | Type | Partner |
|---|---|---|
| synapsedatabase_AsyncOperations | asyncoperation | regardingobjectid_synapsedatabase |
| synapsedatabase_BulkDeleteFailures | bulkdeletefailure | regardingobjectid_synapsedatabase |
| synapsedatabase_DuplicateBaseRecord | duplicaterecord | baserecordid_synapsedatabase |
| synapsedatabase_DuplicateMatchingRecord | duplicaterecord | duplicaterecordid_synapsedatabase |
| synapsedatabase_MailboxTrackingFolders | mailboxtrackingfolder | regardingobjectid_synapsedatabase |
| synapsedatabase_PrincipalObjectAttributeAccesses | principalobjectattributeaccess | objectid_synapsedatabase |
| synapsedatabase_ProcessSession | processsession | regardingobjectid_synapsedatabase |
| synapsedatabase_SyncErrors | syncerror | regardingobjectid_synapsedatabase |
Operations
The following operations can be used with the synapsedatabase entity type.
| Name | Binding |
|---|---|
| CreateMultiple | Not Bound |
| DeleteMultiple | Not Bound |
| GrantAccess | Not Bound |
| IsValidStateTransition | Not Bound |
| ModifyAccess | Not Bound |
| RetrievePrincipalAccess | Not Bound |
| RetrieveSharedPrincipalsAndAccess | Not Bound |
| RevokeAccess | Not Bound |
| UpdateMultiple | Not Bound |