[[["易于理解","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-18。"],[],[],null,["# Microsoft Azure Synapse Analytics\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\nTo learn more about using SSL encryption, see the [Microsoft documentation](https://azure.microsoft.com/en-us/documentation/articles/cloud-services-configure-ssl-certificate/).\n\nUsers and security\n------------------\n\nFirst, connect to the `master` database on your server with your server admin login: \n\n CREATE LOGIN looker\n WITH PASSWORD = '\u003cstrong_password\u003e';\n\nConnect to your Microsoft Azure Synapse Analytics database and create a database user: \n\n CREATE USER looker FOR LOGIN looker;\n\nLooker must be authorized to detect and stop currently running queries, which requires the following permissions: \n\n ALTER ANY CONNECTION\n VIEW SERVER STATE\n\nTo grant these permissions, run the following: \n\n GRANT CONTROL ON DATABASE::userDatabase TO looker;\n\n\u003e Depending on the Microsoft Azure Synapse Analytics tier being used, you may also need to explicitly grant the `VIEW DATABASE STATE` permission.\n\nTo grant `VIEW DATABASE STATE` permission, run the following: \n\n GRANT VIEW DATABASE STATE TO looker;\n\nTemp schema setup\n-----------------\n\nCreate a schema owned by the Looker user: \n\n CREATE SCHEMA looker_scratch AUTHORIZATION looker;\n\nCreating the Looker connection to your database\n-----------------------------------------------\n\nIn the **Admin** section of Looker, select **Connections** , and then click **Add Connection**.\n\nFill 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. The following fields have additional information that applies to Microsoft Azure Synapse Analytics:\n\n- **Dialect** : Select **Microsoft Azure Synapse Analytics**.\n- **Remote Host** and **Port**: Enter the hostname and port (the default port is 1433).\n\n If you need to specify a non-default port other than 1433 and your database requires the use of a comma instead of a colon, you can add `useCommaHostPortSeparator=true` in the **Additional JDBC parameters** field further down in the connection settings, which will allow you to use a comma in the **Remote Host:Port** field. For example:\n\n `jdbc:sqlserver://hostname,1434`\n\nTo verify that the connection is successful, click **Test** . See the [Testing database connectivity](/looker/docs/testing-db-connectivity) documentation page for troubleshooting information.\n\nTo save these settings, click **Connect**.\n\nFeature support\n---------------\n\nFor Looker to support some features, your database dialect must also support them.\n\nMicrosoft Azure Synapse Analytics supports the following features as of Looker 25.14:"]]
