Best Practices for Column Descriptors

1. Define valid data that can be stored in the is column.

2. Do not specify the source data. Focus on the destination column.

3. Column Descriptors are tied to the destination table. If multiple Wranglers are pointed to the same table, they share the same descriptors.

4. Provide examples

5. Tell us how you want us to handle null

6. Tell us how you want us to handle errors; even provide an example

7. Be careful not to create contradictions between the data type and the column descriptor. For instance, if the data type is int32, do not ask to round to zero decimal places.

8. If information is already in a descriptor, be careful of deleting it, especially if it is being shared across Wranglers. It is best practice to add to a description by editing the descriptor rather than deleting it.