Configuration

PROJECT_IDS

Attribute	Value
Name	PROJECT_IDS
ID	BQMANAGER.PROJECT_IDS
Description	Configuration function used to determine which project_ids are included in the cross-project INFORMATION_SCHEMA functions.
Type	USER DEFINED FUNCTION
Arguments	None
Returns	project_ids ARRAY<STRING>
Dependencies	None

configuration: PROJECT_IDS

CREATE OR REPLACE FUNCTION [destination_project_id].BQMANAGER.PROJECT_IDS()
AS (
[
'project_id_1',
'project_id_2',
...
]    
)

execution: PROJECT_IDS

SELECT [project_id].BQMANAGER.PROJECT_IDS();