SYS.ORGANIZATION.CLOUDS
The sys.organization.clouds
table contains metadata for clouds in an organization.
SELECT *
FROM sys.organization.clouds
Example Output
cloud_id | cloud_name | vendor_name | vendor_region | cloud_credentials | security_groups | subnets | owner_id | owner_type | private_endpoints |
---|---|---|---|---|---|---|---|---|---|
72ccc3e6-5444-4848-adaa-2a7945bdddbe | Default | AWS | US_EAST_2 | IAM Role : arn:aws:iam::300000000018:role/DremioIAMCloudComputeRole-DN000B0AAAA0 | sg-005da7e340052a9fc | subnet-901cfaed | 1ebd39a7-d571-4edb-b113-206eb263c775 | USER | vpce-035f62faf3e3510ab |
e6a22c9a-926d-2c6e-012c-7203463e4d10 | Azure East | Azure | EAST_US | Client ID : dd519f08-f0e4-4ca4-8a74-1ba156ae231c | dremiocloudnsg | default | 3e334762-b0c6-4c36-9faf-93800f0d6c71 | USER | /subscriptions/ca6aad79-db4f-4756-9a95-aee7856a3100/resourcegroups/dremiocloud/providers/microsoft.network/privateendpoints/dremioprivatelink |
f7b60f9d-483e-4e7e-914e-4664147d4b14 | Cloud East | AWS | US_EAST_2 | Access Key : AKIAVU7YDKEBHHF6S62G | sg-0cb4444fadbd6f072 | subnet-81z255z5 | 56933e51-1157-41c0-acbb-da540adf8066 | USER | vpce-143b01baa2a1953aa |
b0a88d0b-086a-5c4c-998d-1058244a1c22 | Azure Central | Azure | CENTRAL_US | Client ID : ea826c98-f2c2-8bd9-8b11-2cc921ea101a | subnet1a | 3e334762-b0c6-4c36-9faf-93800f0d6c71 | USER | ||
72cc53e6-5413-4848-ada6-2a7945bdddbe | AWS West | AWS | US_WEST_2 | IAM Role : arn:aws:iam::333377777444:role/DremioIAMCloudComputeRole-DN170B0LEDU7 | sg-005da7e340052a9fc | subnet-991abcde | 1ebd39a7-d571-4edb-b113-206eb263c775 | ROLE |
Fields
Field | Data Type | Description |
---|---|---|
cloud_id | varchar | The UUID to identify the cloud. |
cloud_name | varchar | The user-defined name for the cloud. |
vendor_name | varchar | The name of the cloud provider where the Dremio engines are running. |
vendor_region | varchar | The region for which the cloud is configured. |
cloud_credentials | varchar | The role or access key ID used to configure the cloud. |
security_groups | varchar | The list of security groups associated with the cloud. |
subnets | varchar | The list of subnets that engines associated with this cloud could be spun up in. |
owner_id | varchar | The UUID for the owner (user or role) of the cloud. This UUID corresponds to the id in the users or roles table. |
owner_type | varchar | The type of owner of the cloud. Enum: USER , ROLE |
private_endpoints | varchar | The AWS VPC Endpoint or the Azure Private Endpoint associated with this cloud. |