After integrating with a database service and importing metadata, can I join multiple tables directly in OpenMetadata? #5610
-
|
I am integrating a database service with OpenMetadata. Once the metadata tables are imported, can I run a custom SQL on the metadata tables and add them as tables on OpenMetadata? For example, Table x has the columns a, b, c. Table y has the columns d, e, f. I would like to join the tables x, y together and have a table in OpenMetadata called Table xy with the columns (a, b, c, d, e, f). |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
OpenMetadata connectors retrieve all of your metadata from your databases and data warehouses. The tables can be joined in the database itself as Views. When the ingestion runs in OpenMetadata at the next scheduled time, the view will be ingested into OpenMetadata. |
Beta Was this translation helpful? Give feedback.
OpenMetadata connectors retrieve all of your metadata from your databases and data warehouses. The tables can be joined in the database itself as Views.
When the ingestion runs in OpenMetadata at the next scheduled time, the view will be ingested into OpenMetadata.