How to Fix a Schema Mismatch When Updating Data

When you update datasets on Socrata with a source file that has different column names you end up with a schema mismatch. To fix this:

  1. Select "Edit" to open a draft of your dataset for editing.
  2. Select "Add Data."
  3. Select your new data file.
  4. When the "Column Mismatch" warning pops up, match the name of your Dataset Column (left) with the column name in your source file (right)
  5. Select "Save."
  6. Publish your update!

From now on, Socrata will remember that the column named 'Surname' in your source file should be imported into the column named 'Last Name' in your dataset.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.