You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "mike-code (via GitHub)" <gi...@apache.org> on 2023/12/11 23:56:21 UTC

Re: [I] Import database fails [superset]

mike-code commented on issue #23799:
URL: https://github.com/apache/superset/issues/23799#issuecomment-1851083427

   I have the same issue. It appears that the importer tries to pass the following json parameter which results in the error 
   ```
   'extra': {'allows_virtual_table_explore': True, 'cost_estimate_enabled': True}, 
   ```
   
   If I remove the `extra` key from the yaml file I want to import, the database will import successfully.
   
   My import file:
   
   ```
   databases:
   - sqlalchemy_uri: "postgresql://user:password@10.124.0.21:5432/dbname"
     database_name: the-db
     cache_timeout: null
     expose_in_sqllab: true
     allow_run_async: false
     allow_ctas: false
     allow_cvas: true
     allow_dml: false
     allow_csv_upload: false
     extra:
       allows_virtual_table_explore: true
       cost_estimate_enabled: true
     version: 1.0.0
   ```
   
   <details>
     <summary>python exception</summary>
   
     ```
     Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py]
   logging was configured successfully
   2023-12-11 23:54:36,761:INFO:superset.utils.logging_configurator:logging was configured successfully
   2023-12-11 23:54:36,772:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
   /usr/local/lib/python3.9/site-packages/flask_limiter/extension.py:293: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
     warnings.warn(
   Importing dataset from file foo.yaml
   2023-12-11 23:54:38,347:INFO:superset.datasets.commands.importers.v0:Importing dataset from file foo.yaml
   Importing 1 databases
   2023-12-11 23:54:38,348:INFO:superset.datasets.commands.importers.v0:Importing 1 databases
   Importing new dbs the-db
   2023-12-11 23:54:38,357:INFO:superset.models.helpers:Importing new dbs the-db
   Error running import command
   Traceback (most recent call last):
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   psycopg2.ProgrammingError: can't adapt type 'dict'
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/app/superset/datasets/commands/importers/dispatcher.py", line 57, in run
       command.run()
     File "/app/superset/datasets/commands/importers/v0.py", line 261, in run
       import_from_dict(db.session, config, sync=self.sync)
     File "/app/superset/datasets/commands/importers/v0.py", line 225, in import_from_dict
       session.commit()
     File "<string>", line 2, in commit
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435, in commit
       self._transaction.commit(_to_root=self.future)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit
       self._prepare_impl()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
       self.session.flush()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367, in flush
       self._flush(objects)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507, in _flush
       transaction.rollback(_capture_exception=True)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
       compat.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467, in _flush
       flush_context.execute()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
       rec.execute(self)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
       util.preloaded.orm_persistence.save_obj(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
       _emit_insert_statements(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements
       result = connection._execute_20(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
       return meth(self, args_10style, kwargs_10style, execution_options)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
       return connection._execute_clauseelement(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
       ret = self._execute_context(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
       self._handle_dbapi_exception(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
       util.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'dict'
   [SQL: INSERT INTO dbs (uuid, created_on, changed_on, verbose_name, database_name, sqlalchemy_uri, password, cache_timeout, select_as_create_table_as, expose_in_sqllab, allow_run_async, allow_file_upload, allow_ctas, allow_cvas, allow_dml, force_ctas_schema, extra, encrypted_extra, impersonate_user, server_cert, is_managed_externally, external_url, created_by_fk, changed_by_fk) VALUES (%(uuid)s, %(created_on)s, %(changed_on)s, %(verbose_name)s, %(database_name)s, %(sqlalchemy_uri)s, %(password)s, %(cache_timeout)s, %(select_as_create_table_as)s, %(expose_in_sqllab)s, %(allow_run_async)s, %(allow_file_upload)s, %(allow_ctas)s, %(allow_cvas)s, %(allow_dml)s, %(force_ctas_schema)s, %(extra)s, %(encrypted_extra)s, %(impersonate_user)s, %(server_cert)s, %(is_managed_externally)s, %(external_url)s, %(created_by_fk)s, %(changed_by_fk)s) RETURNING dbs.id]
   [parameters: {'uuid': UUID('f0576fce-20f8-49a1-ae3a-a911408b8783'), 'created_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361669), 'changed_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361676), 'verbose_name': None, 'database_name': 'the-db', 'sqlalchemy_uri': 'postgresql://myuser:mypassword@10.124.0.21:5432/dbname', 'password': None, 'cache_timeout': None, 'select_as_create_table_as': False, 'expose_in_sqllab': True, 'allow_run_async': False, 'allow_file_upload': False, 'allow_ctas': False, 'allow_cvas': True, 'allow_dml': False, 'force_ctas_schema': None, 'extra': {'allows_virtual_table_explore': True, 'cost_estimate_enabled': True}, 'encrypted_extra': None, 'impersonate_user': False, 'server_cert': None, 'is_managed_externally': False, 'external_url': None, 'created_by_fk': None, 'changed_by_fk': None}]
   (Background on this error at: https://sqlalche.me/e/14/f405)
   2023-12-11 23:54:38,363:ERROR:superset.datasets.commands.importers.dispatcher:Error running import command
   Traceback (most recent call last):
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   psycopg2.ProgrammingError: can't adapt type 'dict'
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/app/superset/datasets/commands/importers/dispatcher.py", line 57, in run
       command.run()
     File "/app/superset/datasets/commands/importers/v0.py", line 261, in run
       import_from_dict(db.session, config, sync=self.sync)
     File "/app/superset/datasets/commands/importers/v0.py", line 225, in import_from_dict
       session.commit()
     File "<string>", line 2, in commit
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435, in commit
       self._transaction.commit(_to_root=self.future)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit
       self._prepare_impl()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
       self.session.flush()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367, in flush
       self._flush(objects)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507, in _flush
       transaction.rollback(_capture_exception=True)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
       compat.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467, in _flush
       flush_context.execute()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
       rec.execute(self)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
       util.preloaded.orm_persistence.save_obj(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
       _emit_insert_statements(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements
       result = connection._execute_20(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
       return meth(self, args_10style, kwargs_10style, execution_options)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
       return connection._execute_clauseelement(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
       ret = self._execute_context(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
       self._handle_dbapi_exception(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
       util.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'dict'
   [SQL: INSERT INTO dbs (uuid, created_on, changed_on, verbose_name, database_name, sqlalchemy_uri, password, cache_timeout, select_as_create_table_as, expose_in_sqllab, allow_run_async, allow_file_upload, allow_ctas, allow_cvas, allow_dml, force_ctas_schema, extra, encrypted_extra, impersonate_user, server_cert, is_managed_externally, external_url, created_by_fk, changed_by_fk) VALUES (%(uuid)s, %(created_on)s, %(changed_on)s, %(verbose_name)s, %(database_name)s, %(sqlalchemy_uri)s, %(password)s, %(cache_timeout)s, %(select_as_create_table_as)s, %(expose_in_sqllab)s, %(allow_run_async)s, %(allow_file_upload)s, %(allow_ctas)s, %(allow_cvas)s, %(allow_dml)s, %(force_ctas_schema)s, %(extra)s, %(encrypted_extra)s, %(impersonate_user)s, %(server_cert)s, %(is_managed_externally)s, %(external_url)s, %(created_by_fk)s, %(changed_by_fk)s) RETURNING dbs.id]
   [parameters: {'uuid': UUID('f0576fce-20f8-49a1-ae3a-a911408b8783'), 'created_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361669), 'changed_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361676), 'verbose_name': None, 'database_name': 'the-db', 'sqlalchemy_uri': 'postgresql://myuser:mypassword@10.124.0.21:5432/dbname', 'password': None, 'cache_timeout': None, 'select_as_create_table_as': False, 'expose_in_sqllab': True, 'allow_run_async': False, 'allow_file_upload': False, 'allow_ctas': False, 'allow_cvas': True, 'allow_dml': False, 'force_ctas_schema': None, 'extra': {'allows_virtual_table_explore': True, 'cost_estimate_enabled': True}, 'encrypted_extra': None, 'impersonate_user': False, 'server_cert': None, 'is_managed_externally': False, 'external_url': None, 'created_by_fk': None, 'changed_by_fk': None}]
   (Background on this error at: https://sqlalche.me/e/14/f405)
   There was an error when importing the dataset(s), please check the exception traceback in the log
   Traceback (most recent call last):
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   psycopg2.ProgrammingError: can't adapt type 'dict'
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/app/superset/cli/importexport.py", line 194, in import_datasources
       ImportDatasetsCommand(contents, overwrite=True).run()
     File "/app/superset/datasets/commands/importers/dispatcher.py", line 68, in run
       raise exc
     File "/app/superset/datasets/commands/importers/dispatcher.py", line 57, in run
       command.run()
     File "/app/superset/datasets/commands/importers/v0.py", line 261, in run
       import_from_dict(db.session, config, sync=self.sync)
     File "/app/superset/datasets/commands/importers/v0.py", line 225, in import_from_dict
       session.commit()
     File "<string>", line 2, in commit
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435, in commit
       self._transaction.commit(_to_root=self.future)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit
       self._prepare_impl()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
       self.session.flush()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367, in flush
       self._flush(objects)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507, in _flush
       transaction.rollback(_capture_exception=True)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
       compat.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467, in _flush
       flush_context.execute()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
       rec.execute(self)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
       util.preloaded.orm_persistence.save_obj(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
       _emit_insert_statements(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements
       result = connection._execute_20(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
       return meth(self, args_10style, kwargs_10style, execution_options)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
       return connection._execute_clauseelement(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
       ret = self._execute_context(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
       self._handle_dbapi_exception(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
       util.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'dict'
   [SQL: INSERT INTO dbs (uuid, created_on, changed_on, verbose_name, database_name, sqlalchemy_uri, password, cache_timeout, select_as_create_table_as, expose_in_sqllab, allow_run_async, allow_file_upload, allow_ctas, allow_cvas, allow_dml, force_ctas_schema, extra, encrypted_extra, impersonate_user, server_cert, is_managed_externally, external_url, created_by_fk, changed_by_fk) VALUES (%(uuid)s, %(created_on)s, %(changed_on)s, %(verbose_name)s, %(database_name)s, %(sqlalchemy_uri)s, %(password)s, %(cache_timeout)s, %(select_as_create_table_as)s, %(expose_in_sqllab)s, %(allow_run_async)s, %(allow_file_upload)s, %(allow_ctas)s, %(allow_cvas)s, %(allow_dml)s, %(force_ctas_schema)s, %(extra)s, %(encrypted_extra)s, %(impersonate_user)s, %(server_cert)s, %(is_managed_externally)s, %(external_url)s, %(created_by_fk)s, %(changed_by_fk)s) RETURNING dbs.id]
   [parameters: {'uuid': UUID('f0576fce-20f8-49a1-ae3a-a911408b8783'), 'created_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361669), 'changed_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361676), 'verbose_name': None, 'database_name': 'the-db', 'sqlalchemy_uri': 'postgresql://myuser:mypassword@10.124.0.21:5432/dbname', 'password': None, 'cache_timeout': None, 'select_as_create_table_as': False, 'expose_in_sqllab': True, 'allow_run_async': False, 'allow_file_upload': False, 'allow_ctas': False, 'allow_cvas': True, 'allow_dml': False, 'force_ctas_schema': None, 'extra': {'allows_virtual_table_explore': True, 'cost_estimate_enabled': True}, 'encrypted_extra': None, 'impersonate_user': False, 'server_cert': None, 'is_managed_externally': False, 'external_url': None, 'created_by_fk': None, 'changed_by_fk': None}]
   (Background on this error at: https://sqlalche.me/e/14/f405)
   2023-12-11 23:54:38,368:ERROR:superset.cli.importexport:There was an error when importing the dataset(s), please check the exception traceback in the log
   Traceback (most recent call last):
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   psycopg2.ProgrammingError: can't adapt type 'dict'
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/app/superset/cli/importexport.py", line 194, in import_datasources
       ImportDatasetsCommand(contents, overwrite=True).run()
     File "/app/superset/datasets/commands/importers/dispatcher.py", line 68, in run
       raise exc
     File "/app/superset/datasets/commands/importers/dispatcher.py", line 57, in run
       command.run()
     File "/app/superset/datasets/commands/importers/v0.py", line 261, in run
       import_from_dict(db.session, config, sync=self.sync)
     File "/app/superset/datasets/commands/importers/v0.py", line 225, in import_from_dict
       session.commit()
     File "<string>", line 2, in commit
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435, in commit
       self._transaction.commit(_to_root=self.future)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit
       self._prepare_impl()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
       self.session.flush()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367, in flush
       self._flush(objects)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507, in _flush
       transaction.rollback(_capture_exception=True)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
       compat.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467, in _flush
       flush_context.execute()
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
       rec.execute(self)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
       util.preloaded.orm_persistence.save_obj(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
       _emit_insert_statements(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements
       result = connection._execute_20(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
       return meth(self, args_10style, kwargs_10style, execution_options)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
       return connection._execute_clauseelement(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
       ret = self._execute_context(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
       self._handle_dbapi_exception(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
       util.raise_(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
       raise exception
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
       self.dialect.do_execute(
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
       cursor.execute(statement, parameters)
   sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'dict'
   [SQL: INSERT INTO dbs (uuid, created_on, changed_on, verbose_name, database_name, sqlalchemy_uri, password, cache_timeout, select_as_create_table_as, expose_in_sqllab, allow_run_async, allow_file_upload, allow_ctas, allow_cvas, allow_dml, force_ctas_schema, extra, encrypted_extra, impersonate_user, server_cert, is_managed_externally, external_url, created_by_fk, changed_by_fk) VALUES (%(uuid)s, %(created_on)s, %(changed_on)s, %(verbose_name)s, %(database_name)s, %(sqlalchemy_uri)s, %(password)s, %(cache_timeout)s, %(select_as_create_table_as)s, %(expose_in_sqllab)s, %(allow_run_async)s, %(allow_file_upload)s, %(allow_ctas)s, %(allow_cvas)s, %(allow_dml)s, %(force_ctas_schema)s, %(extra)s, %(encrypted_extra)s, %(impersonate_user)s, %(server_cert)s, %(is_managed_externally)s, %(external_url)s, %(created_by_fk)s, %(changed_by_fk)s) RETURNING dbs.id]
   [parameters: {'uuid': UUID('f0576fce-20f8-49a1-ae3a-a911408b8783'), 'created_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361669), 'changed_on': datetime.datetime(2023, 12, 11, 23, 54, 38, 361676), 'verbose_name': None, 'database_name': 'the-db', 'sqlalchemy_uri': 'postgresql://myuser:mypassword@10.124.0.21:5432/dbname', 'password': None, 'cache_timeout': None, 'select_as_create_table_as': False, 'expose_in_sqllab': True, 'allow_run_async': False, 'allow_file_upload': False, 'allow_ctas': False, 'allow_cvas': True, 'allow_dml': False, 'force_ctas_schema': None, 'extra': {'allows_virtual_table_explore': True, 'cost_estimate_enabled': True}, 'encrypted_extra': None, 'impersonate_user': False, 'server_cert': None, 'is_managed_externally': False, 'external_url': None, 'created_by_fk': None, 'changed_by_fk': None}]
   (Background on this error at: https://sqlalche.me/e/14/f405)
     ```
   </details>


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org