0

I have exported data from JIRA to Bigquery so that I can do customize report and analytics via bigquery. I have a problem with one of the column in bigquery table where i see changelog_histories column have data in nested Json format. I will not able to achieve my goal until I extract data from the nested JSON.

Data extracted to Bigquery JSON from Changelog.histories column

To start with I tried the following query SELECT key, changelog_histories, JSON_EXTRACT (changelog_histories,'$.x[0].author.accountType') as output FROM [Project.Table]``

but it returned null Can someone help me here ?

Sathish Babu
  • 1
  • I don't see the expected output in your question. However, I do have some experience in BigQuery especially when it comes to nested JSON-type data. I suggest looking at the 'UNNEST' function (https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays). If this doesn't help, please show what your expected output is. I might be able to help further depending on that. – RaphX Jan 24 '23 at 08:00

0 Answers0