You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Esp. with JSON formats like the Blueworks dataset, we can end up with a lot of VARCHAR fields which really are downgraded from a more specific datatype.
It would be nice if we could have derivations that would let us explicitly cast them to a more specific type, and then have all the implied derivations and aggregates appropriate for the target type.
It would be cool to if the output would inform us of a failed cast, in a meaningful way.
For example, we could have a pair of expressions like:
TRY_CAST( column AS <type> ) as column_type
, CAST column IS NULL THEN NULL ELSE column_type IS NULL END as success
where column_type would represent the casted value, and success indicating whether the cast was successful (it's false if there is an error).
The success indicator could then be used to render some special indicator value to indicate a value error.
It would be even better if the offending value was also somehow visible - we could do that either by including the original value in the title of the cell, or by simply displaying the original value and using some specific styling to indicate an error (f.e. red background)
The text was updated successfully, but these errors were encountered:
Esp. with JSON formats like the Blueworks dataset, we can end up with a lot of VARCHAR fields which really are downgraded from a more specific datatype.
It would be nice if we could have derivations that would let us explicitly cast them to a more specific type, and then have all the implied derivations and aggregates appropriate for the target type.
It would be cool to if the output would inform us of a failed cast, in a meaningful way.
For example, we could have a pair of expressions like:
where
column_type
would represent the casted value, andsuccess
indicating whether the cast was successful (it's false if there is an error).The success indicator could then be used to render some special indicator value to indicate a value error.
It would be even better if the offending value was also somehow visible - we could do that either by including the original value in the title of the cell, or by simply displaying the original value and using some specific styling to indicate an error (f.e. red background)
The text was updated successfully, but these errors were encountered: