---
title: How to create a query in Dataslayer for Amazon S3
description: In this article, we will explain everything you need to know to create a query in AWS S3 with Dataslayer. Just follow these simple steps.
---
[Skip to content](https://support.dataslayer.ai/how-to-create-a-query-in-dataslayer-for-amazon-s3#main-content)
- [English](https://support.dataslayer.ai/how-to-create-a-query-in-dataslayer-for-amazon-s3)
- [Español](https://support.dataslayer.ai/es/cómo-crear-una-consulta-en-dataslayer-para-amazon-s3)
English
Show submenu for translations
[](https://www.dataslayer.ai/)
Open main navigation
Close main navigation
- - [English](https://support.dataslayer.ai/how-to-create-a-query-in-dataslayer-for-amazon-s3)
- [Español](https://support.dataslayer.ai/es/cómo-crear-una-consulta-en-dataslayer-para-amazon-s3)
English
Show submenu for translations
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en)
2. [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
May 17, 2024
# How to create a query in Dataslayer for Amazon S3
## In this article, we will explain everything you need to know to create a query in AWS S3 with Dataslayer. Just follow these simple steps.
.png?width=688&height=61&name=faqs%20(28).png)
1. Log in to our [website](https://dataslayer.ai/).
2\. Click on Open under the Amazon S3 Destination.
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(10).png)
3. You will see the index of your queries, click on **New Transfer.**
**.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(1).png)**
**.png?width=688&height=61&name=faqs%20(29).png)**
1\. **Select the email** you want to connect with.
- If you are already logged in to**[the Hub](https://support.dataslayer.ai/about-the-dataslayer-hub?hsLang=en),** **select the email** and click **Confirm**.
- If you are not logged in, **click Manage Hub Accounts** and follow the steps to add a new account.
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(2).png)
2. Select the data you want to include in your query.
- You will need to select a [date range](https://support.dataslayer.ai/custom-date-tricks-in-dataslayer?hsLang=en).
- The metrics and dimensions you want to add.
- [Filters](https://support.dataslayer.ai/understanding-filters-in-dataslayer?hsLang=en) and [options](https://support.dataslayer.ai/dataslayerai-advanced-options?hsLang=en) if needed.
If you want, you can save the query you just created as a template for future queries. Learn how [here](https://support.dataslayer.ai/understanding-the-templates-feature-in-dataslayer-for-bigquery-and-api-query-manager?hsLang=en).
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(3).png)
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(4).png)**Save as a Template**
.png?width=688&height=61&name=faqs%20(32).png)
1\. **Select the S3 bucket** you want to connect with.
- If you are already logged in toa bucket, **select the link** on the drop-down and click **Transfer Data**.
- If you are not logged in, **click on Connect with AWS** and [follow the steps to add a new bucket](https://support.dataslayer.ai/understanding-the-amazon-s3-login-fields?hsLang=en).
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(5).png)
2\. Fill in all the fields.
- **Transfer Name:** This will be the name of the transfer in Dataslayer. This name is only visible to you and is not transferred to AWS.
- **Time zone:** Select your time zone.
- **File Name:** This is the name of the file we are creating with the data. This name is visible on AWS.
- **Upload Path:** This field is optional and is the folder path, you can set several folders separated by "**/**". If the entered folder does not exist it will be created in S3.
*Example: If you set File Name "file.csv" and Upload path "a/b" it will dump it inside S3 in a/b/file.csv*
- **Write mode:** Select the write mode you want.
Learn more about the writing mode in [this article](https://support.dataslayer.ai/understanding-dataslayer-writting-modes?hsLang=en).
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(6).png)
3\. Select the **Sync Frequency** of your transfer.
Learn more about the Sync Frequency in [this article](https://support.dataslayer.ai/understanding-the-sync-frequencies-in-the-amazon-destination?hsLang=en).
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(7).png)
4\. Done! Finally, **save** your transfer.
- Click on **Save** to only save your transfer in Dataslayer.
- Click on **Save & Refresh Now** to save the transfer and insert the data on S3.
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(8).png)
### Preview
If you want to see what the table you have created will look like, you can click on the **Preview** button to see it.
**Note that this preview is limited to 200 rows.**
This way you can **make modifications**, if you have detected any errors or if you want to change the order of the columns, **before uploading the table into AWS.**
**The preview won't consume your monthly row limit.**
.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Create%20query%20S3%20(9).png)**Preview**
As always, please do not hesitate to contact us via our live chat on [our website](https://dataslayer.ai/?__hstc=205882892.609c93ea8042b8239c499e224c18b52a.1712818507477.1713422140093.1713518898108.8&__hssc=205882892.7.1713518898108&__hsfp=3856379180) or via [e-mail](mailto:info@dataslayer.ai) if you still have doubts or questions. We are happy to help!
- [General](https://support.dataslayer.ai/general?hsLang=en)
- [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en)
- [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)
- [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en)
- [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en)
- [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en)
- [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
- [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en)
- [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
- [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)
- [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en)
- [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
- [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en)
- [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content)
- [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace)
- [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en)
- [Database](https://support.dataslayer.ai/database?hsLang=en)
- [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en)
- [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en)
- [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en)
- [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en)
- [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en)
- [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en)
- [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en)
- [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en)
[](https://dataslayer.ai/)
Dataslayer.ai: Digital Marketing Reporting Made Easy
Copyright © 2026, DATASLAYER SL