Skip to content

array_contains

array_contains(arr, value)

Description

Returns true if value is in array arr else returns false

Usage

Call or Deploy array_contains ?
Call array_contains directly

The easiest way to use bigfunctions

  • array_contains function is deployed in 39 public datasets for all of the 39 BigQuery regions.
  • It can be called by anyone. Just copy / paste examples below in your BigQuery console. It just works!
  • (You need to use the dataset in the same region as your datasets otherwise you may have a function not found error)

Public BigFunctions Datasets

Region Dataset
eu bigfunctions.eu
us bigfunctions.us
europe-west1 bigfunctions.europe_west1
asia-east1 bigfunctions.asia_east1
... ...
Deploy array_contains in your project

Why deploy?

  • You may prefer to deploy array_contains in your own project to build and manage your own catalog of functions.
  • This is particularly useful if you want to create private functions (for example calling your internal APIs).
  • Get started by reading the framework page

Deployment

array_contains function can be deployed with:

pip install bigfunctions
bigfun get array_contains
bigfun deploy array_contains

Examples

1. When value is in array

select bigfunctions.eu.array_contains([3, 4], 4)

select bigfunctions.us.array_contains([3, 4], 4)

select bigfunctions.europe_west1.array_contains([3, 4], 4)

+-------------+
| is_in_array |
+-------------+
| true        |
+-------------+

2. When value is not in array

select bigfunctions.eu.array_contains([3, 4], 7)

select bigfunctions.us.array_contains([3, 4], 7)

select bigfunctions.europe_west1.array_contains([3, 4], 7)

+-------------+
| is_in_array |
+-------------+
| false       |
+-------------+
Need help or Found a bug?
Get help using array_contains

The community can help! Engage the conversation on Slack

We also provide professional suppport.

Report a bug about array_contains

If the function does not work as expected, please

  • report a bug so that it can be improved.
  • or open the discussion with the community on Slack.

We also provide professional suppport.

Show your ❤ by adding a ⭐ on