View Your Project's Artifacts

important

Projects are assigned artifacts in two ways:

1. You can manually add an artifact to a project by adding it to the project's .yaml file in oss-directory.
2. OSO discovers downstream artifacts linked to projects. For instance, if a project owns a GitHub organization, OSO will discover all the GitHub repositories owned by that organization and link them as project artifacts.

Lookup All Artifacts for a Project

You can lookup all artifacts for a project using either BigQuery or our GraphQL API:

SQL

select
  artifact_id,
  artifact_name,
  artifact_namespace
from `oso_production.artifacts_by_project_v1`
where project_name = 'opensource-observer'

GraphQL

query findProject {
  oso_artifactsByProjectV1(
    where: { projectName: { _eq: "opensource-observer" } }
  ) {
    artifactId
    artifactName
    artifactNamespace
  }
}

Lookup a Specific Artifact

You can lookup a specific artifact by its artifact_name and/or artifact_namespace using either BigQuery or our GraphQL API:

SQL

select
  artifact_id,
  artifact_name,
  artifact_namespace
from `oso_production.artifacts_by_project_v1`
where artifact_name = 'oso' and artifact_namespace = 'opensource-observer'

GraphQL

query findArtifact {
  oso_artifactsByProjectV1(
    where: { artifactName: { _eq: "oso" }, artifactNamespace: { _eq: "opensource-observer" } }
  ) {
    artifactId
    artifactName
    artifactNamespace
  }
}

Lookup Artifacts by Data Source

You can lookup artifacts by their data source using either BigQuery or our GraphQL API:

SQL

select
  artifact_id,
  artifact_name,
  artifact_namespace
from `oso_production.artifacts_by_project_v1`
where artifact_source = 'GITHUB'

GraphQL

query findArtifactsBySource {
  oso_artifactsByProjectV1(
    where: { artifactSource: { _eq: "GITHUB" } }
  ) {
    artifactId
    artifactName
    artifactNamespace
  }
}