title: Parameterize AWS Glue Job for ETL with Date as variables
body: <p>I am fairly new to AWS and I am currently exploring it. I was hoping to get an insight or suggestion on how to work with AWS Glue. 
  Say I want to run a script that uses <code>SELECT</code> for an input and outputs it to <code>Redshift</code>. However, I want to to use a parameter for the <code>WHERE</code> clause particularly <strong>dates</strong>. In Python and it goes something like:</p>
  
  <pre><code>df = "SELECT * FROM table WHERE date between {0}-{1}-{3} AND {4}-{5}-{6}".format(day,month,year,day2,month2,year2)
  </code></pre>
  
  <p>After I get this values, I then use something like a <code>TEMP table</code> in Redshift for staging and <code>LEFT JOIN</code> in the Fact Table. But I can't seem to figure out how Glue can do this.</p>
  
  <p>I've read some articles/posts that suggests to use a flat file for the variables but I'm not so sure how to do this. </p>
  
  <p>Any thoughts?</p>