Constantin Lungudatawise.dev·Jun 22, 2024Determining JSON types in BigQueryHere's a mildly interesting function if you're working with JSON in BigQuery. JSON_TYPE takes in a JSON value and returns the name of the respective JSON type (object, array, string, number, boolean, null) as a STRING. See below an illustration of it...Practical BigQuerybigqueryAdd a thoughtful commentNo comments yetBe the first to start the conversation.