Suggestion: could you add all filters feature of Data table cell to the SQL cells?
I was using SQL cells, but later found Data table cells have more features of those filters, hiding/showing more or less columns, have to define a variable to hold the SQL query results, then call a Data table instead, to have all such good features,
but SQL cells don't have such features, make it less useful; Could you Ob guys make all Data table features also available to SQL cells?
Someone might argue can change SQL to hide/show columns, and ordering and filtering, but it's just less convenient, and sometimes don't want to re-run an already expensive 100+ lines SQL; the Data table client side filtering is just better
Hi Tech@M. Thank you for your feedback. We originally separated the functionality of the Data Table cell and the SQL cell because we were unsure whether it would be obvious to users where the filters were being applied, and we did not want to modify the original SQL statement. However, we have heard similar requests from users recently and we are evaluating ways to consolidate the user experiences for SQL and Data Table cells.
In the meantime, the workaround I would recommend is to name your SQL cell and then create another Data Table cell from the SQL cell. That allows you to run the SQL query only once and use the UI-based interactive filters as needed.