--- title: What syntax should I use in the BigQuery connector to avoid errors in my queries? description: Have you ever experienced any of these errors when trying to run your query in BigQuery? --- [Skip to content](https://support.dataslayer.ai/what-syntax-should-i-use-in-the-bigquery-connector-to-avoid-errors-in-my-queries#main-content) - [English](https://support.dataslayer.ai/what-syntax-should-i-use-in-the-bigquery-connector-to-avoid-errors-in-my-queries) - [Español](https://support.dataslayer.ai/es/qué-sintaxis-debo-utilizar-en-el-conector-de-bigquery-para-evitar-errores-en-mis-consultas) 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/what-syntax-should-i-use-in-the-bigquery-connector-to-avoid-errors-in-my-queries) - [Español](https://support.dataslayer.ai/es/qué-sintaxis-debo-utilizar-en-el-conector-de-bigquery-para-evitar-errores-en-mis-consultas) 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. [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en) February 18, 2025 # What syntax should I use in the BigQuery connector to avoid errors in my queries? ## Have you ever experienced any of these errors when trying to run your query in BigQuery? ![New UI - FAQ Getting started BQ-1](https://support.dataslayer.ai/hs-fs/hubfs/New%20UI%20-%20FAQ%20Getting%20started%20BQ-1.png?width=688&height=268&name=New%20UI%20-%20FAQ%20Getting%20started%20BQ-1.png) **These errors indicate that BigQuery does not recognize the syntax you are using, or that there is some error in it.** ### So, how should I write the syntax of my queries? For this purpose, we give you some recommendations that you should keep in mind to avoid errors: 1\. BigQuery recommends the use of **Standard SQL** instead of Legacy SQL. 2\. Type **FROM without quotation marks** and just put **dataset.table**, selecting the account. 3\. Do not use French quotes in the query, only **single** or **double quotes** (Not this ➞ \` These ➞ ' or "). ### Example #### **In Dataslayer according to the recommendations detailed in this article, you should write it like this:** ``` SELECT * FROM dataset.table ``` In **Dataslayer** you have to **specify the dataset but not the project,**  since the project is obtained by selecting the accounts. **To illustrate:** ``` SELECT * FROM test_flow.Test_2311 ``` ![Browser template (1)-2](https://support.dataslayer.ai/hs-fs/hubfs/Browser%20template%20(1)-2.png?width=688&height=252&name=Browser%20template%20(1)-2.png) You can verify that **BigQuery** generates this SQL automatically: ``` SELECT * FROM `bigquerytest-298608.test_flow.Test_2311` ``` ![image\_c52z16](https://support.dataslayer.ai/hs-fs/hubfs/image_c52z16.png?width=688&height=163&name=image_c52z16.png) If you put this code generated by BigQuery in the Dataslayer extension, **the query will NOT work and you will get an error** similar to those we have mentioned above. #### If you want to get data from **multiple tables,** the SQL query must follow this example structure: ``` SELECT * FROM  [dataset_id.test_1], [dataset_id.test_2] ``` For detailed instructions on **how to build queries in BigQuery**, we recommend exploring Google's documentation on **[query syntax](https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#sql_syntax_notation_rules)**.   As always, please contact us via our live chat on our [website](https://dataslayer.ai/) or via [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