---
title: Understanding the BigQuery platform
description: Understanding the BigQuery platform, how to use it
---
[Skip to content](https://support.dataslayer.ai/understanding-the-bigquery-platform#main-content)
- [English](https://support.dataslayer.ai/understanding-the-bigquery-platform)
- [Español](https://support.dataslayer.ai/es/entendiendo-la-plataforma-de-bigquery)
English
Show submenu for translations
[](https://www.dataslayer.ai/)
Open main navigation
Close main navigation
- - [English](https://support.dataslayer.ai/understanding-the-bigquery-platform)
- [Español](https://support.dataslayer.ai/es/entendiendo-la-plataforma-de-bigquery)
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. [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
May 27, 2024
# Understanding the BigQuery platform
## Dataslayer BigQuery product will help you to easily import your marketing data into Big Query.
Dataslayer serves as a link between your favorite connectors (GA4, Facebook, etc...) and BigQuery, so you can forget the whole manual and complicated importing process of BigQuery. With our integration, it has never been easier to import your historical data so that you never lose it and can visualize it whenever you want.
#### If you are new to BigQuery or if you have doubts about some of the fields or icons of our product, in this article we will explain everything you need to know!
Once logged in to our website, click on [BigQuery](https://app.dataslayer.ai/transfer-query/bigquery) on the top menu.
Depending on whether you **have previously made a transfer or not**, you will see one of the following screens.
**When you do not have transfers created**
****
**When you have already created some transfers**
### Understanding the actions and buttons on BigQuery
1. **Help button**: You will be redirected to our help section for frequently asked questions and tutorials about BigQuery.
2. **New Transfer:** It will take you to the menu to create a new transfer.
3. **Filters**: To help you find an already created transfer.
4. **Active Off/On**: You can activate or deactivate the schedule without having to enter the transfer menu. This is only available for Scheduled transfers.
5. **Actions:**
- **Edit:** You will be redirected to the transfer menu for editing.
- **Duplicate**: It will create a new transfer with the same parameters.
- **Delete**: Will delete the transfer.
- **Refresh:** Will refresh the transfer saving the updates on your Big Query Dataset. This is only available for **Manual transfers.**
Having understood the index, let's explain the transfer menu.
### Understanding the Transfer Menu
When you click on the **New Transfer** button or the **Edit** button, you will see the following screen:
This page is divided into two: the **Origin menu**, and the **Destination menu**.
#### Origin Menu
Located on the left side, is where you can [create the query](https://support.dataslayer.ai/getting-started-with-dataslayer-for-bigquery?hsLang=en) you want to enter in Big Query.
Select the data source, accounts, date range, metrics, dimensions, and even filters and options! Everything you need to ensure that the information that matters most to you is stored correctly.
**You can also load a template or create your own templates! Learn how to do it [here](https://support.dataslayer.ai/understanding-the-templates-feature-in-dataslayer-for-bigquery-and-api-query-manager?hsLang=en).**
#### Destination Menu
Here you have different 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 BigQuery.
- **Timezone:** Select your timezone.
- **Project**: You have to previously [create a Project in Big Query](https://support.dataslayer.ai/how-to-create-a-project-and-a-dataset-in-my-bigquery-account?hsLang=en), once done you can select it in this field.
- **Dataset** or **New Dataset Name**: You can select a Dataset that you have already created or [create a new dataset](https://support.dataslayer.ai/how-to-create-a-project-and-a-dataset-in-my-bigquery-account?hsLang=en). These two options are mutually exclusive.
- **Database Table**: This will be the name of the table on BigQuery. It is not necessary that the table is previously created, the name you put here will create a new table in BQ.
- **Write Mode:** We have three write modes: Append, Replace, and Upsert.
| **Write Modes** |
| --- |
| **Append:** It will add the new data to the end of the table. This is the most used and recommended mode |
| **Replace**: It DELETES all the data previously imported to the table and adds all the new data in the same table. |
| **Upsert**: It updates the old data and adds the new data at the end of the table. Note that this option takes longer to complete as it must update all the data previously imported. |
- Frequency mode: You can choose between a schedule, manually or manually split. We explain how they work [here](https://support.dataslayer.ai/features-to-upload-historical-data-into-bigquery?hsLang=en).
Depending on the frequency mode you choose, you will have different options:
#### Schedule option
**Schedule option**
You can select when to refresh the query, hourly, daily, weekly, … Set it up and click on **Confirm changes.**
#### Manual option
**Manual option**
**Confirm changes** to save the query on Dataslayer and **Save & Refresh t**o upload your data on BigQuery.
#### Manually Splitted option
**Note that you need a date dimension to select this option**
**Manually Splitted option**
**Confirm changes** to save the query on Dataslayer and it will start uploading your data in stages so that no errors occur.
**You can also cancel the upload,** we explain how to do it [here](https://support.dataslayer.ai/how-to-cancel-a-manually-splitted-transfer-in-bigquery?hsLang=en).
**Cancel Manually Splitted option**
### Preview
If you want to see how 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 BigQuery.**
**The preview won't consume your monthly row limit.**
**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