Dataform

Dataform

Google
+
+

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
  • Anaconda
    625 Ratings
    Visit Website
  • Creatio
    589 Ratings
    Visit Website
  • Coevera
    753 Ratings
    Visit Website
  • LTX
    182 Ratings
    Visit Website
  • Pipedrive
    12,537 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

Pylar is a secure data-access layer that sits between AI agents and your databases, enabling agents to safely interact with structured data without giving them direct database access. It connects to one or more data sources (like BigQuery, Snowflake, PostgreSQL, business apps such as HubSpot or Google Sheets). Pylar can create governed SQL views using its built-in SQL IDE; those views define exactly which tables, columns, and rows agents are allowed to access. It lets you build “MCP tools” (either by writing natural-language prompts or manual configuration) that wrap SQL queries into standardized, safe operations. Agents can access data through a single MCP endpoint, compatible with multiple agent builders like custom AI assistants, no-code automation tools, or integrations (e.g. Zapier, n8n, LangGraph, VS Code, etc.).

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 teams, developers, or organizations wanting to safely enable AI agents to query and act on internal data

Support

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

Support

Phone Support Not 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

$20 per month
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 Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

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

Company Information

Pylar
Founded: 2025
USA
www.pylar.ai/

Alternatives

dbt

dbt

dbt Labs

Alternatives

TablePlus

TablePlus

TablePlus InC
DBeaver Community

DBeaver Community

DBeaver Corp.
REGRESSwise

REGRESSwise

iQspeaks Limited
DbSchema

DbSchema

Wise Coders

Categories

Data Pipeline Supported

Categories

AI Tools Supported
SQL IDEs Supported

Integrations

Google Cloud BigQuery Supported
Asana Not Supported
Freshdesk Not Supported
Front Not Supported
GitHub Supported
GitLab Supported
Google Cloud Managed Service for Apache Airflow Supported
Google Sheets Not Supported
HubSpot CRM Not Supported
Intercom Not Supported
Meta Ads Not Supported
Microsoft 365 Not Supported
MotherDuck Not Supported
MySQL Not Supported
Pipedrive Not Supported
QuickBooks Payments Not Supported
Salesforce Not Supported
Shopify Not Supported
Stripe Not Supported
Supabase Not Supported

Integrations

Google Cloud BigQuery Supported
Asana Supported
Freshdesk Supported
Front Supported
GitHub Not Supported
GitLab Not Supported
Google Cloud Managed Service for Apache Airflow Not Supported
Google Sheets Supported
HubSpot CRM Supported
Intercom Supported
Meta Ads Supported
Microsoft 365 Supported
MotherDuck Supported
MySQL Supported
Pipedrive Supported
QuickBooks Payments Supported
Salesforce Supported
Shopify Supported
Stripe Supported
Supabase Supported
Claim Dataform and update features and information
Claim Dataform and update features and information
Claim Pylar and update features and information
Claim Pylar and update features and information