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?

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 ").

Let's look at the following example:

As you can see, BigQuery generates this SQL automatically:

SELECT * FROM `bigquerytest-298608.test_flow.Test_2311`

However, in Dataslayer, according to the recommendations described in this article, you should write it like this:

SELECT * FROM test_flow.Test_2311

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!