Good morning beautiful people! We have a situation that requires us to remove all data uploaded to all datasets in our model for the last 2 days, so everything from January 10th forward. We are examining a few options, but the simplest solution seems to be executing a MAQL statement for each dataset. Does anyone have any experience with a situation like this? Any ideias? Context: We have a few Bricks configured to extract data from some tables in BigQuery, these tables had only partial data due to internal failures on our side, so the data was not fully loaded for most accounts. For example, if there should have been 100 events, there were only 85 at the moment of extraction, so only 85 were loaded by the Brick execution.

Hi Tomas, it sounds to me you are using GoodData Platform rather than GoodData Cloud (in GD Cloud, you are querying the DB directly, not extracting the data through bricks). If so, the way of running MAQL statement at /ldm/manage2 resource is the correct way. Running simply

SYNCHRONIZE {dataset.datasetId};

will delete all the data in the particular dataset.

Hey @Boris i apologize for confusing the channels, I did mean to post on the Platform 😔

yes, we might be able to do that, the question is how many projects are affected.... please send a request to us (support@gooddata.com), we can figure out the details there.

I forgot to mention, these tables don't have PKs, so incremental load on the dates affected results in duplication...