Sample BigQuery Remote Function

CREATE FUNCTION PTY_PROTECT_ALPHA ( val STRING ) 
  RETURNS STRING 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_ALPHA"),("op_type", "PROTECT")]
  );

CREATE FUNCTION PTY_UNPROTECT_ALPHA ( val STRING ) 
  RETURNS STRING 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_ALPHA"),("op_type", "PROTECT")]
  );

SELECT PTY_PROTECT_ALPHA ('Hello World')

SELECT PTY_UNPROTECT_ALPHA('rfDtw sLMJK');

CREATE FUNCTION PTY_PROTECT_NUMERIC ( val NUMERIC ) 
  RETURNS NUMERIC  
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_NUMERIC"),("op_type", "PROTECT")]
  );

CREATE FUNCTION PTY_UNPROTECT_NUMERIC ( val NUMERIC) 
  RETURNS NUMERIC 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_NUMERIC"),("op_type", "PROTECT")]
  );

SELECT PTY_PROTECT_NUMERIC ('123456789');

SELECT PTY_UNPROTECT_NUMERIC ('752513497');

CREATE FUNCTION PTY_PROTECT_DATEYYYYMMDD ( val date ) 
  RETURNS DATE 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_DATEYYYYMMDD"),("op_type", "PROTECT")]
  );

CREATE FUNCTION PTY_UNPROTECT_DATEYYYYMMDD ( val date ) 
  RETURNS DATE 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_DATEYYYYMMDD"),("op_type", "UNPROTECT")]
  );

SELECT PTY_PROTECT_DATEYYYYMMDD ('2020-12-31');

SELECT PTY_UNPROTECT_DATEYYYYMMDD('0653-06-01');

SELECT PTY_PROTECT_DATEYYYYMMDD ('31-DEC-2020');

SELECT PTY_UNPROTECT_DATEYYYYMMDD('01-JUN-0653');

SELECT PTY_PROTECT_DATEYYYYMMDD('12/31/2020');

SELECT PTY_UNPROTECT_DATEYYYYMMDD('06/01/0653');

CREATE FUNCTION PTY_PROTECT_DATETIME ( val DATETIME ) 
  RETURNS DATETIME 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_DATETIME"),("op_type", "PROTECT")]
  );

CREATE FUNCTION PTY_UNPROTECT_DATETIME ( val DATETIME ) 
              RETURNS DATETIME 
              REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
              OPTIONS (
    endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
    user_defined_context = [("data_element", "TOK_DATETIME"),("op_type", "UNPROTECT")]
              );

SELECT PTY_PROTECT_DATETIME('2010-10-25');

SELECT PTY_UNPROTECT_DATETIME('0845-04-04');

SELECT PTY_PROTECT_DATETIME('2010-10-25 10:45:33');

SELECT PTY_UNPROTECT_DATETIME('0845-04-04 10:45:33');

SELECT PTY_PROTECT_DATETIME('2010-10-25 10:45:33.123');

SELECT PTY_UNPROTECT_DATETIME('0845-04-04 10:45:33.123');

CREATE FUNCTION PTY_PROTECT_DECIMAL ( val DECIMAL ) 
  RETURNS DECIMAL 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_DECIMAL"),("op_type", "PROTECT")]
  );

CREATE FUNCTION PTY_UNPROTECT_DECIMAL ( val decimal ) 
  RETURNS decimal 
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_DECIMAL"),("op_type", "UNPROTECT")]
  );

SELECT PTY_PROTECT_DECIMAL (12345678.99);

SELECT PTY_UNPROTECT_DECIMAL (21872469.760000);

CREATE FUNCTION PTY_PROTECT_INTEGER ( val INTEGER ) 
  RETURNS INTEGER
  REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
  OPTIONS (
      endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
      user_defined_context = [("data_element", "TOK_INTEGER"),("op_type", "PROTECT")]
  );

CREATE FUNCTION PTY_UNPROTECT_INTEGER ( val INTEGER ) 
              RETURNS INTEGER
              REMOTE WITH CONNECTION `location.cloud-resource-connection-id`
              OPTIONS (
    endpoint ='https://<location-project-id>.cloudfunctions.net/<protect-function-name>',
    user_defined_context = [("data_element", "TOK_INTEGER"),("op_type", "UNPROTECT")]
              );

SELECT PTY_PROTECT_INTEGER (123456789);

SELECT PTY_UNPROTECT_INTEGER (1104108887);