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_idproject_namestateproject_storeproject_credentialscloud_idowner_idowner_type
    4d9ce7b3-0ccf-4315-b6e0-b1548f798c43test projectACTIVEdremio-df563723-f8aa-4a59-888a-216666a6d66aIAM Role : arn:aws:iam::388677980418:role/DremioIAMProjectDataAccessRole-FTNDY4SBV272cc53e6-5413-4848-ada6-2a7945bdddbe1ebd39a7-d571-4edb-b113-206eb263c775USER

    Fields

    FieldData TypeDescription
    project_idvarcharThe UUID to identify the project.
    project_namevarcharThe user-defined name for the project.
    statevarcharThe state of the project.
    Enum: COMMISSIONING, ACTIVE, FAILED, MARK_DELETE
    project_storevarcharThe name of the project store bucket.
    project_credentialsvarcharThe details of the credentials for the project, including the type of credential and the access key or role.
    Enum: ACCESS_KEY, IAM_ROLE
    cloud_idvarcharThe UUID to identify the cloud where the engines for the project will be spun up.
    owner_idvarcharThe UUID for the owner (user or role) of the project. This UUID corresponds to the id in the users or roles table.
    owner_typevarcharThe type of owner of the project.
    Enum: USER, ROLE