kate-gallo commented on issue #6950: [table config] new metrics don't show up 
in explore
URL: 
https://github.com/apache/incubator-superset/issues/6950#issuecomment-501789441
 
 
   Same thing happen to us. 
   Clicking on the datasource, `Edit datasource`, changing SQL in the advanced 
settings doesn't bring new metrics on the visualisation. 
   On columns, `Sync columns from source` is not available.
   
   If I click on `view query` I get something like this:
   
   ```
   SELECT month AS month,
                   old_metric AS old_metric
   FROM
     (SELECT DATE_TRUNC('month', date_time) AS month,
             COUNT(DISTINCT column_1) AS old_metric,
             COUNT(DISTINCT column_2) AS new_metric
      FROM table
      GROUP BY 1) AS expr_qry
   WHERE month >= '1919-06-13 00:00:00'
   LIMIT 1000;
   ```
   
   So the query is not updated with the new column in my modified SQL query.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to