BigQuery Alter schema set options
Sets the dataset level options
Alter schema set options example
ALTER SCHEMA mydataset
SET OPTIONS(
default_table_expiration_days=30
)
Explanation
schema_set_options_list: List of arguments
| grantee_list types | |
|---|---|
| user:{emailid} | An email address that represents a specific Google account. Example: user:alice@example.com |
| serviceAccount:{emailid} | An email address that represents a serviceaccount. Example: serviceAccount:my-other-app@appspot.gserviceaccount.com |
| group:{emailid} | An email address that represents a Google group. Example: group:admins@example.com |
| domain:{domain} | The Google Workspace domain (primary) that represents allthe users of that domain. Example: domain:example.com |
| allAuthenticatedUsers | A special identifier that represents all serviceaccounts and all users on the internet who have authenticated with aGoogle Account. This identifier includes accounts that aren't connected to aGoogle Workspace or Cloud Identity domain, such as personal Gmail accounts.Users who aren't authenticated, such as anonymous visitors, aren't included. |
| allUsers | A special identifier that represents anyone who is on the internet, including authenticated and unauthenticated users. Because BigQuery requires authentication before a user can access the service, allUsers includes only authenticated users. |
Syntax reference
ALTER SCHEMA [IF EXISTS] [project_name.]dataset_name SET OPTIONS(schema_set_options_list)