On this page

    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_type
    72ccc3e6-5444-4848-adaa-2a7945bdddbeDefaultAWSUS_EAST_2IAM Role : arn:aws:iam::300000000018:role/DremioIAMCloudComputeRole-DN000B0AAAA0sg-005da7e340052a9fcsubnet-901cfaed1ebd39a7-d571-4edb-b113-206eb263c775USER
    54fb37b4-93e5-4ece-874c-ef22eb900103Default CloudAWSUS_WEST_2Access Key : AAAAVVV00SSMMMJJJZZZsg-03b222cd073633333subnet-f4dec3df75ecfc21-6a29-489b-9583-5c223a7fa04bUSER
    f7b60f9d-483e-4e7e-914e-4664147d4b14Cloud EastAWSUS_EAST_2Access Key : AKIAVU7YDKEBHHF6S62Gsg-0cb4444fadbd6f072subnet-81z255z556933e51-1157-41c0-acbb-da540adf8066USER
    72cc53e6-5413-4848-ada6-2a7945bdddbeCloud 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. This value will always be AWS.
    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