Create a BigQuery workload
This guide shows you how to set up encryption keys in the Assured Workloads environment using Google Cloud console, and then use the keys to secure BigQuery. For more information about Assured Workloads, see the Assured Workloads overview.
Before you begin
You must be a project owner, an org admin, or have security access to the project. For first-time users, see Get started with Assured Workloads.
Choose an encryption strategy.
Create a folder in the Assured Workloads environment that supports your compliance regime, as follows:
Select the project ID for the project that contains your Assured Workloads CMEK keys. If you chose IL4 or CJIS as a compliance regime, then, by default, this project is created for you.
Create the key
To create the CMEK key, do the following:
In Google Cloud console, go to Cryptographic Keys:
Select the Assured Workloads CMEK project. By default, this project ID starts with
Click your key ring.
Click Create Key.
In the What type of key do you want to create? drop-down list, select Generated key.
In Key name enter the key name.
In the Protection level drop-down list, select Software.
In the Purpose drop-down list, select Symmetric encryption/decryption.
In the Rotation period drop-down list, select 90 days.
Optional: To add a label, do the following:
- Click Add a label.
- Enter a key in the Key text field.
- Enter a value in the Value text field.
You see that the key was created.
Obtain your CMEK key resource ID
- In Google Cloud console, in the Project Selector, select the project ID
for the project that contains your CMEK keys. By default, if
Assured Workloads creates this project, it prepends the project ID
In Security, go to Cryptographic Keys:
Under Key rings, click the key ring name.
In Key ring details, in the Keys tab, click the name of the key.
Click the more_vertMore icon to the right of the key name.
Click Copy Resource Name.
The resource string is formatted as follows:
Use the key in BigQuery
Go to BigQuery.
In the Project Selector, select the Assured Workloads resource project in which you want to create the BigQuery resource.
In Explorer, click more_vert next to the project in which you want to create the dataset.
Click Create dataset.
Dataset IDfield, enter a unique dataset name.
(Optional) In the Data location drop-down list, choose a geographic location for the dataset. If the value is set to
Default, the location is set to
US. After a dataset is created, the location can't be changed.
In the Default table expiration drop-down list, select one of the following options:
- Never: (Default) BigQuery never deletes tables created in the dataset. You must delete them manually.
- Number of days after table creation: This value determines when BigQuery deletes a newly created table in the dataset. This value is applied if you don't set a table expiration when you create the table.
For Encryption, select
- If you do not see your key, select Don't See Your Key? Enter Key Resource ID.
- The Enter key resource ID dialog appears.
- Follow the instructions in Obtain your CMEK key resource ID, earlier in this guide.
- Paste the key into the Key resource ID field.
- Click Grant.
- Click Create dataset.
If you didn't create a Customer Managed Encryption Key (CMEK) project when you set up Assured Workloads:
- Select Google-managed encryption key.
- Click Create dataset.
- Learn how to delete a workload environment.