Superset and SQLLab - error with Preview for the table · Issue #11 · googleapis/python-bigquery-sqlalchemy · GitHub
Skip to content
This repository was archived by the owner on May 16, 2026. It is now read-only.
This repository was archived by the owner on May 16, 2026. It is now read-only.

Superset and SQLLab - error with Preview for the table #11

Closed
Closed
Superset and SQLLab - error with Preview for the table#11

Description

@darylerwin
darylerwin
opened on Feb 11, 2018

Select the dataset.tablename from the SQLLab drop downs.
The supeset UI returns "cannot import name Row" on the Preview tab.

The log returns the following:

2018-02-11 14:07:04,225:DEBUG:root:[stats_logger] (incr) table
2018-02-11 14:07:04,240:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,240:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,399:DEBUG:urllib3.util.retry:Converted retries value: 3 -> Retry(total=3, connect=None, read=None, redirect=None, status=None)
2018-02-11 14:07:04,402:DEBUG:google.auth.transport.requests:Making request: POST https://accounts.google.com/o/oauth2/token
2018-02-11 14:07:04,406:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): accounts.google.com
2018-02-11 14:07:04,446:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,447:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,452:DEBUG:urllib3.util.retry:Converted retries value: 3 -> Retry(total=3, connect=None, read=None, redirect=None, status=None)
2018-02-11 14:07:04,459:DEBUG:google.auth.transport.requests:Making request: POST https://accounts.google.com/o/oauth2/token
2018-02-11 14:07:04,463:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): accounts.google.com
2018-02-11 14:07:04,481:DEBUG:urllib3.connectionpool:https://accounts.google.com:443 "POST /o/oauth2/token HTTP/1.1" 200 None
2018-02-11 14:07:04,484:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): www.googleapis.com
2018-02-11 14:07:04,502:DEBUG:root:[stats_logger] (incr) extra_table_metadata
2018-02-11 14:07:04,539:DEBUG:urllib3.connectionpool:https://accounts.google.com:443 "POST /o/oauth2/token HTTP/1.1" 200 None
2018-02-11 14:07:04,541:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): www.googleapis.com
2018-02-11 14:07:04,619:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/datasets/visualizations/tables/REVENUE_RPT HTTP/1.1" 200 None
2018-02-11 14:07:04,621:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,621:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,634:DEBUG:urllib3.util.retry:Converted retries value: 3 -> Retry(total=3, connect=None, read=None, redirect=None, status=None)
2018-02-11 14:07:04,636:DEBUG:google.auth.transport.requests:Making request: POST https://accounts.google.com/o/oauth2/token
2018-02-11 14:07:04,637:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): accounts.google.com
2018-02-11 14:07:04,654:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/datasets HTTP/1.1" 200 None
2018-02-11 14:07:04,736:DEBUG:urllib3.connectionpool:https://accounts.google.com:443 "POST /o/oauth2/token HTTP/1.1" 200 None
2018-02-11 14:07:04,738:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): www.googleapis.com
2018-02-11 14:07:04,827:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/datasets/visualizations/tables HTTP/1.1" 200 None
2018-02-11 14:07:04,862:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/datasets/visualizations/tables/REVENUE_RPT HTTP/1.1" 200 None
2018-02-11 14:07:04,863:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,864:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,874:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,879:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,888:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,889:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,898:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,904:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:04,904:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:04,914:DEBUG:urllib3.util.retry:Converted retries value: 3 -> Retry(total=3, connect=None, read=None, redirect=None, status=None)
2018-02-11 14:07:04,919:DEBUG:google.auth.transport.requests:Making request: POST https://accounts.google.com/o/oauth2/token
2018-02-11 14:07:04,923:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): accounts.google.com
2018-02-11 14:07:04,999:DEBUG:urllib3.connectionpool:https://accounts.google.com:443 "POST /o/oauth2/token HTTP/1.1" 200 None
2018-02-11 14:07:05,001:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): www.googleapis.com
2018-02-11 14:07:05,123:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/datasets/visualizations/tables/REVENUE_RPT HTTP/1.1" 200 None
2018-02-11 14:07:05,263:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:05,263:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
...
2018-02-11 14:07:05,458:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:05,458:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`DAY`' should be explicitly declared with text('`DAY`'), or use literal_column('`DAY`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`CUSTOMER`' should be explicitly declared with text('`CUSTOMER`'), or use literal_column('`CUSTOMER`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`CAMPAIGN_NAME`' should be explicitly declared with text('`CAMPAIGN_NAME`'), or use literal_column('`CAMPAIGN_NAME`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`LINE_ITEM_ID`' should be explicitly declared with text('`LINE_ITEM_ID`'), or use literal_column('`LINE_ITEM_ID`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`REGION_PLACEHOLDER`' should be explicitly declared with text('`REGION_PLACEHOLDER`'), or use literal_column('`REGION_PLACEHOLDER`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`STATUS_FINAL`' should be explicitly declared with text('`STATUS_FINAL`'), or use literal_column('`STATUS_FINAL`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`RATE_USD`' should be explicitly declared with text('`RATE_USD`'), or use literal_column('`RATE_USD`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`COUNTRY`' should be explicitly declared with text('`COUNTRY`'), or use literal_column('`COUNTRY`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`COST_BASIS`' should be explicitly declared with text('`COST_BASIS`'), or use literal_column('`COST_BASIS`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
/home/derwin/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4360: SAWarning: Textual column expression '`ADS_SERVED`' should be explicitly declared with text('`ADS_SERVED`'), or use literal_column('`ADS_SERVED`') for more specificity (this warning may be suppressed after 10 occurrences)
  if guess_is_literal else "column"
