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.

This seems like a valuable feature. I am interested in hearing more about the use case here, as we do have a version of database writeback offered in OAC Data Flows. @Brian Watkins-Oracle Would you mind sharing more details on the use case you outlined above? (For example, if you have a specific scenario in mind it would…

@Michal Zima @Greg Faris @BalaGuddeti-Oracle @Jorge Olmeda @Angel Shipp Public REST APIs will be available to use in the January OAC release. Please provide your emails so I can share some information- they will not be documented until officially GA (we are targeting March).

@Greg Holland Unfortunately, this is not currently possible.

@DeepaliG-Oracle Following up on this. Please provide the curl command you are using, including the request method.

I think an alternative approach to this could involve propagating RPD security through a data flow to output datasets. I will connect with @Luis E. Rivas -Oracle to discuss this further. I agree that this is an important feature.

We are currently looking into this and it's on the longer term roadmap. I agree that it is an essential feature. I'm interested in what your current process is for detecting failed jobs?

This feature is actively being worked on by development. I do not have an estimated delivery date to provide just yet.

This is a good suggestion. Is there anything else that you find challenging when performing joins in data flows? Or when using other data flow steps in general? @MihaelaDragomir-Oracle