Table$partition

Q&A
, ,
1

Hi All,

I need to create a view of the internal partition table “table$partition”, but I can’t. Is there another way to access a partition table and create a view of it using boto3?

Tks

2

Hi @July ,
can you please share the usecase and provide more details. Where is this partition and how do you plan to use.

Thanks,
Sri

1 Like
3

There is a view in Quick Sight that uses a very large table, and I got good performance when I got the maximum data from the partition, but when I go to create a view, it says that I don’t have permission to use the $partition table.

For ex:
select column1, column2…
from my_large_table
where my_date = (SELECT max(my_date) FROM database.“my_large_table$partitions”)

4

Hi @July,

Is your my_large_table$partitions a dataset in QuickSight? If the answer is yes, then you will not be able to use that with a select query. What you can do instead is use the relative date filtering on the my_large_table dataset and choose the data granularity depending on your requirement.

As I see you are just trying to filter out the data from my_large_table. Again I am providing my inputs based on the context you have provided. If there are other details you would like to add, please send a private message to me directly and I will try my best to help solve the problem.

Thanks,
Sri

1 Like