chris-bishop-tfs / data_io

5 stars 0 forks source link

Preserve Schema During Write by Default #44

Open chris-bishop-tfs opened 2 months ago

chris-bishop-tfs commented 2 months ago

mode='overwrite' drops and replaces data/tables, which can lead to schema changes without warning.

Worth considering issuing overwrite as a truncate=True by default to force the check

https://stackoverflow.com/questions/49650790/how-to-overwrite-data-with-pysparks-jdbc-without-losing-schema

chris-bishop-tfs commented 2 months ago

Add option here https://github.com/chris-bishop-tfs/data_io/blob/main/data_io/connection.py#L484