I have created a cloud function called “process” from 2st gen. Now I need to call it from a procedure I created in bigquery:

CREATE OR REPLACE PROCEDURE `project-dev.dataset.testCF`()
OPTIONS(strict_mode=false)
BEGIN

  DECLARE response STRING;

  SET response = (

    SELECT *
    FROM EXTERNAL_QUERY(
      CONNECTION_ID("https://europe-west1-project-dev.cloudfunctions.net/process")
    )

  );

  SELECT response;

END;

This procedure returns the following error: Unexpected TVF argument type found, expecting literal, query parameter, or variable of type STRING

I also need to know if this is the best way to call a cloud function from biguqery? or if it is not possible to call her directly