diegomedina248 opened a new pull request, #20350: URL: https://github.com/apache/superset/pull/20350
### SUMMARY The time grain for minute and second is throwing an error. For BigQuery, the `DATE_TRUNC` function does not support MINUTE and SECOND as param. This PR changes the calculation to support these time grain options. ### BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF Error: <img width="1056" alt="Screen Shot 2022-06-10 at 18 31 29" src="https://user-images.githubusercontent.com/17252075/173153899-bf3336d9-99e7-4a0b-a7ac-fb8cbdae7d85.png";> ### TESTING INSTRUCTIONS 1. Create a Time-series table 2. Mark a DATE column as temporal 3. Select that column as the time column 4. Set the time grain to Minute or Second Ensure the query executes as expected. ### ADDITIONAL INFORMATION - [ ] Has associated issue: - [ ] Required feature flags: - [ ] Changes UI - [ ] Includes DB Migration (follow approval process in [SIP-59](https://github.com/apache/superset/issues/13351)) - [ ] Migration is atomic, supports rollback & is backwards-compatible - [ ] Confirm DB migration upgrade and downgrade tested - [ ] Runtime estimates and downtime expectations provided - [ ] Introduces new feature or API - [ ] Removes existing feature or API -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/17252075/173153899-bf3336d9-99e7-4a0b-a7ac-fb8cbdae7d85.png"](https://user-images.githubusercontent.com/17252075/173153899-bf3336d9-99e7-4a0b-a7ac-fb8cbdae7d85.png"){kind=link}