Skip to main content

SYS.ORGANIZATION.CLOUDS

The sys.organization.clouds table contains metadata for clouds in an organization.

Syntax
SELECT *
FROM sys.organization.clouds

Example Output

cloud_idcloud_namevendor_namevendor_regioncloud_credentialssecurity_groupssubnetsowner_idowner_typeprivate_endpoints
72ccc3e6-5444-4848-adaa-2a7945bdddbeDefaultAWSUS_EAST_2IAM Role : arn:aws:iam::300000000018:role/DremioIAMCloudComputeRole-DN000B0AAAA0sg-005da7e340052a9fcsubnet-901cfaed1ebd39a7-d571-4edb-b113-206eb263c775USERvpce-035f62faf3e3510ab
e6a22c9a-926d-2c6e-012c-7203463e4d10Azure EastAzureEAST_USClient ID : dd519f08-f0e4-4ca4-8a74-1ba156ae231cdremiocloudnsgdefault3e334762-b0c6-4c36-9faf-93800f0d6c71USER/subscriptions/ca6aad79-db4f-4756-9a95-aee7856a3100/resourcegroups/dremiocloud/providers/microsoft.network/privateendpoints/dremioprivatelink
f7b60f9d-483e-4e7e-914e-4664147d4b14Cloud EastAWSUS_EAST_2Access Key : AKIAVU7YDKEBHHF6S62Gsg-0cb4444fadbd6f072subnet-81z255z556933e51-1157-41c0-acbb-da540adf8066USERvpce-143b01baa2a1953aa
b0a88d0b-086a-5c4c-998d-1058244a1c22Azure CentralAzureCENTRAL_USClient ID : ea826c98-f2c2-8bd9-8b11-2cc921ea101asubnet1a3e334762-b0c6-4c36-9faf-93800f0d6c71USER
72cc53e6-5413-4848-ada6-2a7945bdddbeAWS WestAWSUS_WEST_2IAM Role : arn:aws:iam::333377777444:role/DremioIAMCloudComputeRole-DN170B0LEDU7sg-005da7e340052a9fcsubnet-991abcde1ebd39a7-d571-4edb-b113-206eb263c775ROLE

Fields

FieldData TypeDescription
cloud_idvarcharThe UUID to identify the cloud.
cloud_namevarcharThe user-defined name for the cloud.
vendor_namevarcharThe name of the cloud provider where the Dremio engines are running.
vendor_regionvarcharThe region for which the cloud is configured.
cloud_credentialsvarcharThe role or access key ID used to configure the cloud.
security_groupsvarcharThe list of security groups associated with the cloud.
subnetsvarcharThe list of subnets that engines associated with this cloud could be spun up in.
owner_idvarcharThe UUID for the owner (user or role) of the cloud. This UUID corresponds to the id in the users or roles table.
owner_typevarcharThe type of owner of the cloud.
Enum: USER, ROLE
private_endpointsvarcharThe AWS VPC Endpoint or the Azure Private Endpoint associated with this cloud.