Google Big Query SQL

[dsebring]

All of a sudden instead of using standard SQL language when writing a query it started putting ' in a ridiculous amount of spots.  How can I revert it back?

Before

select *
from companya.table1
where account_id = 'act_1346583702557040'

Now

select *
from `companya`.`table1` `companya_table1`
where (`companya_table1`.`account_id` = 'act_1346583702557040')

[albert_alaluf]

Hi @dsebring 

This is what we do too when writing GBQ queries, even GBQ UI itself. I believe this is the standard.

Albert

[apathetichell]

do you have your quotes toggled on or off for fields/tables and what's your driver config. I agree with @albert_alaluf that this looks pretty standard - and shouldn't be a cause for concern.

[dsebring]

@apathetichell where would I find the driver config?  Do you mean in my ODBC Connections?

[apathetichell]

yup. - and sometimes in your odbc setup. there's the Table/Field Name SQL Style - sometimes when in not quoted mode - the tables can show up as ` denoted (vs " denoted).

[dsebring]

Does it seem weird the column names have ' ' before and after them?