Hey! We are using GoodData for some basic business reporting. But after longer time and lot of data here we want to change existing dataschemes. For example we have some schema and we want to extend it and add 1:N connection with any other dataschema. But its seems it works just for new data. Old one attributes are ?null?. So i check some articles in documentation how to remove data. I visited GrayPages and try to execute

DROP ALL IN {dataset.superdupertablename} CASCADE;

but nothing happens. Data are still there 😕 Any suggestions? Documentation is really quiet about some data removal.

Hi @Jiří Svěcený, You are right, some changes in Logical Data Model need you to reload the data as there might be broken referential integrity. If I understand correctly, you want to wipe the whole dataset and load it again? In that case, you have several options: 1. do a full load - doing a full load deletes all the old data and loads new data 2. it’s possible to wipe all the data in dataset using MAQL DDL - run

SYNCHRONIZE {dataset.superdupertablename};

(at

/gdc/md/[[workspaces_id]]/ldm/manage2

) - basically recreates phyicial tables and drops the old ones Does any of these options work for you?

@Boris yes, you understand me correctly. I use MAQL DDL run to synchronize data and it works! Nice!

can you please PM me the execution log? I’ll take a look