Open swainjo opened 1 year ago
error when calling get_bytes_transferred remote function created by: bytes_transferred/create_remote_function.sh
Test SQL to repro in BQ: SELECT 'cdmc-gov-388611.remote_functions.get_bytes_transferred'('bytes', 'cdmc-confdata-388611', 'crm', 'AddAcct');
SELECT 'cdmc-gov-388611.remote_functions.get_bytes_transferred'('bytes', 'cdmc-confdata-388611', 'crm', 'AddAcct');
Error Received response code 400 from endpoint https://us-central1-cdmc-gov-388611.cloudfunctions.net/get_bytes_transferred with response {"errorMessage": "403 GET https://bigquery.googleapis.com/bigquery/v2/projects/cdmc-confdata-388611/datasets/crm?prettyPrint=false: Access Denied: Dataset cdmc-confdata-388611:crm: Permission bigquery.datasets.get denied on dataset cdmc-confdata-388611:crm (or it may not exist)."}.
Diagnosis: Unsure what permissions are required, I am running the query under admin context in console.
error when calling get_bytes_transferred remote function created by: bytes_transferred/create_remote_function.sh
Test SQL to repro in BQ:
SELECT 'cdmc-gov-388611.remote_functions.get_bytes_transferred'('bytes', 'cdmc-confdata-388611', 'crm', 'AddAcct');Error Received response code 400 from endpoint https://us-central1-cdmc-gov-388611.cloudfunctions.net/get_bytes_transferred with response {"errorMessage": "403 GET https://bigquery.googleapis.com/bigquery/v2/projects/cdmc-confdata-388611/datasets/crm?prettyPrint=false: Access Denied: Dataset cdmc-confdata-388611:crm: Permission bigquery.datasets.get denied on dataset cdmc-confdata-388611:crm (or it may not exist)."}.
Diagnosis: Unsure what permissions are required, I am running the query under admin context in console.