List BigQuery table groups
This operation returns the list of BigQuery table groups associated to the instance.
Query Parameters
- clientid string required
Id of the cloud Account
- applicationId string required
Default value:
134Id of the App Type
- instanceId string required
Id of the instance
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Table groups details
Schema
- filterQueryCount integer
subClientProperties object[]
status integeruseLocalContent booleanprotectionGroupDeleteOption stringisProtectionGroupGenerated booleanisFailoverSubclient integeruseLocalArchivalRules booleanplanEntity object
planType integerplanName stringplanSubtype integerplanId integercassandraProps object
awsEFSProperties object
taPlanEntity object
splunkProps object
bigDataProps object
proxyClient object
dcPlanEntity object
subClientEntity object
clientName stringinstanceName stringdisplayName stringbackupsetId integer_type_ stringcommCellName stringinstanceId integercsGUID stringsubclientGUID stringsubclientId integerclientId integerappName stringbackupsetName stringapplicationId integersubclientName stringentityInfo object
companyId integercompanyName stringmultiCommcellId integerdfsSubclientProp object
cloudAppsSubClientProp object
instanceType stringcloudBigQuerySubclient object
backupModels booleanbackupMetadataEntities booleantimeConsistentBackups booleanbackupExternalConnections booleanbackupRoutines booleancloudStagingPath stringbackupIndexes booleancloudBigQueryBackupObject object[]
datasetId stringprojectId stringregion object
commonProperties object
slaStatus integerisAdAppAwareSubclient booleandisableArchivingTurboRule booleanisSnapshotV2 booleanfirstBackupTime integerlastBackupTime integerindexingBackupSubClient booleanjobStartTime integerisActivityDisabledFromPolicy booleanisETCDSubclient booleanenableBackupAfterDelay booleanrunAs stringslaCategoryDescription stringenableBackup booleanidaType stringrunTrueUpJobAfterDays integertotalBackupSize integerisTrueUpOptionEnabled booleanslaCategory integersubClientPropertiesFlag integerlastBackupSize integerhasScaleProfileAccessNode booleanassociatedSnapShotSCId object
_type_ stringsnapCopyInfo object
useDB2ACSInterface booleanuseProxyForSQLIntegrity object
sybaseUser object
snapToTapeSelectedEngine object
_type_ stringsqlUser object
vmApplicationUser object
snapToTapeProxyToUse object
_type_ stringquiesceImpersonateUser object
separateProxyForSnapToTape object
_type_ stringsshKey object
configuredSybaseInstance object
_type_ stringsubclientPolicy object
_type_ stringsubclientPolicyName stringapplicationCredentialinfo object
credentialId integerimpersonateUserCredentialinfo object
credentialId integercredentialName stringenableBackupAtDateTime object
TimeZoneID integertime integerturboNASClient object
_type_ stringprepostProcess object
prepostUserName object
storageDevice object
dataBackupStoragePolicy object
_type_ stringstoragePolicyName stringstoragePolicyId integerlogBackupStoragePolicy object
_type_ stringperformanceMode object
pipelineBufferSize integernumOfPipelineBuffers integermuxFactor integerlookAheadReaderSlots integerUNCScriptCredentialinfo object
credentialId integervmBackupValidationSettings object
backupValidationThreadCount integeruncScriptImpersonateUser object
prepostCredentialinfo object
credentialId integercredentialName stringassociatedPolicy object
subclientPolicyId integerguestCredentialinfo object
credentialId integerauditPlanEntity object
analyticsSubclientProp object
{
"filterQueryCount": 0,
"subClientProperties": [
{
"status": 0,
"useLocalContent": true,
"protectionGroupDeleteOption": "string",
"isProtectionGroupGenerated": true,
"isFailoverSubclient": 0,
"useLocalArchivalRules": true,
"planEntity": {
"planType": 0,
"planName": "string",
"planSubtype": 0,
"planId": 0
},
"cassandraProps": {},
"awsEFSProperties": {},
"taPlanEntity": {},
"splunkProps": {},
"bigDataProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "string",
"instanceName": "string",
"displayName": "string",
"backupsetId": 0,
"_type_": "string",
"commCellName": "string",
"instanceId": 0,
"csGUID": "string",
"subclientGUID": "string",
"subclientId": 0,
"clientId": 0,
"appName": "string",
"backupsetName": "string",
"applicationId": 0,
"subclientName": "string",
"entityInfo": {
"companyId": 0,
"companyName": "string",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"cloudAppsSubClientProp": {
"instanceType": "string",
"cloudBigQuerySubclient": {
"backupModels": true,
"backupMetadataEntities": true,
"timeConsistentBackups": true,
"backupExternalConnections": true,
"backupRoutines": true,
"cloudStagingPath": "string",
"backupIndexes": true,
"cloudBigQueryBackupObject": [
{
"datasetId": "string",
"projectId": "string"
}
]
}
},
"region": {},
"commonProperties": {
"slaStatus": 0,
"isAdAppAwareSubclient": true,
"disableArchivingTurboRule": true,
"isSnapshotV2": true,
"firstBackupTime": 0,
"lastBackupTime": 0,
"indexingBackupSubClient": true,
"jobStartTime": 0,
"isActivityDisabledFromPolicy": true,
"isETCDSubclient": true,
"enableBackupAfterDelay": true,
"runAs": "string",
"slaCategoryDescription": "string",
"enableBackup": true,
"idaType": "string",
"runTrueUpJobAfterDays": 0,
"totalBackupSize": 0,
"isTrueUpOptionEnabled": true,
"slaCategory": 0,
"subClientPropertiesFlag": 0,
"lastBackupSize": 0,
"hasScaleProfileAccessNode": true,
"associatedSnapShotSCId": {
"_type_": "string"
},
"snapCopyInfo": {
"useDB2ACSInterface": true,
"useProxyForSQLIntegrity": {},
"sybaseUser": {},
"snapToTapeSelectedEngine": {
"_type_": "string"
},
"sqlUser": {},
"vmApplicationUser": {},
"snapToTapeProxyToUse": {
"_type_": "string"
},
"quiesceImpersonateUser": {},
"separateProxyForSnapToTape": {
"_type_": "string"
},
"sshKey": {},
"configuredSybaseInstance": {
"_type_": "string"
}
},
"subclientPolicy": {
"_type_": "string",
"subclientPolicyName": "string"
},
"applicationCredentialinfo": {
"credentialId": 0
},
"impersonateUserCredentialinfo": {
"credentialId": 0,
"credentialName": "string"
},
"enableBackupAtDateTime": {
"TimeZoneID": 0,
"time": 0
},
"turboNASClient": {
"_type_": "string"
},
"prepostProcess": {
"prepostUserName": {}
},
"storageDevice": {
"dataBackupStoragePolicy": {
"_type_": "string",
"storagePolicyName": "string",
"storagePolicyId": 0
},
"logBackupStoragePolicy": {
"_type_": "string"
},
"performanceMode": {
"pipelineBufferSize": 0,
"numOfPipelineBuffers": 0,
"muxFactor": 0,
"lookAheadReaderSlots": 0
}
},
"UNCScriptCredentialinfo": {
"credentialId": 0
},
"vmBackupValidationSettings": {
"backupValidationThreadCount": 0,
"uncScriptImpersonateUser": {}
},
"prepostCredentialinfo": {
"credentialId": 0,
"credentialName": "string"
},
"associatedPolicy": {
"subclientPolicyId": 0
},
"guestCredentialinfo": {
"credentialId": 0
}
},
"auditPlanEntity": {},
"analyticsSubclientProp": {}
}
]
}
{
"filterQueryCount": 1,
"subClientProperties": [
{
"status": 0,
"useLocalContent": false,
"protectionGroupDeleteOption": "NONE",
"isProtectionGroupGenerated": false,
"isFailoverSubclient": 0,
"useLocalArchivalRules": false,
"planEntity": {
"planType": 2,
"planName": "gcp_m065_plan",
"planSubtype": 33554437,
"planId": 452
},
"cassandraProps": {},
"awsEFSProperties": {},
"taPlanEntity": {},
"splunkProps": {},
"bigDataProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "BQ_Hyp",
"instanceName": "BigQuery",
"displayName": "BQ_Hyp",
"backupsetId": 1894,
"_type_": "SUBCLIENT_ENTITY",
"commCellName": "M065",
"instanceId": 926,
"csGUID": "413AAAAA-AACC-AA4F-A8AA-AA0AF665E91A",
"subclientGUID": "FFF6ACF3-1411-45F7-BAF4-E597FCAAAAAA",
"subclientId": 4119,
"clientId": 1206,
"appName": "Cloud Apps",
"backupsetName": "defaultBackupSet",
"applicationId": 134,
"subclientName": "BigQuery-table-group",
"entityInfo": {
"companyId": 6,
"companyName": "Team-Database",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"cloudAppsSubClientProp": {
"instanceType": "GCP_BIGQUERY",
"cloudBigQuerySubclient": {
"backupModels": false,
"backupMetadataEntities": false,
"timeConsistentBackups": false,
"backupExternalConnections": false,
"backupRoutines": false,
"cloudStagingPath": "AUTOMATIC",
"backupIndexes": false,
"cloudBigQueryBackupObject": [
{
"datasetId": "AMdata2",
"projectId": "sqltestbigquery-d"
}
]
}
},
"region": {},
"commonProperties": {
"slaStatus": 3,
"isAdAppAwareSubclient": false,
"disableArchivingTurboRule": false,
"isSnapshotV2": false,
"firstBackupTime": 0,
"lastBackupTime": 0,
"indexingBackupSubClient": false,
"jobStartTime": -1,
"isActivityDisabledFromPolicy": false,
"isETCDSubclient": false,
"enableBackupAfterDelay": false,
"runAs": "CV_NO_SELECTION",
"slaCategoryDescription": "Recently Installed with No Finished Job",
"enableBackup": true,
"idaType": "0",
"runTrueUpJobAfterDays": 0,
"totalBackupSize": 0,
"isTrueUpOptionEnabled": false,
"slaCategory": 10,
"subClientPropertiesFlag": 0,
"lastBackupSize": 0,
"hasScaleProfileAccessNode": false,
"associatedSnapShotSCId": {
"_type_": "SUBCLIENT_ENTITY"
},
"snapCopyInfo": {
"useDB2ACSInterface": false,
"useProxyForSQLIntegrity": {},
"sybaseUser": {},
"snapToTapeSelectedEngine": {
"_type_": "SNAP_SHOT_ENGINE_ENTITY"
},
"sqlUser": {},
"vmApplicationUser": {},
"snapToTapeProxyToUse": {
"_type_": "CLIENT_ENTITY"
},
"quiesceImpersonateUser": {},
"separateProxyForSnapToTape": {
"_type_": "CLIENT_ENTITY"
},
"sshKey": {},
"configuredSybaseInstance": {
"_type_": "INSTANCE_ENTITY"
}
},
"subclientPolicy": {
"_type_": "SUBCLIENT_POLICY_ENTITY",
"subclientPolicyName": ""
},
"applicationCredentialinfo": {
"credentialId": 0
},
"impersonateUserCredentialinfo": {
"credentialId": 0,
"credentialName": ""
},
"enableBackupAtDateTime": {
"TimeZoneID": 0,
"time": 0
},
"turboNASClient": {
"_type_": "CLIENT_ENTITY"
},
"prepostProcess": {
"prepostUserName": {}
},
"storageDevice": {
"dataBackupStoragePolicy": {
"_type_": "STORAGE_POLICY_ENTITY",
"storagePolicyName": "gcp_m065_plan",
"storagePolicyId": 765
},
"logBackupStoragePolicy": {
"_type_": "STORAGE_POLICY_ENTITY"
},
"performanceMode": {
"pipelineBufferSize": 64,
"numOfPipelineBuffers": 180,
"muxFactor": 0,
"lookAheadReaderSlots": 4
}
},
"UNCScriptCredentialinfo": {
"credentialId": 0
},
"vmBackupValidationSettings": {
"backupValidationThreadCount": 0,
"uncScriptImpersonateUser": {}
},
"prepostCredentialinfo": {
"credentialId": 0,
"credentialName": ""
},
"associatedPolicy": {
"subclientPolicyId": 0
},
"guestCredentialinfo": {
"credentialId": 0
}
},
"auditPlanEntity": {},
"analyticsSubclientProp": {}
}
]
}
Loading...