Table: github_traffic_view_daily - Query GitHub Traffic Views using SQL

GitHub Traffic Views is a feature within GitHub that allows you to monitor and respond to traffic patterns across your repositories. It provides a centralized way to set up and monitor views for various GitHub repositories, including the number of visitors, unique visitors, and the number of views per day. GitHub Traffic Views helps you stay informed about the health and performance of your GitHub repositories and take appropriate actions when predefined conditions are met.

Table Usage Guide

The github_traffic_view_daily table provides insights into daily repository views within GitHub. As a repository owner, explore view-specific details through this table, including the number of views, unique visitors, and the timestamp of the views. Utilize it to uncover information about views, such as those with high traffic, the peak times for views, and the verification of view patterns.

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 daily traffic statistics of the 'turbot/steampipe' repository to assess its popularity and unique visits. This can help you understand the reach and impact of your project over time.

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

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

Schema for github_traffic_view_daily

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
count	bigint		View count for the day.
login_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the user login.
repository_full_name	text	=	Full name of the repository that contains the branch.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
timestamp	timestamp with time zone		Date for the view data.
uniques	bigint		Unique viewer count for the day.

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_daily