ETL Google Spanner data with Dataprep by Trifacta

CATEGORY: Big Data & NoSQL      STATUS: Available


Google Spanner is a fully managed relational database with unlimited scale, strong consistency, and up to 99.999% availability.

ETL data from business-critical applications such as Salesforce, HubSpot, ServiceNow, Zuora, etc. or data from other Google services into Google Spanner in seconds. With Dataprep by Trifacta’s seamless integration with the Google platform, you can transform, analyze, and automate your Google Spanner data pipeline in real-time. No code required.


Join Google Spanner data with any data source

Combine datasets from any data source with your Google Spanner data. Connect to any Google service - Dataprep by Trifacta natively integrates with the Google Cloud ecosystem and adheres to the same consumption, invoicing and security principles of Google Cloud. Whether it's joining Google Spanner data with your Salesforce CRM data, an Excel CSV, or a JSON file, Dataprep by Trifacta's visual workflow lets you interactively access, preview, and standardize joined data with ease.

Google Spanner Screenshot

Google Spanner to your data warehouse in minutes

ETL your Google Spanner data to the destination of your choice.


No-code automation for your Google Spanner data pipeline

Dataprep by Trifacta empowers everyone to easily build data engineering pipelines at scale. With a few simple clicks, automate your Google Spanner data pipeline. No more tedious manual uploads, resource-intensive transformations, and waiting for scheduled tasks. Deploy and manage your self-service Google Spanner data pipeline in minutes not months.

Ensure quality data every time.

No matter how you need to combine and transform data stored in Google Spanner, ensure that the end result is high-quality data, every time. Dataprep by Trifacta automatically surfaces outliers, missing data, and errors and its predictive transformation approach allows you to make the best possible transformations to your data.

Schedule, automate, repeat.

Automate your Google Spanner data pipelines with job scheduling so that the right data is in your Google Spanner database when you need it. When new data lands in your Google Spanner database, let your scheduled data pipelines do the work of preparing it for you—no manual intervention required.


"Designer Cloud allows us to quickly view and understand new datasets, and its flexibility supports our data transformation needs. The GUI is nicely designed, so the learning curve is minimal. Our initial data preparation work is now completed in minutes, not hours or days."


Use cases for the Google Spanner data connector

  • ETL Google Spanner data to Amazon Redshift

  • ETL Google Spanner data to Google BigQuery

  • ETL Google Spanner data to Snowflake

  • ETL Google Spanner data to Databricks

  • ETL Google Spanner data to MySQL

  • ETL Google Spanner data to Microsoft Azure

  • Join Google Spanner data with Google Sheets data

  • Prepare Google Spanner data for data visualization in Tableau

You are in good company with professionals from the world's leading companies