Dataform

Dataform

Google
Panoply

Panoply

SQream
+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • DataBuck
    6 Ratings
    Visit Website
  • Parasoft
    152 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • Creatio
    589 Ratings
    Visit Website
  • Coevera
    753 Ratings
    Visit Website
  • LTX
    182 Ratings
    Visit Website
  • Pipedrive
    12,537 Ratings
    Visit Website
  • Google Cloud Run
    349 Ratings
    Visit Website

About

Dataform enables data analysts and data engineers to develop and operationalize scalable data transformation pipelines in BigQuery using only SQL from a single, unified environment. Its open source core language lets teams define table schemas, configure dependencies, add column descriptions, and set up data quality assertions within a shared code repository while applying software development best practices, version control, environments, testing, and documentation. A fully managed, serverless orchestration layer automatically handles workflow dependencies, tracks lineage, and executes SQL pipelines on demand or via schedules in Cloud Composer, Workflows, BigQuery Studio, or third-party services. In the browser-based development interface, users get real-time error feedback, visualize dependency graphs, connect to GitHub or GitLab for commits and code reviews, and launch production-grade pipelines in minutes without leaving BigQuery Studio.

About

Panoply brings together a managed data warehouse with included, pre-built ELT data connectors, making it the easiest way to store, sync, and access all your business data. Our cloud data warehouse (built on Redshift or BigQuery), along with built-in data integrations to all major CRMs, databases, file systems, ad networks, web analytics tools, and more, will have you accessing usable data in less time, with a lower total cost of ownership. One platform with one easy price is all you need to get your business data up and running today. Panoply gives you unlimited access to data sources with prebuilt Snap Connectors and a Flex Connector that can bring in data from nearly any RestAPI. Panoply can be set up in minutes, requires zero ongoing maintenance, and provides online support including access to experienced data architects.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Data analysts and engineers requiring a solution to build, test, document, and orchestrate production-ready BigQuery data pipelines

Audience

Data analysts and strategists that need to generate insights via data

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Free Version Supported
Free Trial Not Supported

Pricing

$299 per month
Try Panoply with a free 21 day trial. You'll have full access, including support. Discover how Panoply can improve your data management process today.
Free Version Not Supported
Free Trial Supported

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation Supported
Webinars Not Supported
Live Online Supported
In Person Supported

Training

Documentation Supported
Webinars Supported
Live Online Supported
In Person Not Supported

Company Information

Google
Founded: 1998
United States
cloud.google.com/dataform

Company Information

SQream
Founded: 2015
United States
panoply.io

Alternatives

dbt

dbt

dbt Labs

Alternatives

REGRESSwise

REGRESSwise

iQspeaks Limited
Y42

Y42

Datos-Intelligence GmbH

Categories

Data Pipeline Supported

Categories

Big Data Supported
Data Extraction Supported
Data Management Supported
Data Pipeline Supported
Data Warehouse Supported
ETL Supported

Data Extraction Features

Disparate Data Collection Supported
Document Extraction Not Supported
Email Address Extraction Not Supported
Image Extraction Not Supported
IP Address Extraction Not Supported
Phone Number Extraction Not Supported
Pricing Extraction Not Supported
Web Data Extraction Not Supported

Data Management Features

Customer Data Supported
Data Analysis Supported
Data Capture Supported
Data Integration Supported
Data Migration Supported
Data Quality Control Supported
Data Security Supported
Information Governance Supported
Master Data Management Supported
Match & Merge Supported

Data Warehouse Features

Ad hoc Query Supported
Analytics Supported
Data Integration Supported
Data Migration Not Supported
Data Quality Control Not Supported
ETL - Extract / Transfer / Load Supported
In-Memory Processing Not Supported
Match & Merge Not Supported

ETL Features

Data Analysis Supported
Data Filtering Supported
Data Quality Control Not Supported
Job Scheduling Supported
Match & Merge Not Supported
Metadata Management Not Supported
Non-Relational Transformations Not Supported
Version Control Not Supported

Integrations

Google Cloud BigQuery Supported
AppsFlyer Not Supported
BigCommerce Not Supported
Buffer Not Supported
Customer.io Not Supported
Elasticsearch Not Supported
Facebook Ads Not Supported
Fireside Not Supported
Google Cloud Managed Service for Apache Airflow Supported
HubSpot Marketing Hub Not Supported
Klaviyo Not Supported
LinkedIn Ads Not Supported
Luzmo Not Supported
Microsoft OneDrive Not Supported
NetSuite CRM Not Supported
QuickBooks Online Not Supported
SQL Supported
Salesforce Not Supported
Salesforce Marketing Cloud Account Engagement Not Supported
Zoho Analytics Not Supported

Integrations

Google Cloud BigQuery Supported
AppsFlyer Supported
BigCommerce Supported
Buffer Supported
Customer.io Supported
Elasticsearch Supported
Facebook Ads Supported
Fireside Supported
Google Cloud Managed Service for Apache Airflow Not Supported
HubSpot Marketing Hub Supported
Klaviyo Supported
LinkedIn Ads Supported
Luzmo Supported
Microsoft OneDrive Supported
NetSuite CRM Supported
QuickBooks Online Supported
SQL Not Supported
Salesforce Supported
Salesforce Marketing Cloud Account Engagement Supported
Zoho Analytics Supported
Claim Dataform and update features and information
Claim Dataform and update features and information
Claim Panoply and update features and information
Claim Panoply and update features and information