[Feature] Allow import of sheets with no header row

[optroodt]

Configurable header row
I can imagine having a sheet that does now have a header row. Currently that row would be skipped, resulting in data loss. Ideally the .yml config should have an option to indicate if the first row is a header (default) or not.

[bastienboutonnet]

Great one, thanks @optroodt should be really quick to add that so I'll make sure it makes it into the next release

[jflairie]

@optroodt can you provide a use case? As there are no column names to grab, and as Snowflake requires column names to create a table, would you like the ability to provide column names in the sheets.yml?

[bastienboutonnet]

One of the things we should definitely do is to ensure that columns are named in a consistent manner.

When pandas is not given a header it will create integer columns which are really quite annoying. We should therefore quickly replace the columns with a schema such as column_<index>.

We then should allow users to provide a list of columns names in the sheets.yml config. If they do not then the predictable naming schema will ensure that when we push the data to the database we can have predictable columns.