Thank you for the explanation. But we have unstructured json data (it might contain a list of list multiple arry in side json) it gives an error if we try to add it into Athena . What would be the better approach?
Thank you for watching my videos. You need to use Glue job first to convert the data in to required format using crawlers and data refineries tasks store it in Data catalog tables. And then you can use Athena to Query it.
i have one doubt in real world projects as a data scientist how do extract the data (while learning we used to download datasets from kaggle) can you please clarify this
Thank you for watching my videos. I have created many videos on data extractions from many sources like S3 bucket, rds etc. Please.my channel latest videos.
hey hi.....how to join tables in athena for example one json file contains about customer detail other json file contains about transactional details how we join both these tables in athena could you please help me regarding this...
Excellent video!! You explianed in details in an easy way to undertsand and create by myself
Thank you for watching my videos.
Glad that it helped you.
Thanks for the video, I followed the instructions but , I am able to get the schema but not the table contents. Can you please suggest any solution.
Thank you for watching my videos.
Can you please check what is the workgroup you have set there.
I created newworkgroup and used same, but still not able to see the table content.
@@cloudquicklabs I created new workgroup, still I am not able to view my table content.
Thank you for the explanation. But we have unstructured json data (it might contain a list of list multiple arry in side json) it gives an error if we try to add it into Athena . What would be the better approach?
Thank you for watching my videos.
You need to use Glue job first to convert the data in to required format using crawlers and data refineries tasks store it in Data catalog tables. And then you can use Athena to Query it.
@@cloudquicklabs yeah I've tried this . But getting error for un stratured json data.
i have one doubt in real world projects as a data scientist how do extract the data (while learning we used to download datasets from kaggle) can you please clarify this
Thank you for watching my videos.
I have created many videos on data extractions from many sources like S3 bucket, rds etc. Please.my channel latest videos.
@@cloudquicklabs hey thanks man ..
Excellent sir thank u so much
Thank you for watching my videos.
Glad that it helped you.
hey hi.....how to join tables in athena for example one json file contains about customer detail other json file contains about transactional details how we join both these tables in athena could you please help me regarding this...
Thank you for watching my videos.
You can use athena query to merge two tables. Try to find docs.aws.amazon.com/athena/latest/ug/select.html
Like in sql query, you would use merge or join query to merge two source table.
Very nice 🙂
Thank you for watching my videos.
Glad that it helped you.
Thanks for the video.
Thank you for watching my videos.
Glad that it helped you.
querying in athena is returning 0 records
Thank you for watching my videos.
Looks either data there in the file from AWS S3 bucket or Athena is extracting data properly.
speak MORE MORE MORE slowly otherwise your English spoken and accent is a mission impossible . Sorry mate
Thank you for giving valuable feedbacks.
Much appreciated.
I shall consider these to improve my self.