Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Snowflake schemas do not show under a team's assets #10670

Open
Alina-Valea-Forter opened this issue Mar 20, 2023 · 17 comments · Fixed by #13372 · May be fixed by #15812
Open

Snowflake schemas do not show under a team's assets #10670

Alina-Valea-Forter opened this issue Mar 20, 2023 · 17 comments · Fixed by #13372 · May be fixed by #15812
Assignees
Labels
backend P1 High priority UI UI specific issues

Comments

@Alina-Valea-Forter
Copy link

I am running OpenMetadata version 0.13.0. I am trying to assign a Snowflake schema to a team. I have navigated to the schema itself and have assigned the owner there, however, when I navigate back to the Teams view Openmetadata still shows 0 assets.
snowflake_schema_owners
team_asset_view

@harshach harshach added the UI UI specific issues label Mar 20, 2023
@harshach
Copy link
Collaborator

Thanks @Alina-Valea-Forter for reporting the issue.
@chirag-madlani @shahsank3t we do have the data coming back from the backend, but we are not showing the entity
image

@Sachin-chaurasiya
Copy link
Member

@harshach, the owns field returns entity references, however in the assets tab we want to show assets as we have on explore page, and for that, we need more information, so we are using the search API to get the assets owned by the team.

In search API, we only have an index for top-level entities like table, topic, etc, that's why the schemas owned by team a are not listed there.

@CheyenneRobinson
Copy link

Hello I do not believe this to just be a snowflake issue as it occurs with Hive connectors well. Your explanation of the cause should resolve for all of the additional services as well correct in OM 1.1?

@chirag-madlani
Copy link
Collaborator

@CheyenneRobinson Yes it will be resolved for all the services once we fixed it

@harshach
Copy link
Collaborator

@07Himank lets add support for database , databaseSchema as separate docs and that will allow us to list it in Assets tab

@harshach
Copy link
Collaborator

@07Himank we should create an alias for searching across all the entities. So that we can show it as part of the assets with one call to the backend search apis

@harshach
Copy link
Collaborator

@chirag-madlani we need to show assets on Team page similar to Glossary
image

@harshach
Copy link
Collaborator

@07Himank lets follow-up on this and close it out

@chirag-madlani
Copy link
Collaborator

cc: @Ashish8689 @ShaileshParmar11 can you confirm this?

@harshach
Copy link
Collaborator

harshach commented Oct 4, 2023

@07Himank @Ashish8689 @ShaileshParmar11 can someone confirm and close it out
We need to show services/databases/databaseSchemas as well

@Ashish8689
Copy link
Contributor

Ashish8689 commented Oct 4, 2023

@harshach yes, I have raised the PR for that, will close the issue once got merged!

@harshach
Copy link
Collaborator

harshach commented Oct 5, 2023

@Ashish8689 I still see this in the user profile in sandbox-beta
Uploading image.png…

@harshach harshach reopened this Oct 5, 2023
@Ashish8689
Copy link
Contributor

@harshach the images is broken, can you re-share what you are pointing out!

@harshach
Copy link
Collaborator

@Ashish8689 @chirag-madlani this needs to be fixed, lets add Assets tab similar to glossary term
image
and ability to bulk add asses to the team page

@harshach
Copy link
Collaborator

same thing should be available at Users level as well

@chirag-madlani chirag-madlani added the P0 Highest priority label Apr 1, 2024
@Ashish8689
Copy link
Contributor

Ashish8689 commented Apr 2, 2024

@Harsha Needed API support for the following:

Teams : Bulk add and remove asset for Entities for Team, currently in Team we only support bulk add for User .
Users : Same bulk add and remove asset for adding user as owner and following for the entities.

@Ashish8689 Ashish8689 assigned harshach and unassigned 07Himank Apr 2, 2024
@chirag-madlani
Copy link
Collaborator

@Harsha Needed API support for the following:

Teams : Bulk add and remove asset for Entities for Team, currently in Team we only support bulk add for User . Users : Same bulk add and remove asset for adding user as owner and following for the entities.

@Ashish8689 Let's have readonly for assets until we do not have above APIs

@Ashish8689 Ashish8689 linked a pull request Apr 4, 2024 that will close this issue
9 tasks
@Ashish8689 Ashish8689 added P1 High priority and removed P0 Highest priority labels Apr 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backend P1 High priority UI UI specific issues
Projects
None yet
8 participants