Creating a connection to a file

To create a connection to a file:

1. Select a workbook for the new connection and click Create → Connection.

2. Under Files and services, select the Files connection.

3. Click Upload files and select the file. Information about this file and the data to upload will appear at the center of the screen.

   Note

   • Currently, you can upload CSV, TXT, and Excel (xlsx only) files.
   • The number of files per connection cannot exceed 10. Each Excel sheet is counted as a separate file.
   • The size of each file may not exceed 200 MB.
   • The maximum number of columns per file is 300.
   • After you upload the file, only the first 30 rows are previewed.

4. Select the file upload parameters:

   CSV or TXT

   Excel

   1. Information about this file and the data to upload will appear at the center of the screen. At the top of the screen, select:

      • Encoding: Specify the file data encoding. The available values are utf-8, utf-16, windows-1251, and utf-8-sig.
      • Delimiter: Specify the delimiter used in the file. The available values are Comma, Semicolon, and Tabulation character.
      • Column header: Select the header option. If you select Yes, DataLens will use the first row of data as a header.

   2. Optionally, select the type of data for each column. To do this, click the icon to the left of the column name.

   1. If your file contains multiple sheets, specify the ones you want to upload in the Add sheets window. You cannot select empty sheets. Enable the Sheets option to select all available sheets. Each sheet is uploaded to a separate table.
   2. Information about this file and the data to upload will appear at the center of the screen. At the top of the screen, select the Column header option. If you select Yes, DataLens will use the first row of data as a header.

5. Repeat steps 3 and 4 to add files.

6. Click Create connection.

7. Select the workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.

8. Enter a name for the connection and click Create.

You can add, rename, replace, and delete existing files in the connection.

Additional settingsAdditional settings

You can limit data export from charts based on this connection. To do this, click at the top right and uncheck Allow data export. With this option disabled, for charts based on the respective connection, the export data option will not be available in their menu. However, you will still be able to copy chart data and take screenshots.

File replacementFile replacement

To update the connection data, replace a file:

1. In the row with the file name, click → Replace and specify your file. After the file is uploaded, the updated data will be displayed at the center of the screen.
2. Click Save changes. This will update the data for all datasets and chats built based on this connection.

ClickHouse® is a registered trademark of ClickHouse, Inc.