I have an example dataset, and I can use the headers of that dataset to create a schema, but how can I create a schema with the data types already populated (inferred from the data types observed in the dataset)?
For example: Dataset with 4 columns and at least one row of data (more if needed).
BILL_ID:228747
BILL_CUSTOMER_NAME:“TOM JONES”
BILL_TYPE:INTERNAL
BILL_DATE:“2019-02-02”
And I want to load this (successfully did that), then use as template to populate new schema that coverts the above into the following:
BILL_ID (DIGITAL SEQUENCE:######)
BILL_CUSTOMER_NAME (CHARACTER SEQUENCE:@@@@@@@@@)
BILL_TYPE (CHARACTER SEQUENCE:^^^^^^^^)
BILL_DATE (DATE:dd/mm/yyyy)