Skip to main content

How to access chronicle data in Big Query

  • July 27, 2023
  • 4 replies
  • 25 views

Forum|alt.badge.img+1

Hi All,

I want access the metrics available in Big Query which are ingested by Chronicle SIEM using Python. Can any one help on same.

Thanks

4 replies

citreno
Forum|alt.badge.img+6
  • Bronze 1
  • July 27, 2023

Typically we'd use the chronicle_cli to grant a user Big Query access . Here are instructions


Rene_Figueroa
Staff
Forum|alt.badge.img+10

If you do not have the BQ API keys for your Chronicle data set, please open a support case for it. Once you have the BQ API key, you will be able to query the data set programmatically. 

For the chronicle_cli, you also need a set of API keys, so if you do not have those also ask for them. 


Forum|alt.badge.img+1
  • Author
  • New Member
  • July 28, 2023

If you do not have the BQ API keys for your Chronicle data set, please open a support case for it. Once you have the BQ API key, you will be able to query the data set programmatically. 

For the chronicle_cli, you also need a set of API keys, so if you do not have those also ask for them. 


Any sample code would be really helpful


Rene_Figueroa
Staff
Forum|alt.badge.img+10

Any sample code would be really helpful


Chronicle does not have any specific sample code to query the data set; however, BigQuery does offer plenty of sample code. Here it's an example on how to set up the connection with a service account (API key):

https://cloud.google.com/bigquery/docs/authentication/service-account-file

The data set is read-only.