Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Dataform provides a platform for data analysts and engineers to create and manage scalable data transformation pipelines in BigQuery using solely SQL from a single, integrated interface. The open-source core language allows teams to outline table structures, manage dependencies, include column descriptions, and establish data quality checks within a collective code repository, all while adhering to best practices in software development, such as version control, various environments, testing protocols, and comprehensive documentation. A fully managed, serverless orchestration layer seamlessly oversees workflow dependencies, monitors data lineage, and executes SQL pipelines either on demand or on a schedule through tools like Cloud Composer, Workflows, BigQuery Studio, or external services. Within the browser-based development interface, users can receive immediate error notifications, visualize their dependency graphs, link their projects to GitHub or GitLab for version control and code reviews, and initiate high-quality production pipelines in just minutes without exiting BigQuery Studio. This efficiency not only accelerates the development process but also enhances collaboration among team members.
Description
When PostgreSQL serves as the foundation of your enterprise and is a key data source, PeerDB offers an efficient, straightforward, and economical solution for replicating data from PostgreSQL to data warehouses, queues, and storage systems. It is engineered to function seamlessly at any scale and is specifically adapted for various data repositories. By utilizing replication messages sourced from the PostgreSQL replication slot, PeerDB adeptly replays schema updates while providing alerts for slot growth and active connections. It also includes native support for PostgreSQL toast columns and large JSONB columns, making it particularly advantageous for IoT applications. The platform features an optimized query architecture aimed at minimizing warehouse expenditures, which is especially beneficial for users of Snowflake and BigQuery. Additionally, it accommodates partitioned tables through both publication mechanisms. PeerDB ensures rapid and reliable initial data loads via transaction snapshotting and CTID scanning techniques. With features such as high availability, in-place upgrades, autoscaling, advanced logging, comprehensive metrics, and monitoring dashboards, as well as burstable instance types, it is also well-suited for development environments. Overall, PeerDB stands out as a versatile tool that effectively meets the diverse needs of modern data management.
API Access
Has API
No
API Access
Has API
No
Integrations
GitHub
Yes
Google Cloud BigQuery
Yes
Apache Kafka
No
Azure Event Hubs
No
ClickHouse
No
GitLab
Yes
Google Cloud Managed Service for Apache Airflow
Yes
PostgreSQL
No
PubSub+ Platform
No
SQL
Yes
Integrations
GitHub
Yes
Google Cloud BigQuery
Yes
Apache Kafka
Yes
Azure Event Hubs
Yes
ClickHouse
Yes
GitLab
No
Google Cloud Managed Service for Apache Airflow
No
PostgreSQL
Yes
PubSub+ Platform
Yes
SQL
No
Pricing Details
Free
Free Trial
No
Free Version
Yes
Pricing Details
$250 per month
Free Trial
Yes
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
Yes
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
Yes
In Person
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
Yes
In Person
No
Vendor Details
Company Name
Founded
1998
Country
United States
Website
cloud.google.com/dataform
Vendor Details
Company Name
PeerDB
Country
United States
Website
www.peerdb.io
Product Features
Product Features
Data Replication
Asynchronous Data Replication
No
Automated Data Retention
No
Continuous Replication
No
Cross-Platform Replication
No
Dashboard
No
Instant Failover
No
Orchestration
No
Remote Database Replication
No
Reporting / Analytics
No
Simulation / Testing
No
Synchronous Data Replication
No
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No