Connecting to Snowflake

Connecting to Snowflake

Snowflake’s Data Cloud provides data storage, processing, and analytics solutions that scale impressively.

Our Snowflake Connectors will allow you to push and pull data from a Snowflake database or data lake. So if you’re using the Snowflake platform, you’ll soon enjoy smoother data transfer to and from Appenate.

Adding

The Data Hub area of the platform is where you can add connections for connectors. Navigate the side menu to Data Hub > Connections.

On the Connections page:

  • Click the ADD CONNECTION button in the top-right-hand corner to bring up a list of connections.
  • Click on the Snowflake option.

Configuring

Use the Snowflake SQL commands below as templates to set up an Integration with your Snowflake Database. These can be copied to your Snowflake platform and updated as needed before being run.

 Create an integration by running the Snowflake integration commands within Snowflake. Copy the command by clicking on the COPY SQL button.

Once the integration has been created, use the Authentication commands to generate the required codes for your connection authentication.

You need to configure your Account Identifier, Client ID, Client Secret, and Callback URL.

Your account identifier can be obtained by looking at the browser URL in Snowflake, as seen in the screenshot below. Here, xxxxxx.west-europe.azure is an example of your account identifier, where xxxxxx is the identifier and west-europe.azure refers to the location where your Snowflake account is hosted.

You can copy authentication commands by clicking the COPY SQL button and running the copied command within Snowflake. Once the command has run, it will give you the Client ID and Client Secret.

Once you have run the Authentication Command, you’ll find the Client ID and Client Secret in the response. You’ll then be able to configure the Client ID, the Client Secret, and the Callback URL

Next, click on the SAVE button at the top right of the page. Once the page has refreshed, you’ll need to click on the Authorize button and sign in to the Snowflake account with a SYSADMIN user. Your connection will then be verified automatically—you’ll see a message indicating that you are now connected on the right-hand side.

    • Related Articles

    • Form Connector – Snowflake

      Our Premium connector for direct connection to a Snowflake database. Our platform enables you to quickly and easily connect your Form Entries to a Snowflake database. This enables one-way synchronization, where any Forms Entries are pushed to tables ...

    • Data Source Connector – Snowflake

      Our platform enables you to quickly and easily connect your data sources to a Snowflake table. This enables a one-way synchronization to occur – where any changes in the Snowflake table are downloaded into your data source on a regular basis. Your ...

    • Connecting to OneDrive (Personal)

      MS Graph Connection Recommended We highly recommend connecting your Microsoft services using the Microsoft Graph integration. As the unified gateway to Microsoft 365, a single MS Graph connection securely authenticates SharePoint, OneDrive, and Excel ...

    • Connecting to SharePoint

      Authenticating a connection to SharePoint allows the two platforms to communicate. This authentication must be completed before Form Connectors (SharePoint List and SharePoint Document) can push data or Data Source Connectors can pull data. The ...

    • Connecting to FTP

      Authenticating a connection to an FTP server enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Sources can pull data. Adding The Data Hub area of the platform is where you can add ...