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

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