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