Openmetadata can't ingest sample data and metadata from the Oracle database #16793
Unanswered
vulong1503
asked this question in
Q&A
Replies: 1 comment 2 replies
-
@vulong1503 Ensure you have the necessary permissions, including select_catalog_role and create session. Also, verify that the profiler pipeline has the generateSampleData flag enabled. |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi everyone,
![image](https://private-user-images.githubusercontent.com/75939336/342690074-e7ff4042-cbad-4fca-98a9-df2319f21c06.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk0NjM0MDYsIm5iZiI6MTczOTQ2MzEwNiwicGF0aCI6Ii83NTkzOTMzNi8zNDI2OTAwNzQtZTdmZjQwNDItY2JhZC00ZmNhLTk4YTktZGYyMzE5ZjIxYzA2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjEzVDE2MTE0NlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWNkYjFkNThhNDc0Yzk0YTlkOGUwMTUyNGI2OGI4NzYxNWI2MDllMjU0NTg0Nzk4YzEzZTI1ODAzMGUyNGFjZWImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.87A0yG-06uNTDiybpUE_aheUCSuqLjkYyZr1R1485Dc)
I'm quite new to Openmetadata. i'm trying to connect my Oracle Database 19c to Openmetadata. I have followed the step in the https://docs.open-metadata.org/v1.4.x/deployment/ingestion document, granted all needed privileges.
However, I couldn't ingest any sample data from the HR schema (the sample schema from Oracle) after run the DAG for a long time.
![image](https://private-user-images.githubusercontent.com/75939336/342687573-48e1df22-703e-4777-b109-aafdb3d83847.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk0NjM0MDYsIm5iZiI6MTczOTQ2MzEwNiwicGF0aCI6Ii83NTkzOTMzNi8zNDI2ODc1NzMtNDhlMWRmMjItNzAzZS00Nzc3LWIxMDktYWFmZGIzZDgzODQ3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjEzVDE2MTE0NlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTliNTM3MGQ1MDZlMDY1NzM1MWI5NjUzZTU0NmQ2YTM2ZjYzMDgwYjRiNTU4ZTE1YzIzZGI3MTJkZWM3OGU4OTEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.EBBltcqoMF9c7BGodih9F1s-PwUULFXMgNt92-gUPI4)
Here is the schema in my database
I only got the metadata for COUNTRIES table:
![image](https://private-user-images.githubusercontent.com/75939336/342688074-6a897b1a-154a-41c9-9b92-1ff5af98dc88.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk0NjM0MDYsIm5iZiI6MTczOTQ2MzEwNiwicGF0aCI6Ii83NTkzOTMzNi8zNDI2ODgwNzQtNmE4OTdiMWEtMTU0YS00MWM5LTliOTItMWZmNWFmOThkYzg4LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjEzVDE2MTE0NlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTEyYTdiODZmNDlmZmNkNzI0N2U3N2ViNWU5MmVlNDdjZGY4N2EwZGUzNWE4ZDJiOTQ3YzQ2NDIwYzJlZWU3MmYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.ygQaD2LvUqKshwxiyHvg9JFpO-8kMTOxNnv3DQSa7vM)
Also, after the metadata ingestion pipeline completed, I ran the profiler ingestion and it ran so long without update any sample data to Openmetadata.
How can I fix these problems and get the data into Openmetadata?
Thanks and best regards to everyone
Beta Was this translation helpful? Give feedback.
All reactions