课程: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Hands-on learning: Create and query tables using Athena

乡村振兴既要产业兴旺也要环境美

课程: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

开始一个月试用 购买团队方案

Hands-on learning: Create and query tables using Athena

“ 百度 不过遥控赛车最大惊喜在于它巧妙运用了（手柄的）红外线传感器，就像夜视摄像机一样，能让我们以第一人称视角操作遥控赛车。

- [Narrator] In this lesson we'll get some hands-on practice with creating tables for data stored in S3 and querying them with SQL. Note that Athena is not on the free tier and costs about $5 per terabyte of data scanned. If you don't want to incur any charges in your account, then just watch me use Athena. Okay, let's start in the AWS Console and let's go ahead and open a cloud shell and let's explore the bucket that contains the data for this lab in it. And this is going to be a sample bucket from Amazon and I'm just going to list what's in the bucket so we can see the files and how they are partitioned. Okay, so what we have here is we have a number of partitions for flight data and this is basically how many departures there were from different airports and it's partitioned by year and it goes from 1987 to 2016. So what we're going to do now is we're going to go to Athena and we're going to create a database and a table to be able to query this data. So let's switch over to Athena…

内容