Setting up and using AWS Athena federated queries| Query DynamoDB with SQL Via Athena Tutorial

References :

------------------------- Watch ----------------------------------

Title: Learn AWS DynamoDB in a easy Way in 55 Minutes | Indexes | Partition | Boto3


Title: Check out PynamoDB | PynamoDB is a Pythonic interface to Amazon’s DynamoDB


Title: Very Quick Overview on DynamoDB in 8 Minutes


Title: Hands-on Lab Learning DynamoDB with Python Library PynamoDB


Title: Setting up and using AWS Athena federated queries| Query DynamoDB with SQL Via Athena Tutorial

------------------------- Connect With Me ----------------------------------
-------------------------------------------------------------------------------

#python #webdeveloper #php #software #softwaredeveloper #computerscience #tech #webdesign #computer #technology
#programmer #programming #coding #developer #code #coder #programmingofficial #meme #java #javascript
#coder #developer #devops #sysadmin #programmer #geek #engineer #gamer #nerd #entrepreneur



Process finished with exit code 0

#aws
#athena

[chetancc]

Hi Soumil,
Tried it today and it worked. Thanks for sharing and for your time.
Thanks,
Chetan from Kandivali, Mumbai :)

[Dipubuet]

Did you create the s3 spill bucket? or it is auto created in the process? Also, is the spill prefix set by us? if yes, from where? the bucket folder prefix?

[dilipdl]

Nice Explanation sir, Please let me know what is the Value need to be given in the SecretNameorPrefix field while creating the Lambda. If you have any availability please make a video for AthenaDocumentDBConnector. I'm expecting a reply from you.

Thanks

[abimaeldominguez]

Hello Soumil, thanks for the video. I have a question, what is the difference between the "spill bucket" and the "query result location"? Athena ask you for the "query result location" the first time you use it. Thanks.

[rajankshirsagar]

Hi Soumil,

Would this work for cross account DynamoDB? In my case, DynamoDB resides on production account and the analytics is getting done on different account so the connector and lambda should work with cross account DynamoDB to fetch the results near realtime.

[rameshm]

Hi soumil, nice explanation
I have few questions
We have migrated few tables from oracle to dynamodb, the existing query is joining 4 tables.
Using athena causes excessive scan causing pagination.
Using athena is better than PartiQL editor?

[vikassrivastava]

Can we query s3 datasource and postgress data source in one query editor(make join or union both table)

[sabarishsabarish]

Bro can you tell me how to connect Athena and rds..

[kavithakr]

I am using this athenadynamodb connector for few tables getting below error. do you have solution for this "2022-12-05 07:08:04 WARN DynamoDBMetadataHandler:235 - doGetTable: Unable to retrieve table from AWSGlue in database/schema default. Falling back to schema inference. If inferred schema is incorrect, create a matching table in Glue to define schema (see README)
Table not found. (Service: AWSGlue; Status Code: 400; Error Code: EntityNotFoundException;:"