Integrations

AMAZON S3

Unlock endless growth possibilities by combining data from your cloud service, online store, mobile app and more, to analyze multi-step conversion paths.
Amazon Simple Storage Service (Amazon S3) is an object storage service that offers industry-leading scalability, data availability, security, and performance. This means customers of all sizes and industries can use it to store and protect any amount of data for a range of use cases, such as websites, mobile applications, backup and restore, archive, enterprise applications, IoT devices, and big data analytics.

A tangle of threads

Datagran x AMAZON S3

Use Datagran x Amazon S3 integration to bring in structured data.

GETTING STARTED

Before setting up an S3 bucket, create a user with read-only access to your bucket. Follow the next steps:

  • Go to IAM console
  • Go to Users section
  • Click Add User
  • Type a user name2
  • On Access type option, select Programmatic access
  • Set a permission with read-only policy for bucket by going to 'Attach Existing Policies Directly' tab. If you already have a policy, select it.

If you don't have one, click on Create policy and paste the following element, in the JSON tab. Don't forget to edit the bucket_name on the policy element:

"aws_access_key_id": "AKIAQ4DAIOS4W3XV5JE3",
"aws_secret_access_key": "3YLAFFQvOv4pu7EJoCF0Ohbg
5aANqcOzogHhEdIp",
"start_date" : "2017-11-02T00:00:00Z",
"account_id" : "060331422905",
"role_name" : "bda_etl_db05141c-82e6-4c99-976f-477eae5addc6",
"bucket" : "datagran-demo02",
"external_id" : "bda_connection_405e3c1f-3589-4d5a-ad24-1d2a7364cbc7",
"tables":
"search_prefix":"", // NOTE THIS IS THE FIELD CALLED "FILE PATH" in Datagran - leave it blank if using one of the test files listed below
"search_pattern":"my-shop.csv",
"table_name":"my_table",
"key_properties":"", // NOTE THIS MEANS LEAVE IT BLANK IN Datagran
"date_overrides":"id",
"delimiter":","