Favian Hazman

Spec with explicitly stated schema (`AutoDetect = False`) ``` name: project.dataset.table type: external_table version: 1 spec: schema: - name: column_name type: STRING source: type: google_sheets uris: - https://docs.google.com/spreadsheets/d/spreadsheet_id config: range:...

Yes it will, user will only need to explicitly provide a schema if there is a column renaming use case or if the spreadsheet do not provide any header row

Hi @kushsharma , thanks for reviewing. I've added an example in the latest commit https://github.com/odpf/transformers/pull/10/commits/a95c38d5d6e375223c4597c738ba4f4ec76cf5ad.