Best Practices for Column Descriptors

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 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 example, if the data type is int32, do not ask to round to zero decimal places

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