SYS.ORGANIZATION.PROJECTS
The sys.organization.projects table contains metadata for projects in an organization.
SELECT *
FROM sys.organization.projects
Example Output
| project_id | project_name | state | project_store | project_credentials | cloud_id | owner_id | owner_type |
|---|---|---|---|---|---|---|---|
| 4d9ce7b3-0ccf-4315-b6e0-b1548f798c43 | test project | ACTIVE | dremio-df563723-f8aa-4a59-888a-216666a6d66a | IAM Role : arn:aws:iam::388677980418:role/DremioIAMProjectDataAccessRole-FTNDY4SBV2 | 72cc53e6-5413-4848-ada6-2a7945bdddbe | 1ebd39a7-d571-4edb-b113-206eb263c775 | USER |
Fields
| Field | Data Type | Description |
|---|---|---|
| project_id | varchar | The UUID to identify the project. |
| project_name | varchar | The user-defined name for the project. |
| state | varchar | The state of the project. Enum: COMMISSIONING, ACTIVE, FAILED, MARK_DELETE |
| project_store | varchar | The name of the project store bucket. |
| project_credentials | varchar | The details of the credentials for the project, including the type of credential and the access key or role. Enum: ACCESS_KEY, IAM_ROLE |
| cloud_id | varchar | The UUID to identify the cloud where the engines for the project will be spun up. |
| owner_id | varchar | The UUID for the owner (user or role) of the project. This UUID corresponds to the id in the users or roles table. |
| owner_type | varchar | The type of owner of the project. Enum: USER, ROLE |