title: synapse pipeline copied data to azure synapse data lake table - serverless sql select shows rows, but spark sql select does not
body: <p>I made a new Azure synapse data lake database and table:</p>
  <pre><code>CREATE DATABASE IF NOT EXISTS db1 LOCATION '/db1';
  CREATE TABLE IF NOT EXISTS db1.tbl1(id int, name string) USING CSV (header=true);
  </code></pre>
  <p>I then ran a synapse pipeline to copy data from a source to the ADLS sink for this table. I see the expected csv file in the ADLS container and folder - synapse-workspace-container/db1/tbl1/employee.csv:</p>
  <pre><code>id,name
  1,adam
  2,bob
  3,charles
  </code></pre>
  <p>Running a serverless SQL select statement I see my rows:</p>
  <pre><code>SELECT TOP (100) [id]
  ,[name]
   FROM [db1].[dbo].[tbl1]
  </code></pre>
  <pre><code>+---+-------+
  | id|   name|
  +---+-------+
  |  1|   adam|
  |  2|    bob|
  |  3|charles|
  +---+-------+
  </code></pre>
  <p>Running a pyspark sql select I see no rows:</p>
  <pre><code>sdf=spark.sql(&quot;SELECT * FROM db1.tbl1 ORDER BY id ASC&quot;)
  sdf.show()
  </code></pre>
  <pre><code>+---+----+
  | id|name|
  +---+----+
  +---+----+
  </code></pre>
  <p>Why are no rows showing for spark sql?</p>