SQL-Server

Microsoft SQL Server

Databricks - Icon

Databricks

Firebase - Icon

Firebase

ServiceTitan - Icon

ServiceTitan

Google BigQuery - Icon

Google BigQuery

PostgreSQL-icon-color

PostgreSQL

FreshService

Freshservice

MongoDB - Icon

MongoDB

Amazon Athena - Icon

Amazon Athena

MySQL - Icon

MySQL

Redshift - Icon

Redshift

PagerDuty - Full

PagerDuty

Veeva

IBMDB2-icon-color

IBM DB2

AccuWeather - Icon

AccuWeather

Reltio - Icon

Reltio

Samsara - Icon

Samsara

Attentive Mobile

Mode - Icon

Mode

nasa

Nasa

Get bulk generic flags

Retrieve a single generic flag assignment

Get generic flag assigment

Create/update customers and create subscriptions for the customers.

Import main object

Search for a single or series of generic flag assignments based on search parameters. The result contains a series of generic flag assignment IDs.

Search generic flag assignments

Search for a single or series of generic flags based on search parameters. The result contains a series of generic flag IDs.

Search generic flags

Search for a single or series of notes based on search parameters. The result contains a series of note IDs.

Search note

Search for a single or series of subscriptions based on search parameters. The result contains a series of subscription IDs.

Search subscription

Update flag assignment

Delete flag assignment

Get bulk appointments

Get bulk customers

Retrieve a selection of generic flag assignments.

Get bulk generic flag assignments

Get bulk notes

Get bulk subscriptions

Get customer

Get generic flag

Get note

Get subscription

Search for a single or series of customers based on search parameters. The result contains a series of customer IDs.

Search customer

Create flag assignment

Get appointment

Search for a single or series of appointments based on search parameters. The result contains a series of appointment IDs.

Search appointment

case-study-travel-leader

Travel and hospitality leader positions itself for powerful revenue growth

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

Travel and hospitality leader customer story with Tray.io

Travel and Hospitality Leader

Travel and hospitality leader drives powerful revenue growth

Connector Department - Vertical - Cards

ANONYMOUS  - Travel leader

Vertical

pestroutes

PestRoutes

Create database

Create schema

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

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

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

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 columns DDL

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

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

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

See all our connectors (Tertiary)

Similar connectors to PestRoutes and Snowflake

G2-2024-spring_creative

Tray is the leading AI ready integration and automation platform

DigitalOcean - Full - Dark

David Dorman of Digital Ocean works with Tray.io

David Dorman - DigitalOcean

DigitalOcean - David Dorman

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

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

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

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

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

Integrate PestRoutes and Snowflake 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 PestRoutes and Snowflake and any other API, database, webhook, and more.

PestRoutes and Snowflake integration + automation

Popular PestRoutes and Snowflake integrations

PestRoutes and Snowflake Connector Details

PestRoutes

Snowflake

Tray is the leading AI ready integration and automation platform

Similar connectors to PestRoutes and Snowflake