How are the csv files encoded in Looker?

Knowledge Drop

Last tested: Feb 16, 2018
 

1. The files are encoded as utf8
2. The default separator is a comma.
3. Quotes turn into quote quote and then we quote any value that contain ", the separator or LR/CF.
so a string with " in it would become "a string with "" in it"

This content is subject to limited support.                

Comments
KatieK
Participant I

@rducarrouge , why do you say the default delimiter is a comma? Is there a way to select a different delimiter? We have customers asking for that. 

Version history
Last update:
‎06-14-2021 06:16 PM
Updated by: