title: AWS Glue Job Efficiently Fetch 1 Row from Oracle (via Pyspark)
body: <p>So here's the problem...in our glue job (pyspark), we are able to connect to Oracle via pyspark and query large datasets. But before we do this, we want to query a different table and get one row that tells us what the main query is.</p>
  <p>The question is, how do we pull back one row, by an id, from Oracle, in a glue job? My understanding is that if we use a dataframe and then filter it, it pulls back the whole table.</p>
  <p>We investigated using cx_Oracle, but it relies on instantclient which seems to be very hard to install in a Glue job.</p>