--- schema_version: "1" id: f888ce4c4ea607f53395d31833108e18c6949062a566e62c8b2f5c61d29e7533 title: Using Anypoint Studio to Configure Snowflake Connector 1.3 collection: mulesoft version: current locale: en-us portal_url: https://docs.salesforce.com/mulesoft/current/en-us/snowflake-connector/1.3/snowflake-connector-studio.md canonical_url: https://docs.mulesoft.com/snowflake-connector/1.3/snowflake-connector-studio source_site: docs.mulesoft.com content_type: documentation content_hash: f9e95304972597fb6778b6785e971d26b9e4c1c95d34924068186263052d1e0a description: MuleSoft Documentation Site release: "1.3" latest: false --- --- product: Snowflake Connector version: 1.3 --- # Using Anypoint Studio to Configure Snowflake Connector 1.3 > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Anypoint Studio (Studio) editors help you design and update your Mule applications, properties, and configuration files. To add and configure a connector in Studio: 1. [Create a Mule project](#create-mule-project). 2. [Add the connector to your Mule project](#add-connector-to-project). 3. [Configure a source for the connector’s flow](#configure-source). 4. [Add a connector operation to the flow](#add-connector-operation). 5. [Configure a global element for the connector](#configure-global-element). 6. [Configure the other connector fields](#configure-other-fields). When you run the connector, you can view the app log to check for problems in real time, as described in [View the App Log](#view-app-log). If you are new to configuring connectors in Studio, see [Using Anypoint Studio to Configure a Connector](https://docs.mulesoft.com/connectors/introduction/intro-config-use-studio). If, after reading this topic, you need additional information about the connector fields, see the [Snowflake Connector Reference](https://docs.mulesoft.com/snowflake-connector/1.3/snowflake-connector-reference). ## Create a Mule Project In Studio, create a new Mule project in which to add and configure the connector: 1. In Studio, select **File > New > Mule Project**. 2. Enter a name for your Mule project and click **Finish**. ## Add the Connector to Your Mule Project Add Snowflake Connector to your Mule project to automatically populate the XML code with the connector’s namespace and schema location and add the required dependencies to the project’s `pom.xml` file: 1. In **Mule Palette**, click **(X) Search in Exchange**. 2. In **Add Dependencies to Project**, type `snowflake` in the search field. 3. Click **Snowflake Connector** in **Available modules**. 4. Click **Add**. 5. Click **Finish**. Adding a connector to a Mule project in Studio does not make that connector available to other projects in your Studio workspace. ## Configure a Source A source initiates a flow when a specified condition is met. You can configure one of these sources to use with Snowflake Connector: - Snowflake > On Table Row Initiates a flow by selecting from a table at a regular interval and generating one message per obtained row - HTTP Listener Initiates a flow each time it receives a request on the configured host and port - Scheduler Initiates a flow when a time-based condition is met For example, to configure an **On Table Row** source, follow these steps: 1. In **Mule Palette**, select **Snowflake > On Table Row**. 2. Drag **On Table Row** to the Studio canvas. 3. On the **On Table Row** configuration screen, optionally change the value of **Display Name**. 4. Click **+** next to **Connector configuration** to configure a global element that can be used by all instances of the **On Table Row** source in the app. 5. On the **Snowflake Config** window, for **Required Libraries**, add the required Snowflake JDBC driver by selecting **Configure > Add recommended libraries** or **Configure > Add Maven dependency** and adding the artifact ID `snowflake-jdbc`. 6. On the **Connection** section, specify the database connection information for the connector. 7. On the **Advanced** tab, optionally specify connection pooling and reconnection information, including a reconnection strategy. 8. Click **Test Connection** to confirm that Mule can connect with the specified Snowflake database. 9. Click **OK** to close the window. 10. On the **On Table Row** configuration screen, in **Table**, select the name of the table to select from. 11. On the **On Table Row** configuration screen, in **Watermark Column**, select the name of the column to use for the watermark. Values taken from this column are used to filter the contents of the next poll, so that only rows with a later date than the watermark value are processed. 12. On the **On Table Row** configuration screen, in **Id Column**, select the name of the column to consider as the row ID. This parameter ensures the same row is not processed twice by concurrent polls. For example, to configure an HTTP listener source, follow these steps: 1. In **Mule Palette**, select **HTTP > Listener**. 2. Drag **Listener** to the Studio canvas. 3. On the **Listener** configuration screen, optionally change the value of **Display Name**. 4. Specify a value for the **Path** field. 5. Click **+** next to **Connector configuration** to configure a global element that can be used by all instances of the HTTP Listener source in the app. 6. On the **General** tab, specify connection information for the connector. 7. On the **TLS** tab, optionally specify the TLS information for the connector. 8. On the **Advanced** tab, optionally specify reconnection information, including a reconnection strategy. 9. Click **Test Connection** to confirm that Mule can connect with the specified server. 10. Click **OK**. ## Add a Connector Operation to the Flow When you add a connector operation to your flow, you are specifying an action for that connector to perform. To add an operation for Snowflake Connector, follow these steps: 1. In **Mule Palette**, select **Snowflake** and then select the desired operation. 2. Drag the operation onto the Studio canvas to the right of the input source. ## Configure a Global Element for the Connector When you configure a connector, configure a global element that all instances of that connector in the app can use. Configuring a global element requires you to provide the authentication credentials that the connector requires to access the target Snowflake system. Snowflake Connector supports the Snowflake Connection type to connect to Snowflake. To configure the global element for Snowflake Connector, follow these steps: 1. Select the operation in the Studio canvas. 2. In the configuration screen for the operation, click **+** next to the **Connector configuration** field to access the global element configuration fields. 3. In the **General** tab, in **Required Libraries**, click **Configure** and select from the following options to install the required JDBC driver: - **Add recommended libraries** - **Use local file** - **Add Maven dependency** 4. In **Connection**, enter the following required information to configure authentication: - **Account name** Account name that was provided when registering for the Snowflake account. - **Warehouse** Name of the virtual Snowflake warehouse to use. The specified warehouse must be an existing warehouse for which the specified account has privileges. - **Database** Snowflake database to connect to. The specified database must be an existing database for which the specified account has privileges. - **Schema** Snowflake database schema to use. The specified schema must be an existing schema for which the specified account has privileges. Either reference a configuration file that contains ANT-style property placeholders (recommended) or enter your authorization credentials in the global configuration properties. For information about the benefits of using property placeholders and how to configure them, see [Anypoint Connector Configuration](https://docs.mulesoft.com/connectors/introduction/intro-connector-configuration-overview). 5. On the **Advanced** tab, optionally specify reconnection information, including a reconnection strategy. 6. Click **Test Connection** to confirm that Mule can connect with the specified server. 7. Click **OK**. ## Configure Additional Connector Fields After you configure a global element for Snowflake Connector, configure the other required fields for the connector. The required fields vary depending on which connector operation you use. ## View the App Log To check for problems, view the app log: - If you’re running the app from Anypoint Platform, the app log output is visible in the Anypoint Studio console window. - If you’re running the app using Mule from the command line, the app log output is visible in your OS console. Unless the log file path is customized in the app’s log file (`log4j2.xml`), you can also view the app log in the default location `MULE_HOME/logs/.log`. You can configure the location of the log path in the app log file `log4j2.xml`. ## See Also - [Introduction to Anypoint Connectors](https://docs.mulesoft.com/connectors/introduction/introduction-to-anypoint-connectors) - [Using Anypoint Studio to Configure a Connector](https://docs.mulesoft.com/connectors/introduction/intro-config-use-studio) - [Snowflake Connector Reference](https://docs.mulesoft.com/snowflake-connector/1.3/snowflake-connector-reference) - [Salesforce Help](https://help.salesforce.com)