2018-02-11 14:07:05,473:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:05,475:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:06,588:DEBUG:root:[stats_logger] (incr) sql_json
2018-02-11 14:07:06,604:INFO:root:Parsing with sqlparse statement SELECT `DAY`,
       `CUSTOMER`,
       `CAMPAIGN_NAME`,
       `LINE_ITEM_ID`,
       `AD_NAME`,
       `REGION_PLACEHOLDER`,
       `STATUS_FINAL`,
       `ORDER_NAME`,
       `RATE__ORIGINAL_CURRENCY_`,
       `RATE_USD`,
       `COUNTRY`,
       `PLATFORM`,
       `CURRENCY_ORIGINAL`,
       `COST_BASIS`,
       `EXCHANGERATE`,
       `START_DATE`,
       `END_DATE`,
       `AD_TYPE`,
       `ADS_SERVED`,
       `IMPRESSIONS`,
       `CLICKS`,
       `ACCEPTS`,
       `INSTALLS`,
       `REVENUE`,
       `IMP_RATIO`,
       `CTR`,
       `CTI`,
       `ECPM`,
       `ORDER_SALESPERSON`,
       `RATE_DISCOUNT`,
       `BOOKED_IMPRESSIONS`,
       `bq_load_timestamp`
FROM visualizations.REVENUE_RPT
LIMIT 100
2018-02-11 14:07:07,164:INFO:root:Triggering query_id: 19
2018-02-11 14:07:07,208:INFO:root:Parsing with sqlparse statement SELECT `DAY`,
       `CUSTOMER`,
       `CAMPAIGN_NAME`,
       `LINE_ITEM_ID`,
       `AD_NAME`,
       `REGION_PLACEHOLDER`,
       `STATUS_FINAL`,
       `ORDER_NAME`,
       `RATE__ORIGINAL_CURRENCY_`,
       `RATE_USD`,
       `COUNTRY`,
       `PLATFORM`,
       `CURRENCY_ORIGINAL`,
       `COST_BASIS`,
       `EXCHANGERATE`,
       `START_DATE`,
       `END_DATE`,
       `AD_TYPE`,
       `ADS_SERVED`,
       `IMPRESSIONS`,
       `CLICKS`,
       `ACCEPTS`,
       `INSTALLS`,
       `REVENUE`,
       `IMP_RATIO`,
       `CTR`,
       `CTI`,
       `ECPM`,
       `ORDER_SALESPERSON`,
       `RATE_DISCOUNT`,
       `BOOKED_IMPRESSIONS`,
       `bq_load_timestamp`
