Data Type in table which import thru CSV file

Question

Hello I noticed that data type for table import thru CSV file is by default as string, how can I change it to other data type like boolean, array and etc?  Regards

Sunil Krishnamoorthy · Accepted Answer

Hi @Haw Keat LimThanks for question.RAW(aka the staging area) is a temporary storage area for data copied from source systems.It’sa json blob storage behind the scenes.Since it’s a temporary storage it’s not designed to store schema and is not optimised fordirectquerying or analytics.Users are expected to use transformations or functions to read datafrom RAW,enforce schema and write to the data model and then query the data.I hope that helps. Let’s us know if you think we you need schema retained in RAW for your usecase. We would like to understand better.Cheers!Sunil

Dilini Fernando · Answer

Hi @Haw Keat Lim,We are following up to see whether you're satisfied with the responses you've received?If you found the responses offered by our community members to be instructive and helpful,we kindly request that you consider marking the most helpful response as the "Best Answer."This little action will acknowledges the person who offered the answer and also makes it simpler for other community members to find the most correct comments.Best regardsDilini

Data Type in table which import thru CSV file

2 replies

Reply

Reply

Sign up

Log in to the community

Scanning file for viruses.

This file cannot be downloaded