Microsoft Teams

HubSpot - Icon

HubSpot

Salesforce Pardot - Icon

Salesforce Pardot

Microsoft Sharepoint - Icon

Microsoft Sharepoint

Slack-icon-color

Slack

PostgreSQL-icon-color

PostgreSQL

Jira

Redshift - Icon

Redshift

Microsoft Outlook - Icon

Microsoft Outlook

Salesforce Marketing Cloud - Icon

Salesforce Marketing Cloud

SQL-Server

Microsoft SQL Server

Reltio - Icon

Reltio

Google BigQuery - Icon

Google BigQuery

Remarkety - Icon

Remarkety

Amazon Athena - Icon

Amazon Athena

MySQL - Icon

MySQL

Notion - Icon

Notion

MongoDB - Icon

MongoDB

IBMDB2-icon-color

IBM DB2

Marketo - Icon

Marketo

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

Create an asset reference, optionally associated with Opal objects.

Create asset reference

Get label

Retrieve a list of labels for a workspace.

List labels

List phase items

List stories

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

Raw HTTP Request (Advanced)

Update phase item

Upload an asset available to the authenticated user.

Upload asset

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

BLOG - Hot Topic

Personalization is shifting from email to omni-channel. Are you ready?

hot-topics-blog-header-3@2x

Automating Lead List Uploads: Mission-Critical, and Much Easier than You Think

Jellyvision - Card

Jellyvision improves lead response speed, conversions, and win rate with automation

segment-color-logo

Segment uses Tray Platform to unlock insights synced with every component of enterprise stack.

Connector Department - Marketing - Cards

DigitalOcean - Full - Dark

David Dorman of Digital Ocean works with Tray.io

David Dorman - DigitalOcean

DigitalOcean - David Dorman

Marketing

Opal

Marketing Automation Platform (MAP)

Collaboration

"Request a trial" -> Trial LP [Primary] | MAIN SITEWIDE CTA

MAIN SITEWIDE CTA | Trial Landing Page

Experiences

Capabilities

Foundation - Merlin AI and Enterprise Core

CTA - Universal Automation Cloud LP - "Learn more" - Secondary

Universal Automation Cloud

CTA - Cvent case study - "Show me how" - Primary 

cvent-logo-white

Cvent migrates 500+ legacy integrations and achieves a 95% customer retention rate

Customer Spotlight

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua

Lorem ipsum dolor

UAC Solutions - By Team

UAC Solutions - By Use Case

UAC Solutions - By Application

A strategic platform with solutions for mission critical use cases

Solutions

Solutions Customer Spotlight: Beyond Finance CTA - Primary

Logo - Beyond Finance - White

Beyond Finance reduces employee onboarding time from 10 days to 5 minutes

Resources - Learn & Evaluate

Resources - Success

Resources - Company

Your journey to automation excellence starts here

Resources

TUAC Resources Spotlight - Udemy

Resources Customer Spotlight - Primary

Udemy - White Full

Udemy streamlines self-service to enterprise sales process and saves 20+ hours per month

Tray.io > Tray.ai animation DARK

Homepage Tray.ai logo animation DARK

Tray.io > Tray.ai Animation - LIGHT

Homepage Tray.ai logo animation LIGHT

See all our connectors (Tertiary)

Similar connectors to Snowflake and Opal

G2-2024-spring_creative

Tray is the leading AI ready integration and automation platform

Details - Double

Header CTA Banner - Welcome to Tray.ai, the AI-ready iPaaS

Header CTA Banner (Connectors) - Welcome to Tray.ai

Our interactive tour walks you through the Tray platform, showing you how integrations and automations work together to optimize your operations - on your own time, no pressure.

Take interactive tour

First Name

Last Name

Email

Submit (Get a demo)

How did you hear about Tray - Interactive Tour (Hidden)

offer_type (interactive tour)

Salesforce Campaign ID (Interactive Tour)

Interactive Tour Form

"Take interactive tour" -> Interactive Tour Form Modal [Primary]

"Request 1:1 demo" -> Platform Demo 1:1 Form Modal [Primary]

Snowflake and Opal integrations couldn’t be easier with the Tray platform’s robust Snowflake and Opal connector, which connects any services without the need for separate integration tools.

Snowflake and Opal integrations couldn’t be easier with the Tray platform’s robust Snowflake and Opal connectors, which can connect to any service without the need for separate integration tools.

Integrate Snowflake and Opal with any SaaS application or service using the Tray platform’s generic connectivity options, such as the HTTP Client, Webhook Trigger, and our Connector Builder. Configure them to connect to Snowflake and Opal and any other API, database, webhook, and more.

Snowflake and Opal integration + automation

Snowflake and Opal Connector Details

Popular Snowflake and Opal integrations

Snowflake and Opal templates