title: How Do i read the Lake database in Azure Synapse in a PySpark notebook
body: <p>Hi I created a Database in Azure Synapse Studio and I can see the database and table in there, Now I have created a Notebook where I have added the required libraries but I am unable to read the table by below code. Can anyone fix what wrong am i doing here ?</p>
  <p>My database name is <strong>Utilities_66_Demo</strong> . It gives me error as</p>
  <blockquote>
  <p>AnalysisException: Path does not exist:
  abfss://users@stcdmsynapsedev01.dfs.core.windows.net/Utilities_66_Demo.parquet</p>
  </blockquote>
  <p>From where should I take the path? I tried to follow the MS <a href="https://docs.microsoft.com/en-us/azure/synapse-analytics/get-started-analyze-spark" rel="nofollow noreferrer">article</a>. Where Do I read path? if I click on edit Database, i get this</p>
  <p><a href="https://i.stack.imgur.com/Fr1FL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fr1FL.png" alt="enter image description here" /></a></p>
  <pre><code>%%pyspark
  df = spark.read.load('abfss://users@stcdmsynapsedev01.dfs.core.windows.net/Utilities_66_Demo.parquet', format='parquet')
  display(df.limit(10))
  </code></pre>
  <p>Trying to access the created Lake Database Table:
  Selected Azure Synapse Analytics:</p>
  <p><a href="https://i.stack.imgur.com/6o2Xo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6o2Xo.png" alt="enter image description here" /></a></p>
  <p>I select my workspace and in dropdown there is no table shown:</p>
  <p><a href="https://i.stack.imgur.com/pbQod.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pbQod.png" alt="enter image description here" /></a></p>
  <blockquote>
  <p>I select Edit and put my Db name and Table name and it says Invalid
  details.</p>
  </blockquote>
  <p><strong>Now I select Azure Dedicated Synapse Pool from Linked Service</strong>,</p>
  <p>I get no option to select in SQL Pool or Table, and without SQL Pool I am unable to create a Linked service just by inserting Table name:</p>
  <p><a href="https://i.stack.imgur.com/6Dbcm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6Dbcm.png" alt="enter image description here" /></a></p>