Adding data files
Add datasets for use in data analytics. There are a number of ways in which you can add datasets in Qlik Cloud Analytics.
Adding datasets from local files
For supported file types, see Loading data from files.
Data files must be 6 GB or less.
Do the following:
-
Go to the Create page of the Analytics activity center and select Dataset.
You can also add datasets from your mini-homes and by clicking Create new > Dataset in Catalog.
- Click Upload data file.
-
Drag and drop your data files into the Add file dialog.
Alternatively, click Browse and navigate to your data files.
-
Specify the Path for the file using the drop down menu. Start by selecting a space, and then navigate to the folder within the space where you want to store the file.
Alternatively, type the full path manually.
- Select a destination space for the files.
-
Click Upload.
Alternatively, to create an app from your dataset immediately, click Upload and analyze.
When importing a dataset file into a Qlik Sense app or space with Data manager (drag-and-drop or other direct uploads), the maximum number of fields that can be loaded is 5000.
Adding datasets from existing connections
Create datasets from existing ODBC connections. When you create a dataset, you pick a database from the data source and then select tables in that database. A dataset is created for each table you select. Datasets created this way refresh their data every time the dataset is opened.
Creating datasets from connections allows you to use cataloging and lineage options with data from your external data sources.
Datasets created from a connection must reside in the same space as the connection to that data source. If the dataset is moved to a space without that connection, only the dataset name and limited metadata is available from the dataset.
Do the following:
-
Go to the Create page of the Analytics activity center and select Dataset.
You can also add datasets from your mini-homes and by clicking Create new > Dataset in Catalog.
-
Select a connection to a data source from the available connections and click Next.
-
Under Database, select the database containing the tables for which you want to create datasets.
-
Under Tables, select the tables to create datasets from. Each table will make a new dataset.
-
Click Next.
-
Select the destination space for the data set from Select space.
If the space does not have access to your selected connection, you need to select Create new connection in <space name>.
-
Click Create datasets.
Adding datasets from new connections
Add a new ODBC connection and create a dataset from it.
Datasets created from a connection must reside in the same space as the connection to that data source. If the dataset is moved to a space without that connection, only the dataset name and limited metadata is available from the dataset.
Do the following:
-
Go to the Create page of the Analytics activity center and select Dataset.
You can also add datasets from your mini-homes and by clicking Create new > Dataset in Catalog.
-
Click Create connection.
-
Select the destination space for the connection.
-
Under Data connectors, select the data source.
-
Add the details for the connection.
-
Enter the connection settings for the data source.
For information about supported connections, see Loading analytics data.
-
Click Create.
-
Select the connection from the available connections and click Next.
-
Under Database, select the database containing the tables for which you want to create datasets.
-
Under Tables, select the tables to create datasets from. Each table will make a new dataset.
-
Click Next.
-
Select the destination space for the data set from Select space.
If the space does not have access to your selected connection, you need to select Create new connection in <space name>.
-
Click Create datasets.
Other ways to add data files
There are many other ways in which you can upload data files into Qlik Cloud Analytics. For example, it is often possible to add data as you build specific analytics resources.
Common methods include:
-
When managing a space.
-
When building apps and scripts. You can use Data load editor, Data manager, or the Script interface to upload data files.
Loading data from the data catalog
-
As you add training data in an ML experiment.
-
As you create a prediction configuration within an ML deployment.
-
When working with Qlik Answers.
Managing data files in spaces
For more information about managing the data files within a space, see Managing data files.