dlt-hub/dlt
make the use of `loader_file_format` parameter consistent
Offen
#815 geöffnet am 11.12.2023
QoLgood first issue
Repository-Metriken
- Stars
- (5.765 Sterne)
- PR-Merge-Metriken
- (Durchschn. Merge 7T 7h) (54 gemergte PRs in 30 T)
Beschreibung
Background
The loader_file_format can be configured on the pipeline level and this is fine. But technically it is a normalize setting and we should be able to configure it there as well.
Also not all data types are supported by all formats on all destinations. We should detect those and fail early.
Tasks
-
- add
loader_file_formatto normalize configuration and use it to set the file format. If the explicit value is passed from the pipeline, it has the precedence.
- add
-
- add the exceptions to destination capabilities where we declare unsupported types per file format. Take the current cases from particular destination code (ie Bigquery and Snowflake have plenty of exceptions)
-
- detect such exceptions in normalize (preferably in worker: before updating a schema check if any type is on exception list and raise exception with an explanation)
-
- the behavior above must be tested