topic Re: Can we inject a clob type column as a dimension through SQL DB extension? in Extensions

Can we inject a clob type column as a dimension through SQL DB extension?

susmita_k — Thu, 19 Dec 2024 19:40:44 GMT

Can we inject a clob type column as a dimension through SQL DB extension? Is there a limitation or best practice we should follow ?

Re: Can we inject a clob type column as a dimension through SQL DB extension?

AntonPineiro — Fri, 20 Dec 2024 08:07:34 GMT

Hi,

I would say creating your own custom extension. You have more details here.

Best regards

Re: Can we inject a clob type column as a dimension through SQL DB extension?

Mike_L — Fri, 20 Dec 2024 08:25:34 GMT

It has to be something that can be cast to a string, and the dimension value length needs to be shorter than 255 characters. It probably makes more sense to parse out the important parts of the clob and send it in as different dimensions.

Re: Can we inject a clob type column as a dimension through SQL DB extension?

susmita_k — Mon, 06 Jan 2025 21:20:57 GMT

Thanks so much... I finally injected the clob as log instead of metric/dimension.