Skip to main content
cristina_postolache
cristina_postolache
Contributor ⭐️⭐️⭐️⭐️
October 10, 2016
Solved

Why can't I edit Data Type in a MDA object?

  • October 10, 2016
  • 4 replies
  • 140 views
I have just created an object in the MDA Data Management section, based on a .csv. And the system has automatically set-up some default data types, many of them Boolean instead of number, and I've realized that only after the object was created. Now I need to change the type, but I cannot do that. So I have to send a ticket to delete this object and start all over again.
    Best answer by steve_davis
    "But if MDA is redshift enabled and data is already loaded at least once, it is not suggested to change the data type." John, your MDA is redshift enabled 😞

    4 replies

    phanindra_sambaraju
    Gainsight Employee ⭐️
    phanindra_sambaraju
    Gainsight Employee ⭐️
    October 10, 2016
    Hi Cristina,

    We can't change the data type if there is data in that object. We can only change data type of a field if there is no data in the object. Once the data is cleared from the object, we should be able to change the data type.

    If there is no data in the MDA object, please follow the below steps to change the data type:
    • Navigate to the object which you wanted to edit through, Administration > Data Management > click on the object
    • In the schema screen, you should be able to see a pencil for each column under 'Actions'
    • Now click on the pencil for the column you want to edit, and change the data type. Now click on update which should update the schema successfully.
    But if MDA is redshift enabled and data is already loaded at least once, it is not suggested to change the data type.

    Thanks,
    Phanindra
      cristina_postolache
      cristina_postolacheAuthor
      Contributor ⭐️⭐️⭐️⭐️
      October 11, 2016
      The strange thing is that yesterday when I created the new object I couldn't edit the data type, although the object was EMPTY. But today is editable. Is it that maybe just after creating the object I can't change the data type?
      johnny_burtchaell
      johnny_burtchaell
      Helper ⭐️
      March 1, 2017
      Even if you remove data, which i did today, the Data Type cannot be edited. I was just told by Gainsight Support that you have to create a ticket to have the field deleted. Burdensome.
      steve_davis
      steve_davisAnswer
      Gainsight Employee ⭐️⭐️
      March 1, 2017
      "But if MDA is redshift enabled and data is already loaded at least once, it is not suggested to change the data type." John, your MDA is redshift enabled 😞
        Terms & ConditionsAccessibility statement