# Select and load data from Databricks

You can select data and load it into an application once you have created a connection to Databricks. In Qlik Sense, you load data through the Data manager or the Data load editor.

Information noteThe SELECT statement does not include a WHERE clause, but one can be added in the Data load editor after the script built automatically in the script panel is inserted there. The SELECT statement for the Apache Databricks Connector supports the addition of WHERE clause.

## Qlik Sense: Databricks connection properties

Information noteIf the Databricks host supports Unity Catalog, the Catalog property showing the available catalogs will also be shown.

Connection properties that can be configured

| Properties | Description |
| --- | --- |
| Catalog | Shows the catalogs in the Databricks workspace available to the current account. |
| Schema | Shows the schemas available in the selected catalog. |
| Tables | Shows the tables associated with the selected owner.<br><br>Selecting a table will cause the table fields to be displayed in the Data preview tab.<br><br>Overriding the default number of tables retrieved<br><br>Information noteRequires Direct Access gateway 1.7.1 or later.<br><br>By default, a maximum of 10,000 tables are retrieved from the database. You can override the default when your database has more than 10,0000 tables.<br><br>To do this, on the Direct Access gateway machine:<br><br><ol> <li>Using a text editor, open <span>C:\ProgramData\Qlik\Gateway\configuration.properties </span>as admin. If you are doing this via Windows Explorer, make sure that <span>Show &gt;&nbsp;Hidden items</span> is selected.</li> <li> <p>Locate the <span>ODBC_TABLES_LIMIT_FOR_GENERICODBC</span> property and set it to the directory of your choice.</p> <p><span>Example:</span> </p> <p>ODBC_TABLES_LIMIT_FOR_GENERICODBC=15000</p> </li> <li>Save the <span>configuration.properties</span> file and restart the <span>Qlik Data Gateway - Direct Access</span> service.</li> </ol> |
| Data preview | Shows a preview of the fields and data of the selected table. |
| Metadata | Shows a table of the fields and whether they are primary keys. Primary key fields are also labeled with a key icon the Primary key icon beside the field name. |
| Fields | Lists the fields in each selected table. If the table name check box is selected, all the fields in the table are automatically selected. If you click only the table name, fields are displayed but not selected. They can then be selected individually.<br><br>You can also change the field name by clicking on the existing field name. The new name is then used as an alias for the name the field has in the database. |
| Filter data | Shows a field where you can enter filter criteria.<br><br>[Filter data from an ODBC database](https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Filter-ODBC-data.htm) |
| Filter fields | Displays a field where you can filter on field names |
| Hide script/Preview script | Shows or hides the load script that is automatically generated when table and field selections are made. |
| Include LOAD statement | Adds a LOAD statement before the SELECT statement.<br><br>[Add a LOAD statement to an ODBC connection](https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to-add-LOAD-statement.htm) |
| Add data | Opens the Associations view of the Data manager.<br><br>Allows you add more data sources, fix any errors in your data, and create table associations. This option is available only when you use Add data.<br><br>[Managing data associations](https://help.qlik.com/en-US/sense/May2026/Subsystems/Hub/Content/Sense_Hub/LoadData/associating-data.htm) |
| Insert script | Inserts the script displayed in the Data preview panel into the script editor. This option is available only when you use the Data load editor. |