Would you want those extra columns filled with nulls, or something else? @MJC

Thanks for this great suggestion- we have an item to track this in our backlog. Out of curiosity, how many transform steps do you typically have to "chain" together? @User_W8LTR

Thank you for your feedback, @Rajakumar Burra. I agree that a dedicated 'remove duplicates' capability would be a large value-add in data flows. Both the Aggregate and Union distinct rows workarounds can achieve the desired outcome, but I recognize they are not ideal. I'm tracking this improvement in our backlog. In the…

Yes, this is a bug. We're working to fix this

Hello! I’m curious what your use case looks like — what kinds of filters are you updating in your Data Flows each month? Are these mostly date filters, or do they include other fields as well? @MJC

Are you trying to export tabular data from a visualization like a table or pivot in a workbook? Or are you looking to extract data from a specific dataset behind the scenes? Curious to learn more about the use case here.

This isn’t currently planned for an upcoming release, but it’s a great suggestion — especially for customers managing a high volume of datasets manually. If you're able to share a bit more about how you're currently handling manual reloads or any challenges you're facing, that would be really helpful. @Kartik Mali-Oracle

@MJC Thank you for the feedback! We do support zoom functionality within the Data Flow editor, which may help you more easily navigate and manage complex flows. Additionally, we’ve recently made some improvements to layout and zoom behavior in the OAC July 2025 update.

Thanks for the detailed feedback @Chris Allies— I’ll review this with our team internally. Improving type handling could be a great enhancement. Out of curiosity, which database are you using with your data flow? If you know the column can be safely trimmed, your approach of using 'cast' is definitely the right workaround.…

@Angel Shipp Would email notification on failure be sufficient?

You should be allowed to use a data flow output as another data flow input in a sequence. Do the task-level logs provide any more information?

Hello! Data flows will not allow you to read from and overwrite the same “Dataset A” within one data flow. Here's a pattern you can use instead that involves two data flows placed in a single sequence that can be run on a schedule - Data Flow 1 Read Dataset A Write it out immediately as Dataset A_backup (in case you need…

Thank you for the idea! Incremental reload is currently available in OAC are we are planning on supporting this in OAS in the future.

Hello @User_OVUF9 I believe we do allow select sum distinct aggregation when creating datasets via manual sql. Here's an example of a syntax that should work: SELECT region, SUM(DISTINCT amount) AS total_unique_amount FROM SH.Sales GROUP BY region; Is there somewhere else that you're trying to use this aggregation method?

Thank you for the idea @aditya.k.pinjala-Oracle I think this would be an excellent improvement for data flows- I do have this as an item in the backlog.

I think this would be helpful for a lot of customers- I will communicate this with our team. Currently keeping this at 'Need Votes' to assist in prioritization. @Bret Grinslade - Oracle Analytics-Oracle

@vkm Can you please create a new Idea Lab post for this?

@Tasha This is a great suggestion. I agree that we should make it more clear which datasets are generated manually versus created via data flow. Currently there is information in dataset Inspect → Developer → Metadata that indicates whether the dataset was created by a data flow.

This item is currently in the backlog for data flows.

The Catalog APIs were recently delivered in OAC. There are endpoints that will provide metadata about certain catalog objects- I am tagging @Mike Durran-Oracle to provide more information regarding if/when these APIs will be available in OAS.