Tables - Create Or Update

Service:: Log Analytics

API Version:: 2025-02-01

Update or Create a Log Analytics workspace table.

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.OperationalInsights/workspaces/{workspaceName}/tables/{tableName}?api-version=2025-02-01

URI Parameters

Name	In	Required	Type	Description
resourceGroupName	path	True	string minLength: 1 maxLength: 90	The name of the resource group. The name is case insensitive.
subscriptionId	path	True	string minLength: 1	The ID of the target subscription.
tableName	path	True	string minLength: 4 maxLength: 63 pattern: ^[A-Za-z0-9-_]+$	The name of the table.
workspaceName	path	True	string minLength: 4 maxLength: 63 pattern: ^[A-Za-z0-9][A-Za-z0-9-]+[A-Za-z0-9]$	The name of the workspace.
api-version	query	True	string minLength: 1	The API version to use for this operation.

Request Body

Name	Type	Description
properties.plan	TablePlanEnum	Instruct the system how to handle and charge the logs ingested to this table.
properties.restoredLogs	RestoredLogs	Parameters of the restore operation that initiated this table.
properties.retentionInDays	integer (int32) minimum: 4 maximum: 730	The table retention in days, between 4 and 730. Setting this property to -1 will default to the workspace retention.
properties.schema	Schema	Table schema.
properties.searchResults	SearchResults	Parameters of the search job that initiated this table.
properties.totalRetentionInDays	integer (int32) minimum: 4 maximum: 4383	The table total retention in days, between 4 and 4383. Setting this property to -1 will default to table retention.

Responses

Name	Type	Description
200 OK	Table	OK response definition.
202 Accepted		Accepted response definition (Long running operation).
Other Status Codes	ErrorResponse	Error response describing why the operation failed.

Security

azure_auth

Azure Active Directory OAuth2 Flow

Type: oauth2
Flow: implicit
Authorization URL: https://login.microsoftonline.com/common/oauth2/authorize

Scopes

Name	Description
user_impersonation	impersonate your user account

Examples

TablesUpsert

PUT https://management.azure.com/subscriptions/00000000-0000-0000-0000-00000000000/resourceGroups/oiautorest6685/providers/Microsoft.OperationalInsights/workspaces/oiautorest6685/tables/AzureNetworkFlow?api-version=2025-02-01

{
  "properties": {
    "schema": {
      "name": "AzureNetworkFlow",
      "columns": [
        {
          "name": "MyNewColumn",
          "type": "guid"
        }
      ]
    },
    "retentionInDays": 45,
    "totalRetentionInDays": 70
  }
}

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.OperationalInsights.Models;
using Azure.ResourceManager.OperationalInsights;

// Generated from example definition: specification/operationalinsights/resource-manager/Microsoft.OperationalInsights/stable/2025-02-01/examples/TablesUpsert.json
// this example is just showing the usage of "Tables_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://free.blessedness.top/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this OperationalInsightsWorkspaceResource created on azure
// for more information of creating OperationalInsightsWorkspaceResource, please refer to the document of OperationalInsightsWorkspaceResource
string subscriptionId = "00000000-0000-0000-0000-00000000000";
string resourceGroupName = "oiautorest6685";
string workspaceName = "oiautorest6685";
ResourceIdentifier operationalInsightsWorkspaceResourceId = OperationalInsightsWorkspaceResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, workspaceName);
OperationalInsightsWorkspaceResource operationalInsightsWorkspace = client.GetOperationalInsightsWorkspaceResource(operationalInsightsWorkspaceResourceId);

// get the collection of this OperationalInsightsTableResource
OperationalInsightsTableCollection collection = operationalInsightsWorkspace.GetOperationalInsightsTables();

// invoke the operation
string tableName = "AzureNetworkFlow";
OperationalInsightsTableData data = new OperationalInsightsTableData
{
    RetentionInDays = 45,
    TotalRetentionInDays = 70,
    Schema = new OperationalInsightsSchema
    {
        Name = "AzureNetworkFlow",
        Columns = {new OperationalInsightsColumn
        {
        Name = "MyNewColumn",
        ColumnType = OperationalInsightsColumnType.Guid,
        }},
    },
};
ArmOperation<OperationalInsightsTableResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, tableName, data);
OperationalInsightsTableResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
OperationalInsightsTableData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "properties": {
    "schema": {
      "name": "AzureNetworkFlow",
      "tableSubType": "DataCollectionRuleBased",
      "tableType": "Microsoft",
      "columns": [
        {
          "isHidden": false,
          "name": "MyNewColumn",
          "type": "guid",
          "isDefaultDisplay": false
        }
      ],
      "standardColumns": [
        {
          "isHidden": true,
          "name": "TenantId",
          "type": "guid",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "SourceSystem",
          "type": "string",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "TimeGenerated",
          "type": "dateTime",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "AgentID",
          "type": "string",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "SourceIP",
          "type": "string",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "Protocol",
          "type": "string",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "SourcePort",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "DestinationPort",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "TcpFlags",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "Packets",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "Bytes",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "BytesOut",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "DurationInMs",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "RstCount",
          "type": "int",
          "isDefaultDisplay": false
        },
        {
          "isHidden": false,
          "name": "MaxSampleRtt",
          "type": "int",
          "isDefaultDisplay": false
        }
      ],
      "solutions": [
        "LogManagement"
      ]
    },
    "provisioningState": "Succeeded",
    "retentionInDays": 45,
    "totalRetentionInDays": 70,
    "archiveRetentionInDays": 25,
    "retentionInDaysAsDefault": false,
    "totalRetentionInDaysAsDefault": false,
    "plan": "Analytics"
  },
  "id": "/subscriptions/00000000-0000-0000-0000-00000000000/resourcegroups/oiautorest6685/providers/Microsoft.OperationalInsights/workspaces/oiautorest6685/tables/AzureNetworkFlow",
  "name": "AzureNetworkFlow"
}

