Boomi

Snowflake Connection Configuration In Boomi 

In this blog, we will discuss how can we create a developer trail account in Snowflake and create a Boomi Snowflake connection configuration. By following below steps:

  1. Creating a Snowflake developer account.
  2. Configuration of custom database and schema.
  3. Configuration of Boomi Snowflake connection.

Creating a Snowflake account:

  • Choose ‘start for free’ option as shown in the image
  • Now enter the necessary information in the fields.
  • We can use any mail like corporate, business and personal but we cannot use any temporary mails.
  • Hit the continue button.
  • Use the default settings for the Snowflake edition type and choose your favorite cloud provider.
  • I would suggest you choose a cloud provider that your company uses the most, low cost and the cloud should be near to your data center to avoid latency.
  • We can skip the survey and proceed to the further steps.
  • They will ask multiple questions we can skip all of them.
  • After completing all of them we will receive a link to the mail which we have provided.
  • Go to the mail and click on “click to activate” button.
  • We can also see one more link at the bottom of the mail, with that link we can login to the Snowflake account which we have created.
  • We can also login to our account via https://www.snowflake.com/login/m as well.
  • It will open a new window in the default browser.
  • It will ask to configure username and password.

Configuration of database and schema in Snowflake

  • After logging to the Snowflake account, go to data and choose databases.
  • Click on +Database button highlighted in the image.
  • Then go to the database that you have created and click on the +schema button highlighted in the image.
  • Once database and schemas are created then we can create our tables in the schema.
  • To create a table, go to worksheets and open a work sheet.
  • Worksheets are used to perform operations on the database, schemas and tables to modify, create and delete the data.
  • Once we click on the worksheets it will navigate to new page to write Snowflake queries.
  • Now we have completed our prerequisites for the Snowflake connection configuration.
  • Now we will go to Boomi and create a new connection for Snowflake.

Snowflake connection configuration in Boomi

  • Open platform.boomi.com and login to your Boomi account and go to Integration service.
  • Click on create new option in the build tab and highlighted in the image.
  • Select connection component and then select Snowflake connector.
  • Now we need to configure the highlighted fields in the below image.
  • For username go to your account option on the top left corner, then choose profile inside that you can find the username.
  • You have to provide your password which you have created after activating the account.
  •  For now, we are leaving warehouse as its default value. If you want to know your warehouse name, check in the profile section.
  • We need to provide the database name and the schema name which we need to access in Boomi.
  • For now, we are using the ACCOUNTADMIN role, so we need to change the role according to the level of authorization.
  •  We can leave the remaining values as default. Or you can modify it according to your business requirements.
  • The connection configuration ready now you can use any runtime engine to test the connection.

If test connection fails?

  • If the test connection fails that means your runtime engine may not have a Snowflake jar in its path.
  • So, we need to download the Snowflake jar file from the Maven repository.

Follow the below steps to deploy the jar file as a custom library in Boomi

  • Go to settings and then choose account information and setup.
  • Click on the account libraries and upload the jar file into the account libraries.
  • Now go to the build tab and choose create new component then choose custom library component.
  • In the custom library component choose the connection option and select the Snowflake jar file which you have uploaded into the account libraries.
  • Then deploy the custom library component to the runtime that you want to connect with your Snowflake database.
  • Then restart your runtime engine.
  • Now open the Snowflake connection and test the connection.
  • It will show you “test connection successful”.

Author

Saikiran Matta

Leave a comment

Your email address will not be published. Required fields are marked *