Hello there,
I'm having trouble getting started with the current release @ 2023-06-27 After load_examples and init, many of the dashboards don't work, complaining that tables don't exist I removed the image and restarted from the beginning and still get the same.
Some of the dashboards do work: FCC New Coder Survey 2018, deck.gl Demo, Unicode Test, some of Misc Charts, USA Births Names, World Bank's Data
The others all seem to have missing tables.
During load_examples I get various warnings, for some tables I'm seeing "couldn't check if the table exists, assuming it does" But, for example, the one shown in the image above, is one that according to the logs did get created.
Logs
...
Creating a dashboard
/app/superset/commands/importers/v1/utils.py:112: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
for uuid, password in db.session.query(Database.uuid, Database.password).all()
/app/superset/commands/importers/v1/utils.py:117: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
for uuid, password in db.session.query(SSHTunnel.uuid, SSHTunnel.password).all()
/app/superset/commands/importers/v1/utils.py:122: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
for uuid, private_key in db.session.query(
/app/superset/commands/importers/v1/utils.py:129: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
for uuid, private_key_password in db.session.query(
Importing new tables main.threads
2023-06-27 06:54:18,382:INFO:superset.models.helpers:Importing new tables main.threads
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:18,385:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning.
obj = obj_query.one_or_none()
Importing new sql_metrics count
2023-06-27 06:54:18,401:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns ts
2023-06-27 06:54:18,406:INFO:superset.models.helpers:Importing new table_columns ts
Importing new table_columns client_msg_id
2023-06-27 06:54:18,409:INFO:superset.models.helpers:Importing new table_columns client_msg_id
Importing new table_columns channel_id
2023-06-27 06:54:18,413:INFO:superset.models.helpers:Importing new table_columns channel_id
Importing new table_columns thread_ts
2023-06-27 06:54:18,417:INFO:superset.models.helpers:Importing new table_columns thread_ts
Importing new table_columns latest_reply
2023-06-27 06:54:18,420:INFO:superset.models.helpers:Importing new table_columns latest_reply
Importing new table_columns team
2023-06-27 06:54:18,422:INFO:superset.models.helpers:Importing new table_columns team
Importing new table_columns type
2023-06-27 06:54:18,426:INFO:superset.models.helpers:Importing new table_columns type
Importing new table_columns user
2023-06-27 06:54:18,430:INFO:superset.models.helpers:Importing new table_columns user
Importing new table_columns text
2023-06-27 06:54:18,434:INFO:superset.models.helpers:Importing new table_columns text
Importing new table_columns subscribed
2023-06-27 06:54:18,436:INFO:superset.models.helpers:Importing new table_columns subscribed
Importing new table_columns reply_count
2023-06-27 06:54:18,439:INFO:superset.models.helpers:Importing new table_columns reply_count
Importing new table_columns reply_users
2023-06-27 06:54:18,442:INFO:superset.models.helpers:Importing new table_columns reply_users
Importing new table_columns blocks
2023-06-27 06:54:18,446:INFO:superset.models.helpers:Importing new table_columns blocks
Importing new table_columns reply_users_count
2023-06-27 06:54:18,449:INFO:superset.models.helpers:Importing new table_columns reply_users_count
Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/threads.csv
2023-06-27 06:54:18,454:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/threads.csv
Loading data inside the import transaction
2023-06-27 06:54:18,732:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction
Importing new tables main.unicode_test
2023-06-27 06:54:18,787:INFO:superset.models.helpers:Importing new tables main.unicode_test
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:18,789:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning.
obj = obj_query.one_or_none()
Importing new sql_metrics count
2023-06-27 06:54:18,799:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns with_missing
2023-06-27 06:54:18,802:INFO:superset.models.helpers:Importing new table_columns with_missing
Importing new table_columns phrase
2023-06-27 06:54:18,805:INFO:superset.models.helpers:Importing new table_columns phrase
Importing new table_columns short_phrase
2023-06-27 06:54:18,807:INFO:superset.models.helpers:Importing new table_columns short_phrase
Importing new table_columns dttm
2023-06-27 06:54:18,810:INFO:superset.models.helpers:Importing new table_columns dttm
Importing new table_columns value
2023-06-27 06:54:18,813:INFO:superset.models.helpers:Importing new table_columns value
Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/unicode_test.csv
2023-06-27 06:54:18,819:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/unicode_test.csv
Loading data inside the import transaction
2023-06-27 06:54:19,109:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction
Importing new tables main.users_channels
2023-06-27 06:54:19,144:INFO:superset.models.helpers:Importing new tables main.users_channels
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:19,147:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning.
obj = obj_query.one_or_none()
Importing new sql_metrics count
2023-06-27 06:54:19,156:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns user_id
2023-06-27 06:54:19,159:INFO:superset.models.helpers:Importing new table_columns user_id
Importing new table_columns name
2023-06-27 06:54:19,163:INFO:superset.models.helpers:Importing new table_columns name
Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/users_channels.csv
2023-06-27 06:54:19,168:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/users_channels.csv
Loading data inside the import transaction
2023-06-27 06:54:19,415:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction
Importing new tables main.messages_channels
2023-06-27 06:54:19,904:INFO:superset.models.helpers:Importing new tables main.messages_channels
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:19,906:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning.
obj = obj_query.one_or_none()
Importing new sql_metrics count
2023-06-27 06:54:19,916:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns ts
2023-06-27 06:54:19,919:INFO:superset.models.helpers:Importing new table_columns ts
Importing new table_columns name
2023-06-27 06:54:19,922:INFO:superset.models.helpers:Importing new table_columns name
Importing new table_columns text
2023-06-27 06:54:19,925:INFO:superset.models.helpers:Importing new table_columns text
Importing new tables main.members_channels_2
2023-06-27 06:54:19,936:INFO:superset.models.helpers:Importing new tables main.members_channels_2
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:19,938:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:54:19,948:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns channel_name
2023-06-27 06:54:19,951:INFO:superset.models.helpers:Importing new table_columns channel_name
Importing new table_columns member_name
2023-06-27 06:54:19,954:INFO:superset.models.helpers:Importing new table_columns member_name
Importing new tables main.new_members_daily
2023-06-27 06:54:19,965:INFO:superset.models.helpers:Importing new tables main.new_members_daily
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:19,967:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:54:19,974:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns date
2023-06-27 06:54:19,977:INFO:superset.models.helpers:Importing new table_columns date
Importing new table_columns new_members
2023-06-27 06:54:19,981:INFO:superset.models.helpers:Importing new table_columns new_members
Importing new tables main.users_channels-uzooNNtSRO
2023-06-27 06:54:19,992:INFO:superset.models.helpers:Importing new tables main.users_channels-uzooNNtSRO
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:19,993:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:54:20,002:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns channel_1
2023-06-27 06:54:20,005:INFO:superset.models.helpers:Importing new table_columns channel_1
Importing new table_columns channel_2
2023-06-27 06:54:20,008:INFO:superset.models.helpers:Importing new table_columns channel_2
Importing new table_columns cnt
2023-06-27 06:54:20,011:INFO:superset.models.helpers:Importing new table_columns cnt
Importing new tables main.FCC 2018 Survey
2023-06-27 06:54:20,021:INFO:superset.models.helpers:Importing new tables main.FCC 2018 Survey
Dataset has no database will retry with database_id to set permission
2023-06-27 06:54:20,023:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:54:20,031:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns highest_degree_earned
2023-06-27 06:54:20,036:INFO:superset.models.helpers:Importing new table_columns highest_degree_earned
Importing new table_columns job_location_preference
2023-06-27 06:54:20,040:INFO:superset.models.helpers:Importing new table_columns job_location_preference
Importing new table_columns ethnic_minority
2023-06-27 06:54:20,043:INFO:superset.models.helpers:Importing new table_columns ethnic_minority
Importing new table_columns willing_to_relocate
2023-06-27 06:54:20,047:INFO:superset.models.helpers:Importing new table_columns willing_to_relocate
Importing new table_columns developer_type
2023-06-27 06:54:20,050:INFO:superset.models.helpers:Importing new table_columns developer_type
Importing new table_columns first_time_developer
2023-06-27 06:54:20,053:INFO:superset.models.helpers:Importing new table_columns first_time_developer
Importing new table_columns gender
2023-06-27 06:54:20,056:INFO:superset.models.helpers:Importing new table_columns gender
Importing new table_columns calc_first_time_dev
2023-06-27 06:54:20,060:INFO:superset.models.helpers:Importing new table_columns calc_first_time_dev
Importing new table_columns yt_codingtuts360
2023-06-27 06:54:20,064:INFO:superset.models.helpers:Importing new table_columns yt_codingtuts360
Importing new table_columns is_recv_disab_bnft
2023-06-27 06:54:20,067:INFO:superset.models.helpers:Importing new table_columns is_recv_disab_bnft
Importing new table_columns job_intr_qa_engn
2023-06-27 06:54:20,070:INFO:superset.models.helpers:Importing new table_columns job_intr_qa_engn
Importing new table_columns has_high_spd_ntnet
2023-06-27 06:54:20,073:INFO:superset.models.helpers:Importing new table_columns has_high_spd_ntnet
Importing new table_columns is_first_dev_job
2023-06-27 06:54:20,075:INFO:superset.models.helpers:Importing new table_columns is_first_dev_job
Importing new table_columns job_intr_ux_engn
2023-06-27 06:54:20,079:INFO:superset.models.helpers:Importing new table_columns job_intr_ux_engn
Importing new table_columns bootcamp_have_loan
2023-06-27 06:54:20,083:INFO:superset.models.helpers:Importing new table_columns bootcamp_have_loan
Importing new table_columns podcast_js_jabber
2023-06-27 06:54:20,086:INFO:superset.models.helpers:Importing new table_columns podcast_js_jabber
Importing new table_columns job_intr_datasci
2023-06-27 06:54:20,089:INFO:superset.models.helpers:Importing new table_columns job_intr_datasci
Importing new table_columns job_intr_dataengn
2023-06-27 06:54:20,091:INFO:superset.models.helpers:Importing new table_columns job_intr_dataengn
Importing new table_columns rsrc_khan_acdm
2023-06-27 06:54:20,095:INFO:superset.models.helpers:Importing new table_columns rsrc_khan_acdm
Importing new table_columns has_finance_depends
2023-06-27 06:54:20,098:INFO:superset.models.helpers:Importing new table_columns has_finance_depends
Importing new table_columns has_served_military
2023-06-27 06:54:20,101:INFO:superset.models.helpers:Importing new table_columns has_served_military
Importing new table_columns job_intr_backend
2023-06-27 06:54:20,104:INFO:superset.models.helpers:Importing new table_columns job_intr_backend
Importing new table_columns job_intr_teacher
2023-06-27 06:54:20,106:INFO:superset.models.helpers:Importing new table_columns job_intr_teacher
Importing new table_columns months_job_search
2023-06-27 06:54:20,110:INFO:superset.models.helpers:Importing new table_columns months_job_search
Importing new table_columns student_debt_has
2023-06-27 06:54:20,114:INFO:superset.models.helpers:Importing new table_columns student_debt_has
Importing new table_columns student_debt_amt
2023-06-27 06:54:20,117:INFO:superset.models.helpers:Importing new table_columns student_debt_amt
Importing new table_columns job_intr_gamedev
2023-06-27 06:54:20,120:INFO:superset.models.helpers:Importing new table_columns job_intr_gamedev
Importing new table_columns rsrc_code_wars
2023-06-27 06:54:20,122:INFO:superset.models.helpers:Importing new table_columns rsrc_code_wars
Importing new table_columns do_finance_support
2023-06-27 06:54:20,126:INFO:superset.models.helpers:Importing new table_columns do_finance_support
Importing new table_columns last_yr_income
2023-06-27 06:54:20,130:INFO:superset.models.helpers:Importing new table_columns last_yr_income
Importing new table_columns is_software_dev
2023-06-27 06:54:20,134:INFO:superset.models.helpers:Importing new table_columns is_software_dev
Importing new table_columns money_for_learning
2023-06-27 06:54:20,137:INFO:superset.models.helpers:Importing new table_columns money_for_learning
Importing new table_columns home_mrtg_has
2023-06-27 06:54:20,139:INFO:superset.models.helpers:Importing new table_columns home_mrtg_has
Importing new table_columns job_intr_mobile
2023-06-27 06:54:20,143:INFO:superset.models.helpers:Importing new table_columns job_intr_mobile
Importing new table_columns job_intr_infosec
2023-06-27 06:54:20,146:INFO:superset.models.helpers:Importing new table_columns job_intr_infosec
Importing new table_columns job_intr_fllstck
2023-06-27 06:54:20,149:INFO:superset.models.helpers:Importing new table_columns job_intr_fllstck
Importing new table_columns job_intr_frntend
2023-06-27 06:54:20,152:INFO:superset.models.helpers:Importing new table_columns job_intr_frntend
Importing new table_columns job_intr_devops
2023-06-27 06:54:20,155:INFO:superset.models.helpers:Importing new table_columns job_intr_devops
Importing new table_columns job_intr_projm
2023-06-27 06:54:20,158:INFO:superset.models.helpers:Importing new table_columns job_intr_projm
Importing new table_columns rsrc_css_tricks
2023-06-27 06:54:20,161:INFO:superset.models.helpers:Importing new table_columns rsrc_css_tricks
Importing new table_columns yt_cs_dojo
2023-06-27 06:54:20,165:INFO:superset.models.helpers:Importing new table_columns yt_cs_dojo
Importing new table_columns is_ethnic_minority
2023-06-27 06:54:20,168:INFO:superset.models.helpers:Importing new table_columns is_ethnic_minority
Importing new table_columns yt_mit_ocw
2023-06-27 06:54:20,171:INFO:superset.models.helpers:Importing new table_columns yt_mit_ocw
Importing new table_columns is_self_employed
2023-06-27 06:54:20,175:INFO:superset.models.helpers:Importing new table_columns is_self_employed
Importing new table_columns home_mrtg_owe
2023-06-27 06:54:20,179:INFO:superset.models.helpers:Importing new table_columns home_mrtg_owe
Importing new table_columns yt_engn_truth
2023-06-27 06:54:20,182:INFO:superset.models.helpers:Importing new table_columns yt_engn_truth
Importing new table_columns bootcamp_attend
2023-06-27 06:54:20,185:INFO:superset.models.helpers:Importing new table_columns bootcamp_attend
Importing new table_columns yt_derekbanas
2023-06-27 06:54:20,189:INFO:superset.models.helpers:Importing new table_columns yt_derekbanas
Importing new table_columns yt_learncodeacdm
2023-06-27 06:54:20,193:INFO:superset.models.helpers:Importing new table_columns yt_learncodeacdm
Importing new table_columns podcast_changelog
2023-06-27 06:54:20,197:INFO:superset.models.helpers:Importing new table_columns podcast_changelog
Importing new table_columns rsrc_hackerrank
2023-06-27 06:54:20,200:INFO:superset.models.helpers:Importing new table_columns rsrc_hackerrank
Importing new table_columns podcast_devtea
2023-06-27 06:54:20,203:INFO:superset.models.helpers:Importing new table_columns podcast_devtea
Importing new table_columns podcast_sedaily
2023-06-27 06:54:20,207:INFO:superset.models.helpers:Importing new table_columns podcast_sedaily
Importing new table_columns podcast_seradio
2023-06-27 06:54:20,210:INFO:superset.models.helpers:Importing new table_columns podcast_seradio
Importing new table_columns codeevnt_gamejam
2023-06-27 06:54:20,213:INFO:superset.models.helpers:Importing new table_columns codeevnt_gamejam
Importing new table_columns podcast_geekspeak
2023-06-27 06:54:20,216:INFO:superset.models.helpers:Importing new table_columns podcast_geekspeak
Importing new table_columns podcast_talkpythonme
2023-06-27 06:54:20,218:INFO:superset.models.helpers:Importing new table_columns podcast_talkpythonme
Importing new table_columns podcast_hanselmnts
2023-06-27 06:54:20,222:INFO:superset.models.helpers:Importing new table_columns podcast_hanselmnts
Importing new table_columns podcast_syntaxfm
2023-06-27 06:54:20,225:INFO:superset.models.helpers:Importing new table_columns podcast_syntaxfm
Importing new table_columns podcast_shoptalk
2023-06-27 06:54:20,228:INFO:superset.models.helpers:Importing new table_columns podcast_shoptalk
Importing new table_columns yt_mozillahacks
2023-06-27 06:54:20,231:INFO:superset.models.helpers:Importing new table_columns yt_mozillahacks
Importing new table_columns podcast_codingblcks
2023-06-27 06:54:20,234:INFO:superset.models.helpers:Importing new table_columns podcast_codingblcks
Importing new table_columns podcast_codenewbie
2023-06-27 06:54:20,238:INFO:superset.models.helpers:Importing new table_columns podcast_codenewbie
Importing new table_columns bootcamp_recommend
2023-06-27 06:54:20,241:INFO:superset.models.helpers:Importing new table_columns bootcamp_recommend
Importing new table_columns codeevnt_railsbrdg
2023-06-27 06:54:20,243:INFO:superset.models.helpers:Importing new table_columns codeevnt_railsbrdg
Importing new table_columns bootcamp_finished
2023-06-27 06:54:20,246:INFO:superset.models.helpers:Importing new table_columns bootcamp_finished
Importing new table_columns podcast_rubyrogues
2023-06-27 06:54:20,249:INFO:superset.models.helpers:Importing new table_columns podcast_rubyrogues
Importing new table_columns job_relocate
2023-06-27 06:54:20,253:INFO:superset.models.helpers:Importing new table_columns job_relocate
Importing new table_columns debt_amt
2023-06-27 06:54:20,256:INFO:superset.models.helpers:Importing new table_columns debt_amt
Importing new table_columns rsrc_codeacdm
2023-06-27 06:54:20,258:INFO:superset.models.helpers:Importing new table_columns rsrc_codeacdm
Importing new table_columns podcast_fcc
2023-06-27 06:54:20,261:INFO:superset.models.helpers:Importing new table_columns podcast_fcc
Importing new table_columns podcast_codepenrd
2023-06-27 06:54:20,265:INFO:superset.models.helpers:Importing new table_columns podcast_codepenrd
Importing new table_columns podcast_fullstckrd
2023-06-27 06:54:20,268:INFO:superset.models.helpers:Importing new table_columns podcast_fullstckrd
Importing new table_columns codeevnt_hackthn
2023-06-27 06:54:20,271:INFO:superset.models.helpers:Importing new table_columns codeevnt_hackthn
Importing new table_columns rsrc_udacity
2023-06-27 06:54:20,274:INFO:superset.models.helpers:Importing new table_columns rsrc_udacity
Importing new table_columns podcast_ltcwm
2023-06-27 06:54:20,276:INFO:superset.models.helpers:Importing new table_columns podcast_ltcwm
Importing new table_columns rsrc_coursera
2023-06-27 06:54:20,279:INFO:superset.models.helpers:Importing new table_columns rsrc_coursera
Importing new table_columns codeevnt_djangogrls
2023-06-27 06:54:20,283:INFO:superset.models.helpers:Importing new table_columns codeevnt_djangogrls
Importing new table_columns codeevnt_startupwknd
2023-06-27 06:54:20,286:INFO:superset.models.helpers:Importing new table_columns codeevnt_startupwknd
Importing new table_columns podcast_progthrwdwn
2023-06-27 06:54:20,289:INFO:superset.models.helpers:Importing new table_columns podcast_progthrwdwn
Importing new table_columns expected_earn
2023-06-27 06:54:20,292:INFO:superset.models.helpers:Importing new table_columns expected_earn
Importing new table_columns rsrc_egghead
2023-06-27 06:54:20,295:INFO:superset.models.helpers:Importing new table_columns rsrc_egghead
Importing new table_columns codeevnt_railsgrls
2023-06-27 06:54:20,299:INFO:superset.models.helpers:Importing new table_columns codeevnt_railsgrls
Importing new table_columns has_children
2023-06-27 06:54:20,302:INFO:superset.models.helpers:Importing new table_columns has_children
Importing new table_columns podcast_frnthppyhr
2023-06-27 06:54:20,304:INFO:superset.models.helpers:Importing new table_columns podcast_frnthppyhr
Importing new table_columns yt_codingtrain
2023-06-27 06:54:20,307:INFO:superset.models.helpers:Importing new table_columns yt_codingtrain
Importing new table_columns rsrc_lynda
2023-06-27 06:54:20,310:INFO:superset.models.helpers:Importing new table_columns rsrc_lynda
Importing new table_columns rsrc_pluralsight
2023-06-27 06:54:20,314:INFO:superset.models.helpers:Importing new table_columns rsrc_pluralsight
Importing new table_columns hours_learning
2023-06-27 06:54:20,317:INFO:superset.models.helpers:Importing new table_columns hours_learning
Importing new table_columns yt_simplilearn
2023-06-27 06:54:20,320:INFO:superset.models.helpers:Importing new table_columns yt_simplilearn
Importing new table_columns codeevnt_wkndbtcmp
2023-06-27 06:54:20,323:INFO:superset.models.helpers:Importing new table_columns codeevnt_wkndbtcmp
Importing new table_columns codeevnt_fcc
2023-06-27 06:54:20,325:INFO:superset.models.helpers:Importing new table_columns codeevnt_fcc
Importing new table_columns rsrc_fcc
2023-06-27 06:54:20,329:INFO:superset.models.helpers:Importing new table_columns rsrc_fcc
Importing new table_columns codeevnt_coderdojo
2023-06-27 06:54:20,333:INFO:superset.models.helpers:Importing new table_columns codeevnt_coderdojo
Importing new table_columns codeevnt_nodeschl
2023-06-27 06:54:20,336:INFO:superset.models.helpers:Importing new table_columns codeevnt_nodeschl
Importing new table_columns codeevnt_womenwc
2023-06-27 06:54:20,338:INFO:superset.models.helpers:Importing new table_columns codeevnt_womenwc
Importing new table_columns codeevnt_confs
2023-06-27 06:54:20,341:INFO:superset.models.helpers:Importing new table_columns codeevnt_confs
Importing new table_columns yt_fcc
2023-06-27 06:54:20,343:INFO:superset.models.helpers:Importing new table_columns yt_fcc
Importing new table_columns codeevnt_girldevit
2023-06-27 06:54:20,347:INFO:superset.models.helpers:Importing new table_columns codeevnt_girldevit
Importing new table_columns codeevnt_meetup
2023-06-27 06:54:20,350:INFO:superset.models.helpers:Importing new table_columns codeevnt_meetup
Importing new table_columns codeevnt_workshps
2023-06-27 06:54:20,353:INFO:superset.models.helpers:Importing new table_columns codeevnt_workshps
Importing new table_columns rsrc_frntendmstr
2023-06-27 06:54:20,355:INFO:superset.models.helpers:Importing new table_columns rsrc_frntendmstr
Importing new table_columns num_children
2023-06-27 06:54:20,358:INFO:superset.models.helpers:Importing new table_columns num_children
Importing new table_columns rsrc_udemy
2023-06-27 06:54:20,361:INFO:superset.models.helpers:Importing new table_columns rsrc_udemy
Importing new table_columns rsrc_edx
2023-06-27 06:54:20,364:INFO:superset.models.helpers:Importing new table_columns rsrc_edx
Importing new table_columns rsrc_mdn
2023-06-27 06:54:20,367:INFO:superset.models.helpers:Importing new table_columns rsrc_mdn
Importing new table_columns rsrc_treehouse
2023-06-27 06:54:20,370:INFO:superset.models.helpers:Importing new table_columns rsrc_treehouse
Importing new table_columns yt_computerphile
2023-06-27 06:54:20,373:INFO:superset.models.helpers:Importing new table_columns yt_computerphile
Importing new table_columns yt_funfunfunct
2023-06-27 06:54:20,376:INFO:superset.models.helpers:Importing new table_columns yt_funfunfunct
Importing new table_columns rsrc_so
2023-06-27 06:54:20,379:INFO:superset.models.helpers:Importing new table_columns rsrc_so
Importing new table_columns yt_googledevs
2023-06-27 06:54:20,382:INFO:superset.models.helpers:Importing new table_columns yt_googledevs
Importing new table_columns yt_devtips
2023-06-27 06:54:20,385:INFO:superset.models.helpers:Importing new table_columns yt_devtips
Importing new table_columns yt_simpleprog
2023-06-27 06:54:20,387:INFO:superset.models.helpers:Importing new table_columns yt_simpleprog
Importing new table_columns yt_lvluptuts
2023-06-27 06:54:20,390:INFO:superset.models.helpers:Importing new table_columns yt_lvluptuts
Importing new table_columns time_start
2023-06-27 06:54:20,394:INFO:superset.models.helpers:Importing new table_columns time_start
Importing new table_columns time_total_sec
2023-06-27 06:54:20,397:INFO:superset.models.helpers:Importing new table_columns time_total_sec
Importing new table_columns months_programming
2023-06-27 06:54:20,400:INFO:superset.models.helpers:Importing new table_columns months_programming
Importing new table_columns age
2023-06-27 06:54:20,402:INFO:superset.models.helpers:Importing new table_columns age
Importing new table_columns ID
2023-06-27 06:54:20,405:INFO:superset.models.helpers:Importing new table_columns ID
Importing new table_columns reasons_to_code_other
2023-06-27 06:54:20,408:INFO:superset.models.helpers:Importing new table_columns reasons_to_code_other
Importing new table_columns lang_at_home
2023-06-27 06:54:20,412:INFO:superset.models.helpers:Importing new table_columns lang_at_home
Importing new table_columns when_appl_job
2023-06-27 06:54:20,415:INFO:superset.models.helpers:Importing new table_columns when_appl_job
Importing new table_columns reasons_to_code
2023-06-27 06:54:20,418:INFO:superset.models.helpers:Importing new table_columns reasons_to_code
Importing new table_columns live_city_population
2023-06-27 06:54:20,420:INFO:superset.models.helpers:Importing new table_columns live_city_population
Importing new table_columns job_lctn_pref
2023-06-27 06:54:20,424:INFO:superset.models.helpers:Importing new table_columns job_lctn_pref
Importing new table_columns job_intr_other
2023-06-27 06:54:20,428:INFO:superset.models.helpers:Importing new table_columns job_intr_other
Importing new table_columns curr_employment_other
2023-06-27 06:54:20,432:INFO:superset.models.helpers:Importing new table_columns curr_employment_other
Importing new table_columns marital_status
2023-06-27 06:54:20,435:INFO:superset.models.helpers:Importing new table_columns marital_status
Importing new table_columns bootcamp_name
2023-06-27 06:54:20,438:INFO:superset.models.helpers:Importing new table_columns bootcamp_name
Importing new table_columns podcast_other
2023-06-27 06:54:20,442:INFO:superset.models.helpers:Importing new table_columns podcast_other
Importing new table_columns school_major
2023-06-27 06:54:20,445:INFO:superset.models.helpers:Importing new table_columns school_major
Importing new table_columns job_pref
2023-06-27 06:54:20,448:INFO:superset.models.helpers:Importing new table_columns job_pref
Importing new table_columns country_citizen
2023-06-27 06:54:20,451:INFO:superset.models.helpers:Importing new table_columns country_citizen
Importing new table_columns school_degree
2023-06-27 06:54:20,454:INFO:superset.models.helpers:Importing new table_columns school_degree
Importing new table_columns codeevnt_other
2023-06-27 06:54:20,458:INFO:superset.models.helpers:Importing new table_columns codeevnt_other
Importing new table_columns curr_field
2023-06-27 06:54:20,462:INFO:superset.models.helpers:Importing new table_columns curr_field
Importing new table_columns communite_time
2023-06-27 06:54:20,465:INFO:superset.models.helpers:Importing new table_columns communite_time
Importing new table_columns rsrc_other
2023-06-27 06:54:20,468:INFO:superset.models.helpers:Importing new table_columns rsrc_other
Importing new table_columns country_live
2023-06-27 06:54:20,472:INFO:superset.models.helpers:Importing new table_columns country_live
Importing new table_columns curr_employment
2023-06-27 06:54:20,476:INFO:superset.models.helpers:Importing new table_columns curr_employment
Importing new table_columns gender_other
2023-06-27 06:54:20,479:INFO:superset.models.helpers:Importing new table_columns gender_other
Importing new table_columns time_end
2023-06-27 06:54:20,482:INFO:superset.models.helpers:Importing new table_columns time_end
Importing new table_columns network_id
2023-06-27 06:54:20,486:INFO:superset.models.helpers:Importing new table_columns network_id
Importing new table_columns yt_other
2023-06-27 06:54:20,490:INFO:superset.models.helpers:Importing new table_columns yt_other
Updating table_columns gender
2023-06-27 06:54:20,493:INFO:superset.models.helpers:Updating table_columns gender
Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz
2023-06-27 06:54:20,501:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz
Loading data inside the import transaction
2023-06-27 06:54:22,150:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction
Importing new tables main.channels
2023-06-27 06:55:53,824:INFO:superset.models.helpers:Importing new tables main.channels
Dataset has no database will retry with database_id to set permission
2023-06-27 06:55:53,826:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead.
self.database = session.query(Database).filter_by(id=self.database_id).one()
/app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning.
obj = obj_query.one_or_none()
Importing new sql_metrics count
2023-06-27 06:55:53,837:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns topic__last_set
2023-06-27 06:55:53,841:INFO:superset.models.helpers:Importing new table_columns topic__last_set
Importing new table_columns purpose__last_set
2023-06-27 06:55:53,845:INFO:superset.models.helpers:Importing new table_columns purpose__last_set
Importing new table_columns created
2023-06-27 06:55:53,848:INFO:superset.models.helpers:Importing new table_columns created
Importing new table_columns unlinked
2023-06-27 06:55:53,851:INFO:superset.models.helpers:Importing new table_columns unlinked
Importing new table_columns topic__creator
2023-06-27 06:55:53,853:INFO:superset.models.helpers:Importing new table_columns topic__creator
Importing new table_columns purpose__creator
2023-06-27 06:55:53,856:INFO:superset.models.helpers:Importing new table_columns purpose__creator
Importing new table_columns topic__value
2023-06-27 06:55:53,859:INFO:superset.models.helpers:Importing new table_columns topic__value
Importing new table_columns purpose__value
2023-06-27 06:55:53,863:INFO:superset.models.helpers:Importing new table_columns purpose__value
Importing new table_columns parent_conversation
2023-06-27 06:55:53,866:INFO:superset.models.helpers:Importing new table_columns parent_conversation
Importing new table_columns name_normalized
2023-06-27 06:55:53,869:INFO:superset.models.helpers:Importing new table_columns name_normalized
Importing new table_columns channel_id
2023-06-27 06:55:53,873:INFO:superset.models.helpers:Importing new table_columns channel_id
Importing new table_columns creator
2023-06-27 06:55:53,877:INFO:superset.models.helpers:Importing new table_columns creator
Importing new table_columns name
2023-06-27 06:55:53,881:INFO:superset.models.helpers:Importing new table_columns name
Importing new table_columns id
2023-06-27 06:55:53,884:INFO:superset.models.helpers:Importing new table_columns id
Importing new table_columns is_pending_ext_shared
2023-06-27 06:55:53,887:INFO:superset.models.helpers:Importing new table_columns is_pending_ext_shared
Importing new table_columns is_ext_shared
2023-06-27 06:55:53,891:INFO:superset.models.helpers:Importing new table_columns is_ext_shared
Importing new table_columns is_org_shared
2023-06-27 06:55:53,894:INFO:superset.models.helpers:Importing new table_columns is_org_shared
Importing new table_columns is_archived
2023-06-27 06:55:53,897:INFO:superset.models.helpers:Importing new table_columns is_archived
Importing new table_columns is_channel
2023-06-27 06:55:53,900:INFO:superset.models.helpers:Importing new table_columns is_channel
Importing new table_columns is_shared
2023-06-27 06:55:53,903:INFO:superset.models.helpers:Importing new table_columns is_shared
Importing new table_columns is_general
2023-06-27 06:55:53,906:INFO:superset.models.helpers:Importing new table_columns is_general
Importing new table_columns is_private
2023-06-27 06:55:53,910:INFO:superset.models.helpers:Importing new table_columns is_private
Importing new table_columns is_member
2023-06-27 06:55:53,913:INFO:superset.models.helpers:Importing new table_columns is_member
Importing new table_columns is_group
2023-06-27 06:55:53,916:INFO:superset.models.helpers:Importing new table_columns is_group
Importing new table_columns is_mpim
2023-06-27 06:55:53,920:INFO:superset.models.helpers:Importing new table_columns is_mpim
Importing new table_columns is_im
2023-06-27 06:55:53,923:INFO:superset.models.helpers:Importing new table_columns is_im
Importing new table_columns num_members
2023-06-27 06:55:53,927:INFO:superset.models.helpers:Importing new table_columns num_members
Importing new table_columns pending_connected_team_ids
2023-06-27 06:55:53,930:INFO:superset.models.helpers:Importing new table_columns pending_connected_team_ids
Importing new table_columns shared_team_ids
2023-06-27 06:55:53,932:INFO:superset.models.helpers:Importing new table_columns shared_team_ids
Importing new table_columns pending_shared
2023-06-27 06:55:53,936:INFO:superset.models.helpers:Importing new table_columns pending_shared
Importing new table_columns previous_names
2023-06-27 06:55:53,940:INFO:superset.models.helpers:Importing new table_columns previous_names
Importing new table_columns members
2023-06-27 06:55:53,943:INFO:superset.models.helpers:Importing new table_columns members
Couldn't check if table channels exists, assuming it does
2023-06-27 06:55:58,964:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table channels exists, assuming it does
Importing new tables main.cleaned_sales_data
2023-06-27 06:55:58,988:INFO:superset.models.helpers:Importing new tables main.cleaned_sales_data
Dataset has no database will retry with database_id to set permission
2023-06-27 06:55:58,991:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:55:59,007:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns order_date
2023-06-27 06:55:59,013:INFO:superset.models.helpers:Importing new table_columns order_date
Importing new table_columns price_each
2023-06-27 06:55:59,019:INFO:superset.models.helpers:Importing new table_columns price_each
Importing new table_columns sales
2023-06-27 06:55:59,022:INFO:superset.models.helpers:Importing new table_columns sales
Importing new table_columns address_line1
2023-06-27 06:55:59,025:INFO:superset.models.helpers:Importing new table_columns address_line1
Importing new table_columns address_line2
2023-06-27 06:55:59,028:INFO:superset.models.helpers:Importing new table_columns address_line2
Importing new table_columns contact_last_name
2023-06-27 06:55:59,031:INFO:superset.models.helpers:Importing new table_columns contact_last_name
Importing new table_columns contact_first_name
2023-06-27 06:55:59,035:INFO:superset.models.helpers:Importing new table_columns contact_first_name
Importing new table_columns quantity_ordered
2023-06-27 06:55:59,038:INFO:superset.models.helpers:Importing new table_columns quantity_ordered
Importing new table_columns year
2023-06-27 06:55:59,040:INFO:superset.models.helpers:Importing new table_columns year
Importing new table_columns postal_code
2023-06-27 06:55:59,042:INFO:superset.models.helpers:Importing new table_columns postal_code
Importing new table_columns customer_name
2023-06-27 06:55:59,046:INFO:superset.models.helpers:Importing new table_columns customer_name
Importing new table_columns deal_size
2023-06-27 06:55:59,050:INFO:superset.models.helpers:Importing new table_columns deal_size
Importing new table_columns state
2023-06-27 06:55:59,053:INFO:superset.models.helpers:Importing new table_columns state
Importing new table_columns status
2023-06-27 06:55:59,056:INFO:superset.models.helpers:Importing new table_columns status
Importing new table_columns order_line_number
2023-06-27 06:55:59,059:INFO:superset.models.helpers:Importing new table_columns order_line_number
Importing new table_columns order_number
2023-06-27 06:55:59,063:INFO:superset.models.helpers:Importing new table_columns order_number
Importing new table_columns month
2023-06-27 06:55:59,068:INFO:superset.models.helpers:Importing new table_columns month
Importing new table_columns quarter
2023-06-27 06:55:59,072:INFO:superset.models.helpers:Importing new table_columns quarter
Importing new table_columns msrp
2023-06-27 06:55:59,075:INFO:superset.models.helpers:Importing new table_columns msrp
Importing new table_columns product_code
2023-06-27 06:55:59,079:INFO:superset.models.helpers:Importing new table_columns product_code
Importing new table_columns product_line
2023-06-27 06:55:59,083:INFO:superset.models.helpers:Importing new table_columns product_line
Importing new table_columns city
2023-06-27 06:55:59,086:INFO:superset.models.helpers:Importing new table_columns city
Importing new table_columns country
2023-06-27 06:55:59,089:INFO:superset.models.helpers:Importing new table_columns country
Importing new table_columns phone
2023-06-27 06:55:59,091:INFO:superset.models.helpers:Importing new table_columns phone
Importing new table_columns territory
2023-06-27 06:55:59,094:INFO:superset.models.helpers:Importing new table_columns territory
Couldn't check if table cleaned_sales_data exists, assuming it does
2023-06-27 06:56:04,114:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table cleaned_sales_data exists, assuming it does
Importing new tables main.users
2023-06-27 06:56:04,125:INFO:superset.models.helpers:Importing new tables main.users
Dataset has no database will retry with database_id to set permission
2023-06-27 06:56:04,128:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:56:04,145:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns updated
2023-06-27 06:56:04,153:INFO:superset.models.helpers:Importing new table_columns updated
Importing new table_columns has_2fa
2023-06-27 06:56:04,160:INFO:superset.models.helpers:Importing new table_columns has_2fa
Importing new table_columns real_name
2023-06-27 06:56:04,167:INFO:superset.models.helpers:Importing new table_columns real_name
Importing new table_columns tz_label
2023-06-27 06:56:04,174:INFO:superset.models.helpers:Importing new table_columns tz_label
Importing new table_columns team_id
2023-06-27 06:56:04,179:INFO:superset.models.helpers:Importing new table_columns team_id
Importing new table_columns name
2023-06-27 06:56:04,183:INFO:superset.models.helpers:Importing new table_columns name
Importing new table_columns color
2023-06-27 06:56:04,187:INFO:superset.models.helpers:Importing new table_columns color
Importing new table_columns id
2023-06-27 06:56:04,190:INFO:superset.models.helpers:Importing new table_columns id
Importing new table_columns tz
2023-06-27 06:56:04,193:INFO:superset.models.helpers:Importing new table_columns tz
Importing new table_columns is_ultra_restricted
2023-06-27 06:56:04,196:INFO:superset.models.helpers:Importing new table_columns is_ultra_restricted
Importing new table_columns is_primary_owner
2023-06-27 06:56:04,199:INFO:superset.models.helpers:Importing new table_columns is_primary_owner
Importing new table_columns is_app_user
2023-06-27 06:56:04,203:INFO:superset.models.helpers:Importing new table_columns is_app_user
Importing new table_columns is_admin
2023-06-27 06:56:04,206:INFO:superset.models.helpers:Importing new table_columns is_admin
Importing new table_columns is_bot
2023-06-27 06:56:04,210:INFO:superset.models.helpers:Importing new table_columns is_bot
Importing new table_columns is_restricted
2023-06-27 06:56:04,213:INFO:superset.models.helpers:Importing new table_columns is_restricted
Importing new table_columns is_owner
2023-06-27 06:56:04,216:INFO:superset.models.helpers:Importing new table_columns is_owner
Importing new table_columns deleted
2023-06-27 06:56:04,220:INFO:superset.models.helpers:Importing new table_columns deleted
Importing new table_columns tz_offset
2023-06-27 06:56:04,224:INFO:superset.models.helpers:Importing new table_columns tz_offset
Couldn't check if table users exists, assuming it does
2023-06-27 06:56:09,246:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table users exists, assuming it does
Importing new tables main.covid_vaccines
2023-06-27 06:56:09,256:INFO:superset.models.helpers:Importing new tables main.covid_vaccines
Dataset has no database will retry with database_id to set permission
2023-06-27 06:56:09,259:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:56:09,277:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns clinical_stage
2023-06-27 06:56:09,282:INFO:superset.models.helpers:Importing new table_columns clinical_stage
Importing new table_columns fda_approved_indications
2023-06-27 06:56:09,287:INFO:superset.models.helpers:Importing new table_columns fda_approved_indications
Importing new table_columns anticipated_next_steps
2023-06-27 06:56:09,291:INFO:superset.models.helpers:Importing new table_columns anticipated_next_steps
Importing new table_columns ioc_country_code
2023-06-27 06:56:09,295:INFO:superset.models.helpers:Importing new table_columns ioc_country_code
Importing new table_columns clinical_trials_for_other_diseases_or_related_use
2023-06-27 06:56:09,299:INFO:superset.models.helpers:Importing new table_columns clinical_trials_for_other_diseases_or_related_use
Importing new table_columns country_name
2023-06-27 06:56:09,304:INFO:superset.models.helpers:Importing new table_columns country_name
Importing new table_columns product_category
2023-06-27 06:56:09,308:INFO:superset.models.helpers:Importing new table_columns product_category
Importing new table_columns clinical_trials
2023-06-27 06:56:09,311:INFO:superset.models.helpers:Importing new table_columns clinical_trials
Importing new table_columns date_last_updated
2023-06-27 06:56:09,313:INFO:superset.models.helpers:Importing new table_columns date_last_updated
Importing new table_columns product_description
2023-06-27 06:56:09,317:INFO:superset.models.helpers:Importing new table_columns product_description
Importing new table_columns developer_or_researcher
2023-06-27 06:56:09,320:INFO:superset.models.helpers:Importing new table_columns developer_or_researcher
Importing new table_columns stage_of_development
2023-06-27 06:56:09,323:INFO:superset.models.helpers:Importing new table_columns stage_of_development
Importing new table_columns funder
2023-06-27 06:56:09,326:INFO:superset.models.helpers:Importing new table_columns funder
Importing new table_columns published_results
2023-06-27 06:56:09,328:INFO:superset.models.helpers:Importing new table_columns published_results
Importing new table_columns sources
2023-06-27 06:56:09,332:INFO:superset.models.helpers:Importing new table_columns sources
Importing new table_columns treatment_vs_vaccine
2023-06-27 06:56:09,335:INFO:superset.models.helpers:Importing new table_columns treatment_vs_vaccine
Couldn't check if table covid_vaccines exists, assuming it does
2023-06-27 06:56:14,358:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table covid_vaccines exists, assuming it does
Importing new tables main.exported_stats
2023-06-27 06:56:14,379:INFO:superset.models.helpers:Importing new tables main.exported_stats
Dataset has no database will retry with database_id to set permission
2023-06-27 06:56:14,382:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:56:14,400:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns new_members
2023-06-27 06:56:14,406:INFO:superset.models.helpers:Importing new table_columns new_members
Importing new table_columns percent_of_messages_private_channels
2023-06-27 06:56:14,410:INFO:superset.models.helpers:Importing new table_columns percent_of_messages_private_channels
Importing new table_columns percent_of_messages_public_channels
2023-06-27 06:56:14,414:INFO:superset.models.helpers:Importing new table_columns percent_of_messages_public_channels
Importing new table_columns percent_of_views_private_channels
2023-06-27 06:56:14,417:INFO:superset.models.helpers:Importing new table_columns percent_of_views_private_channels
Importing new table_columns percent_of_views_public_channels
2023-06-27 06:56:14,420:INFO:superset.models.helpers:Importing new table_columns percent_of_views_public_channels
Importing new table_columns percent_of_messages_dms
2023-06-27 06:56:14,424:INFO:superset.models.helpers:Importing new table_columns percent_of_messages_dms
Importing new table_columns percent_of_views_dms
2023-06-27 06:56:14,427:INFO:superset.models.helpers:Importing new table_columns percent_of_views_dms
Importing new table_columns date
2023-06-27 06:56:14,430:INFO:superset.models.helpers:Importing new table_columns date
Importing new table_columns daily_members_posting_messages
2023-06-27 06:56:14,433:INFO:superset.models.helpers:Importing new table_columns daily_members_posting_messages
Importing new table_columns messages_in_shared_channels
2023-06-27 06:56:14,435:INFO:superset.models.helpers:Importing new table_columns messages_in_shared_channels
Importing new table_columns messages_in_private_channels
2023-06-27 06:56:14,438:INFO:superset.models.helpers:Importing new table_columns messages_in_private_channels
Importing new table_columns messages_in_public_channels
2023-06-27 06:56:14,442:INFO:superset.models.helpers:Importing new table_columns messages_in_public_channels
Importing new table_columns weekly_members_posting_messages
2023-06-27 06:56:14,445:INFO:superset.models.helpers:Importing new table_columns weekly_members_posting_messages
Importing new table_columns public_channels_single_workspace
2023-06-27 06:56:14,448:INFO:superset.models.helpers:Importing new table_columns public_channels_single_workspace
Importing new table_columns messages_in_dms
2023-06-27 06:56:14,451:INFO:superset.models.helpers:Importing new table_columns messages_in_dms
Importing new table_columns daily_active_members
2023-06-27 06:56:14,456:INFO:superset.models.helpers:Importing new table_columns daily_active_members
Importing new table_columns weekly_active_members
2023-06-27 06:56:14,460:INFO:superset.models.helpers:Importing new table_columns weekly_active_members
Importing new table_columns full_members
2023-06-27 06:56:14,463:INFO:superset.models.helpers:Importing new table_columns full_members
Importing new table_columns messages_posted
2023-06-27 06:56:14,467:INFO:superset.models.helpers:Importing new table_columns messages_posted
Importing new table_columns total_membership
2023-06-27 06:56:14,471:INFO:superset.models.helpers:Importing new table_columns total_membership
Importing new table_columns guests
2023-06-27 06:56:14,475:INFO:superset.models.helpers:Importing new table_columns guests
Importing new table_columns name
2023-06-27 06:56:14,478:INFO:superset.models.helpers:Importing new table_columns name
Couldn't check if table exported_stats exists, assuming it does
2023-06-27 06:56:19,500:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table exported_stats exists, assuming it does
Importing new tables main.messages
2023-06-27 06:56:19,516:INFO:superset.models.helpers:Importing new tables main.messages
Dataset has no database will retry with database_id to set permission
2023-06-27 06:56:19,520:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:56:19,539:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns bot_profile__updated
2023-06-27 06:56:19,543:INFO:superset.models.helpers:Importing new table_columns bot_profile__updated
Importing new table_columns last_read
2023-06-27 06:56:19,546:INFO:superset.models.helpers:Importing new table_columns last_read
Importing new table_columns ts
2023-06-27 06:56:19,549:INFO:superset.models.helpers:Importing new table_columns ts
Importing new table_columns bot_profile__team_id
2023-06-27 06:56:19,552:INFO:superset.models.helpers:Importing new table_columns bot_profile__team_id
Importing new table_columns bot_profile__app_id
2023-06-27 06:56:19,554:INFO:superset.models.helpers:Importing new table_columns bot_profile__app_id
Importing new table_columns bot_profile__name
2023-06-27 06:56:19,557:INFO:superset.models.helpers:Importing new table_columns bot_profile__name
Importing new table_columns bot_profile__id
2023-06-27 06:56:19,561:INFO:superset.models.helpers:Importing new table_columns bot_profile__id
Importing new table_columns parent_user_id
2023-06-27 06:56:19,564:INFO:superset.models.helpers:Importing new table_columns parent_user_id
Importing new table_columns client_msg_id
2023-06-27 06:56:19,567:INFO:superset.models.helpers:Importing new table_columns client_msg_id
Importing new table_columns icons__emoji
2023-06-27 06:56:19,570:INFO:superset.models.helpers:Importing new table_columns icons__emoji
Importing new table_columns channel_id
2023-06-27 06:56:19,575:INFO:superset.models.helpers:Importing new table_columns channel_id
Importing new table_columns source_team
2023-06-27 06:56:19,578:INFO:superset.models.helpers:Importing new table_columns source_team
Importing new table_columns thread_ts
2023-06-27 06:56:19,581:INFO:superset.models.helpers:Importing new table_columns thread_ts
...
Importing new table_columns reply_users_count
2023-06-27 06:56:19,660:INFO:superset.models.helpers:Importing new table_columns reply_users_count
Importing new table_columns unread_count
2023-06-27 06:56:19,663:INFO:superset.models.helpers:Importing new table_columns unread_count
Importing new table_columns reply_count
2023-06-27 06:56:19,666:INFO:superset.models.helpers:Importing new table_columns reply_count
Importing new table_columns file_ids
2023-06-27 06:56:19,669:INFO:superset.models.helpers:Importing new table_columns file_ids
Importing new table_columns pinned_to
2023-06-27 06:56:19,672:INFO:superset.models.helpers:Importing new table_columns pinned_to
Importing new table_columns reply_users
2023-06-27 06:56:19,675:INFO:superset.models.helpers:Importing new table_columns reply_users
Importing new table_columns reactions
2023-06-27 06:56:19,678:INFO:superset.models.helpers:Importing new table_columns reactions
Importing new table_columns blocks
2023-06-27 06:56:19,680:INFO:superset.models.helpers:Importing new table_columns blocks
Couldn't check if table messages exists, assuming it does
2023-06-27 06:56:24,702:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table messages exists, assuming it does
Importing new tables main.video_game_sales
2023-06-27 06:56:24,712:INFO:superset.models.helpers:Importing new tables main.video_game_sales
Dataset has no database will retry with database_id to set permission
2023-06-27 06:56:24,715:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:56:24,732:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns year
2023-06-27 06:56:24,739:INFO:superset.models.helpers:Importing new table_columns year
Importing new table_columns na_sales
2023-06-27 06:56:24,746:INFO:superset.models.helpers:Importing new table_columns na_sales
Importing new table_columns eu_sales
2023-06-27 06:56:24,754:INFO:superset.models.helpers:Importing new table_columns eu_sales
Importing new table_columns global_sales
2023-06-27 06:56:24,761:INFO:superset.models.helpers:Importing new table_columns global_sales
Importing new table_columns jp_sales
2023-06-27 06:56:24,764:INFO:superset.models.helpers:Importing new table_columns jp_sales
Importing new table_columns other_sales
2023-06-27 06:56:24,767:INFO:superset.models.helpers:Importing new table_columns other_sales
Importing new table_columns rank
2023-06-27 06:56:24,770:INFO:superset.models.helpers:Importing new table_columns rank
Importing new table_columns genre
2023-06-27 06:56:24,773:INFO:superset.models.helpers:Importing new table_columns genre
Importing new table_columns name
2023-06-27 06:56:24,776:INFO:superset.models.helpers:Importing new table_columns name
Importing new table_columns platform
2023-06-27 06:56:24,779:INFO:superset.models.helpers:Importing new table_columns platform
Importing new table_columns publisher
2023-06-27 06:56:24,783:INFO:superset.models.helpers:Importing new table_columns publisher
Couldn't check if table video_game_sales exists, assuming it does
2023-06-27 06:56:29,804:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table video_game_sales exists, assuming it does
Importing new tables main.channel_members
2023-06-27 06:56:29,826:INFO:superset.models.helpers:Importing new tables main.channel_members
Dataset has no database will retry with database_id to set permission
2023-06-27 06:56:29,830:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission
Importing new sql_metrics count
2023-06-27 06:56:29,848:INFO:superset.models.helpers:Importing new sql_metrics count
Importing new table_columns channel_id
2023-06-27 06:56:29,853:INFO:superset.models.helpers:Importing new table_columns channel_id
Importing new table_columns user_id
2023-06-27 06:56:29,859:INFO:superset.models.helpers:Importing new table_columns user_id
Couldn't check if table channel_members exists, assuming it does
2023-06-27 06:56:34,880:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table channel_members exists, assuming it does
Importing new slices Total Items Sold
2023-06-27 06:56:34,904:INFO:superset.models.helpers:Importing new slices Total Items Sold
Environment
$ docker images REPOSITORY TAG IMAGE ID CREATED SIZE apache/superset latest 7502beb92ce5 15 hours ago 1.11GB
Running on Ubuntu 20.04 in WSL 2 on Windows 10 / Docker Desktop
Many thanks for any assistance!
Comment From: moelfus
I was facing the same problem. I re-setup everything with a mysql backend and:
- superset upgrade db
- superset init
- superset load-examples
And I don't face the problems mentioned above, even though the warnings still appear.
Comment From: onestarshang
have the same problems
Comment From: sebastianliebscher
Hi @pcrozer does this issue still persist for you? I could not reproduce this with Superset 3.0.1. Can you provide more info about steps to reproduce?
Comment From: dbaltor
I'm having the same issue with Superset 3.0.1 on Kubernetes.
Here is the end of the superset-init-db pod logs
Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz
2023-12-27 13:37:23,438:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz
Loading data outside the import transaction
2023-12-27 13:37:25,123:WARNING:superset.datasets.commands.importers.v1.utils:Loading data outside the import transaction
Importing new slices Work Location Preference
2023-12-27 13:38:54,667:INFO:superset.models.helpers:Importing new slices Work Location Preference
Importing new slices Weekly Threads
2023-12-27 13:38:54,680:INFO:superset.models.helpers:Importing new slices Weekly Threads
Importing new slices Weekly Messages
2023-12-27 13:38:54,694:INFO:superset.models.helpers:Importing new slices Weekly Messages
Importing new slices Video Game Sales filter
2023-12-27 13:38:54,705:INFO:superset.models.helpers:Importing new slices Video Game Sales filter
Importing new slices Vehicle Sales Filter
2023-12-27 13:38:54,717:INFO:superset.models.helpers:Importing new slices Vehicle Sales Filter
Importing new slices Vaccine Candidates per Phase
2023-12-27 13:38:54,732:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Phase
Importing new slices Vaccine Candidates per Phase
2023-12-27 13:38:54,749:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Phase
Importing new slices Vaccine Candidates per Country & Stage
2023-12-27 13:38:54,759:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country & Stage
Importing new slices Vaccine Candidates per Country & Stage
2023-12-27 13:38:54,769:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country & Stage
Importing new slices Vaccine Candidates per Country
2023-12-27 13:38:54,778:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country
Importing new slices Vaccine Candidates per Country
2023-12-27 13:38:54,790:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country
Importing new slices Vaccine Candidates per Approach & Stage
2023-12-27 13:38:54,807:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Approach & Stage
Importing new slices Unicode Cloud
2023-12-27 13:38:54,817:INFO:superset.models.helpers:Importing new slices Unicode Cloud
Importing new slices Total Sales per Market (Grouped by Genre)
2023-12-27 13:38:54,827:INFO:superset.models.helpers:Importing new slices Total Sales per Market (Grouped by Genre)
Importing new slices Total Revenue
2023-12-27 13:38:54,838:INFO:superset.models.helpers:Importing new slices Total Revenue
Importing new slices Total Items Sold (By Product Line)
2023-12-27 13:38:54,847:INFO:superset.models.helpers:Importing new slices Total Items Sold (By Product Line)
Importing new slices Total Items Sold
2023-12-27 13:38:54,857:INFO:superset.models.helpers:Importing new slices Total Items Sold
Importing new slices Top Timezones
2023-12-27 13:38:54,867:INFO:superset.models.helpers:Importing new slices Top Timezones
Importing new slices Top 15 Languages Spoken at Home
2023-12-27 13:38:54,876:INFO:superset.models.helpers:Importing new slices Top 15 Languages Spoken at Home
Importing new slices Top 10 Games: Proportion of Sales in Markets
2023-12-27 13:38:54,888:INFO:superset.models.helpers:Importing new slices Top 10 Games: Proportion of Sales in Markets
Importing new slices Seasonality of Revenue (per Product Line)
2023-12-27 13:38:54,899:INFO:superset.models.helpers:Importing new slices Seasonality of Revenue (per Product Line)
Importing new slices Rise & Fall of Video Game Consoles
2023-12-27 13:38:54,910:INFO:superset.models.helpers:Importing new slices Rise & Fall of Video Game Consoles
Importing new slices Revenue by Deal Size
2023-12-27 13:38:54,921:INFO:superset.models.helpers:Importing new slices Revenue by Deal Size
Importing new slices ✈️ Relocation ability
2023-12-27 13:38:54,934:INFO:superset.models.helpers:Importing new slices ✈️ Relocation ability
Importing new slices Quarterly Sales (By Product Line)
2023-12-27 13:38:54,945:INFO:superset.models.helpers:Importing new slices Quarterly Sales (By Product Line)
Importing new slices Quarterly Sales
2023-12-27 13:38:54,956:INFO:superset.models.helpers:Importing new slices Quarterly Sales
Importing new slices Publishers With Most Titles
2023-12-27 13:38:54,967:INFO:superset.models.helpers:Importing new slices Publishers With Most Titles
Importing new slices Proportion of Revenue by Product Line
2023-12-27 13:38:54,977:INFO:superset.models.helpers:Importing new slices Proportion of Revenue by Product Line
Importing new slices Preferred Employment Style
2023-12-27 13:38:54,989:INFO:superset.models.helpers:Importing new slices Preferred Employment Style
Importing new slices Popular Genres Across Platforms
2023-12-27 13:38:55,004:INFO:superset.models.helpers:Importing new slices Popular Genres Across Platforms
Importing new slices Overall Sales (By Product Line)
2023-12-27 13:38:55,017:INFO:superset.models.helpers:Importing new slices Overall Sales (By Product Line)
Importing new slices Number of Members
2023-12-27 13:38:55,029:INFO:superset.models.helpers:Importing new slices Number of Members
Importing new slices # of Games That Hit 100k in Sales By Release Year
2023-12-27 13:38:55,044:INFO:superset.models.helpers:Importing new slices # of Games That Hit 100k in Sales By Release Year
Importing new slices Number of Deals (for each Combination)
2023-12-27 13:38:55,055:INFO:superset.models.helpers:Importing new slices Number of Deals (for each Combination)
Importing new slices Number of Aspiring Developers
2023-12-27 13:38:55,071:INFO:superset.models.helpers:Importing new slices Number of Aspiring Developers
Importing new slices New Members per Month
2023-12-27 13:38:55,083:INFO:superset.models.helpers:Importing new slices New Members per Month
Importing new slices Most Dominant Platforms
2023-12-27 13:38:55,104:INFO:superset.models.helpers:Importing new slices Most Dominant Platforms
Importing new slices Messages per Channel
2023-12-27 13:38:55,119:INFO:superset.models.helpers:Importing new slices Messages per Channel
Importing new slices Members per Channel
2023-12-27 13:38:55,137:INFO:superset.models.helpers:Importing new slices Members per Channel
Importing new slices Location of Current Developers
2023-12-27 13:38:55,154:INFO:superset.models.helpers:Importing new slices Location of Current Developers
Importing new slices Last Year Income Distribution
2023-12-27 13:38:55,168:INFO:superset.models.helpers:Importing new slices Last Year Income Distribution
Importing new slices How much do you expect to earn? ($0 - 100k)
2023-12-27 13:38:55,179:INFO:superset.models.helpers:Importing new slices How much do you expect to earn? ($0 - 100k)
Importing new slices How do you prefer to work?
2023-12-27 13:38:55,200:INFO:superset.models.helpers:Importing new slices How do you prefer to work?
Importing new slices Highest degree held
2023-12-27 13:38:55,221:INFO:superset.models.helpers:Importing new slices Highest degree held
Importing new slices Gender
2023-12-27 13:38:55,237:INFO:superset.models.helpers:Importing new slices Gender
Importing new slices Games per Genre over time
2023-12-27 13:38:55,251:INFO:superset.models.helpers:Importing new slices Games per Genre over time
Importing new slices Games per Genre
2023-12-27 13:38:55,262:INFO:superset.models.helpers:Importing new slices Games per Genre
Importing new slices Games
2023-12-27 13:38:55,275:INFO:superset.models.helpers:Importing new slices Games
Importing new slices First Time Developer & Commute Time
2023-12-27 13:38:55,287:INFO:superset.models.helpers:Importing new slices First Time Developer & Commute Time
Importing new slices First Time Developer?
2023-12-27 13:38:55,304:INFO:superset.models.helpers:Importing new slices First Time Developer?
Importing new slices Filtering Vaccines
2023-12-27 13:38:55,319:INFO:superset.models.helpers:Importing new slices Filtering Vaccines
Importing new slices Filter Segments
2023-12-27 13:38:55,330:INFO:superset.models.helpers:Importing new slices Filter Segments
Importing new slices Ethnic Minority & Gender
2023-12-27 13:38:55,343:INFO:superset.models.helpers:Importing new slices Ethnic Minority & Gender
Importing new slices Degrees vs Income
2023-12-27 13:38:55,354:INFO:superset.models.helpers:Importing new slices Degrees vs Income
Importing new slices Current Developers: Is this your first development job?
2023-12-27 13:38:55,365:INFO:superset.models.helpers:Importing new slices Current Developers: Is this your first development job?
Importing new slices Cross Channel Relationship heatmap
2023-12-27 13:38:55,376:INFO:superset.models.helpers:Importing new slices Cross Channel Relationship heatmap
Importing new slices Cross Channel Relationship
2023-12-27 13:38:55,389:INFO:superset.models.helpers:Importing new slices Cross Channel Relationship
Importing new slices Country of Citizenship
2023-12-27 13:38:55,411:INFO:superset.models.helpers:Importing new slices Country of Citizenship
Importing new slices Commute Time
2023-12-27 13:38:55,421:INFO:superset.models.helpers:Importing new slices Commute Time
Importing new slices Breakdown of Developer Type
2023-12-27 13:38:55,430:INFO:superset.models.helpers:Importing new slices Breakdown of Developer Type
Importing new slices Are you an ethnic minority in your city?
2023-12-27 13:38:55,445:INFO:superset.models.helpers:Importing new slices Are you an ethnic minority in your city?
Importing new slices Age distribution of respondents
2023-12-27 13:38:55,459:INFO:superset.models.helpers:Importing new slices Age distribution of respondents
Importing new dashboards Dashboard<None>
2023-12-27 13:38:55,477:INFO:superset.models.helpers:Importing new dashboards Dashboard<None>
Importing new dashboards Dashboard<unicode-test>
2023-12-27 13:38:55,493:INFO:superset.models.helpers:Importing new dashboards Dashboard<unicode-test>
Importing new dashboards Dashboard<None>
2023-12-27 13:38:55,503:INFO:superset.models.helpers:Importing new dashboards Dashboard<None>
Importing new dashboards Dashboard<None>
2023-12-27 13:38:55,515:INFO:superset.models.helpers:Importing new dashboards Dashboard<None>
Importing new dashboards Dashboard<None>
2023-12-27 13:38:55,527:INFO:superset.models.helpers:Importing new dashboards Dashboard<None>
Importing new dashboards Dashboard<None>
2023-12-27 13:38:55,540:INFO:superset.models.helpers:Importing new dashboards Dashboard<None>
Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py]
Loading examples metadata and related data into examples
Creating default CSS templates
Loading [World Bank's Health Nutrition and Population Stats]
Creating table [wb_health_population] reference
Creating a World's Health Bank dashboard
Loading [Birth names]
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
Creating some slices
Creating a dashboard
Loading [Random long/lat data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
Creating a slice
Loading [Country Map data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
Creating a slice
Loading [San Francisco population polygons]
Creating table sf_population_polygons reference
Loading [Flights data]
Done loading table!
Loading [BART lines]
Creating table bart_lines reference
Loading [Misc Charts] dashboard
Creating the dashboard
Loading DECK.gl demo
Loading deck.gl dashboard
Creating Scatterplot slice
Creating Screen Grid slice
Creating Hex slice
Creating Grid slice
Creating Polygon slice
Creating Arc slice
Creating Path slice
Creating a dashboard
I can't find any errors in the logs but this warning:
2023-12-27 13:37:25,123:WARNING:superset.datasets.commands.importers.v1.utils:Loading data outside the import transaction
Here is a snippet from the Superset node logs when I try to open an example dashboard:
Query SELECT country_name AS country_name,
COUNT(*) AS count
FROM main.covid_vaccines
GROUP BY country_name
LIMIT 10000
OFFSET 0 on schema main failed
Traceback (most recent call last):
File "/app/superset/connectors/sqla/models.py", line 1214, in query
df = self.database.get_df(sql, self.schema, mutator=assign_column_label)
File "/app/superset/models/core.py", line 611, in get_df
self.db_engine_spec.execute(cursor, sqls[-1])
File "/app/superset/db_engine_specs/base.py", line 1535, in execute
raise cls.get_dbapi_mapped_exception(ex) from ex
File "/app/superset/db_engine_specs/base.py", line 1533, in execute
cursor.execute(query)
sqlite3.OperationalError: no such table: main.covid_vaccines
2023-12-27 13:40:35,855:WARNING:superset.connectors.sqla.models:Query SELECT country_name AS country_name,
COUNT(*) AS count
FROM main.covid_vaccines
GROUP BY country_name
LIMIT 10000
OFFSET 0 on schema main failed
Traceback (most recent call last):
File "/app/superset/connectors/sqla/models.py", line 1214, in query
df = self.database.get_df(sql, self.schema, mutator=assign_column_label)
File "/app/superset/models/core.py", line 611, in get_df
self.db_engine_spec.execute(cursor, sqls[-1])
File "/app/superset/db_engine_specs/base.py", line 1535, in execute
raise cls.get_dbapi_mapped_exception(ex) from ex
File "/app/superset/db_engine_specs/base.py", line 1533, in execute
cursor.execute(query)
sqlite3.OperationalError: no such table: main.covid_vaccines
It looks like superset-init-db silently fails to create the tables and load the data.
Comment From: rusackas
This issue hasn't been touched since last year, so I'm assuming folks here have either solved it or moved along somehow. Let me know if you think it's a problem closing this, and I'll be happy to reopen it.
Comment From: dbaltor
I had to deploy Superset without the examples to move forward. It's a shame as I think it would be helpful to have them around in some lower environments. I'd like to see this solved.
Comment From: rusackas
@dbaltor the original bug reported is quote old... what issues are you facing? I run docker compose on each and every release to test the example dashboards, and they've all been fine. In fact, I'm testing the new 3.1.3 and 4.0.1 release candidates today, and all seems well so far.
Comment From: MohamedRhimii
I'm viewing a similar issue. All load_examples dashboards are created on helm upgrade --install. But whenever I helm upgrade again, the dashboards/charts related to examples seem to be returning same issues as reported here.
Running manually these steps in the superset pod fixes the dashboards/charts again: - superset upgrade db - superset init - superset load-examples
Is there anyway to persist them? Cache them? I want to get rid of this behaviour.
Comment From: rusackas
@betodealmeida or @sadpandajoe might have some insights on that.
Comment From: dbaltor
Thanks @rusackas for replying and apologies for not being able to look into this before.
I'm still facing the same issues with the examples after upgrading the helm chart to the latest version, 0.12.11 which deploys Superset 4.0.1 on Kubernetes. Given that you're running it on compose and I'm using K8s, I think the issue isn't with the code but instead with the installation process, in other words, it might well be an issue with the helm chart.
After reading the @MohamedRhimii comments above, I gave it a whirl and run superset load-examples in the superset pod. That fixed the examples over here as well.
Comment From: dbaltor
Can we get this issue reopened please?
Comment From: MohamedRhimii
@dbaltor I'm happy my workaround worked for you. This issue should be adressed, anyone has an idea of a possible permanent fix?
Comment From: rusackas
Reopened... any updated context folks can add (versions, logs, errors, etc) to recapitulate the situation would probably help.
Comment From: MohamedRhimii
Ok, for reference, I'm using superset helm, appVersion: "3.1.0", version: 0.12.3
Example screenshot:
This screenshot is an example. All superset example dashboards/charts are broken, in this same way.
Logs generated after accessing the dashboard:
WARNING:superset.views.base:Superset.explore_json This API endpoint is deprecated and will be removed in version 4.0.0 DEBUG:parsedatetime:eval - with context - False, False Cache key: c4eaa8267cee23dd01548b85a3c127db INFO:superset.viz:Cache key: c4eaa8267cee23dd01548b85a3c127db Superset.explore_json This API endpoint is deprecated and will be removed in version 4.0.0 WARNING:superset.views.base:Superset.explore_json This API endpoint is deprecated and will be removed in version 4.0.0 DEBUG:parsedatetime:eval - with context - False, False Cache key: 350f59f6383a87ae03b43cedca52db5e INFO:superset.viz:Cache key: 350f59f6383a87ae03b43cedca52db5e Query SELECT sum(sales) AS "(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data WARNING:superset.connectors.sqla.models:Query SELECT sum(sales) AS "(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data Query SELECT DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) AS __timestamp, sum(sales) AS "SUM(Sales)" FROM main.cleaned_sales_data GROUP BY DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) ORDER BY "SUM(Sales)" DESC LIMIT 10000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data WARNING:superset.connectors.sqla.models:Query SELECT DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) AS __timestamp, sum(sales) AS "SUM(Sales)" FROM main.cleaned_sales_data GROUP BY DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) ORDER BY "SUM(Sales)" DESC LIMIT 10000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data Query SELECT sum(quantity_ordered) AS "SUM(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data WARNING:superset.connectors.sqla.models:Query SELECT sum(quantity_ordered) AS "SUM(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data
My workaround, as stated above, was to just run superset load-examples within the superset main pod. That reloaded all broken dashboard examples.
Thanks!
Comment From: rusackas
Curious if @dosu-bot has any light to shed on this
Comment From: dbaltor
The same issue with the latest version when deployed on Kubernetes: Superset "4.0.1", helm chart version: "0.12.11". The logs are exactly like above.
Comment From: dbaltor
@MohamedRhimii by any chance, would you know where we can find the latest helm chart 0.13.0? It's mentioned on the repo but it is not available at helm repo add superset http://apache.github.io/superset/ and I'd like to upgrade to Superset 4.0.2 .
Comment From: cnu80
superset load-examples
kubectl exec -it superset-666fb469b4-p9p26 -- superset load-examples
Comment From: rusackas
Anyone still facing this? It seems the superset load-examples bit helped some. I don't want to close this if there's an actual bug in current versions (i.e. 4.1.2)