By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Using Iceberg tables and time travel feature in Quicksight

0

I have Iceberg tables in AWS data catalog which I want to use to create dashboards in AWS QuickSight. The idea is to set a date paremter in QuickSight and then to be able to use it with Iceberg time travel feature. I.e. I'd like QuickSight to filter the data as of specific date using Iceberg capability to execute queries "as of timestamp" (e.g. select * from table FOR TIMESTAMP AS OF (timestamp '2022-12-01 22:00:00').

My questions are:

Does Quicksight support Iceberg tables as a data source? Is it possible to use the time travel feature of Iceberg tables in Quicksight when writing custom sql queries for the data source? Is it possible to use Quicksight parameter with Iceberg time travel? If this is possible, it would be extremely powerful combination Iceberge timetravel + Quicksight dashboards. If it is not possible what is the best alternatives, assuming that my data are in Iceberg tables.

It seems that Quicksight can work with Icerberg tables as a data source, but I can't figure out if quciksight paramters somehow can be used im time travel for Iceberg tables.

Topics
Analytics
Tags
Amazon QuickSight
Language
English
MikeW
asked a year ago404 views
1 Answer
0

Hello,

I see you have the following questions

Does Quicksight support Iceberg tables as a data source? Yes, Quicksight supports Athena as a data source.

Is it possible to use the time travel feature of Iceberg tables in Quicksight when writing custom sql queries for the data source? Yes, there should be no issue specifying a time travel query to Athena from quicksight.

Is it possible to use Quicksight parameter with Iceberg time travel? If I am understanding your question correctly, it is not possible to create a parameter that can dynamically alter a custom SQL query to reload data. You may use a time parameter to filter timestamps of data that has been loaded as a dataset.

If it is not possible what is the best alternatives, assuming that my data are in Iceberg tables.

I would ask that you open an AWS support case in the case I have misunderstood any of the above questions, but also to further discuss your use case to understand the best options you have available.

Thank You.

AWS
AWS_Dylan
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content