Skip to content

Add ID for each import to enable use of incremental syncs #22

@Dynnammo

Description

@Dynnammo

We'll use an ELT tool to synchronize data.

We therefore need to have an id column, uniq for each line.

  • Adapt the script to create a column id with computed hash
  • Import function to_sql must use such column

Documentation :
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html
https://stackoverflow.com/questions/51178961/hash-each-row-of-pandas-dataframe-column-using-apply

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions