SQL primer

 

Warning: You must assign the Invoker role (roles/run.invoker) through Cloud Run if you want to allow the function to receive requests from additional principals or other given authorities in IAM.

Note: if you want to achieve the equivalent of assigning the Cloud Functions "Admin" or "Developer" role to a Cloud Run function 1st gen, you need to assign Cloud Functions "Admin" or "Developer" to this function and assign "Cloud Run Invoker" to the Cloud Run service.

$

gcloud functions add-invoker-policy-binding badd \

      --region="us-central1" \

      --member="MEMBER_NAME"

Learn more 

This warning means that if you want to allow other users or services to call your Cloud Run function, you need to specifically grant them the "Cloud Run Invoker" role (identified as "roles/run.invoker") directly through the Cloud Run service in your Google Cloud console, not through a different service or by using a different IAM role name; essentially, you must manage access to your Cloud Run function using Cloud Run's specific permissions system. 

https://stackoverflow.com/questions/75711486/gcp-functions-gen2-you-must-assign-the-invoker-role

SQL Data Types

In MySQL there are three main data types: string, numeric, and date and time.