bug: `snyk_sbom` table only syncs data from last organisation about cloudquery

[erezrokah]

Hi @akash1810, can you try with version v5.4.0? Release notes in https://hub.cloudquery.io/plugins/source/cloudquery/snyk/v5.4.0/versions

[akash1810]

Hi @akash1810, can you try with version v5.4.0? Release notes in https://hub.cloudquery.io/plugins/source/cloudquery/snyk/v5.4.0/versions

Amazing! Thanks for this! I can confirm this works too.

[candiduslynx]

Hi @akash1810!
Thank you for submitting the issue.
As we don't have the enterprise access for the Snyk API, would you mind testing v0.0.0-sbom-rc1 of the snyk source plugin & tell us if the issue was fixed?

[candiduslynx]

Additionally, as SBOM is a per project table in the source plugin, could you please verify that the orgs you can see have at least 1 project?
If there's an org that has 0 projects it will be skipped altogether.

[akash1810]

Thanks for the fast response @candiduslynx 🙏🏽.

would you mind testing v0.0.0-sbom-rc1 of the snyk source plugin & tell us if the issue was fixed?

Unfortunately this version has not solved the issue. The last organisation is still the only one that is synced. The logs appear unchanged too.

Additionally, as SBOM is a per project table in the source plugin, could you please verify that the orgs you can see have at least 1 project?

With the following query:

select    o.id as organization_id
          , count(p.id) as total_projects
from      snyk_projects p
          join snyk_organizations o on p.organization_id = o.id
group by  o.id
order by  total_projects desc
limit     4;

I have the following (redacted) output:

organization_id	total_projects
fce564f1-REDACTED	224
c9f872db-REDACTED	99
b0cbace2-REDACTED	69
622782f7-REDACTED	69

We have 30 organisations with at least 1 project:

with data as (
  select    o.id as organization_id
            , count(p.id) as total_projects
  from      snyk_projects p
            join snyk_organizations o on p.organization_id = o.id
  group by  o.id
  order by  total_projects desc
)

select  count(organization_id) 
from    data 
where   total_projects > 0;

-- 30

[erezrokah]

We found the bug and we'll release a version with a fix in a bit. I'll keep the issue open until we do and then comment once have the release out