The latest media dbt package, although not tested with Roku, should be compatible with the media events tracked using the Roku tracker. The Roku tracker is tracking the older media schemas, but that is still supported by the media package.
There is currently no direct support for Roku but the data model can be customised to add the Roku events. In order for the incremental logic to work, the session_identifiers variable in the configuration can be configured to make use of the videoId property in the Roku video context entity (see here). This ID is unique for each video playback, so could be used for this purpose.
As this is not tested, there might be some additional configuration in order to get the Roku events integrated to the package as we have noticed with other media players.