SQL-Server

Microsoft SQL Server

Firebase-icon-color

Firebase

Tableau-icon-color

Tableau Desktop

Looker - Icon

Looker

Google BigQuery - Icon

Google BigQuery

Prometheus - Icon

Prometheus

MongoDB - Icon

MongoDB

AmazonAthena-icon-color

Amazon Athena

Databricks - Icon

Databricks

ArcGis-icon-color

ArcGis

ZoomInfo - Icon

ZoomInfo

MySQL-icon-color

MySQL

PostgreSQL-icon-color

PostgreSQL

InfluxDB

FreshService

Freshservice

SAP Analytics Cloud - Icon

SAP Analytics Cloud

Oracle E-Business Suite EBS - Icon

Oracle E-Business Suite EBS

Azure Synapse Analytics - Icon

Microsoft Azure Synapse Analytics

PagerDuty - Full

PagerDuty

Neo4j

List push datasets DDL

List tables DDL

List push datasets

Create a new dataset in the specified workspace.

Create dataset in group

Create push dataset

Add new data rows to the specified table, within the specified dataset, from the specified workspace.

Create rows in group

Delete dataset

Delete all rows from the specified table, within the specified dataset, from the specified workspace.

Delete rows in group

Return a list of tables within the specified dataset from the specified workspace.

List tables in group

List tables in group DDL

Push rows

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

Raw HTTP request (advanced)

Update the metadata and schema for the specified table, within the specified dataset, from the specified workspace.

Update table in group

Power BI1

Integrations

Flexible Power BI integrations 

Power BI2

Automation

Rapid Power BI automation 

PowerBI3

Use cases

Generate actionable analytics at scale

Power BI4

Governance

Turbo-charge data governance with Power BI automation 

Power BI5

Data warehouse

 Any Power BI + data warehouse use case

marketing tools by tray.io

How Automation is Changing the Face of Business

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

Streamline strategic sales with an automated deal desk

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

Vox Media is on the Tray platform

Vox Media connects and automates pre- and post-sales to streamline workflow

business-automation blog post cover image

business-automation

GDPR compliance for US companies: What you need to know

Connector Department - All - Cards

New Relic - Full - Dark

New Relic - ANONYMOUS

Software analytics company - Customer Story Quote

White New Relic Logo

MicrosoftPowerBI-icon-color

Microsoft Power BI

Business Intelligence (BI)

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

Developers

Snowflake - Icon

Snowflake

Database

Salesforce-icon-color

Salesforce

Slack-icon-color

Slack

Google Drive - Icon

Google Drive

HubSpot-icon-color

HubSpot

Connectors

See all connectors

AWSS3

AWS S3

Zendesk-icon-color

Zendesk

Oracle NetSuite - Icon

NetSuite

Gmail - Icon

Gmail

Google Sheets - Icon

Google Sheets

Zoom - Icon

Zoom

Facebook - Icon

Facebook

Office365

Microsoft Office 365

Shopify-icon-color

Shopify

Asana-icon-color

Asana

Jira

Marketo - Icon

Marketo

Airtable-icon-color

Airtable

Customer Stories

Featured: Gartner MQ for iPaaS

Gartner Feature

Log in

Get Started

Navbar links

Microsoft Power BI and Snowflake integration + automation

Popular Microsoft Power BI and Snowflake integrations

Microsoft Power BI and Snowflake Connector Details

Microsoft Power BI

Snowflake

Tray.io is the leader in low-code automation

Similar connectors to Microsoft Power BI and Snowflake

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