Create table using a location

vvt1976 — Fri, 10 May 2024 11:43:36 GMT

Hi,

Databricks newbie here. I have copied delta files from my Synapse workspace into DBFS. To add them as a table, I executed.
create table audit_payload using delta location '/dbfs/FileStore/data/general/audit_payload'

The command executed properly. However, the SELECT on the table gives
[DELTA_READ_TABLE_WITHOUT_COLUMNS] You are trying to read a Delta table `spark_catalog`.`default`.`audit_payload` that does not have any columns.

How can I bring the table with all the column mapping

Re: Create table using a location

-werners- — Fri, 17 May 2024 07:50:33 GMT

can you read the delta lake files using spark.read.format("delta").load("path/to/delta/table")?
If not, it is not a valid delta lake table, which is my guess as creating a table from delta lake is nothing more than a semantic wrapper around the actual files.

topic Re: Create table using a location in Data Engineering

Create table using a location

Re: Create table using a location