Profile picture
, 8 tweets, 3 min read
My Authors
Read all threads
I know it's Friday afternoon, but I can't stop playing with the new #reInvent2019 features 🤯

Next up: Amazon Athena’s federated queries ❤️

This new feature allows you to query ANY data source and integrate it with your data lake!

[Thread]
First, you connect a Data Source: DynamoDB, DocumentDB, Redshift, CloudWatch Logs, CloudWatch Metrics, Hbase, MySQL, PostgresSQL, Redis, or even custom sources!
The connectors are open-sourced on Github here 👉 github.com/awslabs/aws-at…

So you just deploy a connector once (per region/account) via the Serverless Application Repository (SAR) ⚡
For example, let's pick Amazon DynamoDB!

Athena automatically brings you to corresponding SAR app, where you can review the template and configure a few parameters! ⚙️
To access this feature in preview you'll have to create a special Athena workgroup named "AmazonAthenaPreviewFunctionality" 🤷‍♂️ and attach an IAM policy to your user so you can switch to the workgroup!
Now we can finally query our DynamoDB tables from the Athena console!

When we select the new DynamoDB data source on the left-hand panel, the connector will auto-discover our DynamoDB tables 🎉
And we can run a NoSQL query (DynamoDB.GetItem) as a beautiful SELECT+WHERE statement 🤯
This could greatly simplify the integration of dynamic values (from DynamoDB) as part of our data analytics pipeline, but it also allows us to integrate other relational data from RDS or Redshift without any duplication 🙌
Missing some Tweet in this thread? You can try to force a refresh.

Enjoying this thread?

Keep Current with Alex Casalboni

Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

Twitter may remove this content at anytime, convert it as a PDF, save and print for later use!

Try unrolling a thread yourself!

how to unroll video

1) Follow Thread Reader App on Twitter so you can easily mention us!

2) Go to a Twitter thread (series of Tweets by the same owner) and mention us with a keyword "unroll" @threadreaderapp unroll

You can practice here first or read more on our help page!

Related hashtags

#reInvent2019

More from @alex_casalboni see all

Profile picture
Alex Casalboni
@alex_casalboni
Today I'm playing with the new Amazon S3 Access Points 🙌

It's quite a convenient way to create and manage custom access rules for data stored on S3 without having to maintain a single (complex) bucket access policy 👌

[Thread]
You can think of an Access Point as a sort of "alias" to your bucket, accessible from the Internet or from a specific VPC.

You can create hundreds of Access Points per bucket to provide access to shared data for different applications, teams, or any other consumer 👥👨‍💻👩‍💻
These "aliases" don't have to be unique globally, but only per account & region.

So it's quite easy to pick your own Access Point name without worrying about conflicting with other existing applications or environments 🚀
Read 8 tweets

Related threads

Profile picture
Eric Hammond @ AWS re:Invent
@esh
AWS #reInvent SRV401 Optimizing Your Serverless Applications

@chrismunns starts by dissection the AWS Lambda function environment.

He's lulling us with a basic intro before waking us up with the 400-level content.

Even so, it's a more technical basic intro.
Now we jump into the simpler optimizations.
Options for configuration.

"Hardcoding is not one of them. "
Read 24 tweets
Profile picture
Corey Quinn
@QuinnyPig
All right, the @awscloud #reinvent Expo Nature Walk livetweet thread!
Before we begin, remember that we're guests in these noble creatures' habitat. Don't disturb them; they're more scared of you than you are of them.
Also, make sure not to let any of them scan your badge. It disrupts their ecosystem; we don't want them to grow to depend upon #reinvent attendees to survive.
Read 30 tweets
Profile picture
Corey Quinn
@QuinnyPig
The lights dim. An entirely-too-loud video for 8AM starts. Welcome to @awscloud #reinvent
It's a three hour keynote. Thank you to keynote sponsor Depends adult diapers. #reinvent
I see you, @github logo. #reinvent
Read 97 tweets
Profile picture
Tom Leaman
@tleam
Next up: Building SRE from scratch during Hypergrowth at Coinbase with @phrawzty and @niallohiggins should be a great overview of the practice and a case study of adoption. #reInvent
Awesome delineation of the purpose of an #SRE : it isn’t to perform the firefighting, pager calls and incident response. It’s in place to help prevent and reduce these. #reInvent
#SRE isn’t just building observability into technical systems but your human and organizational systems as well. Took measurement is critical. #reInvent
Read 16 tweets
Profile picture
Tom Leaman
@tleam
Next up: Optimizing Your Serverless Applications with @chrismunns. Looking forward for tips on improving perf but more importantly I hope we cover how to best track serverless “service levels” over time
We are getting started with the Serverless Optimization talk. Every seat is filled. #reInvent
While it’s a 400 level session, always helps to give an appropriate high level review to set context. We are talking Lambda today #reInvent
Read 19 tweets
Profile picture
Chris Allison
@ToferC
Next up: Katie Malone @multiarmbandit From Presidential campaign trail to Enterprise - Building a #DataScience team @CivisAnalytics
Effective #data-driven teams: different in existing organizations than start-ups. Need to find the best places to build in data value without overturning everything else. Challenges: personal-level analytics, resource allocation, security, privacy. #ODSCWest
Business & data teams will see problems differently. Data teams need to be comfortable with trade-offs in business. Metrics can be ill-defined. Speed can be better than perfection. Important to understand adequate accuracy of models. #ODSCWest Oh yeah, and security.
Read 9 tweets

Trending hashtags

#DroneFactory #ConstitutionalCommitteeSuccessful #weekends #ReadTheMuellerReport #foreigners #HumanShields #monitoring #data #Alien #MuellerDud #car #RIPStrummer #musictherapy #blacksmith #border #StupidLingo #ThugLife #Teaching #Iranian #BadMusic #nohillary2016 #unforeseeable #NotManyKnowThis #Summer #SAA
Follow Us on Twitter!

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just three indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!