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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