Skip to content

github_team table is broken via discussionsUrl #530

@JayRovacsek

Description

@JayRovacsek

Describe the bug
Queries to any table that depends on Team fails with:

Error: github: Field 'discussionsUrl' doesn't exist on type 'Team' (SQLSTATE HV000)

While I am still investigating it, I strongly suspect upstream APIs may have changed in a way that breaks the github_team table (will update if I can find anything)

Steampipe version (steampipe -v)
Steampipe v2.3.4

Plugin version (steampipe plugin list)
hub.steampipe.io/plugins/turbot/github@latest | 1.7.0

To reproduce
Query the github_team table with sql:

select
    combined_slug,
    created_at,
    description,
    id,
    name,
    organization,
    parent_team,
    privacy,
    slug,
    updated_at
from
    github_team
where organization = 'acme'
limit 1

Expected behavior
The above query does not error on utilisation

Additional context
Further example queries that share this behaviour:

with teams as (
    select
    distinct slug
    from
        github_team
    where
        organization = 'acme'
    limit 1
)

select
    repository.id,
    repository.name as repository_name,
    repository.slug as team_slug,
    repository.permission
from
    github_team_repository as repository
inner join teams as team
    on
        repository.slug = team.slug
where
    repository.organization = 'acme'
    and repository.archived_at is null
    and repository.permission = 'ADMIN'
limit 1
with teams as (
    select
        organization,
        slug as team_slug
    from
        github_team
    where organization = 'acme'
)

select
    ghtm.email,
    ghtm.id,
    ghtm.login_id,
    ghtm.login,
    ghtm.login,
    ghtm.name,
    ghtm.organization,
    ghtm.role,
    ghtm.slug as team_slug,
    ghtm.status,
    ghtm.updated_at
from
    github_team_member as ghtm
join
    teams as t
    on
        t.organization = ghtm.organization
        and t.team_slug = ghtm.slug

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions