1. Containers
2. File share
3. Tables
   

2. How to import data from Azure Data Lake?    

Note: The connection details will be saved, and you can use them later to import files or tables from the same storage types.

3. How long does it take for the data to be imported into Zoho Analytics?

Import Settings

1. How to set custom date format?

Zoho Analytics intelligently identifies the format of the date column while importing but if there's any difference in the identified format you can change it using the Format Date option while importing. Refer to this link to know more about constructing custom date format.

2. Can I change the data type of the columns imported in Zoho Analytics?

Yes, you can change the data type of the columns imported into Zoho Analytics. However, it is necessary that the data type of your column is compatible with the data type of the column in Azure Datalake for successful data synchronizations. It is always recommended that you change the data type in both your Azure datalake as well as your Zoho Analytics workspace.

To change the data type, click the drop-down icon of the column and select the data type from the list.

3. Will I be notified of Import failures?

Yes, you can be notified after consecutive import failures, in case it occurs. To get notified of import failures, you need to set the number of consecutive import failures after which you need to be notified in the Notify me after every Sync Failure(s) option of the schedule import.Yes, you can be notified after consecutive import failures, in case it occurs. To get notified of import failures, you need to set the number of consecutive import failures after which you need to be notified in the Notify me after every Sync Failure(s) option of the schedule import.

4. Can I save my import settings? 

Data Blending

1. Can I import data into an existing table?

Note: To import data into an existing table, at least one column header should match the data that is set to import.

1. From the required table, click Import Data > Import Data into this Table.
   
   
   
   
2. The Import Your Data tab will open listing the relevant data sources. Choose  Azure Data Lake from the listed data sources.
   
   
   
   
3. The Import Data tab will open. Select How do you want to Import from the drop-down menu.
   
   
   
   
4. You can configure a new connection as mentioned in this presentation or use the existing connection to import data. Select the file to import and click Next.
   
   
   
   
5. The Import settings tab will open.By default, Zoho Analytics will map the corresponding column headers of the existing table with the table that is set for import. It also allows you to import data as a new column.
   
6. Click Import.
   
   
   

1. Open the workspace into which you intend to import the data.
2. Click Create > New Table/Import Data.
   
3. Choose Azure Data Lake from the listed sources.
   
4. You can configure a new connection as mentioned in the setup presentation or use the existing connection details to import data.
   
5. To import data using existing connection details,
   
1. Click the drop-down icon of the  Connection Name  field.
2. Select the storage type (connection) from which you intend to import.
3. The connection string/credentials will be auto filled. Click Browse and choose the file to import.
4. Click Next.
   
   
   
   
6. The Create Table (Import) page will open. Click Join Tables to define lookups.
7. The Join Tables - Combine the new tables with existing tables dialog will open.
   
8. Select the columns and specify the relation to be defined.
   
9. Click Save and Close.
   
   

Manage Data Sources

1. How to edit the import setup?

1. Open the workspace for which you intend to edit the setup.
   
2. Click the Data Sources tab from the Navigation bar.
   
3. The Data Sources page will open. All the data sources in that workspace will be listed.
4. Click Edit Setup to make the changes.
   
5. Modify the settings as required and click Save.