Query Error when using date field in Date Range Dimension or Filter (PostgreSQL)[ Edited ]
April 2017 - last edited April 2017
Using "Date Range Dimension" when you select a field type "date" to the server comes SQL-query without condition "WHERE" and Data Studio throws an error "There`s a query error.", because the result is too large and Data Studio crash.
Query like this one:
2017-04-03 11:31:46 UTC [7965-2] agency_103@agency_103 STATEMENT: SELECT SUM(conv) AS _conv_, SUM(imps) AS _imps_, account_id, date, keyword_name FROM keywords_raw_table_adwords AS t0 GROUP BY account_id,
Also condition "WHERE" won't be added if use additional filters as e.g. account_id.
Instruction step-by-step: https://docs.google.com/document/d/1Brg0N0SShzGOuB4zmN8VFTwqbTnDtfQtSkGE_AnBzws/edit?usp=sharing