Knowledge Drop

Do I need to specify a 'type' for a field that has a 'case' in it?


Userlevel 2

Last tested: Jan 21, 2019

The "case" parameter always returns a type "string". In other words, the generated SQL includes a cast to a string. Since the Looker default "type" is "string", there is no need to specify 'type: string' in a field that has a case. That being said, it is recommended that you specify 'type: string' for consistency of code.

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply