Issue 1:
Superset version

{"GIT_SHA": "", "version": "0.24.0"}

Expected results

I create a table from a request (sql lab) -> Superset view

How to copy this table (with sql) without losing the filled "verbose name" fields ?

I would like to use the same table but on different schemas

Issue 2:
Hi, I am trying to bring up superset version 0.37.2 while using sqlLite for metadata. However, the service fails to start with an error. Can someone please help with this?

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table sqlatable_user already exists1

Actual results

File "/appvenv/bin/superset", line 21, in

superset()

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 829, in call

return self.main(*args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/flask/cli.py", line 586, in main

return super(FlaskGroup, self).main(*args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 782, in main

rv = self.invoke(ctx)

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1259, in invoke

return _process_result(sub_ctx.command.invoke(sub_ctx))

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1259, in invoke

return _process_result(sub_ctx.command.invoke(sub_ctx))

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1066, in invoke

return ctx.invoke(self.callback, **ctx.params)

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 610, in invoke

return callback(*args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/click/decorators.py", line 21, in new_func

return f(get_current_context(), *args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/flask/cli.py", line 426, in decorator

return __ctx.invoke(f, *args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/click/core.py", line 610, in invoke

return callback(*args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/flask_migrate/cli.py", line 134, in upgrade

_upgrade(directory, revision, sql, tag, x_arg)

File "/appvenv/lib/python3.6/site-packages/flask_migrate/init.py", line 96, in wrapped

f(*args, **kwargs)

File "/appvenv/lib/python3.6/site-packages/flask_migrate/init.py", line 271, in upgrade

command.upgrade(config, revision, sql=sql, tag=tag)

File "/appvenv/lib/python3.6/site-packages/alembic/command.py", line 298, in upgrade

script.run_env()

File "/appvenv/lib/python3.6/site-packages/alembic/script/base.py", line 489, in run_env

util.load_python_file(self.dir, "env.py")

File "/appvenv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file

module = load_module_py(module_id, path)

File "/appvenv/lib/python3.6/site-packages/alembic/util/compat.py", line 184, in load_module_py

spec.loader.exec_module(module)

File "", line 678, in exec_module

File "", line 219, in call_with_frames_removed

File "/appvenv/lib/python3.6/site-packages/superset/migrations/env.py", line 124, in

run_migrations_online()

File "/appvenv/lib/python3.6/site-packages/superset/migrations/env.py", line 116, in run_migrations_online

context.run_migrations()

File "", line 8, in run_migrations

File "/appvenv/lib/python3.6/site-packages/alembic/runtime/environment.py", line 846, in run_migrations

self.get_context().run_migrations(**kw)

File "/appvenv/lib/python3.6/site-packages/alembic/runtime/migration.py", line 522, in run_migrations

step.migration_fn(**kw)

File "/appvenv/lib/python3.6/site-packages/superset/migrations/versions/3e1b21cd94a4_change_owner_to_m2m_relation_on.py", line 75, in upgrade

sa.PrimaryKeyConstraint("id"),

File "", line 8, in create_table

File "", line 3, in create_table

File "/appvenv/lib/python3.6/site-packages/alembic/operations/ops.py", line 1252, in create_table

return operations.invoke(op)

File "/appvenv/lib/python3.6/site-packages/alembic/operations/base.py", line 373, in invoke

return fn(self, operation)

File "/appvenv/lib/python3.6/site-packages/alembic/operations/toimpl.py", line 101, in create_table

operations.impl.create_table(table)

File "/appvenv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 259, in create_table

self._exec(schema.CreateTable(table))

File "/appvenv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 141, in _exec

return conn.execute(construct, *multiparams, **params)

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute

return meth(self, multiparams, params)

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection

return connection._execute_ddl(self, multiparams, params)

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1073, in _execute_ddl

compiled,

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in execute_context

e, statement, parameters, cursor, context

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in handle_dbapi_exception

sqlalchemy_exception, with_traceback=exc_info[2], from=e

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise

raise exception

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context

cursor, statement, parameters, context

File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute

cursor.execute(statement, parameters)

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table sqlatable_user already exists

How to reproduce the bug

Try to bring up superset version 0.37.2

Configure sqlLite to store metadata info.

Environment

superset version: 0.37.2

python version: python3.6

node.js version: v10.23.0

Checklist

Make sure to follow these steps before submitting your issue - thank you!

[ Y] I have checked the superset logs for python stacktraces and included it here as text if there are any.

[ Y] I have reproduced the issue with at least the latest released version of superset.

[ Y] I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.