Status code:: 202

azure-asyncoperation: https://management.azure.com/subscriptions/00000000-0000-0000-0000-00000000000/providers/Microsoft.OperaitonalInsights/locations/eastus/operationstatuses/62e4d893-d233-4005-988e-a428d9f77076?api-version=2025-02-01
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-00000000000/resourceGroups/oiautorest6685/providers/Microsoft.OperaitonalInsights/workspaces/oiautorest6685/tables/table1_CL/operationresults/62e4d893-d233-4005-988e-a428d9f77076?api-version=2025-02-01

Definitions

Name	Description
Column	Table column.
ColumnDataTypeHintEnum	Column data type logical hint.
ColumnTypeEnum	Column data type.
createdByType	The type of identity that created the resource.
ErrorAdditionalInfo	The resource management error additional info.
ErrorDetail	The error detail.
ErrorResponse	Error response
ProvisioningStateEnum	Table's current provisioning state. If set to 'updating', indicates a resource lock due to ongoing operation, forbidding any update to the table until the ongoing operation is concluded.
RestoredLogs	Restore parameters.
ResultStatistics	Search job execution statistics.
Schema	Table's schema.
SearchResults	Parameters of the search job that initiated this table.
SourceEnum	Table's creator.
systemData	Metadata pertaining to creation and last modification of the resource.
Table	Workspace data table definition.
TablePlanEnum	Instruct the system how to handle and charge the logs ingested to this table.
TableSubTypeEnum	The subtype describes what APIs can be used to interact with the table, and what features are available against it.
TableTypeEnum	Table's creator.

Column

Object

Table column.

Name	Type	Description
dataTypeHint	ColumnDataTypeHintEnum	Column data type logical hint.
description	string	Column description.
displayName	string	Column display name.
isDefaultDisplay	boolean	Is displayed by default.
isHidden	boolean	Is column hidden.
name	string	Column name.
type	ColumnTypeEnum	Column data type.

ColumnDataTypeHintEnum

Enumeration

Column data type logical hint.

Value	Description
uri	A string that matches the pattern of a URI, for example, scheme://username:password@host:1234/this/is/a/path?k1=v1&k2=v2#fragment
guid	A standard 128-bit GUID following the standard shape, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
armPath	An Azure Resource Model (ARM) path: /subscriptions/{...}/resourceGroups/{...}/providers/Microsoft.{...}/{...}/{...}/{...}...
ip	A standard V4/V6 ip address following the standard shape, x.x.x.x/y:y:y:y:y:y:y:y

ColumnTypeEnum

Enumeration

Column data type.

Value	Description
string
int
long
real
boolean
dateTime
guid
dynamic

createdByType

Enumeration

The type of identity that created the resource.

Value	Description
User
Application
ManagedIdentity
Key

ErrorAdditionalInfo

Object

The resource management error additional info.

Name	Type	Description
info	object	The additional info.
type	string	The additional info type.

ErrorDetail

Object

The error detail.

Name	Type	Description
additionalInfo	ErrorAdditionalInfo[]	The error additional info.
code	string	The error code.
details	ErrorDetail[]	The error details.
message	string	The error message.
target	string	The error target.

ErrorResponse

Object

Error response

Name	Type	Description
error	ErrorDetail	The error object.

ProvisioningStateEnum

Enumeration

Table's current provisioning state. If set to 'updating', indicates a resource lock due to ongoing operation, forbidding any update to the table until the ongoing operation is concluded.

Value	Description
Updating	Table schema is still being built and updated, table is currently locked for any changes till the procedure is done.
InProgress	Table schema is stable and without changes, table data is being updated.
Succeeded	Table state is stable and without changes, table is unlocked and open for new updates.
Deleting	Table state is deleting.

RestoredLogs

Object

Restore parameters.

Name	Type	Description
azureAsyncOperationId	string	Search results table async operation id.
endRestoreTime	string (date-time)	The timestamp to end the restore by (UTC).
sourceTable	string	The table to restore data from.
startRestoreTime	string (date-time)	The timestamp to start the restore from (UTC).

