Export

This sync enables moving data from a user specified datawarehouse to the PostgreSQL.

SETUP

Configuring the Credentials

Select the account credentials which has access to relevant PostgreSQL account from the given list & Click Next

Credentials not listed ?: Click on + for adding new credentials and fill the form that pops-up.

Data Sync Details

Data Sync: Select Export & click Next
How do you want to fetch data?: Select whether you want to fetch data from the Data Model or from Table/ View.
Data Model: In case you want to fetch data using Data Model, select the data model that you would like to use for this sync. Checkout how to configure a model here.
Data Warehouse: In case you want to fetch data using Table/ View, select the data warehouse that you would like to use for this sync.
Table / View: Select the Table/ view in the data warehouse that you would like to use for this sync.

Setting Parameters

Parameter Description Values

Parameter	Description	Values
Fields Selection	*Dependent* *Required* Select the field(s) you would like to push in your slack here. To push all the fields, simple select "Select All Fields".	{Model Field Name, Destination Field Name}
Fetch Mode	*Required* This refers to the manner in which data will get updated : FULL will update the entire column(s) from the selected data, INCREMENTAL will update the fresh record(S) added since last fetch.	{Incremental,Full} *Default Value:* FULL
Incremental Key	*Dependent* *Required* This refers to the key using whihc the rows will be incrementally fetched for upload.	Enter a row number
Insert Mode	*Required* This refers to the manner in which data will get updated in the data warehouse, with 'Upsert' selected, the data will be upserted (only new records or records with changes) and with 'Append' selected, all data fetched will be inserted. Selecting 'Replace' will ensure the table is dropped and recreated with fresh data on each run. Recommended to use "Upsert" option unless there is a specific requirement.	`Upsert`, `Append`, `Replace` *Default Value:* Upsert
Upsert Key	*Dependent* *Required* This refers to the key on which the upsert has to be performed.	'NUMBER'

Fields Selection

Dependent Required

Select the field(s) you would like to push in your slack here. To push all the fields, simple select "Select All Fields".

{Model Field Name, Destination Field Name}

Fetch Mode

Required

This refers to the manner in which data will get updated : FULL will update the entire column(s) from the selected data, INCREMENTAL will update the fresh record(S) added since last fetch.

{Incremental,Full}

Default Value: FULL

Incremental Key

Dependent Required

This refers to the key using whihc the rows will be incrementally fetched for upload.

Enter a row number

Insert Mode

Required

This refers to the manner in which data will get updated in the data warehouse, with 'Upsert' selected, the data will be upserted (only new records or records with changes) and with 'Append' selected, all data fetched will be inserted. Selecting 'Replace' will ensure the table is dropped and recreated with fresh data on each run. Recommended to use "Upsert" option unless there is a specific requirement.

Upsert, Append, Replace

Default Value: Upsert

Upsert Key

Dependent Required

This refers to the key on which the upsert has to be performed.

'NUMBER'

Data Sync Scheduling

Set the schedule for the sync to run. Detailed explanation on scheduling of syncs can be found here

Dataset & Name

Give your sync a name and some description (optional) and click on Finish to save it. Read more about naming and saving your syncs including the option to save them as templates here

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.