- 2351 Views
- 3 replies
- 4 kudos
Resolved! QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks
Hi Team - In azure databricks sql alerts, I was able to use QUERY_RESULT_ROWS only if I'm selecting the trigger as first row. Is there a possibility to get count of number of rows and also the query result (both rows and columns to display the data a...
- 2351 Views
- 3 replies
- 4 kudos
- 4 kudos
Hi @Rajalakshmi Amara​ Hope everything is going great.Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell u...
- 4 kudos
- 6324 Views
- 5 replies
- 5 kudos
Resolved! Limit on number of result rows displayed on databricks SQL UI
Databricks SQL UI currently limits the query results display to 64000 rows. When will this limit go away? Using SSMS I get 40MM rows results in the UI and my users won't switch to databricks SQL for this reason
- 6324 Views
- 5 replies
- 5 kudos
- 5 kudos
Hi @prasad vaze​ - We do have a feature in the works that will increase this limit. If you reach out to your Databricks contact they can give you more details regarding dates and the preview.
- 5 kudos