Is it possible to change the schema associated with a data set? | Community
Skip to main content
M
MichaelJo13
Level 4
February 12, 2025
Solved

Is it possible to change the schema associated with a data set?

  • February 12, 2025
  • 2 replies
  • 725 views

I somehow selected the wrong schema for my data set. Two questions, first is it possible to change the schema associated with the data set, and if so, how (in the UI). Also, we have the adobe analytics source data connector. I was wondering how this will affect that? 

 

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bjoern__koth

Hi @michaeljo13 

afaik that is not possible.

Schemas are blueprints for database tables, and Datasets are essentially individual database tables that were created based on that blueprint.

The best would be to create a new dataset on the correct schema.

 

Maybe this link is helpful.

2 replies

bjoern__koth
Community Advisor and Adobe Champion
bjoern__kothCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
February 13, 2025

Hi @michaeljo13 

afaik that is not possible.

Schemas are blueprints for database tables, and Datasets are essentially individual database tables that were created based on that blueprint.

The best would be to create a new dataset on the correct schema.

 

Maybe this link is helpful.

Cheers from Switzerland!
    Harveer_SinghGi1
    Community Advisor and Adobe Champion
    Harveer_SinghGi1Community Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    February 13, 2025

    Hi @michaeljo13 ,

    As @bjoern__koth mentioned you cannot change the schema used for dataset, best option will be to create a new dataset with right schema and use that dataset for your ingestion. This will mean you'll have to re-ingest the historical data (if any).

    Regarding AA source connector, did you use the custom schema for this connection? If yes and you selected the wrong schema then you need to recreate the connection with correct schema which will automatically create the dataset based on the schema you used. This setup will automatically request all the historical data in new dataset.

    Cheers!

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      February 17, 2025

      @michaeljo13 Did you find the suggestions helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...