--- title: How to create a query in Dataslayer for Snowflake description: In this guide, we'll walk you through the process of creating a query in Snowflake destination. You'll be able to automatically import your marketing data into Snowflake in seconds. --- [Skip to content](https://support.dataslayer.ai/how-to-create-a-query#main-content) - [English](https://support.dataslayer.ai/how-to-create-a-query) - [Español](https://support.dataslayer.ai/es/cómo-crear-una-consulta-en-dataslayer-para-snowflake) English Show submenu for translations [![Dataslayer](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?height=35&name=Dataslayer_New_Logo.png)](https://www.dataslayer.ai/) Open main navigation Close main navigation - - [English](https://support.dataslayer.ai/how-to-create-a-query) - [Español](https://support.dataslayer.ai/es/cómo-crear-una-consulta-en-dataslayer-para-snowflake) 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. [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en) June 16, 2025 # How to create a query in Dataslayer for Snowflake ## In this guide, we'll walk you through the process of creating a query in Snowflake destination. You'll be able to automatically import your marketing data into Snowflake in seconds. If you log in [here](https://app.dataslayer.ai/snowflake), you will go directly to our **Snowflake product** and you will see the **[Index section](https://app.dataslayer.ai/es/snowflake)** of your queries there. Let's see how it works: ![](https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc00/faqs-1_176xgvm.png) 1\. Let's create a new transfer by clicking on **New transfer** button. ![Snowflake view in Dataslayer with a button to create a new transfer.](https://support.dataslayer.ai/hs-fs/hubfs/3-Jun-12-2025-02-18-38-0599-PM.png?width=688&height=268&name=3-Jun-12-2025-02-18-38-0599-PM.png) ![](https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc00/faqs_thuiud.png) 1\. Select the **data source** you want and log in to your **Hub Account**. ![Selecting a Google Ads account as data source in Dataslayer.](https://support.dataslayer.ai/hs-fs/hubfs/5-Jun-12-2025-02-20-01-9487-PM.png?width=688&height=268&name=5-Jun-12-2025-02-20-01-9487-PM.png) In **[this guide](https://support.dataslayer.ai/about-the-dataslayer-hub?hsLang=en)**, you can learn **how to connect your Hub Account** to our available data sources. 2\. Select the **data source's accounts** you want to get data from. ![Dropdown list to choose specific Google Ads accounts](https://support.dataslayer.ai/hs-fs/hubfs/6-Jun-12-2025-02-20-17-3923-PM.png?width=688&height=268&name=6-Jun-12-2025-02-20-17-3923-PM.png) 3. Select the configuration of your query, such as: - You will need to select a **[date range](https://support.dataslayer.ai/custom-date-tricks-in-dataslayer?hsLang=en)**. ![Date range selection for querying Google Ads data.](https://support.dataslayer.ai/hs-fs/hubfs/7-Jun-12-2025-02-20-49-0669-PM.png?width=688&height=268&name=7-Jun-12-2025-02-20-49-0669-PM.png) - The **metrics** and **dimensions** you want to add. ![Configuration of dimensions and metrics for the query.](https://support.dataslayer.ai/hs-fs/hubfs/8-Jun-12-2025-02-21-06-5593-PM.png?width=688&height=268&name=8-Jun-12-2025-02-21-06-5593-PM.png) - **[Filters](https://support.dataslayer.ai/understanding-filters-in-dataslayer?hsLang=en)** and **[options](https://support.dataslayer.ai/dataslayerai-advanced-options?hsLang=en)**, if needed. ![Filter and advanced options section for the data query.](https://support.dataslayer.ai/hs-fs/hubfs/9-Jun-12-2025-02-21-19-8714-PM.png?width=688&height=268&name=9-Jun-12-2025-02-21-19-8714-PM.png) **You can use our templates or create your own! Learn how [here](https://support.dataslayer.ai/understanding-the-templates-feature-in-dataslayer-for-bigquery-and-api-query-manager?hsLang=en).** ![](https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc00/faqs_t9q64.png) 1\. Select your **Snowflake account** email and click on **Transfer Data. ![Established Snowflake connection showing destination identifier.](https://support.dataslayer.ai/hs-fs/hubfs/10-Jun-12-2025-02-21-40-1920-PM.png?width=688&height=268&name=10-Jun-12-2025-02-21-40-1920-PM.png)** **[This article](https://support.dataslayer.ai/understanding-the-snowflake-login-fields?hsLang=en)** will guide you on how to **understand login fields** for a successful **Snowflake connection**. 2\. Fill in all the transfer details: - **Transfer Name**- This will be the name of the transfer in Dataslayer. - **Timezone**- Select your time zone. - **Table**- In the drop-down, you can select an already *created table* or create a *new table*. - **Table Name**-  If you have selected the "Create new table" option on the previous field, set here the name of your new table. - **[Write Mode](https://support.dataslayer.ai/understanding-dataslayer-writting-modes?hsLang=en)** - 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). ![Destination section to enter transfer name, table name, timezone, and write mode](https://support.dataslayer.ai/hs-fs/hubfs/11-1.png?width=688&height=268&name=11-1.png) 3\. Select the **Sync Frequency**. You can choose between a *schedule*, *manually* or *manually splitted*. ![12-1Sync frequency settings with options for schedule, manual, and custom intervals](https://support.dataslayer.ai/hs-fs/hubfs/12-1.png?width=688&height=268&name=12-1.png) **Learn how each mode works in [this link](https://support.dataslayer.ai/understanding-the-sync-frequencies-in-the-snowflake-destination?hsLang=en).** **If you want to upload historical data to Snowflake, learn the best way to import it [here](https://support.dataslayer.ai/features-to-upload-historical-data-into-bigquery?hsLang=en).** 4.  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 in Snowflake. **Don't forget to also click on Save & refresh if you chose the Manually frequency mode.** **![Save button highlighted to confirm query configuration in Dataslayer.](https://support.dataslayer.ai/hs-fs/hubfs/13-1.png?width=688&height=268&name=13-1.png)** **That's it!** You have inserted your data into Snowflake! ### 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 Snowflake.** **The preview won't consume your monthly row limit.** ![Preview data button showing limit of 200 rows before running full query.](https://support.dataslayer.ai/hs-fs/hubfs/14-1.png?width=688&height=268&name=14-1.png) As always, please contact us via [our live chat](http://dataslayer.ai) or [email](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) [![Chill listening crop-3](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?width=142&height=24&name=Dataslayer_New_Logo.png "Chill listening crop-3")](https://dataslayer.ai/) Dataslayer.ai: Digital Marketing Reporting Made Easy Copyright © 2026, DATASLAYER SL