Create target table - Precisely Data Integrity Suite

Data Integrity Suite

Product
Spatial_Analytics
dis_mcp
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
platform_spatial_analytics
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Precisely MCP
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
2026

To create a table in target BigQuery, SQL server, Snowflake, or Databricks 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. Select Next. If the target tables have a red icon (X), the tables do not exist.
  3. Select 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, select Map Fields to open the Map Fields page and change options in the Action column and select Save .
    Note: When creating a single table, table creation is initiated after you configure Map Fields (if Create table if not exists is selected) and select Save.
  5. Select 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, navigation is unavailable. To open other pages, select the Data Integrity Suite banner.

Note:

BigQuery clustering behavior

When you create target tables in BigQuery, clustering works differently depending on how the tables are created. If you are creating more than one table and clustering is enabled:

  • Tables are created with a CLUSTER BY clause.
  • The cluster by fields are taken from up to the first four columns of the unique index or primary key for the source table. If there are fewer than four columns, only the available columns are used.
  • These fields are automatically selected based on the key or index for the source table.

Single table creation

When creating a single table:
  • Clustering fields are based on the first four columns of the DKey.
  • The DKey columns can be chosen by you.
  • This is different from bulk creation, where clustering is always based on the key or index for the source table.
Kafka limitation

For Kafka targets:

  • The following options are currently not supported :
    • Create topic if it does not exist
    • Create subject if it does not exist

You must configure these options before you proceed.

Databricks target tables

Preview: This feature is currently in Preview for select workspaces and might be subject to change before general availability.

When a mapped Databricks target table does not exist, select Create target tables if it does not exist and then select Next. The status for each table appears while the tables are created.

To create one target table while you update its column mappings, open Map Fields and select Save. If a target table already exists, resolve the conflict by selecting a different target table or removing the existing table before you try again.