Question:

Why is the column that was selected for the Primary Key in my .yml file appearing as the first column in a table?

Answer:

The proper way to define a Primary Key in a .yml file through the FTP Intelligent Connector is to set it at the TableLevel at the top of the .yml file.

Example: name: xx_xxx_xxxx_stg__v
distStyle: key
distKey: example_customer__v
tableName: xx_xxx_xxxx_stg__v
primaryKey: xxx_xxxx__v Setting the Primary Key at this level ensures that the key is properly marked without modifying the layout or structure of tables.

Related Documentation:

Nitro Support Documentation: N/A