Can't create continuous aggregate on ps_trace.span

[StarpTech]

Describe the bug

Span table is growing very fast. How can I make use of continuous aggregate (realtime) to optimize aggregates as described in https://docs.timescale.com/timescaledb/latest/how-to-guides/hyperfunctions/percentile-approx/approximate-percentile/ ?

This is not possible because ps_trace.span is a postgres view not a hypertable or another continuous aggregate.

Error:

Error occurred during SQL query execution

Reason:
SQL Error [0A000]: ERROR: invalid continuous aggregate query
  Hint: continuous aggregate needs to query hypertable or another continuous aggregate

With that limitation in mind, what's the way to optimize resource-intensive queries?

To Reproduce <Steps to reproduce the behavior:>

Expected behavior I expected that it is possible

Configuration (as applicable) Using Timescaledb Cloud

Version

• Promscale: Latest (0.17.0)
• TimescaleDB: Cloud

Additional context Support Case #: 00012349