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

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

  • February 12, 2025
  • 2 replies
  • 724 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!

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

kautuk_sahni
kautuk_sahni
Employee
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
bjoern__koth
bjoern__kothAccepted solution
New Participant
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
    Harveer_SinghGi1
    New Participant
    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!

      Terms & ConditionsAccessibility statement

      Loading footer...