Hey, I am trying to make a POC for setting up ETL ...
# troubleshooting
p
Hey, I am trying to make a POC for setting up ETL pipelines from postgres to json, I am able to have the EL part working fine but am having some issues with the T (transformation part) I believe there have been some changes in the ui and the model tab is unable to detect the extractors that I have already imported in the project. I am using tap-postgres ( the connection is working fine) and loader as jsonl. Is anyone else having the same issue?
a
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. 👍