Need to know limitation on derived dataset created via queries.
Query 1:
If the query output number is in the millions, will it be able to successfully ingest the data into a data lake, profile store, or identity services?
Test use case: An error was thrown when batch ingesting data larger than 20 GB.
Few limitation is available in the below link required some additional information.
Ref url: Export Datasets to Cloud Storage Destinations | Adobe Experience Platform