Hi, @prateek_gupta . Sorry for the delay. Did you find an answer on this already? The analytics/reporting functionality in the UI is actually being deprioritized in favor of some other 3rd party visualization tools like Superset and LightDash (coming soon). Many users are leveraging the Analyze UI successfully but compatibility with non-Postgres backends is not guaranteed.
In terms of the Analysis function, this is that it is only tested with Postgres backends. Even for the dbt "Transform" phase, you'll need to select a target that supports dbt. We have out-of-box support for snowflake, bigquery, and postgres, but you can add others as well.
Because you asked this a bit ago, I imagine you may have already found this info yourself. But happy to provide more info if needed. 👍