https://community.databricks.com/t5/data-engineering/add-data-manually-to-dlt/m-p/47675#M28175 <P>Hi Team,</P><P>Is there a way that we can add data manually to the tables that are generated by DLT?</P><P>We have done a PoC using DLT for Sep 15 to current data. Now, that they are happy, they wanted the previous data from Synapse and put into Databricks.</P><P>I can easily do this by pointing to the root of the source folder, but the files are group via batchid/year/month/date sub-folders.</P><P>The only way that I can think of and probably the easiest is to look directly to delta table created by Synapse and have a separate table in Databricks.</P><P>Ideally, I want to only have 1 table rather than 2 tables. i.e. DimRetailer (databricks) instead of DimRetailer_synapse and DimRetailer (databricks)</P><P>Cheers,</P><P>G</P> Mon, 02 Oct 2023 21:59:00 GMT Gilg 2023-10-02T21:59:00Z https://community.databricks.com/t5/data-engineering/add-data-manually-to-dlt/m-p/47675#M28175 <P>Hi Team,</P><P>Is there a way that we can add data manually to the tables that are generated by DLT?</P><P>We have done a PoC using DLT for Sep 15 to current data. Now, that they are happy, they wanted the previous data from Synapse and put into Databricks.</P><P>I can easily do this by pointing to the root of the source folder, but the files are group via batchid/year/month/date sub-folders.</P><P>The only way that I can think of and probably the easiest is to look directly to delta table created by Synapse and have a separate table in Databricks.</P><P>Ideally, I want to only have 1 table rather than 2 tables. i.e. DimRetailer (databricks) instead of DimRetailer_synapse and DimRetailer (databricks)</P><P>Cheers,</P><P>G</P> Mon, 02 Oct 2023 21:59:00 GMT https://community.databricks.com/t5/data-engineering/add-data-manually-to-dlt/m-p/47675#M28175 Gilg 2023-10-02T21:59:00Z