My data source is Google Sheets with lots of columns being imported into Looker. However, the currency formatted columns from Google Sheets are being pulled in as a format type “number”. Is there a way to format the columns in Google Sheets, so it automatically recognizes the format type when pulled into Looker?
And if not, is there a way to update multiple data field types in Looker at once?