FROM visualizations.REVENUE_RPT
LIMIT 100
2018-02-11 14:07:07,264:INFO:root:Set query to 'running'
2018-02-11 14:07:07,307:ERROR:root:No JSON object could be decoded
2018-02-11 14:07:07,308:INFO:root:Database.get_sqla_engine(). Masked URL: bigquery://production-bigdata/
2018-02-11 14:07:07,313:INFO:root:Running query: 
SELECT `DAY`,
       `CUSTOMER`,
       `CAMPAIGN_NAME`,
       `LINE_ITEM_ID`,
       `AD_NAME`,
       `REGION_PLACEHOLDER`,
       `STATUS_FINAL`,
       `ORDER_NAME`,
       `RATE__ORIGINAL_CURRENCY_`,
       `RATE_USD`,
       `COUNTRY`,
       `PLATFORM`,
       `CURRENCY_ORIGINAL`,
       `COST_BASIS`,
       `EXCHANGERATE`,
       `START_DATE`,
       `END_DATE`,
       `AD_TYPE`,
       `ADS_SERVED`,
       `IMPRESSIONS`,
       `CLICKS`,
       `ACCEPTS`,
       `INSTALLS`,
       `REVENUE`,
       `IMP_RATIO`,
       `CTR`,
       `CTI`,
       `ECPM`,
       `ORDER_SALESPERSON`,
       `RATE_DISCOUNT`,
       `BOOKED_IMPRESSIONS`,
       `bq_load_timestamp`
FROM visualizations.REVENUE_RPT
LIMIT 100
2018-02-11 14:07:07,313:INFO:root:SELECT `DAY`,
       `CUSTOMER`,
       `CAMPAIGN_NAME`,
       `LINE_ITEM_ID`,
       `AD_NAME`,
       `REGION_PLACEHOLDER`,
       `STATUS_FINAL`,
       `ORDER_NAME`,
       `RATE__ORIGINAL_CURRENCY_`,
       `RATE_USD`,
       `COUNTRY`,
       `PLATFORM`,
       `CURRENCY_ORIGINAL`,
       `COST_BASIS`,
       `EXCHANGERATE`,
       `START_DATE`,
       `END_DATE`,
       `AD_TYPE`,
       `ADS_SERVED`,
       `IMPRESSIONS`,
       `CLICKS`,
       `ACCEPTS`,
       `INSTALLS`,
       `REVENUE`,
       `IMP_RATIO`,
       `CTR`,
       `CTI`,
       `ECPM`,
       `ORDER_SALESPERSON`,
       `RATE_DISCOUNT`,
       `BOOKED_IMPRESSIONS`,
       `bq_load_timestamp`
FROM visualizations.REVENUE_RPT
LIMIT 100
2018-02-11 14:07:07,314:DEBUG:urllib3.util.retry:Converted retries value: 3 -> Retry(total=3, connect=None, read=None, redirect=None, status=None)
2018-02-11 14:07:07,316:DEBUG:google.auth.transport.requests:Making request: POST https://accounts.google.com/o/oauth2/token
2018-02-11 14:07:07,317:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): accounts.google.com
2018-02-11 14:07:07,386:DEBUG:urllib3.connectionpool:https://accounts.google.com:443 "POST /o/oauth2/token HTTP/1.1" 200 None
2018-02-11 14:07:07,388:DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): www.googleapis.com
2018-02-11 14:07:07,541:DEBUG:root:[stats_logger] (incr) queries
2018-02-11 14:07:07,792:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "POST /bigquery/v2/projects/production-bigdata/jobs HTTP/1.1" 200 None
2018-02-11 14:07:09,042:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/queries/a71e3fcf-9970-4a64-845b-74ded5268989?maxResults=0 HTTP/1.1" 200 None
2018-02-11 14:07:09,145:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/jobs/a71e3fcf-9970-4a64-845b-74ded5268989 HTTP/1.1" 200 None
2018-02-11 14:07:09,147:INFO:root:Handling cursor
2018-02-11 14:07:09,162:INFO:root:Fetching data: {u'changedOn': datetime.datetime(2018, 2, 11, 14, 7, 7), u'tempTable': None, u'userId': 1L, u'executedSql': u'SELECT `DAY`,\n       `CUSTOMER`,\n       `CAMPAIGN_NAME`,\n       `LINE_ITEM_ID`,\n       `AD_NAME`,\n       `REGION_PLACEHOLDER`,\n       `STATUS_FINAL`,\n       `ORDER_NAME`,\n       `RATE__ORIGINAL_CURRENCY_`,\n       `RATE_USD`,\n       `COUNTRY`,\n       `PLATFORM`,\n       `CURRENCY_ORIGINAL`,\n       `COST_BASIS`,\n       `EXCHANGERATE`,\n       `START_DATE`,\n       `END_DATE`,\n       `AD_TYPE`,\n       `ADS_SERVED`,\n       `IMPRESSIONS`,\n       `CLICKS`,\n       `ACCEPTS`,\n       `INSTALLS`,\n       `REVENUE`,\n       `IMP_RATIO`,\n       `CTR`,\n       `CTI`,\n       `ECPM`,\n       `ORDER_SALESPERSON`,\n       `RATE_DISCOUNT`,\n       `BOOKED_IMPRESSIONS`,\n       `bq_load_timestamp`\nFROM visualizations.REVENUE_RPT\nLIMIT 100', u'ctas': False, u'tab': u'', u'sqlEditorId': u'', u'id': u'HJfzCTaUM', u'changed_on': '2018-02-11T14:07:07', u'rows': None, u'endDttm': None, u'limit_reached': False, u'state': u'running', u'progress': 0L, u'schema': None, u'dbId': 3L, u'errorMessage': None, u'db': u'BigQuery', u'trackingUrl': None, u'user': u'admin', u'sql': u'SELECT `DAY`,\n       `CUSTOMER`,\n       `CAMPAIGN_NAME`,\n       `LINE_ITEM_ID`,\n       `AD_NAME`,\n       `REGION_PLACEHOLDER`,\n       `STATUS_FINAL`,\n       `ORDER_NAME`,\n       `RATE__ORIGINAL_CURRENCY_`,\n       `RATE_USD`,\n       `COUNTRY`,\n       `PLATFORM`,\n       `CURRENCY_ORIGINAL`,\n       `COST_BASIS`,\n       `EXCHANGERATE`,\n       `START_DATE`,\n       `END_DATE`,\n       `AD_TYPE`,\n       `ADS_SERVED`,\n       `IMPRESSIONS`,\n       `CLICKS`,\n       `ACCEPTS`,\n       `INSTALLS`,\n       `REVENUE`,\n       `IMP_RATIO`,\n       `CTR`,\n       `CTI`,\n       `ECPM`,\n       `ORDER_SALESPERSON`,\n       `RATE_DISCOUNT`,\n       `BOOKED_IMPRESSIONS`,\n       `bq_load_timestamp`\nFROM visualizations.REVENUE_RPT\nLIMIT 100', u'startDttm': Decimal('1518358027090.300000'), u'limit': 1000000L, u'serverId': 19L, u'resultsKey': None}
2018-02-11 14:07:09,162:DEBUG:root:DEBUG 2   fetch_data ======================
2018-02-11 14:07:09,323:DEBUG:urllib3.connectionpool:https://www.googleapis.com:443 "GET /bigquery/v2/projects/production-bigdata/datasets/_502a1d151dbcdc9998f3fc57071106c6e473a198/tables/anonda85ab5ab9617bb315b69f60a90a18b3ed9c7251/data?selectedFields=DAY%2CCUSTOMER%2CCAMPAIGN_NAME%2CLINE_ITEM_ID%2CAD_NAME%2CREGION_PLACEHOLDER%2CSTATUS_FINAL%2CORDER_NAME%2CRATE__ORIGINAL_CURRENCY_%2CRATE_USD%2CCOUNTRY%2CPLATFORM%2CCURRENCY_ORIGINAL%2CCOST_BASIS%2CEXCHANGERATE%2CSTART_DATE%2CEND_DATE%2CAD_TYPE%2CADS_SERVED%2CIMPRESSIONS%2CCLICKS%2CACCEPTS%2CINSTALLS%2CREVENUE%2CIMP_RATIO%2CCTR%2CCTI%2CECPM%2CORDER_SALESPERSON%2CRATE_DISCOUNT%2CBOOKED_IMPRESSIONS%2Cbq_load_timestamp HTTP/1.1" 200 None
2018-02-11 14:07:09,348:ERROR:root:cannot import name Row
Traceback (most recent call last):
  File "/home/derwin/venv/local/lib/python2.7/site-packages/superset/sql_lab.py", line 192, in execute_sql
    data = db_engine_spec.fetch_data(cursor, query.limit)
  File "/home/derwin/venv/local/lib/python2.7/site-packages/superset/db_engine_specs.py", line 1204, in fetch_data
    from google.cloud.bigquery._helpers import Row  # pylint: disable=import-error
ImportError: cannot import name Row
2018-02-11 14:07:09,547:DEBUG:root:[stats_logger] (incr) queries

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions