To connect BigQuery to Gravity, you need the following:
- A BigQuery account or a Google Apps account
- Gravity account owner permission to add destinations
- 4.Select + Add.
- 5.In the New Members field, enter the name of the Service Account you created in Step 2, which is the entire email address.
- 6.Click Select a role > BigQuery > BigQuery User.
Set bucket access control
Assign permissions to service account
You must give the service account Storage Object Admin permission for the bucket, so that it can read and write the data from the bucket.
- 2.Select the bucket you want to use.
- 3.Go to Permissions and then click Add Members.
- 4.In the Add members window, enter the Service Account name
- 5.From the Select a role dropdown, select Storage Object Admin.
Set the life cycle of objects in the bucket
You must set a lifecycle rule so that data older than one day is deleted from your bucket.
- 2.In the list, find the bucket you are using for Gravity, and in the Lifecycle rules column, select its rules.
- 3.Click Add rule. A detail view will open.
- 4.In Select object conditions, select Age and enter 1.
- 5.Click Continue.
- 6.In Select action, select Delete.
- 7.Click Continue and then click Save.
- 1.Choose Service Account Key file
- 2.Insert Service Account Email
- 3.Insert Project Name
- 4.Set Timeout
- 5.Click Save, Test, and Publish
- Test checks connectivity to BigQuery and permission to create datasets and tables on your BigQuery warehouse.
- create a dataset to check if we have
bigquery.datasets.createpermissions on your data warehouse.
- create a table in the dataset (