dbt-ml-preprocessing icon indicating copy to clipboard operation
dbt-ml-preprocessing copied to clipboard

Published 20 hours ago • verified publisher icon omnata-labs

OHE error handling... casting string ass boolean?

Open dataders opened this issue 3 years ago • 0 comments

I'm working to make the one_hot_encoder macro compatible with Azure SQL and Azure Synapse. The compiler is having takes issue with line 93 because there is no boolean datatype in TSQL. My question is what does this resolve to in other DW's, NULL?

https://github.com/omnata-labs/dbt-ml-preprocessing/blob/08f8c42c4373b6bfe64e349b701199f73682b6ee/macros/one_hot_encoder.sql#L89-L95

cc: @comaraDOTcom

dataders avatar Mar 12 '21 08:03 dataders