Sync to External Target

Sync-to-external-target is supported from data lake environments (Databricks, Dataproc, Amazon EMR).

Is it not supported from CDW environments (Snowflake, BiqQuery).

Feature

External Targets










Snowflake

Oracle

SQL Server

Teradata

Azure Cosmos DB

(Spark 2.x and Scala 2.12 is NOT supported)

Azure Synapse (SQL DW)

BiqQuery (except EMR 6.6)

Postgre SQL 15.13/GCP Cloud SQL (only Postgre SQL)

Delimited Files

Full Export

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes


Incremental Export

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes


Exported Table Creation

Yes

Yes

Yes

Yes

Yes

Yes

Yes

-


Export to Existing Table

Yes

Yes

Yes

Yes

No

Yes

Yes

-


Column Projection

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes


Schema Sync

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes












xxx

  Last updated