<h3 dir="auto">Superset version</h3>
<p dir="auto">{"GIT_SHA": "", "version": "0.24.0"}</p>
<h3 dir="auto">Expected results</h3>
<p dir="auto">I create a table from a request (sql lab) -&gt; Superset view<br>
How to copy this table (with sql) without losing the filled "verbose name" fields ?<br>
I would like to use the same table but on different schemas</p>
<p dir="auto">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?<br>
<code class="notranslate">sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table sqlatable_user already exists1</code></p>
<h3 dir="auto">Actual results</h3>
<p dir="auto">File "/appvenv/bin/superset", line 21, in <br>
superset()<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 829, in <strong>call</strong><br>
return self.main(*args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/flask/cli.py", line 586, in main<br>
return super(FlaskGroup, self).main(*args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 782, in main<br>
rv = self.invoke(ctx)<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1259, in invoke<br>
return _process_result(sub_ctx.command.invoke(sub_ctx))<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1259, in invoke<br>
return _process_result(sub_ctx.command.invoke(sub_ctx))<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1066, in invoke<br>
return ctx.invoke(self.callback, **ctx.params)<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 610, in invoke<br>
return callback(*args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/click/decorators.py", line 21, in new_func<br>
return f(get_current_context(), *args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/flask/cli.py", line 426, in decorator<br>
return __ctx.invoke(f, *args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 610, in invoke<br>
return callback(*args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/flask_migrate/cli.py", line 134, in upgrade<br>
_upgrade(directory, revision, sql, tag, x_arg)<br>
File "/appvenv/lib/python3.6/site-packages/flask_migrate/<strong>init</strong>.py", line 96, in wrapped<br>
f(*args, **kwargs)<br>
File "/appvenv/lib/python3.6/site-packages/flask_migrate/<strong>init</strong>.py", line 271, in upgrade<br>
command.upgrade(config, revision, sql=sql, tag=tag)<br>
File "/appvenv/lib/python3.6/site-packages/alembic/command.py", line 298, in upgrade<br>
script.run_env()<br>
File "/appvenv/lib/python3.6/site-packages/alembic/script/base.py", line 489, in run_env<br>
util.load_python_file(self.dir, "env.py")<br>
File "/appvenv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file<br>
module = load_module_py(module_id, path)<br>
File "/appvenv/lib/python3.6/site-packages/alembic/util/compat.py", line 184, in load_module_py<br>
spec.loader.exec_module(module)<br>
File "", line 678, in exec_module<br>
File "", line 219, in <em>call_with_frames_removed<br>
File "/appvenv/lib/python3.6/site-packages/superset/migrations/env.py", line 124, in <br>
run_migrations_online()<br>
File "/appvenv/lib/python3.6/site-packages/superset/migrations/env.py", line 116, in run_migrations_online<br>
context.run_migrations()<br>
File "", line 8, in run_migrations<br>
File "/appvenv/lib/python3.6/site-packages/alembic/runtime/environment.py", line 846, in run_migrations<br>
self.get_context().run_migrations(**kw)<br>
File "/appvenv/lib/python3.6/site-packages/alembic/runtime/migration.py", line 522, in run_migrations<br>
step.migration_fn(**kw)<br>
File "/appvenv/lib/python3.6/site-packages/superset/migrations/versions/3e1b21cd94a4_change_owner_to_m2m_relation_on</em>.py", line 75, in upgrade<br>
sa.PrimaryKeyConstraint("id"),<br>
File "", line 8, in create_table<br>
File "", line 3, in create_table<br>
File "/appvenv/lib/python3.6/site-packages/alembic/operations/ops.py", line 1252, in create_table<br>
return operations.invoke(op)<br>
File "/appvenv/lib/python3.6/site-packages/alembic/operations/base.py", line 373, in invoke<br>
return fn(self, operation)<br>
File "/appvenv/lib/python3.6/site-packages/alembic/operations/toimpl.py", line 101, in create_table<br>
operations.impl.create_table(table)<br>
File "/appvenv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 259, in create_table<br>
self._exec(schema.CreateTable(table))<br>
File "/appvenv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 141, in _exec<br>
return conn.execute(construct, *multiparams, **params)<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute<br>
return meth(self, multiparams, params)<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection<br>
return connection._execute_ddl(self, multiparams, params)<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1073, in _execute_ddl<br>
compiled,<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in <em>execute_context<br>
e, statement, parameters, cursor, context<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in <em>handle_dbapi_exception<br>
sqlalchemy_exception, with_traceback=exc_info[2], from</em>=e<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise</em><br>
raise exception<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context<br>
cursor, statement, parameters, context<br>
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute<br>
cursor.execute(statement, parameters)<br>
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table sqlatable_user already exists</p>
<h4 dir="auto">How to reproduce the bug</h4>
<ol dir="auto">
<li>Try to bring up superset version 0.37.2</li>
<li>Configure sqlLite to store metadata info.</li>
</ol>
<h3 dir="auto">Environment</h3>
<ul dir="auto">
<li>superset version: 0.37.2</li>
<li>python version: python3.6</li>
<li>node.js version: v10.23.0</li>
</ul>
<h3 dir="auto">Checklist</h3>
<p dir="auto">Make sure to follow these steps before submitting your issue - thank you!</p>
<ul dir="auto">
<li>[ Y] I have checked the superset logs for python stacktraces and included it here as text if there are any.</li>
<li>[ Y] I have reproduced the issue with at least the latest released version of superset.</li>
<li>[ Y] I have checked the issue tracker for the same issue and I haven't found one similar.</li>
</ul>
<h3 dir="auto">Additional context</h3>
<p dir="auto">Add any other context about the problem here.</p>