Skip to content

github_team table is broken via discussionsUrl #530

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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions