Intro
Azure Synapse Analytics lets you quickly implement a high-performance, globally available, and secure cloud data warehouse. Use Domo’s Azure Synapse Partition SQL connector to bring your Azure data into Domo. Combine your Azure data with data from other data sources throughout your company for a comprehensive view of your business. You can set up custom alerts to be notified in real-time when your key metrics change, so you can make faster, better business decisions. You can connect to your Azure Synapse Partition account in the Data Center. This topic discusses the fields and menus that are specific to the Azure Synapse Partition connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.Prerequisites
To connect to your Azure Synapse Partition account and create a DataSet, you need the following:- You need to select the JDBC Driver Version
- Server Name
- Database Name
- Port number
- Username and password
- Host Name In Certificate
Connecting to Your Azure Synapse Partition Account
This section enumerates the options in the Credentials and Details panes on the Azure Synapse Partition Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your Azure Synapse Partition account. The following table describes what is needed for each field:Field | Description |
|---|---|
| JDBC Driver Version | Select the JDBC driver version. |
| Server Name | Go to the Azure Portal. Click Azure Synapse Analytics. Click the Synapse SQL Pool you want to connect. Locate the full server name. For example yourserver.database.windows.net |
| Database Name | Enter the database name. |
| Port | Enter the port number. |
| Username | Enter the username. |
| Password | Enter the password. |
| HostNameInCertificate | Enter the hostNameInCertificate obtained from the show database connection strings. |
Details Pane
Menu | Description |
|---|---|
| Partition Criteria | Select the Partition Criteria. |
| Schema Name | Select the schema name. |
| Table Name | Select the database table. |
| Partition Date Key Column Name | Select the date key partition column name. |
| Partition Non Date Key Column Name | Select the non date key partition column name. |
| Partition Meta Query to determine partition tags | Enter the partition meta query to determine the distinct partition tags(or keys). Example SELECT DISTINCT(DATE_COLUMN_NAME) FROM TABLENAME. In this example DATE_COLUMN_NAME is the partition column and distinct values from the table are the keys. |
| Partition Support Format | Select the partition format. |
| Past Years | Enter the number of past years that you want to get data for. Value can be X, where X is a positive integer. For example: 30. |
| Future Years | Enter the number of future years that you want to get data for. Value can be X, where X is a positive integer. For example: 30. |
| Past Months | Enter the number of past months that you want to get data for. Value can be X, where X is a positive integer. For example: 30. |
| Future Months | Enter the number of future months that you want to get data for. Value can be X, where X is a positive integer. For example: 30. |
| Past Days | Enter the number of past days that you want to get data for. Value can be X, where X is a positive integer. For example: 30. |
| Custom Date Format | Enter the custom date format. |
| Query | Enter the query to execute. Note: Subqueries are used for partitioning. Read the rules and construct the query accordingly. Rules: https://learn.microsoft.com/en-us/sql/relational-databases/performance/subqueries?view=sql-server-ver16#rules |
| Cast To Date | Select this checkbox if you want to cast the partition column to DATE type. |
| Limit Buffer Size | Select this checkbox if you want to Limit the maximum heap memory used by ResultBuffer. |