Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft Azure Synapse SQL Connector
  3. Connections for Microsoft Azure Synapse SQL
  4. Mappings for Microsoft Azure Synapse SQL
  5. Upgrading to Microsoft Azure Synapse SQL Connector
  6. Migrating a mapping
  7. SQL ELT optimization
  8. Data type reference
  9. Troubleshooting

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

IDENTITY column

IDENTITY column

You can use the IDENTITY column in mappings and
mapping
tasks.
Consider the following instructions when you use the IDENTITY column:
  • You can use the IDENTITY column only for insert operation.
  • Ensure that the metadata of the target object including the IDENTITY column matches the metadata fetched in an override.
  • You cannot enable dynamic schema change handling for the IDENTITY column.
  • You cannot define an IDENTITY column when you create a new target at runtime .
  • The IDENTITY column is not highlighted in the imported objects.

0 COMMENTS

We’d like to hear from you!