Hi,
I am using DataBrick to create Tables in Azure ADLS Gen2. I have one "DataBase" and a few "Tables" of Delta format. I am following the Denodo Doc to connect to dfs and able to connect my azure ADLS.
**Prob1**: while creating "Create Base View" . I specified the path till database, like "DatabaseName.Table1" . and for second table , I use "DatabaseName.Table2"
My full path is: `abfss://<ContainerName>@<adlsName>.dfs.core.windows.net/database/dir1/`
I gave:
> Parquet File Path = /database/dir1/DatabaseName.Table1
> File Name pattern = (.*)parquet
but its not able to recognize like this way. While If I give like below , it works. But I am not sure how to provide a databasename and Table to be sure, I am not getting data from Table2. Its confusing. Please explain.
> Parquet File Path = /database/dir1/
> File Name pattern = (.*)parquet
**Prob **2: The table data is being repeated. Every time I load data in delta table and access it through DataBrick (Notepad), it shows me LATEST data.. but in Denodo it keeps adding for each load. Simple query like below gives me 5 rows if I loaded data 5 times. It should be always Latest data only. What am I missing?
`select * from denodo_poc.ds_adlsview where myColumn1='A1'`
