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
Best answer by Sunil Krishnamoorthy
View originalHello
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
Best answer by Sunil Krishnamoorthy
View originalHi
RAW(aka the staging area) is a temporary storage area for data copied from source systems. It’s a json blob storage behind the scenes. Since it’s a temporary storage it’s not designed to store schema and is not optimised for direct querying or analytics.
Users are expected to use transformations or functions to read data from 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
Hi
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 regards
Dilini
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.