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

Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.