About axjia

axjia · 08-12-2018

I’ve developed some BigQuery UDFs (to remove non-business time between two timestamps) that we’re currently leveraging through sql_preamble in our explores, but I can’t seem to find a way to use them in a PDT – or a derived table of any sort for that...

axjia · 08-18-2018

Oh man, that’s a heck of a workaround! I gave it a shot – it works great for derived tables, but doesn’t work in the sql_preamble for some reason. All in all though, maintaining the util functions in two places (util view and util explore with preamb...

axjia · 08-14-2018

Hi Bernard, Just to clarify – I’ve already followed the process outlined in this thread ([Analytic Block] Weighted Medians in BigQuery with UDFs) to define UDFs and leverage them in defining dimensions / measures! The use case here is not leveraging ...

axjia · 08-12-2018

Okay, did more experimenting: Got the 2nd solution (copy-pasting UDFs directly into a derived table) to work by adding persistence – when materializing the view, it isn’t put into a subquery. Which is nice. Also got it working with sql_create – nothi...

My Stats

alan_terlep-164's Bio

Badges axjia Earned

Recent Activity

BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)

Re: BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)

Re: BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)

Re: BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)