Datastore upload dag failing when field name have extra white space on the schema.
Open
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 34
- Forks
- 8
- Avg merge
- 2d 22h
- Merged PRs (30d)
- 1
Description
api_ckan_load_multiple_nodes dag failed when the schema fieldname has extra white space at end of name.
Steps to reproduce:
- Setup ckan instance with ckanext-blob-storage, ckanext-aircan extensions.
- Upload CSV file with extra space on the column header. eg. 'Field_Name '
- check the airflow task
create_datastore_table_tasklog, you will see the validation errors even tasks marked as successful.
Possible fix
check and remove whitespace from the schema field name on datapub while creating/generating a schema information
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing schema generation in datapub and reproduce the CSV upload with trailing whitespace in a column header. Then inspect the create_datastore_table_task log and verify that generated schema field names are normalized and the validation errors no longer occur.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100