IIS-CONN-GP-01030W    In the input link schema, the following distribution key columns from the table_name table were not found: column_name. The temporary table will use a random distribution.

Explanation

When the connector creates a staging table, the connector tries to use the same distribution mechanism as the target table. The target table uses hash distribution to organize the database table, and one or more distribution key columns are missing from the link. Because the connector cannot use hash distribution, the connector uses random distribution for the staging table that it creates.

User response

To suppress the warning message, make sure that all distribution key columns are present on the link and that their data types match the data types of the columns in the target table so that the distribution of the staging table matches the distribution of the target table.