DLT table from a text source

[raghu2]

I am trying to create a delta live table by reading a text source. I get an error message that states that both source and target should be in delta format. 

Am I missing something? 

[Kaniz_Fatma]

Hi @raghu2, 

• The error message you’re encountering might indicate that no tables were discovered in your specified source code. Verify that your source code includes proper table definitions.
• Consider using either a notebook with pure SQL or pure Python to define your tables¹.
• If your text source is a CSV file, ensure that you specify the option to infer column types. For instance, when creating a Delta Live Table on top of a CSV file, you can use the following optio...

  USING csv OPTIONS (path "./file.csv", header "true", inferSchema "true")
  

  This will help infer the data types for columns².
• The error could also occur if you attempt to update an empty pipeline. Make sure your pipeline initialization is correct and that tables are properly discovered in your so...¹.