Salesforce Pardot - Icon

Salesforce Pardot

Google BigQuery - Icon

Google BigQuery

Firebase - Icon

Firebase

SQL-Server

Microsoft SQL Server

MongoDB - Icon

MongoDB

Autopilot-icon-color

Autopilot

Amazon Athena - Icon

Amazon Athena

Databricks - Icon

Databricks

Opal

Salesforce Marketing Cloud - Icon

Salesforce Marketing Cloud

Marketo - Icon

Marketo

FreshService

Freshservice

PostgreSQL-icon-color

PostgreSQL

MySQL - Icon

MySQL

ConvertKit

GetResponse - Icon

GetResponse

PagerDuty - Full

PagerDuty

Ontraport

MailChimp

Mailchimp

Campaign Monitor - Icon

Campaign Monitor

Custom query

Create a new named internal or external stage to use for loading data from files into Snowflake tables and unloading data from tables into files.

Create stage

List table columns DDL

Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).

Update schema

Modifies the properties for an existing named internal or external stage.

Update stage

Modifies the properties, columns, or constraints for an existing table.

Update table

Suspends or resumes a virtual warehouse, or aborts all queries (and other SQL statements) for a warehouse. Can also be used to rename or set/unset the properties for a warehouse.

Update warehouse

Unload data from a table (or query) into one or more files in a named internal stage, a named external stage or an external stage.

Unload data from table

This operation can be used to query Snowflake data loading history along various dimensions within the last 7 days.

List copy history

Create database

Create schema

Create table

Creates a new virtual warehouse in the system. Creating a warehouse includes specifying its size. Initial creation of a warehouse may take some time to provision the servers, unless the warehouse is set to be created initially in a SUSPENDED state.

Create warehouse

Delete database

Removes files that have been staged (i.e. uploaded from a local file system or unloaded from a table)

Delete files from stage

Delete rows from the target table using optional query and additional (non-target) tables.

Delete rows from table

Delete a schema from the current or specified database.

Delete schema

Removes the specified named internal or external stage from the current/specified schema. The status of the files in the stage depends on the stage type.

Delete stage

Delete a table from the current or specified schema.

Delete table

Removes the specified virtual warehouse from the system.

Delete warehouse

Updates a table by inserting one or more rows into the table.

Insert rows in table

Lists the databases for which you have access privileges, including the dropped databases that are still within the Time Travel retention period.

List databases

List files in stage

Lists the schemas for which you have access privileges, including the dropped schemas that are still within the Time Travel retention period.

List schemas

Lists the stages for which you have access privileges.

List stages

List table rows

Lists the tables for which you have access privileges, including the dropped tables that are still within the Time Travel retention period.

List tables

Lists the warehouses for which you have access privileges.

List warehouses

Load data from staged files to an existing table. The files must already be staged.

Load data to table

Modifies the properties for an existing database, including changing the name of the database and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).

Update database

Updates specified rows in the target table with new values.

Update row in table

MongoDB-Logo

How to integrate MongoDB

postgresql-logo

How to integrate PostgresSQL

aws redshift

How to integrate Amazon Redshift

flow-data-between-csv-and-your-stack-with-csv-processor blog post cover image

flow-data-between-csv-and-your-stack-with-csv-processor

Learn How to Automate Your CSV and Flat File Management

Connector Department - Developers - Cards

New Relic - Full - Dark

New Relic - Anonymous

Developers

Snowflake - Icon

Snowflake

Database

Add contact to company

Add contact records that have already been created in the system to a contact list. You can either specify their email addresses or their IDs.

Add contact to list

Move a specified property to the recycling bin.

Archive property

Move a specified property group to the recycling bin.

Archive property group

Associate crm objects

Associate a custom object with another object.

Associate custom object

Create a group of line items in your HubSpot account.

Batch create line items

Create a group of products in your HubSpot account.

Batch create products

If multiple contacts already exist update their data. Create new contacts if they do not i.e. Upsert

Batch create/update contact

Delete a group of line items from your HubSpot account.

Batch delete line items

Delete a group of products from your HubSpot account.

Batch delete products

Batch update companies

Update a group of deals in your HubSpot account.

Batch update deals

Update a group of line items in your HubSpot account.

Batch update line items

Update a group of products in your HubSpot account

Batch update products

Using the Event ID calculate the attendance duration for all attendees and update said attendees timeline entries.

Calculate attendance duration at event for all attendees

Cancel marketing event (beta)

Check if a contact with an email address exists.

Contact exists with email?

Create blog post

Create call engagement

Create company

Create contact

Create contact list

Create a CRM object with the given properties and return a copy of the object, including the ID. Please define a schema in advance using the 'Create object schema' operation.

Create custom object

Creates and tracks deals in HubSpot. It also allows you to connect HubSpot with an external CRM or other sales management software.

Create deal

Create an email with the given properties.

Create email engagement

Create a line item in your HubSpot account.

Create line item

Create marketing event (beta)

Create a meeting with the given properties.

Create meeting engagement

Create note engagement

Define a new object schema, along with custom properties and associations.

Create object schema

Create a product in your Hubspot account.

Create product

Create property

Create a new property group for an object type.

Create property group

Create task engagement

Create ticket

If contact already exists update their data. Create a new contact if not i.e. Upsert

Create/update contact

If a marketing event already exists update the data. Create a new marketing event if it does not i.e. Upsert

Create/update marketing event (beta)

Delete all associations between two records.

Delete associations from CRM objects

Delete blog post

Delete comment

Delete company

Delete contact

Delete contact list

Delete custom object association

Delete deal

Delete line item

Delete a schema. NB: Any existing records of this schema must be deleted first, otherwise this request will fail.

Snowflake and HubSpot integration + automation

Popular Snowflake and HubSpot integrations

Snowflake and HubSpot Connector Details

Snowflake

HubSpot

Tray.io is the leader in low-code automation

Similar connectors to Snowflake and HubSpot