Managing Integrated Data Lake data sources¶
If Integrated Data Lake is provisioned for your tenant, you can subscribe to files from there. The data source will automatically synchronize upon every file update.
To create an Integrated data lake data source, follow these steps:
- Select either a file or an entire directory by browsing Integrated Data Lake.
Note
- In search field, you can search in the list of files that are directly located in the selected directory.
- For CSV files, the wizard tries to infer the delimiter, the date style and the column data types automatically. On the right-hand, you can review the changes, if necessary.
- For a selected directory, the synchronization will include all the parquet files within that directory and its sub-directories. These files may not have different data types for columns with the same name.
2.Click "Next" to proceed to the "Save" step.
Note
You can specify the name of the data source, tags can be assigned and a project can be selected.
3.Click "Finish" to save the data source.
Supported files and file sizes¶
Currently, a total of 20 MB of data per IDL data source is supported. Maximum number of subscription-based data sources is limited to 10 per tenant.
Date style¶
Almost all date and time formats are supported in the order of year, month and day may be ambiguous for some dates and formats. Therefore, this order can be defined by the date style.
It applies to all date or timestamp columns throughout the file. Different date styles within the same file are not supported.