DataZone empty PUB database in Athena

0

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?

ksazon
已提問 10 個月前檢視次數 207 次
1 個回答
0

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

已回答 10 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南