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

[MichaelJo13]

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!

[bjoern__koth · Accepted solution]

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.

[Harveer_SinghGi1]

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]

@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!