Google Store Sales

⌘K
  2. Home
  4. Docs
  6. Google Store Sales
  8. Step 1 : Set up Store Sal...
  10. Option 2: Set up AWS S3 File source for Google Store Sales

Option 2: Set up AWS S3 File source for Google Store Sales

Video Walkthrough

Description:
Amazon Web Services (AWS) provides Amazon S3, a secure and scalable cloud-based object storage service. It allows you to store and retrieve data from anywhere via a web interface or API. By integrating AWS S3 as a source in Datahash, you can directly pull store sales data files for seamless processing and analysis.

Prerequisites:  

Before you begin, ensure you have the following details:

  • S3 Bucket Name
  • S3 Bucket Access Key
  • S3 Bucket Secret
  • Relative Path to Data Folder (e.g., myfolder/salesdata)

Getting Started:  

Choose Data Entity  

  • Select Store Sales as the data entity.
  • Provide a name for your file source.
  • Click Next.

Download Sample File  

  • Download the sample file to review the required structure and format.
  • Prepare your sales data in the same format.
  • Upload the file into your AWS S3 bucket.

Provide AWS S3 Credentials  

Enter the following details so Datahash can access your data:

  • S3 Bucket Name – Unique identifier of your storage container.
  • S3 Bucket Access Key – Used for authentication and authorization.
  • S3 Bucket Secret – Secret key paired with the access key for secure authentication.
  • Relative Path to Data Folder – Path where files are stored (e.g., myfolder/thistable).
  • Click Validate Credentials.

.

  • Once validation succeeds, click Finish to complete the setup.
  • The connected instance will now appear in your dashboard.

Managing Instances  

Adding a New Instance  

  • Follow the same setup steps as above.
  • Provide a new connection name and data entity.
  • Upload or configure the new file.
  • Enter AWS S3 credentials and click Validate Credentials.
  • Click Finish.
  • The new instance (e.g., Ads Connection 2) will appear in the Manage Connections table.

Editing an Existing Instance  

  • From the Manage Connections table, click on the connection name you want to edit.
  • Click on the Edit option (top-right corner).
  • Update the required field(s).
  • Click Validate Credentials to confirm the changes.
  • Click Finish to save and apply.
  • If you click Cancel during editing, the previous configuration will remain active. Updates are only applied once you click Finish.

How can we help?