Skip to main content
Seasoned ⭐️⭐️
Haw Keat Lim
Seasoned ⭐️⭐️
June 26, 2023
Solved

Data Type in table which import thru CSV file

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
      Sunil KrishnamoorthyAnswer
      Product Manager
      July 3, 2023

      Hi @Haw Keat Lim Thanks for question.

      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

      View in thread

      2 replies

      Sunil Krishnamoorthy
      Expert ⭐️⭐️⭐️⭐️
      Sunil KrishnamoorthyAnswer
      Product Manager
      July 3, 2023

      Hi @Haw Keat Lim Thanks for question.

      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

        Dilini Fernando
        Expert ⭐️⭐️⭐️⭐️
        Dilini Fernando
        Expert ⭐️⭐️⭐️⭐️
        July 13, 2023

        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 regards
        Dilini

         

        Terms & ConditionsAccessibility statement