Edit

Share via

Troubleshoot the Azure Database for PostgreSQL connector in Data Factory in Microsoft Fabric

This article provides suggestions to troubleshoot common problems with the Azure Database for PostgreSQL connector in Data Factory in Microsoft Fabric.

Error code: 23704 - AzurePostgreSqlNpgsqlDataTypeNotSupported

  • Message: The data type of the chosen Partition Column, '%partitionColumn;', is '%dataType;' and this data type is not supported for partitioning.

  • Recommendation: Pick a partition column with int, bigint, smallint, serial, bigserial, smallserial, timestamp with or without time zone, time without time zone or date data type.

Error code: 23705 - AzurePostgreSqlNpgsqlPartitionColumnNameNotProvided

  • Message: Partition column name must be specified.

  • Cause: No partition column name is provided, and it couldn't be decided automatically.

Related content

For more troubleshooting help, try these resources: