steampipe plugin install github

Table: github_traffic_view_weekly - Query GitHub Traffic View Weekly using SQL

GitHub Weekly Traffic Views is a feature within GitHub that allows repository owners to monitor and understand the frequency and source of visits to their repositories. It provides a weekly summary of the number of views and unique visitors to a repository. This feature aids in understanding the popularity and reach of a repository over time.

Table Usage Guide

The github_traffic_view_weekly table provides insights into weekly traffic views within GitHub. As a repository owner or contributor, explore weekly view details through this table, including the number of views, unique visitors, and timestamp of the views. Utilize it to uncover information about repository popularity, such as peak visit times, trending repositories, and the reach of your repository.

Important Notes

  • You must specify the repository_full_name column in where or join clause to query the table.

Examples

List view statistics

Explore the popularity and unique visitor count of the 'Steampipe' repository on Github over time. This can be beneficial in understanding the reach and impact of the project, helping to inform future development and marketing strategies.

select
timestamp,
count,
uniques
from
github_traffic_view_weekly
where
repository_full_name = 'turbot/steampipe'
order by
timestamp;
select
timestamp,
count,
uniques
from
github_traffic_view_weekly
where
repository_full_name = 'turbot/steampipe'
order by
timestamp;

Schema for github_traffic_view_weekly

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
countbigintView count for the week.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
repository_full_nametext=Full name of the repository that contains the branch.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
timestamptimestamp with time zoneDate for the view data.
uniquesbigintUnique viewer count for the week.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- github

You can pass the configuration to the command with the --config argument:

steampipe_export_github --config '<your_config>' github_traffic_view_weekly