HubSpot-icon-color

HubSpot

Salesforce Pardot - Icon

Salesforce Pardot

SQL-Server

Microsoft SQL Server

Salesforce Marketing Cloud - Icon

Salesforce Marketing Cloud

Firebase-icon-color

Firebase

Google BigQuery - Icon

Google BigQuery

Prometheus - Icon

Prometheus

MongoDB - Icon

MongoDB

AmazonAthena-icon-color

Amazon Athena

Databricks - Icon

Databricks

Marketo - Icon

Marketo

MySQL-icon-color

MySQL

PostgreSQL-icon-color

PostgreSQL

InfluxDB

FreshService

Freshservice

MailChimp

Mailchimp

Oracle E-Business Suite EBS - Icon

Oracle E-Business Suite EBS

SendGrid - Icon

SendGrid

Azure Synapse Analytics - Icon

Microsoft Azure Synapse Analytics

PagerDuty - Full

PagerDuty

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

Removes the specified virtual warehouse from the system.

Delete warehouse

List table columns DDL

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

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

Custom query

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

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

Insert rows in table

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

List copy history

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

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

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

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

weekly-group-demo 2x

Tray Platform group demo every 3rd Thursday at 10am PT

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

Software analytics company - Customer Story Quote

White New Relic Logo

Developers

Snowflake - Icon

Snowflake

Database

Create contact record

Delete contact record

Retrieve an individual contact record by ID

Get contact record

Get a contact record's activity facts and scores.

Get contact record fact and score data

Get list

Get message report

Get a drilldown report for a specific email message

Get message report drilldown

Check whether upsert async contact record upload is complete

Get upsert upload status

List all lists

List messages

Get a list of subscriptions listed by category.

List subscription categories

List subscription categories DDL

Get a list of categories that an email address has explicitly opted into.

List subscription category opt ins by email

Get a list of records specifically opted out of a specific category

List subscription opt outs

Add/remove individual records from multiple subscription category by email address.

Opt in / Opt out email from multiple subscription categories

Add/remove individual contact records from a subscription category by email address

Opt in / Opt out email from subscription category

Update a contact record in a list using its ID

Update contact record

Update an existing record or insert a new contact record using the email address that you specify using the following logic. If the email address exists in the list, only the first record matching that email address is updated with the data you provide. If the email address is not already in the list, a new record is added. Please take note that this means that any duplicate records are NOT updated.

Upsert contact record

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

The State of Marketing technology eBook by Tray.io

Snowflake and Act-On integration + automation

Popular Snowflake and Act-On integrations

Snowflake and Act-On Connector Details

Snowflake

Act-On

Tray.io is the leader in low-code automation

Similar connectors to Snowflake and Act-On

Try Tray today and see for yourself. No strings attached.