[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-25。"],[],[],null,["# Dremio\n\nThe Looker dialect testing of [Dremio](https://www.dremio.com/) runs against Dremio version 1.4.9 Enterprise Edition.\n\nEncrypting network traffic\n--------------------------\n\nIt is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options described on the [Enabling secure database access](/looker/docs/enabling-secure-db-access) documentation page.\n\nCreating the Looker connection to your database\n-----------------------------------------------\n\nFollow these steps to create the connection from Looker to your database:\n\n1. In the **Admin** section of Looker, select **Connections** , and then click **Add Connection**.\n2. Fill out the connection details. The majority of the settings are common to most database dialects. See the [Connecting Looker to your database](/looker/docs/connecting-to-your-db) documentation page for information. Some of the settings are described next. Use the default values in all the other fields, or leave them blank.\n\n - **Name**: Assign a unique name to the connection. The name is how LookML refers to this connection.\n - **Dialect** : Select **Dremio 11+** or **Dremio**.\n\n | **Note:** If you are on a [Looker (Google Cloud core)](/looker/docs/looker-core-overview) instance and you don't see your dialect listed in the **Dialect** drop-down menu, see the [Looker (Google Cloud core) documentation](/looker/docs/looker-core-dialects#supported_dialects_for) to verify that the dialect is supported for Looker (Google Cloud core) instances.\n - **Host**: Enter the IP address or hostname of the server where Dremio is running.\n\n - **Port** : The default port is `31010`.\n\n - **Database** : The default value is `DREMIO`.\n\n - **Username**: Enter the username that Looker uses to access Dremio.\n\n - **Password**: Enter the password that is associated with the username that you entered.\n\n3. To verify that the connection is successful, click **Test** . See the [Testing database connectivity](/looker/docs/testing-db-connectivity) documentation page for troubleshooting information.\n\n Looker will run `SELECT 1 FROM (VALUES(1))` to verify a basic connection and query test. It will not validate that the user can access any of the Dremio sources or underlying tables.\n4. To save these settings, click **Connect**.\n\nDebugging\n---------\n\nConnect your web browser to `dremio_host:9047` on the server. From the SQL Editor, run `SELECT 1 FROM (VALUES(1))` to verify that Dremio is installed correctly and that queries are able to execute.\n\nFeature support\n---------------\n\nFor Looker to support some features, your database dialect must also support them.\n\nDremio supports the following features as of Looker 25.14:\n\nDremio 11+ supports the following features as of Looker 25.14:\n\nNext steps\n----------\n\nAfter you have completed the database connection, [configure authentication options](/looker/docs/getting-started-with-users)."]]
