When opening Athena from DataZone portal project I can see no tables in the database with the `_pub_db` suffix. I expected to see them. Steps I took: 1. create a data source in AWS DataZone console (from Glue catalog that was created in Lake Formation) 2. in DataZone portal, being in correct project "publish data" button -> "automated publish" -> select correct data source -> data asset publishing: draft -> create publishing job I can see all the tables in project -> publishing -> published data. Also, if I make any of the data assets active and subscribe to it, from the same project, then the table appears in Athena '_sub_db' database and I can query it. Is this behavior expected?

DataZone empty PUB database in Athena

When opening Athena from DataZone portal project I can see no tables in the database with the _pub_db suffix. I expected to see them. Steps I took:

create a data source in AWS DataZone console (from Glue catalog that was created in Lake Formation)
in DataZone portal, being in correct project "publish data" button -> "automated publish" -> select correct data source -> data asset publishing: draft -> create publishing job I can see all the tables in project -> publishing -> published data. Also, if I make any of the data assets active and subscribe to it, from the same project, then the table appears in Athena '_sub_db' database and I can query it.

Is this behavior expected?

태그

아마존 DataZone

언어

English

ksazon

질문됨 10달 전207회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Yes, that is an expected behavior, you need to subscribe to the data assets that you published in order to consume them. so in that case you are going to see in the _sub_db

Leo Gomez

답변함 10달 전

DataZone empty PUB database in Athena

관련 콘텐츠