Bigquery keyword Remote is not supported

Question

We are trying out the REMOTE functions within bigquery as per this guide. We created the CLOUD_RESOURCE using the following command :

bq mk --connection --display_name='get-rewards' --connection_type=CLOUD_RESOURCE --project_id=<redacted_place_holder> --location=EU get-rewards-connection

We can display the CLOUD_RESOURCE with the following command:

bq show --location=EU --connection  get-rewards-connection

Result :

                   name                    friendlyName   description    Last modified         type        hasCredential                                               properties                           

 ---------------------------------------- -------------- ------------- ----------------- ---------------- --------------- -----------------------------------------------------------------------------------------------------

  <redacted>.eu.get-rewards-connection   get-rewards                  <redacted_date>   CLOUD_RESOURCE   False           {"serviceAccountId": <redacted service account email>}

After I create the relevant dataset & table, I try to run the following query :

CREATE FUNCTION `<redacted`.tes_org_name>.test_jpp.get_rewards_points(guid STRING) RETURNS INT64

REMOTE WITH CONNECTION `<redacted>.eu.get-rewards-connection`

OPTIONS (endpoint = 'https://<redacted>.cloudfunctions.net/get-rewards-points')

The error I get :

Keyword REMOTE is not supported at [2:1]

What's going on here?