Recreate GBQ tables and views in your BigQuery dataset

Learn how to recreate tables and views in the BigQuery dataset you created.

After configuring the GBQ connector, the data schema changes.

To recreate tables and views send this request:

POST http://{{dphUrl}}/api/tenants/{{ternantId}}/adapters/{{adapterName}}/actions/recreate_objects
{"types": ["tables", "views"]}

If you only need to recreate tables, remove views from the request body. If you only need to recreate views, remove tables from the request body.


Parameter Name	Required	Values/Description
`types`	Yes	`types` requires values as an array. The accepted values are: `views` – Recreates all views. View recreation is an asynchronous job in BigQuery. `tables` – Recreates all tables. Table recreation happens synchronously.
`force`	No	Accepted values: `true` / `false` `true` – Forces table recreation to ensure that the new schema is reflected. `false` – Tables will be created if absent. If present, they will be skipped. Note: This parameter applies only to tables. Views are always replaced with new content.
`tableName`	No	Accepted values: `entity` `entity<entityType>` (e.g., `entityHCP`) `relation` `relation<relationType>` (e.g., `relationHasAddress`) `interaction` `interaction<interactionType>` (e.g., `interactionTransaction`) `match` `merge` `links` `activity`

After you recreate the tables and views, validate if the GBQ tables and views recreation command is successfully performed. You can verify if the tables and views are successfully recreated by sending the following request:

GET {{dphUrl}}/api/tenants/{{tenantId}}/adapters/{{adapterName}}/actions?actionType=recreate_objects

If the recreation is successful, you see a SUCCESS status in the response.

Note: If you're using the legacy column-based schema, you need to recreate the tables and views and re-sync data. You don't need to do this step if you're using the JSON schema.

Unify and manage your data

Recreate GBQ tables and views in your BigQuery dataset

Footer