Skip to main content

Adding Censys Datasets to BigQuery

  • Updated

Before you can query Censys data through Google BigQuery, you'll need to add the censys-io resource to your BigQuery project. This article explains how to add the dataset once you have created a Google Cloud account.

Note: BigQuery access is only available to users of an enterprise data contract and verified non-commercial researchers. If you have any questions about access, please contact support@censys.io.

Pinning the Censys Resource

Log in to the BigQuery UI in the Google Cloud Console. If your account is set up correctly, you should see your primary project and the standard query interface.  I have created and switched to a new project, that is specific to Censys Research. Research_Step1.png

Automatically pin the resource

Follow this link to automatically add censys-io to your Resource tree. 

Research_Step2.pngAfter you expand "censys-io" to view the tables, refreshing the page will notify you that 'censys-io' was pinned to the Resource tree.

Research_Step3.png

Manually pin the resource

If you prefer to manually pin censys-io to the Resource tree, click "+ ADD DATA", and then "Pin a project".

Research_manual1.png

Enter "censys-io" as the project name, and click "PIN".

Research_manual2.png

You'll receive notification that 'censys-io' was pinned to the Resource tree.Research_Step3.png

 Execute Test Query

Once the Censys project has been added, you can query the Censys datasets just like you would query any of your own data. Click Compose Query to get started. For example, you can get a count of the distinct IPs in our current IPv4 scan dataset: 

#standardsql
SELECT COUNT(DISTINCT ip)
FROM `censys-io.ipv4_public.current`

What Now?

Now that you've added the datasets, to your account, here's some more information on how to write queries. 

 
 

Related articles