Unable to upload csv to database

[ShubhamSharmaCSE]

Bug description

Getting the below error when doing a csv upload:

Unable to upload CSV file "sankey_sample_working.csv" to table "SankeySampleTest" in database "cube". Error message: (psycopg2.errors.FeatureNotSupported) Unsupported query type: CREATE TABLE public."SankeySampleTestSharma" (source TEXT, target TEXT, total_count BIGINT) QUERY: CREATE TABLE public."SankeySampleTestSharma" (source TEXT, target TEXT, total_count BIGINT) [SQL: CREATE TABLE public."SankeySampleTestSharma" ( source TEXT, target TEXT, total_count BIGINT ) ] (Background on this error at: https://sqlalche.me/e/14/tw8g)

Enabled the csv upload from the database connection table. Added CSV_EXTENSIONS = {'csv'}, ENABLE_CSV_EXPORT = True to the superset_config.py.

Is the issue with postgres driver that it does not have the feature to do create table?

Or is there any restriction on the create operations on the database? Seems like it should have the permission to do that operation.

How to reproduce the bug

Go to database connection. Select postgres, add connection settings for database, under security tab, enable allow csv file to upload. Post that go to upload csv to database under data section, upload a csv to the database. It will result in mentioned error.

Screenshots/recordings

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.

[dpgaspar]

Hi,

What database engine are you using? Also can you share your connection string