Managed Service for ClickHouse Audit Trails Events: AddClusterShard
- Event JSON schema
- Field description
- IamAuthentication
- IamTokenInfo
- Authorization
- ResourceMetadata
- Resource
- RequestMetadata
- Status
- ShardEventDetails
- Shard
- ShardConfig
- Clickhouse
- ClickhouseConfigSet
- ClickhouseConfig
- AccessControlImprovements
- MergeTree
- Compression
- ExternalDictionary
- Structure
- Id
- Key
- Attribute
- Layout
- Range
- HttpSource
- Header
- MysqlSource
- Replica
- ClickhouseSource
- MongodbSource
- PostgresqlSource
- GraphiteRollup
- Pattern
- Retention
- Kafka
- KafkaTopic
- Rabbitmq
- QueryMaskingRule
- QueryCache
- JdbcBridge
- Macro
- Resources
- DiskSizeAutoscaling
Event JSON schema
{
"eventId": "string",
"eventSource": "string",
"eventType": "string",
"eventTime": "string",
"authentication": {
"authenticated": "boolean",
// Includes only one of the fields `subjectType`
"subjectType": "string",
// end of the list of possible fields
// Includes only one of the fields `subjectId`
"subjectId": "string",
// end of the list of possible fields
// Includes only one of the fields `subjectName`
"subjectName": "string",
// end of the list of possible fields
// Includes only one of the fields `federationId`
"federationId": "string",
// end of the list of possible fields
// Includes only one of the fields `federationName`
"federationName": "string",
// end of the list of possible fields
// Includes only one of the fields `federationType`
"federationType": "string",
// end of the list of possible fields
"tokenInfo": {
"maskedIamToken": "string",
// Includes only one of the fields `iamTokenId`
"iamTokenId": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorId`
"impersonatorId": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorType`
"impersonatorType": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorName`
"impersonatorName": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorFederationId`
"impersonatorFederationId": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorFederationName`
"impersonatorFederationName": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorFederationType`
"impersonatorFederationType": "string"
// end of the list of possible fields
}
},
"authorization": {
"authorized": "boolean"
},
"resourceMetadata": {
"path": [
{
"resourceType": "string",
"resourceId": "string",
// Includes only one of the fields `resourceName`
"resourceName": "string"
// end of the list of possible fields
}
]
},
"requestMetadata": {
"remoteAddress": "string",
"userAgent": "string",
"requestId": "string",
// Includes only one of the fields `remotePort`
"remotePort": "string"
// end of the list of possible fields
},
"eventStatus": "string",
"error": {
"code": "integer",
"message": "string",
"details": [
"object"
]
},
"details": {
"clusterId": "string",
"shardName": "string",
"shard": {
"name": "string",
"clusterId": "string",
"config": {
"clickhouse": {
"config": {
"effectiveConfig": {
"backgroundPoolSize": "string",
"backgroundMergesMutationsConcurrencyRatio": "string",
"backgroundSchedulePoolSize": "string",
"backgroundFetchesPoolSize": "string",
"backgroundMovePoolSize": "string",
"backgroundDistributedSchedulePoolSize": "string",
"backgroundBufferFlushSchedulePoolSize": "string",
"backgroundMessageBrokerSchedulePoolSize": "string",
"backgroundCommonPoolSize": "string",
"dictionariesLazyLoad": "boolean",
"logLevel": "string",
"queryLogRetentionSize": "string",
"queryLogRetentionTime": "string",
"queryThreadLogEnabled": "boolean",
"queryThreadLogRetentionSize": "string",
"queryThreadLogRetentionTime": "string",
"partLogRetentionSize": "string",
"partLogRetentionTime": "string",
"metricLogEnabled": "boolean",
"metricLogRetentionSize": "string",
"metricLogRetentionTime": "string",
"traceLogEnabled": "boolean",
"traceLogRetentionSize": "string",
"traceLogRetentionTime": "string",
"textLogEnabled": "boolean",
"textLogRetentionSize": "string",
"textLogRetentionTime": "string",
"textLogLevel": "string",
"opentelemetrySpanLogEnabled": "boolean",
"opentelemetrySpanLogRetentionSize": "string",
"opentelemetrySpanLogRetentionTime": "string",
"queryViewsLogEnabled": "boolean",
"queryViewsLogRetentionSize": "string",
"queryViewsLogRetentionTime": "string",
"asynchronousMetricLogEnabled": "boolean",
"asynchronousMetricLogRetentionSize": "string",
"asynchronousMetricLogRetentionTime": "string",
"sessionLogEnabled": "boolean",
"sessionLogRetentionSize": "string",
"sessionLogRetentionTime": "string",
"zookeeperLogEnabled": "boolean",
"zookeeperLogRetentionSize": "string",
"zookeeperLogRetentionTime": "string",
"asynchronousInsertLogEnabled": "boolean",
"asynchronousInsertLogRetentionSize": "string",
"asynchronousInsertLogRetentionTime": "string",
"processorsProfileLogEnabled": "boolean",
"processorsProfileLogRetentionSize": "string",
"processorsProfileLogRetentionTime": "string",
"errorLogEnabled": "boolean",
"errorLogRetentionSize": "string",
"errorLogRetentionTime": "string",
"queryMetricLogEnabled": "boolean",
"queryMetricLogRetentionSize": "string",
"queryMetricLogRetentionTime": "string",
"accessControlImprovements": {
"selectFromSystemDbRequiresGrant": "boolean",
"selectFromInformationSchemaRequiresGrant": "boolean"
},
"maxConnections": "string",
"maxConcurrentQueries": "string",
"maxTableSizeToDrop": "string",
"maxPartitionSizeToDrop": "string",
"keepAliveTimeout": "string",
"uncompressedCacheSize": "string",
"markCacheSize": "string",
"timezone": "string",
"geobaseEnabled": "boolean",
"geobaseUri": "string",
"defaultDatabase": "string",
"totalMemoryProfilerStep": "string",
"totalMemoryTrackerSampleProbability": "number",
"asyncInsertThreads": "string",
"backupThreads": "string",
"restoreThreads": "string",
"vectorSimilarityIndexCacheSize": "string",
"vectorSimilarityIndexCacheMaxEntries": "string",
"maxBuildVectorSimilarityIndexThreadPoolSize": "string",
"mergeTree": {
"partsToDelayInsert": "string",
"partsToThrowInsert": "string",
"inactivePartsToDelayInsert": "string",
"inactivePartsToThrowInsert": "string",
"maxAvgPartSizeForTooManyParts": "string",
"maxPartsInTotal": "string",
"maxReplicatedMergesInQueue": "string",
"numberOfFreeEntriesInPoolToLowerMaxSizeOfMerge": "string",
"numberOfFreeEntriesInPoolToExecuteMutation": "string",
"numberOfFreeEntriesInPoolToExecuteOptimizeEntirePartition": "string",
"maxBytesToMergeAtMinSpaceInPool": "string",
"maxBytesToMergeAtMaxSpaceInPool": "string",
"minBytesForWidePart": "string",
"minRowsForWidePart": "string",
"cleanupDelayPeriod": "string",
"maxCleanupDelayPeriod": "string",
"mergeSelectingSleepMs": "string",
"maxMergeSelectingSleepMs": "string",
"minAgeToForceMergeSeconds": "string",
"minAgeToForceMergeOnPartitionOnly": "boolean",
"mergeMaxBlockSize": "string",
"deduplicateMergeProjectionMode": "string",
"lightweightMutationProjectionMode": "string",
"replicatedDeduplicationWindow": "string",
"replicatedDeduplicationWindowSeconds": "string",
"fsyncAfterInsert": "boolean",
"fsyncPartDirectory": "boolean",
"minCompressedBytesToFsyncAfterFetch": "string",
"minCompressedBytesToFsyncAfterMerge": "string",
"minRowsToFsyncAfterMerge": "string",
"ttlOnlyDropParts": "boolean",
"mergeWithTtlTimeout": "string",
"mergeWithRecompressionTtlTimeout": "string",
"maxNumberOfMergesWithTtlInPool": "string",
"materializeTtlRecalculateOnly": "boolean",
"checkSampleColumnIsCorrect": "boolean",
"allowRemoteFsZeroCopyReplication": "boolean"
},
"compression": [
{
"method": "string",
"minPartSize": "string",
"minPartSizeRatio": "string",
"level": "string"
}
],
"dictionaries": [
{
"name": "string",
"structure": {
"id": {
"name": "string"
},
"key": {
"attributes": [
{
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
}
]
},
"rangeMin": {
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
},
"rangeMax": {
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
},
"attributes": [
{
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
}
]
},
"layout": {
"type": "string",
"sizeInCells": "string",
"allowReadExpiredKeys": "boolean",
"maxUpdateQueueSize": "string",
"updateQueuePushTimeoutMilliseconds": "string",
"queryWaitTimeoutMilliseconds": "string",
"maxThreadsForUpdates": "string",
"initialArraySize": "string",
"maxArraySize": "string",
"accessToKeyFromAttributes": "boolean"
},
// Includes only one of the fields `fixedLifetime`, `lifetimeRange`
"fixedLifetime": "string",
"lifetimeRange": {
"min": "string",
"max": "string"
},
// end of the list of possible fields
// Includes only one of the fields `httpSource`, `mysqlSource`, `clickhouseSource`, `mongodbSource`, `postgresqlSource`
"httpSource": {
"url": "string",
"format": "string",
"headers": [
{
"name": "string",
"value": "string"
}
]
},
"mysqlSource": {
"db": "string",
"table": "string",
"port": "string",
"user": "string",
"password": "string",
"replicas": [
{
"host": "string",
"priority": "string",
"port": "string",
"user": "string",
"password": "string"
}
],
"where": "string",
"invalidateQuery": "string",
"closeConnection": "boolean",
"shareConnection": "boolean"
},
"clickhouseSource": {
"db": "string",
"table": "string",
"host": "string",
"port": "string",
"user": "string",
"password": "string",
"where": "string",
"secure": "boolean"
},
"mongodbSource": {
"db": "string",
"collection": "string",
"host": "string",
"port": "string",
"user": "string",
"password": "string",
"options": "string"
},
"postgresqlSource": {
"db": "string",
"table": "string",
"hosts": [
"string"
],
"port": "string",
"user": "string",
"password": "string",
"invalidateQuery": "string",
"sslMode": "string"
}
// end of the list of possible fields
}
],
"graphiteRollup": [
{
"name": "string",
"patterns": [
{
"regexp": "string",
"function": "string",
"retention": [
{
"age": "string",
"precision": "string"
}
]
}
],
"pathColumnName": "string",
"timeColumnName": "string",
"valueColumnName": "string",
"versionColumnName": "string"
}
],
"kafka": {
"securityProtocol": "string",
"saslMechanism": "string",
"saslUsername": "string",
"saslPassword": "string",
"enableSslCertificateVerification": "boolean",
"maxPollIntervalMs": "string",
"sessionTimeoutMs": "string",
"debug": "string",
"autoOffsetReset": "string",
"messageMaxBytes": "string",
"batchSize": "string"
},
"kafkaTopics": [
{
"name": "string",
"settings": {
"securityProtocol": "string",
"saslMechanism": "string",
"saslUsername": "string",
"saslPassword": "string",
"enableSslCertificateVerification": "boolean",
"maxPollIntervalMs": "string",
"sessionTimeoutMs": "string",
"debug": "string",
"autoOffsetReset": "string",
"messageMaxBytes": "string",
"batchSize": "string"
}
}
],
"rabbitmq": {
"username": "string",
"password": "string",
"vhost": "string"
},
"queryMaskingRules": [
{
"name": "string",
"regexp": "string",
"replace": "string"
}
],
"queryCache": {
"maxSizeInBytes": "string",
"maxEntries": "string",
"maxEntrySizeInBytes": "string",
"maxEntrySizeInRows": "string"
},
"jdbcBridge": {
"host": "string",
"port": "string"
},
"mysqlProtocol": "boolean",
"customMacros": [
{
"name": "string",
"value": "string"
}
],
"builtinDictionariesReloadInterval": "string"
},
"userConfig": {
"backgroundPoolSize": "string",
"backgroundMergesMutationsConcurrencyRatio": "string",
"backgroundSchedulePoolSize": "string",
"backgroundFetchesPoolSize": "string",
"backgroundMovePoolSize": "string",
"backgroundDistributedSchedulePoolSize": "string",
"backgroundBufferFlushSchedulePoolSize": "string",
"backgroundMessageBrokerSchedulePoolSize": "string",
"backgroundCommonPoolSize": "string",
"dictionariesLazyLoad": "boolean",
"logLevel": "string",
"queryLogRetentionSize": "string",
"queryLogRetentionTime": "string",
"queryThreadLogEnabled": "boolean",
"queryThreadLogRetentionSize": "string",
"queryThreadLogRetentionTime": "string",
"partLogRetentionSize": "string",
"partLogRetentionTime": "string",
"metricLogEnabled": "boolean",
"metricLogRetentionSize": "string",
"metricLogRetentionTime": "string",
"traceLogEnabled": "boolean",
"traceLogRetentionSize": "string",
"traceLogRetentionTime": "string",
"textLogEnabled": "boolean",
"textLogRetentionSize": "string",
"textLogRetentionTime": "string",
"textLogLevel": "string",
"opentelemetrySpanLogEnabled": "boolean",
"opentelemetrySpanLogRetentionSize": "string",
"opentelemetrySpanLogRetentionTime": "string",
"queryViewsLogEnabled": "boolean",
"queryViewsLogRetentionSize": "string",
"queryViewsLogRetentionTime": "string",
"asynchronousMetricLogEnabled": "boolean",
"asynchronousMetricLogRetentionSize": "string",
"asynchronousMetricLogRetentionTime": "string",
"sessionLogEnabled": "boolean",
"sessionLogRetentionSize": "string",
"sessionLogRetentionTime": "string",
"zookeeperLogEnabled": "boolean",
"zookeeperLogRetentionSize": "string",
"zookeeperLogRetentionTime": "string",
"asynchronousInsertLogEnabled": "boolean",
"asynchronousInsertLogRetentionSize": "string",
"asynchronousInsertLogRetentionTime": "string",
"processorsProfileLogEnabled": "boolean",
"processorsProfileLogRetentionSize": "string",
"processorsProfileLogRetentionTime": "string",
"errorLogEnabled": "boolean",
"errorLogRetentionSize": "string",
"errorLogRetentionTime": "string",
"queryMetricLogEnabled": "boolean",
"queryMetricLogRetentionSize": "string",
"queryMetricLogRetentionTime": "string",
"accessControlImprovements": {
"selectFromSystemDbRequiresGrant": "boolean",
"selectFromInformationSchemaRequiresGrant": "boolean"
},
"maxConnections": "string",
"maxConcurrentQueries": "string",
"maxTableSizeToDrop": "string",
"maxPartitionSizeToDrop": "string",
"keepAliveTimeout": "string",
"uncompressedCacheSize": "string",
"markCacheSize": "string",
"timezone": "string",
"geobaseEnabled": "boolean",
"geobaseUri": "string",
"defaultDatabase": "string",
"totalMemoryProfilerStep": "string",
"totalMemoryTrackerSampleProbability": "number",
"asyncInsertThreads": "string",
"backupThreads": "string",
"restoreThreads": "string",
"vectorSimilarityIndexCacheSize": "string",
"vectorSimilarityIndexCacheMaxEntries": "string",
"maxBuildVectorSimilarityIndexThreadPoolSize": "string",
"mergeTree": {
"partsToDelayInsert": "string",
"partsToThrowInsert": "string",
"inactivePartsToDelayInsert": "string",
"inactivePartsToThrowInsert": "string",
"maxAvgPartSizeForTooManyParts": "string",
"maxPartsInTotal": "string",
"maxReplicatedMergesInQueue": "string",
"numberOfFreeEntriesInPoolToLowerMaxSizeOfMerge": "string",
"numberOfFreeEntriesInPoolToExecuteMutation": "string",
"numberOfFreeEntriesInPoolToExecuteOptimizeEntirePartition": "string",
"maxBytesToMergeAtMinSpaceInPool": "string",
"maxBytesToMergeAtMaxSpaceInPool": "string",
"minBytesForWidePart": "string",
"minRowsForWidePart": "string",
"cleanupDelayPeriod": "string",
"maxCleanupDelayPeriod": "string",
"mergeSelectingSleepMs": "string",
"maxMergeSelectingSleepMs": "string",
"minAgeToForceMergeSeconds": "string",
"minAgeToForceMergeOnPartitionOnly": "boolean",
"mergeMaxBlockSize": "string",
"deduplicateMergeProjectionMode": "string",
"lightweightMutationProjectionMode": "string",
"replicatedDeduplicationWindow": "string",
"replicatedDeduplicationWindowSeconds": "string",
"fsyncAfterInsert": "boolean",
"fsyncPartDirectory": "boolean",
"minCompressedBytesToFsyncAfterFetch": "string",
"minCompressedBytesToFsyncAfterMerge": "string",
"minRowsToFsyncAfterMerge": "string",
"ttlOnlyDropParts": "boolean",
"mergeWithTtlTimeout": "string",
"mergeWithRecompressionTtlTimeout": "string",
"maxNumberOfMergesWithTtlInPool": "string",
"materializeTtlRecalculateOnly": "boolean",
"checkSampleColumnIsCorrect": "boolean",
"allowRemoteFsZeroCopyReplication": "boolean"
},
"compression": [
{
"method": "string",
"minPartSize": "string",
"minPartSizeRatio": "string",
"level": "string"
}
],
"dictionaries": [
{
"name": "string",
"structure": {
"id": {
"name": "string"
},
"key": {
"attributes": [
{
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
}
]
},
"rangeMin": {
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
},
"rangeMax": {
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
},
"attributes": [
{
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
}
]
},
"layout": {
"type": "string",
"sizeInCells": "string",
"allowReadExpiredKeys": "boolean",
"maxUpdateQueueSize": "string",
"updateQueuePushTimeoutMilliseconds": "string",
"queryWaitTimeoutMilliseconds": "string",
"maxThreadsForUpdates": "string",
"initialArraySize": "string",
"maxArraySize": "string",
"accessToKeyFromAttributes": "boolean"
},
// Includes only one of the fields `fixedLifetime`, `lifetimeRange`
"fixedLifetime": "string",
"lifetimeRange": {
"min": "string",
"max": "string"
},
// end of the list of possible fields
// Includes only one of the fields `httpSource`, `mysqlSource`, `clickhouseSource`, `mongodbSource`, `postgresqlSource`
"httpSource": {
"url": "string",
"format": "string",
"headers": [
{
"name": "string",
"value": "string"
}
]
},
"mysqlSource": {
"db": "string",
"table": "string",
"port": "string",
"user": "string",
"password": "string",
"replicas": [
{
"host": "string",
"priority": "string",
"port": "string",
"user": "string",
"password": "string"
}
],
"where": "string",
"invalidateQuery": "string",
"closeConnection": "boolean",
"shareConnection": "boolean"
},
"clickhouseSource": {
"db": "string",
"table": "string",
"host": "string",
"port": "string",
"user": "string",
"password": "string",
"where": "string",
"secure": "boolean"
},
"mongodbSource": {
"db": "string",
"collection": "string",
"host": "string",
"port": "string",
"user": "string",
"password": "string",
"options": "string"
},
"postgresqlSource": {
"db": "string",
"table": "string",
"hosts": [
"string"
],
"port": "string",
"user": "string",
"password": "string",
"invalidateQuery": "string",
"sslMode": "string"
}
// end of the list of possible fields
}
],
"graphiteRollup": [
{
"name": "string",
"patterns": [
{
"regexp": "string",
"function": "string",
"retention": [
{
"age": "string",
"precision": "string"
}
]
}
],
"pathColumnName": "string",
"timeColumnName": "string",
"valueColumnName": "string",
"versionColumnName": "string"
}
],
"kafka": {
"securityProtocol": "string",
"saslMechanism": "string",
"saslUsername": "string",
"saslPassword": "string",
"enableSslCertificateVerification": "boolean",
"maxPollIntervalMs": "string",
"sessionTimeoutMs": "string",
"debug": "string",
"autoOffsetReset": "string",
"messageMaxBytes": "string",
"batchSize": "string"
},
"kafkaTopics": [
{
"name": "string",
"settings": {
"securityProtocol": "string",
"saslMechanism": "string",
"saslUsername": "string",
"saslPassword": "string",
"enableSslCertificateVerification": "boolean",
"maxPollIntervalMs": "string",
"sessionTimeoutMs": "string",
"debug": "string",
"autoOffsetReset": "string",
"messageMaxBytes": "string",
"batchSize": "string"
}
}
],
"rabbitmq": {
"username": "string",
"password": "string",
"vhost": "string"
},
"queryMaskingRules": [
{
"name": "string",
"regexp": "string",
"replace": "string"
}
],
"queryCache": {
"maxSizeInBytes": "string",
"maxEntries": "string",
"maxEntrySizeInBytes": "string",
"maxEntrySizeInRows": "string"
},
"jdbcBridge": {
"host": "string",
"port": "string"
},
"mysqlProtocol": "boolean",
"customMacros": [
{
"name": "string",
"value": "string"
}
],
"builtinDictionariesReloadInterval": "string"
},
"defaultConfig": {
"backgroundPoolSize": "string",
"backgroundMergesMutationsConcurrencyRatio": "string",
"backgroundSchedulePoolSize": "string",
"backgroundFetchesPoolSize": "string",
"backgroundMovePoolSize": "string",
"backgroundDistributedSchedulePoolSize": "string",
"backgroundBufferFlushSchedulePoolSize": "string",
"backgroundMessageBrokerSchedulePoolSize": "string",
"backgroundCommonPoolSize": "string",
"dictionariesLazyLoad": "boolean",
"logLevel": "string",
"queryLogRetentionSize": "string",
"queryLogRetentionTime": "string",
"queryThreadLogEnabled": "boolean",
"queryThreadLogRetentionSize": "string",
"queryThreadLogRetentionTime": "string",
"partLogRetentionSize": "string",
"partLogRetentionTime": "string",
"metricLogEnabled": "boolean",
"metricLogRetentionSize": "string",
"metricLogRetentionTime": "string",
"traceLogEnabled": "boolean",
"traceLogRetentionSize": "string",
"traceLogRetentionTime": "string",
"textLogEnabled": "boolean",
"textLogRetentionSize": "string",
"textLogRetentionTime": "string",
"textLogLevel": "string",
"opentelemetrySpanLogEnabled": "boolean",
"opentelemetrySpanLogRetentionSize": "string",
"opentelemetrySpanLogRetentionTime": "string",
"queryViewsLogEnabled": "boolean",
"queryViewsLogRetentionSize": "string",
"queryViewsLogRetentionTime": "string",
"asynchronousMetricLogEnabled": "boolean",
"asynchronousMetricLogRetentionSize": "string",
"asynchronousMetricLogRetentionTime": "string",
"sessionLogEnabled": "boolean",
"sessionLogRetentionSize": "string",
"sessionLogRetentionTime": "string",
"zookeeperLogEnabled": "boolean",
"zookeeperLogRetentionSize": "string",
"zookeeperLogRetentionTime": "string",
"asynchronousInsertLogEnabled": "boolean",
"asynchronousInsertLogRetentionSize": "string",
"asynchronousInsertLogRetentionTime": "string",
"processorsProfileLogEnabled": "boolean",
"processorsProfileLogRetentionSize": "string",
"processorsProfileLogRetentionTime": "string",
"errorLogEnabled": "boolean",
"errorLogRetentionSize": "string",
"errorLogRetentionTime": "string",
"queryMetricLogEnabled": "boolean",
"queryMetricLogRetentionSize": "string",
"queryMetricLogRetentionTime": "string",
"accessControlImprovements": {
"selectFromSystemDbRequiresGrant": "boolean",
"selectFromInformationSchemaRequiresGrant": "boolean"
},
"maxConnections": "string",
"maxConcurrentQueries": "string",
"maxTableSizeToDrop": "string",
"maxPartitionSizeToDrop": "string",
"keepAliveTimeout": "string",
"uncompressedCacheSize": "string",
"markCacheSize": "string",
"timezone": "string",
"geobaseEnabled": "boolean",
"geobaseUri": "string",
"defaultDatabase": "string",
"totalMemoryProfilerStep": "string",
"totalMemoryTrackerSampleProbability": "number",
"asyncInsertThreads": "string",
"backupThreads": "string",
"restoreThreads": "string",
"vectorSimilarityIndexCacheSize": "string",
"vectorSimilarityIndexCacheMaxEntries": "string",
"maxBuildVectorSimilarityIndexThreadPoolSize": "string",
"mergeTree": {
"partsToDelayInsert": "string",
"partsToThrowInsert": "string",
"inactivePartsToDelayInsert": "string",
"inactivePartsToThrowInsert": "string",
"maxAvgPartSizeForTooManyParts": "string",
"maxPartsInTotal": "string",
"maxReplicatedMergesInQueue": "string",
"numberOfFreeEntriesInPoolToLowerMaxSizeOfMerge": "string",
"numberOfFreeEntriesInPoolToExecuteMutation": "string",
"numberOfFreeEntriesInPoolToExecuteOptimizeEntirePartition": "string",
"maxBytesToMergeAtMinSpaceInPool": "string",
"maxBytesToMergeAtMaxSpaceInPool": "string",
"minBytesForWidePart": "string",
"minRowsForWidePart": "string",
"cleanupDelayPeriod": "string",
"maxCleanupDelayPeriod": "string",
"mergeSelectingSleepMs": "string",
"maxMergeSelectingSleepMs": "string",
"minAgeToForceMergeSeconds": "string",
"minAgeToForceMergeOnPartitionOnly": "boolean",
"mergeMaxBlockSize": "string",
"deduplicateMergeProjectionMode": "string",
"lightweightMutationProjectionMode": "string",
"replicatedDeduplicationWindow": "string",
"replicatedDeduplicationWindowSeconds": "string",
"fsyncAfterInsert": "boolean",
"fsyncPartDirectory": "boolean",
"minCompressedBytesToFsyncAfterFetch": "string",
"minCompressedBytesToFsyncAfterMerge": "string",
"minRowsToFsyncAfterMerge": "string",
"ttlOnlyDropParts": "boolean",
"mergeWithTtlTimeout": "string",
"mergeWithRecompressionTtlTimeout": "string",
"maxNumberOfMergesWithTtlInPool": "string",
"materializeTtlRecalculateOnly": "boolean",
"checkSampleColumnIsCorrect": "boolean",
"allowRemoteFsZeroCopyReplication": "boolean"
},
"compression": [
{
"method": "string",
"minPartSize": "string",
"minPartSizeRatio": "string",
"level": "string"
}
],
"dictionaries": [
{
"name": "string",
"structure": {
"id": {
"name": "string"
},
"key": {
"attributes": [
{
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
}
]
},
"rangeMin": {
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
},
"rangeMax": {
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
},
"attributes": [
{
"name": "string",
"type": "string",
"nullValue": "string",
"expression": "string",
"hierarchical": "boolean",
"injective": "boolean"
}
]
},
"layout": {
"type": "string",
"sizeInCells": "string",
"allowReadExpiredKeys": "boolean",
"maxUpdateQueueSize": "string",
"updateQueuePushTimeoutMilliseconds": "string",
"queryWaitTimeoutMilliseconds": "string",
"maxThreadsForUpdates": "string",
"initialArraySize": "string",
"maxArraySize": "string",
"accessToKeyFromAttributes": "boolean"
},
// Includes only one of the fields `fixedLifetime`, `lifetimeRange`
"fixedLifetime": "string",
"lifetimeRange": {
"min": "string",
"max": "string"
},
// end of the list of possible fields
// Includes only one of the fields `httpSource`, `mysqlSource`, `clickhouseSource`, `mongodbSource`, `postgresqlSource`
"httpSource": {
"url": "string",
"format": "string",
"headers": [
{
"name": "string",
"value": "string"
}
]
},
"mysqlSource": {
"db": "string",
"table": "string",
"port": "string",
"user": "string",
"password": "string",
"replicas": [
{
"host": "string",
"priority": "string",
"port": "string",
"user": "string",
"password": "string"
}
],
"where": "string",
"invalidateQuery": "string",
"closeConnection": "boolean",
"shareConnection": "boolean"
},
"clickhouseSource": {
"db": "string",
"table": "string",
"host": "string",
"port": "string",
"user": "string",
"password": "string",
"where": "string",
"secure": "boolean"
},
"mongodbSource": {
"db": "string",
"collection": "string",
"host": "string",
"port": "string",
"user": "string",
"password": "string",
"options": "string"
},
"postgresqlSource": {
"db": "string",
"table": "string",
"hosts": [
"string"
],
"port": "string",
"user": "string",
"password": "string",
"invalidateQuery": "string",
"sslMode": "string"
}
// end of the list of possible fields
}
],
"graphiteRollup": [
{
"name": "string",
"patterns": [
{
"regexp": "string",
"function": "string",
"retention": [
{
"age": "string",
"precision": "string"
}
]
}
],
"pathColumnName": "string",
"timeColumnName": "string",
"valueColumnName": "string",
"versionColumnName": "string"
}
],
"kafka": {
"securityProtocol": "string",
"saslMechanism": "string",
"saslUsername": "string",
"saslPassword": "string",
"enableSslCertificateVerification": "boolean",
"maxPollIntervalMs": "string",
"sessionTimeoutMs": "string",
"debug": "string",
"autoOffsetReset": "string",
"messageMaxBytes": "string",
"batchSize": "string"
},
"kafkaTopics": [
{
"name": "string",
"settings": {
"securityProtocol": "string",
"saslMechanism": "string",
"saslUsername": "string",
"saslPassword": "string",
"enableSslCertificateVerification": "boolean",
"maxPollIntervalMs": "string",
"sessionTimeoutMs": "string",
"debug": "string",
"autoOffsetReset": "string",
"messageMaxBytes": "string",
"batchSize": "string"
}
}
],
"rabbitmq": {
"username": "string",
"password": "string",
"vhost": "string"
},
"queryMaskingRules": [
{
"name": "string",
"regexp": "string",
"replace": "string"
}
],
"queryCache": {
"maxSizeInBytes": "string",
"maxEntries": "string",
"maxEntrySizeInBytes": "string",
"maxEntrySizeInRows": "string"
},
"jdbcBridge": {
"host": "string",
"port": "string"
},
"mysqlProtocol": "boolean",
"customMacros": [
{
"name": "string",
"value": "string"
}
],
"builtinDictionariesReloadInterval": "string"
}
},
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
},
"weight": "string",
"diskSizeAutoscaling": {
"plannedUsageThreshold": "string",
"emergencyUsageThreshold": "string",
"diskSizeLimit": "string"
}
}
}
},
"clusterName": "string"
},
"requestParameters": "object",
"response": "object"
}
Field description
|
Field |
Description |
|
eventId |
string |
|
eventSource |
string |
|
eventType |
string |
|
eventTime |
string (date-time) String in RFC3339 To work with values in this field, use the APIs described in the |
|
authentication |
|
|
authorization |
|
|
resourceMetadata |
|
|
requestMetadata |
|
|
eventStatus |
enum (EventStatus)
|
|
error |
The error result of the operation in case of failure or cancellation. |
|
details |
|
|
requestParameters |
object |
|
response |
object |
IamAuthentication
|
Field |
Description |
|
authenticated |
boolean |
|
subjectType |
enum (IamSubjectType) Includes only one of the fields
|
|
subjectId |
string Includes only one of the fields |
|
subjectName |
string Includes only one of the fields |
|
federationId |
string Includes only one of the fields |
|
federationName |
string Includes only one of the fields |
|
federationType |
enum (FederationType) Includes only one of the fields
|
|
tokenInfo |
IamTokenInfo
|
Field |
Description |
|
maskedIamToken |
string |
|
iamTokenId |
string Includes only one of the fields |
|
impersonatorId |
string Includes only one of the fields |
|
impersonatorType |
enum (IamSubjectType) Includes only one of the fields
|
|
impersonatorName |
string Includes only one of the fields |
|
impersonatorFederationId |
string Includes only one of the fields |
|
impersonatorFederationName |
string Includes only one of the fields |
|
impersonatorFederationType |
enum (FederationType) Includes only one of the fields
|
Authorization
|
Field |
Description |
|
authorized |
boolean |
ResourceMetadata
|
Field |
Description |
|
path[] |
Resource
|
Field |
Description |
|
resourceType |
string |
|
resourceId |
string |
|
resourceName |
string Includes only one of the fields |
RequestMetadata
|
Field |
Description |
|
remoteAddress |
string |
|
userAgent |
string |
|
requestId |
string |
|
remotePort |
string (int64) Includes only one of the fields |
Status
The error result of the operation in case of failure or cancellation.
|
Field |
Description |
|
code |
integer (int32) Error code. An enum value of google.rpc.Code |
|
message |
string An error message. |
|
details[] |
object A list of messages that carry the error details. |
ShardEventDetails
|
Field |
Description |
|
clusterId |
string |
|
shardName |
string |
|
shard |
|
|
clusterName |
string |
Shard
|
Field |
Description |
|
name |
string |
|
clusterId |
string |
|
config |
ShardConfig
|
Field |
Description |
|
clickhouse |
Clickhouse
|
Field |
Description |
|
config |
|
|
resources |
|
|
weight |
string (int64) |
|
diskSizeAutoscaling |
ClickhouseConfigSet
|
Field |
Description |
|
effectiveConfig |
|
|
userConfig |
|
|
defaultConfig |
ClickhouseConfig
|
Field |
Description |
|
backgroundPoolSize |
string (int64) The minimum value is 1. |
|
backgroundMergesMutationsConcurrencyRatio |
string (int64) |
|
backgroundSchedulePoolSize |
string (int64) The minimum value is 1. |
|
backgroundFetchesPoolSize |
string (int64) The minimum value is 1. |
|
backgroundMovePoolSize |
string (int64) The minimum value is 1. |
|
backgroundDistributedSchedulePoolSize |
string (int64) The minimum value is 1. |
|
backgroundBufferFlushSchedulePoolSize |
string (int64) The minimum value is 1. |
|
backgroundMessageBrokerSchedulePoolSize |
string (int64) The minimum value is 1. |
|
backgroundCommonPoolSize |
string (int64) The minimum value is 1. |
|
dictionariesLazyLoad |
boolean |
|
logLevel |
enum (LogLevel)
|
|
queryLogRetentionSize |
string (int64) The minimum value is 0. |
|
queryLogRetentionTime |
string (int64) The minimum value is 0. |
|
queryThreadLogEnabled |
boolean |
|
queryThreadLogRetentionSize |
string (int64) The minimum value is 0. |
|
queryThreadLogRetentionTime |
string (int64) The minimum value is 0. |
|
partLogRetentionSize |
string (int64) The minimum value is 0. |
|
partLogRetentionTime |
string (int64) The minimum value is 0. |
|
metricLogEnabled |
boolean |
|
metricLogRetentionSize |
string (int64) The minimum value is 0. |
|
metricLogRetentionTime |
string (int64) The minimum value is 0. |
|
traceLogEnabled |
boolean |
|
traceLogRetentionSize |
string (int64) |
|
traceLogRetentionTime |
string (int64) |
|
textLogEnabled |
boolean |
|
textLogRetentionSize |
string (int64) |
|
textLogRetentionTime |
string (int64) |
|
textLogLevel |
enum (LogLevel)
|
|
opentelemetrySpanLogEnabled |
boolean |
|
opentelemetrySpanLogRetentionSize |
string (int64) The minimum value is 0. |
|
opentelemetrySpanLogRetentionTime |
string (int64) The minimum value is 0. |
|
queryViewsLogEnabled |
boolean |
|
queryViewsLogRetentionSize |
string (int64) The minimum value is 0. |
|
queryViewsLogRetentionTime |
string (int64) The minimum value is 0. |
|
asynchronousMetricLogEnabled |
boolean |
|
asynchronousMetricLogRetentionSize |
string (int64) The minimum value is 0. |
|
asynchronousMetricLogRetentionTime |
string (int64) The minimum value is 0. |
|
sessionLogEnabled |
boolean |
|
sessionLogRetentionSize |
string (int64) The minimum value is 0. |
|
sessionLogRetentionTime |
string (int64) The minimum value is 0. |
|
zookeeperLogEnabled |
boolean |
|
zookeeperLogRetentionSize |
string (int64) The minimum value is 0. |
|
zookeeperLogRetentionTime |
string (int64) The minimum value is 0. |
|
asynchronousInsertLogEnabled |
boolean |
|
asynchronousInsertLogRetentionSize |
string (int64) The minimum value is 0. |
|
asynchronousInsertLogRetentionTime |
string (int64) The minimum value is 0. |
|
processorsProfileLogEnabled |
boolean |
|
processorsProfileLogRetentionSize |
string (int64) The minimum value is 0. |
|
processorsProfileLogRetentionTime |
string (int64) The minimum value is 0. |
|
errorLogEnabled |
boolean |
|
errorLogRetentionSize |
string (int64) The minimum value is 0. |
|
errorLogRetentionTime |
string (int64) The minimum value is 0. |
|
queryMetricLogEnabled |
boolean |
|
queryMetricLogRetentionSize |
string (int64) The minimum value is 0. |
|
queryMetricLogRetentionTime |
string (int64) The minimum value is 0. |
|
accessControlImprovements |
|
|
maxConnections |
string (int64) Acceptable values are 128 to 8192, inclusive. |
|
maxConcurrentQueries |
string (int64) The minimum value is 100. |
|
maxTableSizeToDrop |
string (int64) The minimum value is 0. |
|
maxPartitionSizeToDrop |
string (int64) The minimum value is 0. |
|
keepAliveTimeout |
string (int64) |
|
uncompressedCacheSize |
string (int64) |
|
markCacheSize |
string (int64) |
|
timezone |
string |
|
geobaseEnabled |
boolean |
|
geobaseUri |
string |
|
defaultDatabase |
string |
|
totalMemoryProfilerStep |
string (int64) |
|
totalMemoryTrackerSampleProbability |
number (double) |
|
asyncInsertThreads |
string (int64) The minimum value is 0. |
|
backupThreads |
string (int64) |
|
restoreThreads |
string (int64) |
|
vectorSimilarityIndexCacheSize |
string (int64) The minimum value is 0. |
|
vectorSimilarityIndexCacheMaxEntries |
string (int64) The minimum value is 0. |
|
maxBuildVectorSimilarityIndexThreadPoolSize |
string (int64) The minimum value is 0. |
|
mergeTree |
|
|
compression[] |
|
|
dictionaries[] |
|
|
graphiteRollup[] |
|
|
kafka |
|
|
kafkaTopics[] |
|
|
rabbitmq |
|
|
queryMaskingRules[] |
|
|
queryCache |
|
|
jdbcBridge |
|
|
mysqlProtocol |
boolean |
|
customMacros[] |
|
|
builtinDictionariesReloadInterval |
string (int64) |
AccessControlImprovements
|
Field |
Description |
|
selectFromSystemDbRequiresGrant |
boolean |
|
selectFromInformationSchemaRequiresGrant |
boolean |
MergeTree
|
Field |
Description |
|
partsToDelayInsert |
string (int64) |
|
partsToThrowInsert |
string (int64) |
|
inactivePartsToDelayInsert |
string (int64) The minimum value is 0. |
|
inactivePartsToThrowInsert |
string (int64) The minimum value is 0. |
|
maxAvgPartSizeForTooManyParts |
string (int64) The minimum value is 0. |
|
maxPartsInTotal |
string (int64) |
|
maxReplicatedMergesInQueue |
string (int64) |
|
numberOfFreeEntriesInPoolToLowerMaxSizeOfMerge |
string (int64) |
|
numberOfFreeEntriesInPoolToExecuteMutation |
string (int64) |
|
numberOfFreeEntriesInPoolToExecuteOptimizeEntirePartition |
string (int64) |
|
maxBytesToMergeAtMinSpaceInPool |
string (int64) |
|
maxBytesToMergeAtMaxSpaceInPool |
string (int64) The minimum value is 0. |
|
minBytesForWidePart |
string (int64) |
|
minRowsForWidePart |
string (int64) |
|
cleanupDelayPeriod |
string (int64) The minimum value is 0. |
|
maxCleanupDelayPeriod |
string (int64) The minimum value is 0. |
|
mergeSelectingSleepMs |
string (int64) The minimum value is 0. |
|
maxMergeSelectingSleepMs |
string (int64) The minimum value is 0. |
|
minAgeToForceMergeSeconds |
string (int64) The minimum value is 0. |
|
minAgeToForceMergeOnPartitionOnly |
boolean |
|
mergeMaxBlockSize |
string (int64) |
|
deduplicateMergeProjectionMode |
enum (DeduplicateMergeProjectionMode)
|
|
lightweightMutationProjectionMode |
enum (LightweightMutationProjectionMode)
|
|
replicatedDeduplicationWindow |
string (int64) |
|
replicatedDeduplicationWindowSeconds |
string (int64) |
|
fsyncAfterInsert |
boolean |
|
fsyncPartDirectory |
boolean |
|
minCompressedBytesToFsyncAfterFetch |
string (int64) |
|
minCompressedBytesToFsyncAfterMerge |
string (int64) |
|
minRowsToFsyncAfterMerge |
string (int64) |
|
ttlOnlyDropParts |
boolean |
|
mergeWithTtlTimeout |
string (int64) |
|
mergeWithRecompressionTtlTimeout |
string (int64) |
|
maxNumberOfMergesWithTtlInPool |
string (int64) |
|
materializeTtlRecalculateOnly |
boolean |
|
checkSampleColumnIsCorrect |
boolean |
|
allowRemoteFsZeroCopyReplication |
boolean |
Compression
|
Field |
Description |
|
method |
enum (Method)
|
|
minPartSize |
string (int64) |
|
minPartSizeRatio |
string |
|
level |
string (int64) |
ExternalDictionary
|
Field |
Description |
|
name |
string |
|
structure |
|
|
layout |
|
|
fixedLifetime |
string (int64) Includes only one of the fields |
|
lifetimeRange |
Includes only one of the fields |
|
httpSource |
Includes only one of the fields |
|
mysqlSource |
Includes only one of the fields |
|
clickhouseSource |
Includes only one of the fields |
|
mongodbSource |
Includes only one of the fields |
|
postgresqlSource |
Includes only one of the fields |
Structure
|
Field |
Description |
|
id |
|
|
key |
|
|
rangeMin |
|
|
rangeMax |
|
|
attributes[] |
The number of elements must be greater than 0. |
Id
|
Field |
Description |
|
name |
string |
Key
|
Field |
Description |
|
attributes[] |
The number of elements must be greater than 0. |
Attribute
|
Field |
Description |
|
name |
string |
|
type |
string |
|
nullValue |
string |
|
expression |
string |
|
hierarchical |
boolean |
|
injective |
boolean |
Layout
|
Field |
Description |
|
type |
enum (Type)
|
|
sizeInCells |
string (int64) The minimum value is 0. |
|
allowReadExpiredKeys |
boolean |
|
maxUpdateQueueSize |
string (int64) The minimum value is 0. |
|
updateQueuePushTimeoutMilliseconds |
string (int64) The minimum value is 0. |
|
queryWaitTimeoutMilliseconds |
string (int64) The minimum value is 0. |
|
maxThreadsForUpdates |
string (int64) The minimum value is 0. |
|
initialArraySize |
string (int64) The minimum value is 0. |
|
maxArraySize |
string (int64) The minimum value is 0. |
|
accessToKeyFromAttributes |
boolean |
Range
|
Field |
Description |
|
min |
string (int64) |
|
max |
string (int64) |
HttpSource
|
Field |
Description |
|
url |
string |
|
format |
string |
|
headers[] |
Header
|
Field |
Description |
|
name |
string |
|
value |
string |
MysqlSource
|
Field |
Description |
|
db |
string |
|
table |
string |
|
port |
string (int64) Acceptable values are 0 to 65535, inclusive. |
|
user |
string |
|
password |
string |
|
replicas[] |
|
|
where |
string |
|
invalidateQuery |
string |
|
closeConnection |
boolean |
|
shareConnection |
boolean |
Replica
|
Field |
Description |
|
host |
string The maximum string length in characters is 253. |
|
priority |
string (int64) The minimum value is 0. |
|
port |
string (int64) Acceptable values are 0 to 65535, inclusive. |
|
user |
string |
|
password |
string |
ClickhouseSource
|
Field |
Description |
|
db |
string |
|
table |
string |
|
host |
string The maximum string length in characters is 253. |
|
port |
string (int64) Acceptable values are 0 to 65535, inclusive. |
|
user |
string |
|
password |
string |
|
where |
string |
|
secure |
boolean |
MongodbSource
|
Field |
Description |
|
db |
string |
|
collection |
string |
|
host |
string The maximum string length in characters is 253. |
|
port |
string (int64) Acceptable values are 0 to 65535, inclusive. |
|
user |
string |
|
password |
string |
|
options |
string |
PostgresqlSource
|
Field |
Description |
|
db |
string |
|
table |
string |
|
hosts[] |
string |
|
port |
string (int64) Acceptable values are 0 to 65535, inclusive. |
|
user |
string |
|
password |
string |
|
invalidateQuery |
string |
|
sslMode |
enum (SslMode)
|
GraphiteRollup
|
Field |
Description |
|
name |
string |
|
patterns[] |
The number of elements must be greater than 0. |
|
pathColumnName |
string |
|
timeColumnName |
string |
|
valueColumnName |
string |
|
versionColumnName |
string |
Pattern
|
Field |
Description |
|
regexp |
string |
|
function |
string |
|
retention[] |
Retention
|
Field |
Description |
|
age |
string (int64) |
|
precision |
string (int64) |
Kafka
|
Field |
Description |
|
securityProtocol |
enum (SecurityProtocol)
|
|
saslMechanism |
enum (SaslMechanism)
|
|
saslUsername |
string |
|
saslPassword |
string |
|
enableSslCertificateVerification |
boolean |
|
maxPollIntervalMs |
string (int64) The minimum value is 0. |
|
sessionTimeoutMs |
string (int64) The minimum value is 0. |
|
debug |
enum (Debug)
|
|
autoOffsetReset |
enum (AutoOffsetReset)
|
|
messageMaxBytes |
string (int64) Acceptable values are 1000 to 1000000000, inclusive. |
|
batchSize |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
KafkaTopic
|
Field |
Description |
|
name |
string |
|
settings |
Rabbitmq
|
Field |
Description |
|
username |
string |
|
password |
string |
|
vhost |
string |
QueryMaskingRule
|
Field |
Description |
|
name |
string |
|
regexp |
string |
|
replace |
string |
QueryCache
|
Field |
Description |
|
maxSizeInBytes |
string (int64) The minimum value is 0. |
|
maxEntries |
string (int64) The minimum value is 0. |
|
maxEntrySizeInBytes |
string (int64) The minimum value is 0. |
|
maxEntrySizeInRows |
string (int64) The minimum value is 0. |
JdbcBridge
|
Field |
Description |
|
host |
string |
|
port |
string (int64) Acceptable values are 0 to 65535, inclusive. |
Macro
|
Field |
Description |
|
name |
string The maximum string length in characters is 63. Value must match the regular expression |
|
value |
string The maximum string length in characters is 63. Value must match the regular expression |
Resources
|
Field |
Description |
|
resourcePresetId |
string |
|
diskSize |
string (int64) |
|
diskTypeId |
string |
DiskSizeAutoscaling
|
Field |
Description |
|
plannedUsageThreshold |
string (int64) Acceptable values are 0 to 100, inclusive. |
|
emergencyUsageThreshold |
string (int64) Acceptable values are 0 to 100, inclusive. |
|
diskSizeLimit |
string (int64) |