Question

BigQuery: How to filter out nulls from ARRAYS of STRUCT

score 18 · Answer 1 · 2024-03-28T18:49:15.297000

18

Views

BigQuery: How to filter out nulls from ARRAYS of STRUCT

Published on 28 March 2024 at 18:49

score 71 · Answer 2 · 2024-03-20T13:17:32.080000

71

Views

Is there an alternative function for unnest_longer()?

Published on 20 March 2024 at 13:17

score 46 · Answer 3 · 2024-03-13T08:04:55.913000

46

Views

Unnest all nested rows (GA4/BigQuery)

Published on 13 March 2024 at 08:04

score 24 · Answer 4 · 2024-03-10T19:39:54.243000

24

Views

How to Unnest hours and categories them using Bigquery?

Published on 10 March 2024 at 19:39

score 40 · Answer 5 · 2024-02-26T10:19:31.203000

40

Views

QUERY ERROR - Duplicate alias offset found

Published on 26 February 2024 at 10:19

score 47 · Answer 6 · 2024-02-21T20:34:06.597000

47

Views

How to avoid duplicates while doing unnest of multiple columns based on comma delimiter in bigquery?

Published on 21 February 2024 at 20:34

score 58 · Answer 7 · 2024-02-14T19:45:00.510000

58

Views

How to unnest a "list" in a martix?

Published on 14 February 2024 at 19:45

score 36 · Answer 8 · 2024-02-12T17:34:24.460000

36

Views

How to unnest and order an array

Published on 12 February 2024 at 17:34

score 129 · Answer 9 · 2024-01-26T20:28:35.613000

129

Views

alias a table returning function (UNNEST) using pypika

Published on 26 January 2024 at 20:28

score 188 · Answer 10 · 2023-12-12T11:55:53.830000

188

Views

Unnest elements of each object in Trino/Presto

Published on 12 December 2023 at 11:55

score 106 · Answer 11 · 2023-11-17T20:04:37.053000

106

Views

Using BigQuery SQL to split nested values on multiple columns

Published on 17 November 2023 at 20:04

score 71 · Answer 12 · 2023-10-24T07:56:27.487000

71

Views

Cannot access field criteria on a value with type ARRAY<STRUCT<id STRING, totalResults INT64, resultType STRING, ...>>

Published on 24 October 2023 at 07:56

score 49 · Answer 13 · 2023-10-10T15:01:59.783000

49

Views

Combine data of 2 tables with same array struct in Bigquery

Published on 10 October 2023 at 15:01

score 56 · Answer 14 · 2023-10-06T02:18:47.260000

56

Views

Unnesting a JSON Stringified data that was stored in a STRING Column, not RECORD Column

Published on 06 October 2023 at 02:18

score 49 · Answer 15 · 2023-09-20T10:42:59.770000

49

Views

How to break down a string into separate lines in BigQuery?

Published on 20 September 2023 at 10:42

score 39 · Answer 16 · 2023-09-08T22:56:39.050000

39

Views

BigQuery extract fields from unnested json

Published on 08 September 2023 at 22:56

score 79 · Answer 17 · 2023-08-28T07:17:30.450000

79

Views

Postgresql, json, query

Published on 28 August 2023 at 07:17

score 208 · Answer 18 · 2023-08-24T14:41:54.493000

208

Views

Unnest array in Redshift using SQL SELECT statement

Published on 24 August 2023 at 14:41

score 57 · Answer 19 · 2023-08-15T11:31:03.767000

57

Views

Unnesting lists inside a column using unnest_longer()

Published on 15 August 2023 at 11:31

score 108 · Answer 20 · 2023-08-04T19:07:11.867000

108

Views

Is there an alternative to tidyr::unnest_wider? It fails when nested list element is not a vector

Published on 04 August 2023 at 19:07

List Question

BigQuery: How to filter out nulls from ARRAYS of STRUCT

Is there an alternative function for unnest_longer()?

Unnest all nested rows (GA4/BigQuery)

How to Unnest hours and categories them using Bigquery?

QUERY ERROR - Duplicate alias offset found

How to avoid duplicates while doing unnest of multiple columns based on comma delimiter in bigquery?

How to unnest a "list" in a martix?

How to unnest and order an array

alias a table returning function (UNNEST) using pypika

Unnest elements of each object in Trino/Presto

Using BigQuery SQL to split nested values on multiple columns

Cannot access field criteria on a value with type ARRAY<STRUCT<id STRING, totalResults INT64, resultType STRING, ...>>

Combine data of 2 tables with same array struct in Bigquery

Unnesting a JSON Stringified data that was stored in a STRING Column, not RECORD Column

How to break down a string into separate lines in BigQuery?

BigQuery extract fields from unnested json

Postgresql, json, query

Unnest array in Redshift using SQL SELECT statement

Unnesting lists inside a column using unnest_longer()

Is there an alternative to tidyr::unnest_wider? It fails when nested list element is not a vector

Trending Questions

Popular # Hahtags

Popular Questions