Skip to main content

Create an Iceberg Writer application using TQL

Before creating an Iceberg Writer application you must perform the tasks described in Iceberg Writer initial setup.

Sample TQL:

CREATE TARGET IcebergTarget USING IcebergWriter ( 
  DataLakeType: 'GCS',
  DataLakeConnectionProfile: 'shared.GCSCP', 
  ComputeType: 'GoogleDataproc',
  ComputeConnectionProfile: 'shared.DataprocCP',
  CatalogType: 'Hadoop',
  CatalogConnectionProfile: 'shared.NessieCP', 
  IcebergTablesLocation: 'mybucket/tables', 
  ExternalStagingType: 'GCS',
  ExternalStageLocation: 'mybucket/staging', 
  Tables: 'src.%,src.%') 
INPUT FROM OracleSource;