CODEWITHSUNDEEP
google-bigquerygoogle-cloud-platform
andre622
andre622

Reputation: 515

Referencing other tables in BigQuery UDF as lookups

Is there any way to reference other tables within a Project/Dataset from a BigQuery UDF as lookup tables? I have read the documentation here which indicates that it is not possible in Standard SQL; any chance it is available in Legacy?

Also, while I understand that similar behavior can be accomplished with a join, being able to directly reference lookup tables would be infinitely cleaner.

Any other methods of accomplishing similar lookup-type functionality would be appreciated.

Upvotes: 0

Views: 1075

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33705

This is not currently possible, but you may be interested in the following feature requests:

Upvotes: 1

Related Questions