Create target table

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2025

To create a table in target BigQuery and SQL server, and catalog the data connection, follow these steps:

Note: The clustering option is now available for BigQuery target tables in continuous replication pipelines.
  1. Select a schema and the tables will populate.
  2. Click Next, if the target table(s) have a red icon (X), the tables do not exist.
  3. Click the Create target tables if it does not exist option. The icons change from a red (X) to a yellow (!).
  4. If you want to modify column mapping for a particular table, click Map Fields to open the Map Fields page and change options in the Action column and click Save.
  5. Click Next to perform a bulk table creation on the dataset.
  6. The Creating Datasets page displays with a status for the number of target tables created. If the cataloging failed, go to Connections > Data Catalog Connections and verify the cataloging status.

While the Creating Datasets page is processing, the navigational is grayed-out. If you want to navigate to other sections, click the Data Integrity Suite banner.