QuickBooks-icon-color

QuickBooks Online

PostgreSQL-icon-color

PostgreSQL

Redshift - Icon

Redshift

SageIntacct-icon-color

Sage Intacct

Sage 300 - Icon

Sage 300

SQL-Server

Microsoft SQL Server

Reltio - Icon

Reltio

Google BigQuery - Icon

Google BigQuery

Amazon Athena - Icon

Amazon Athena

MySQL - Icon

MySQL

PortaBilling - Icon

PortaBilling

Stripe - Icon

Stripe

MongoDB - Icon

MongoDB

IBMDB2-icon-color

IBM DB2

Databricks - Icon

Databricks

FreshService

Freshservice

PagerDuty - Full

PagerDuty

Firebase - Icon

Firebase

Square - Icon

Square

Mode - Icon

Mode

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

Finance Leader

Finance leader integrates CRM & payments to strengthen sales, support, and strategy

new-workflow-template-create-slack-notifications-for-zuora-events blog post cover image

new-workflow-template-create-slack-notifications-for-zuora-events

Optimize your events with Zuora-Slack integration

Dex Yp used Tray.io to connect their MarTech stack

dex-yp-color-logo

Thryv integrates online orders & payments to mobilize 1,500-person sales team

recurly-color-logo

Recurly's subscription-payment functionality integrates with the Tray Platform to directly connect billing to all other mission-critical business operations.

sales-operations-best-practices blog post cover image

sales-operations-best-practices

How to close the sales revenue gap

Connector Department - Finance and Accounting - Cards

Vestorly - Full - Dark

Vestorly - Jonathan Tartell

Finance and Accounting

Pigment logo

Pigment

Create a batch of new records in Salesforce. (Max 200).

Batch create records

Delete a batch of records in Salesforce. (Max 200).

Batch delete records

Update a batch of records in Salesforce. (Max 200).

Batch update records

Delete custom field metadata. Single or multiple fields can be deleted in a single operation.

Delete custom field

Bulk update records using the Salesforce Bulk API. Record data should be in CSV format.

Bulk update records

Bulk upsert records using the Salesforce Bulk API. Record data should be in CSV format

Bulk upsert records

Delete query job

Convert a lead into an account, contact and/or opportunity

Convert Lead

Count the number of records that match a given set of conditions.

Count records

Create an amendment quote for a contract.

Create amendment quote

Create custom field metadata. Single or multiple fields can be created.

Create custom field

Create query job

Create record

Create a record if a record with the "lookup value" doesn't already exist. Update it if it does exist.

Create/update record

Create a record if a record with the 'lookup value' doesn't already exist. Update it if it does exist. If there is no external ID to reference, insert a new record using ID as the External ID.

Create/update record using ID

Delete a record in Salesforce, using it's unique object id.

Delete record

Describes the raw structure of an object in Salesforce.

Describe object (advanced)

Downloads a file attachment from Salesforce, for use in other connectors.

Download attachment

Download file

Runs an instance of a report asynchronously with or without filters.

Execute report async

Runs a report immediately with or without changing filters, groupings, or aggregates and returns the latest summary data with or without details for your level of access.

Execute report sync

Find records

Get the description of a record type, given the unique ID of the record of that type in Salesforce.

Get Record Object Description

Locate customers’ preferences for consent across multiple records.

Get consent

Retrieves results of an asynchronous report run.

Get instance results

Get details about a bulk data processing job

Get job info

Get the presence status of an omni-channel

Get omni-channel presence status

Get query job

Returns a CSV file with the results of a completed query job.

Get query job results

Get details about the authenticated Salesforce user.

Get user info

Retrieve a list of jobs created by bulk data operations e.g. Bulk upsert records

List jobs

List query jobs

List query jobs DDL

Retrieves report fields available for specified reports.

List report fields

List report fields DDL

List report fields for standard date filter DDL

Returns a list of instances for a report.

List report instances

List report types

List report types DDL

List reports DDL

Execute a raw SOSL query to extract data from Salesforce.

SOSL Query (advanced)

Merge records into a master record. Be advised if you want to keep values from non-master records the Fields to populate input must be used

Merge records

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Snowflake and Pigment integration + automation

Popular Snowflake and Pigment integrations

Snowflake and Pigment Connector Details

Snowflake

Pigment

Tray is the leading AI ready integration and automation platform

Similar connectors to Snowflake and Pigment