Jasper Ideas

Add BigQuery support for Records and repeated fields when creating domains.

BigQuery extends the standard SQL model by supporting Records and Repeated fields (and, if you add those two things together, repeated records). Domains in JasperSoft have no support for these whatsoever.

While workarounds (derived tables) can be used in some cases, they are mostly less than ideal, and almost always much more expensive to use (BigQuery charges by the amount of processing time/data used)due to how derived tables must be written.

A repeated record can be thought of as a pre-joined table (without the need for foreign keys). In BigQuery SQL, repeated records are accessed using the UNNEST() function, and can be treated similarly as a table join. They can be CROSS joined, OUTER LEFT joined, etc. They can have an ON condition (helpful for pre-filtering). They can have multiple level of nesting. They are, in essence, very handy structures.

Likewise, records are helpful grouping structures, but Domains don't understand them, either. They leave out the record container name, which creates problems when multiple records have the same inner field name. It makes them unusable in Domains, unless used as a derived table, and, as stated above, this can be a very expensive workaround with BigQuery.

  • Corey Pennycuff
  • Sep 28 2021
  • Under consideration
Components Domains
  • Attach files
  • Admin
    Damayanti Anand commented
    8 Nov, 2021 10:38am

    Thanks for bringing this to our notice. We will get back to you shortly.