ResultStatistics

Object

Search job execution statistics.

Name	Type	Description
ingestedRecords	integer (int32)	The number of rows that were returned by the search job.
progress	number multipleOf: 0.01	Search job completion percentage.
scannedGb	number multipleOf: 0.01	Search job: Amount of scanned data.

Schema

Object

Table's schema.

Name	Type	Description
categories	string[]	Table category.
columns	Column[]	A list of table custom columns.
description	string	Table description.
displayName	string	Table display name.
labels	string[]	Table labels.
name	string	Table name.
solutions	string[]	List of solutions the table is affiliated with
source	SourceEnum	Table's creator.
standardColumns	Column[]	A list of table standard columns.
tableSubType	TableSubTypeEnum	The subtype describes what APIs can be used to interact with the table, and what features are available against it.
tableType	TableTypeEnum	Table's creator.

SearchResults

Object

Parameters of the search job that initiated this table.

Name	Type	Description
azureAsyncOperationId	string	Search results table async operation id.
description	string	Search job Description.
endSearchTime	string (date-time)	The timestamp to end the search by (UTC)
limit	integer (int32)	Limit the search job to return up to specified number of rows.
query	string	Search job query.
sourceTable	string	The table used in the search job.
startSearchTime	string (date-time)	The timestamp to start the search from (UTC)

SourceEnum

Enumeration

Table's creator.

Value	Description
microsoft	Tables provisioned by the system, as collected via Diagnostic Settings, the Agents, or any other standard data collection means.
customer	Tables created by the owner of the Workspace, and only found in this Workspace.

systemData

Object

Metadata pertaining to creation and last modification of the resource.

Name	Type	Description
createdAt	string (date-time)	The timestamp of resource creation (UTC).
createdBy	string	The identity that created the resource.
createdByType	createdByType	The type of identity that created the resource.
lastModifiedAt	string (date-time)	The timestamp of resource last modification (UTC)
lastModifiedBy	string	The identity that last modified the resource.
lastModifiedByType	createdByType	The type of identity that last modified the resource.

Table

Object

Workspace data table definition.

Name	Type	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties.archiveRetentionInDays	integer (int32)	The table data archive retention in days. Calculated as (totalRetentionInDays-retentionInDays)
properties.lastPlanModifiedDate	string	The timestamp that table plan was last modified (UTC).
properties.plan	TablePlanEnum	Instruct the system how to handle and charge the logs ingested to this table.
properties.provisioningState	ProvisioningStateEnum	Table's current provisioning state. If set to 'updating', indicates a resource lock due to ongoing operation, forbidding any update to the table until the ongoing operation is concluded.
properties.restoredLogs	RestoredLogs	Parameters of the restore operation that initiated this table.
properties.resultStatistics	ResultStatistics	Search job execution statistics.
properties.retentionInDays	integer (int32) minimum: 4 maximum: 730	The table retention in days, between 4 and 730. Setting this property to -1 will default to the workspace retention.
properties.retentionInDaysAsDefault	boolean	True - Value originates from workspace retention in days, False - Customer specific.
properties.schema	Schema	Table schema.
properties.searchResults	SearchResults	Parameters of the search job that initiated this table.
properties.totalRetentionInDays	integer (int32) minimum: 4 maximum: 4383	The table total retention in days, between 4 and 4383. Setting this property to -1 will default to table retention.
properties.totalRetentionInDaysAsDefault	boolean	True - Value originates from retention in days, False - Customer specific.
systemData	systemData	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

TablePlanEnum

Enumeration

Instruct the system how to handle and charge the logs ingested to this table.

Value	Description
Basic	Logs that are adjusted to support high volume low value verbose logs.
Analytics	Logs that allow monitoring and analytics.

TableSubTypeEnum

Enumeration

The subtype describes what APIs can be used to interact with the table, and what features are available against it.

Value	Description
Any	The default subtype with which built-in tables are created.
Classic	Indicates a table created through the Data Collector API or with the custom logs feature of the MMA agent, or any table against which Custom Fields were created.
DataCollectionRuleBased	A table eligible to have data sent into it via any of the means supported by Data Collection Rules: the Data Collection Endpoint API, ingestion-time transformations, or any other mechanism provided by Data Collection Rules

TableTypeEnum

Enumeration

Table's creator.

Value	Description
Microsoft	Standard data collected by Azure Monitor.
CustomLog	Custom log table.
RestoredLogs	Restored data.
SearchResults	Data collected by a search job.

Share via

Tables - Create Or Update

URI Parameters

Request Body

Responses

Security

azure_auth

Scopes

Examples

TablesUpsert

Sample request

Sample response

Definitions

Column

ColumnDataTypeHintEnum

ColumnTypeEnum

createdByType

ErrorAdditionalInfo

ErrorDetail

ErrorResponse

ProvisioningStateEnum

RestoredLogs

ResultStatistics

Schema

SearchResults

SourceEnum

systemData

Table

TablePlanEnum

TableSubTypeEnum

TableTypeEnum