Create table from Spark into Lake Database - Doesn't show up in Synapse Studio

Regular Visitor

Hi,

I want to build a Lake Database in Spark SQL based on Parquet files. 

So I created a database using

 

CREATE DATABASE xxx

 

This works fine, I see the Lake Database in Synapse Studio.

Then I create an external table using

 

CREATE TABLE IF NOT EXISTS Account
USING PARQUET
LOCATION 'abfss://email address removed for privacy reasons/folder/'

 

The command was executed successfully and I now can query the table using

 

select * from Account

 

However, the list of tables and views in Synapse Studio is still empty.

So how can I make sure that the external is listed under my database in Synapse Studio?

0 Replies