Dremio Cloud
Dremio Software
 
On this page

    SYS.ORGANIZATION.PROJECTS

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

    Syntax 
    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