Forum Discussion
Athena ODBC Configuration
Hi,coolsandeee
I am glad to help you.
According to your description, you need a few details about AWS S3 bucket？
If I understand you correctly, then you can refer to my solution.
An S3 bucket is a storage container provided by Amazon Web Services (AWS) for storing objects (files, data, etc.). It’s commonly used for various purposes, such as hosting static websites, storing backups, serving media files, and more.
It is used by every report refresh (Scheduled refresh or on-demand refresh) that sets up S3 bucket. When we refresh the report, it will fetch the data from S3 bucket and process it.
To avoid overuse of S3 resources, we can optimize data storage, use appropriate storage classes, reduce the number of refreshes, and so on.
For more specific and detailed information, you can go to consult Amazon's official senior technical support engineers or after-sales customer service.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the details, Anonymous
So, when a refresh is initiated, Athena queries get executed. Is the resultant data and metadata stored in the specified S3 bucket and then the Power BI Service retrieves data from this S3 bucket?
Hi,coolsandeee
Yes, your understanding is correct. And the whole process is encrypted and secure.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.