Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema name and Table name are empty after CSV import #29568

Open
1 of 3 tasks
xavier-GitHub76 opened this issue Jul 12, 2024 · 1 comment
Open
1 of 3 tasks

Schema name and Table name are empty after CSV import #29568

xavier-GitHub76 opened this issue Jul 12, 2024 · 1 comment
Labels
data:csv Related to import/export of CSVs

Comments

@xavier-GitHub76
Copy link
Contributor

xavier-GitHub76 commented Jul 12, 2024

Bug description

Hello
I import a CSV file
A dataset is created
Schema name and Table name are empty after CSV import in "Source" section :
image

Best regards

How to reproduce the bug

See Bub description

Screenshots/recordings

No response

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

  • I have searched Superset docs and Slack and didn't find a solution to my problem.
  • I have searched the GitHub issue tracker and didn't find a similar bug report.
  • I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
@dosubot dosubot bot added the data:csv Related to import/export of CSVs label Jul 12, 2024
Copy link

dosubot bot commented Jul 12, 2024

The Schema name and Table name fields are empty in the "Source" section after importing a CSV file into Superset because the schema and table name are not mandatory fields in the CSV upload schema. The schema field is optional, and the table_name field is required but might not be populated correctly during the import process [1].

To manually set or correct the schema and table name fields after a CSV import, follow these steps:

  1. Navigate to the Datasets Page: Go to the "Datasets" section in Superset.
  2. Select the Dataset: Find and select the dataset that was created from the CSV import.
  3. Edit Dataset: Click on the "Edit" button to modify the dataset's settings.
  4. Set Schema and Table Name:
    • Schema: In the edit form, locate the field for the schema name and set it to the desired schema.
    • Table Name: Similarly, find the field for the table name and set it to the correct table name.
  5. Save Changes: After setting the schema and table name, save the changes to update the dataset configuration [1].

These steps should resolve the issue with the empty Schema name and Table name fields.

To continue talking to Dosu, mention @dosu.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data:csv Related to import/export of CSVs
Projects
None yet
Development

No branches or pull requests

1 participant