Skip to main content

AWS

Query DynamoDB, Redshift, S3, Lambda, SQS, SNS, and more

J
Written by Johan Åkerman

Introduction

Connect AWS to Sana to query DynamoDB tables, Redshift databases, S3 files, invoke Lambda functions, and send messages through SQS, SNS, and EventBridge. In summary, the connector has the following key characteristics:

  • Category: Engineering

  • Connector type: Real-time

  • Auth type: API keys

  • Hosting type: Managed

Capabilities

This connector is able to do the following:

Capability

Query DynamoDB

Read S3 files

Invoke Lambda functions

Query Redshift

Send SQS messages

Send SNS messages

Send EventBridge events

Write CloudWatch logs

Tools

While the capabilities above describe what the connector can do at a high level, the underlying tools show exactly which operations the agent can use when you ask Sana about AWS. In practice, the agent may call one or more tools to achieve a single capability.

Tool

Cloudwatch logs put log event

Dynamodb create table

Dynamodb execute statement

Dynamodb query

Dynamodb scan

Eventbridge send event

Lambda create function

Lambda invoke function

Redshift create rows

Redshift delete rows

Redshift query database

Redshift update rows

S3 download file to tmp

S3 generate presigned url

Sns send message

Sqs send message

Scope and permissions

This connector uses API keys. When you connect your account, we securely store your keys to connect to this connector's APIs. The scopes for this connector depends on the scopes you assign your API key in AWS when generating the key.

Set up instructions

Prerequisites:

  • Your Sana workspace admin has enabled this integration – if the workspace admin has disabled the integration it won't appear in the list of available integrations.

Step 1: Go to the integrations page in Sana

In Sana, click on ... More in the sidebar, then select Integrations

Step 2: Find AWS in the list of available integrations

Scroll to the Available integrations section and locate AWS.

Step 3: Connect the integration

Click the integration card and select "Connect just for me", this will open a pop-up powered by Pipedream. Follow the steps in the pop-up to complete the set-up.

Step 4: Provide your AWS credentials

You'll be asked to paste the credentials for AWS so Sana can store them securely and use them to call the connector's APIs on your behalf.

Step 5: Complete the set up

You've successfully connected your AWS account. Click Continue to complete the setup and start using the connector.

Known limitations

  • S3 search: File search is limited — the connector can only list files in a bucket, not run a filtered search.

  • S3 file formats: Sana can only read the following file formats stored in S3: doc, docx, dot, dotx, dotm, xls, xlsm, xlsx, pps, ppsx, ppt, pptx, odp, ods, odt, rtf, eml, msg, htm, html, markdown, md, epub, tif, tiff, pdf, jpeg, jpg, png, gif, webp, loop, fluid, fluidframework, whiteboard, wbtx, form, note, task, page, pulse, loot, dwg, dsn.

Did this answer your question?