Composing Big Query in App Script

Question

I want to compose bigquery in app script with date1 & date2 variable (as mentioned below). What is the format to pass these 2 variable?

var date1="20180601"
var date2="20180606"

var sql = "select * from table_query([project-name:dataset],
'table_id <= "date2" and table_id >= "date1"');";

I am new to apps scripting..any help regarding this is very much appreciated.. — Praveen, Jun 11 '18 at 17:53
I could do with following way: var sql = "select * from table_query([project-name:dataset], 'table_id <= \""+date2+"\" and table_id >= \""+date1+"\"');"; — Praveen, Jun 12 '18 at 08:13
Can you post as an answer your own solution so other people can get help from it, please? — Rubén C., Jun 12 '18 at 08:31

score 0 · Answer 1 · edited Jun 15 '18 at 11:14

0

I could do it in the following way:

var date1="20180601"
var date2="20180606"
var sql = "select * from table_query([project-name:dataset], 'table_id <= \""+date2+"\" and table_id >= \""+date1+"\"');";

edited Jun 15 '18 at 11:14

Rubén C.

1,098
6
16

answered Jun 12 '18 at 08:42

Praveen

31
8

Composing Big Query in App Script

1 Answers1