Hi - I'm trying to create a delta table with

write_deltalake

It raises `deltalake.PyDeltaTableError: Schema error: Invalid data type for Delta Lake: Null`error if there is a column with all none values. Is there a way to solve this? E.g. define the schema for table or define column type

import pandas as pd
from deltalake.writer import write_deltalake

data = [['tom', None], ['nick', None], ['juli', None]]
data = pd.DataFrame(data, columns=['Name', 'City'])
write_deltalake("s3a://.....", data, mode='overwrite')

I think doing a create table statement and then appending those records should work

Create table with spark? Isn't there a solution with pure python?

you can create an empty dataframe in python and write that.