empty-table-hack.py

# Make sure the table is created in the db even if it's empty. This is ugly,
# including in that every column will have type `string`, but the types will be
# fixed up as soon as there's actual data to load
if count == 0:
    nulls_df = result_to_df([], field_info)
    nulls_df = pd.concat(
        [nulls_df, pd.DataFrame([{c: None for c in nulls_df.columns}])]
    )
    nulls_df.to_sql(
        # ...
    )
    connection.execute(f"delete from identifier('{schema}.{temporary_table}') ")