Forum Discussion

MohammedS's avatar
MohammedS
New Member
1 year ago

External table Creation in Fabric

Hi, I wanted to create an external table in fabric/ADLS and file type is Parquet. Not getting to find any article which is useful , all the sql query which is written is giving syntax error: h...
data engineering
lakehouse
MohammedS's avatar
MohammedS
New Member
1 year ago

I am facing an identifier issue when using a shortcut table in Fabric for a Parquet file, which is preventing the table from being displayed. To resolve this, I want to create an external table, as it could potentially fix the problem.

I will definitely try the approach you shared, but please provide an alternative approach that can address this issue.

Thank you.

frithjof_v's avatar
frithjof_v
Community Champion
1 year ago

I'm curious why you got the identifier issue. Did the error message tell more?
(In case you share more details, please don't share any sensitive or secret information).

 

Regarding the external table with parquet as a source - this worked for me:

 

 

spark.sql("""
CREATE EXTERNAL TABLE IF NOT EXISTS table_name (
    column_name COLUMN_TYPE,
    another_column_name COLUMN_TYPE,
    another_column_name COLUMN_TYPE
)
STORED AS PARQUET
LOCATION 'Files/folder_name/another_folder_name'
""")

 

 

 

Here is another one, very similar: