OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
I upgraded to the latest OpenMetadata version (1.5.2), which OM experts communicated to me, and tried to establish a connection with Apache Superset using the MySQL API. However, it still shows an error when fetching charts.
Superset version: 4.0.2
MySQL version: 8.0.30
Open metadata Version: 1.5.2
OpenMetadata Ingestion package 1.5.2
I will mention the below query which works fine OM expert provided it:
select
s.id,
s.slice_name,
s.description,
s.datasource_id,
s.viz_type,
t.table_name,
t.schema,
db.database_name,
db.sqlalchemy_uri
from
slices s left join tables t
on s.datasource_id = t.id and s.datasource_type = 'table'
left join dbs db
on db.id = t.database_id
I upgraded to the latest OpenMetadata version (1.5.2), which OM experts communicated to me, and tried to establish a connection with Apache Superset using the MySQL API. However, it still shows an error when fetching charts.
Superset version: 4.0.2 MySQL version: 8.0.30 Open metadata Version: 1.5.2 OpenMetadata Ingestion package 1.5.2
I will mention the below query which works fine OM expert provided it:
select s.id, s.slice_name, s.description, s.datasource_id, s.viz_type, t.table_name, t.schema, db.database_name, db.sqlalchemy_uri from slices s left join
tablest on s.datasource_id = t.id and s.datasource_type = 'table' left joindbsdb on db.id = t.database_idSo, the OM team needs to fix the query.