Configure NetSuite Analytics Warehouse (NSAW) as your Celigo sync destination with guided database selection, customizable table-name prefixes, and a dedicated schema for your sync's tables — making your synced data instantly recognizable and organized in the warehouse. This article walks you through each destination setting so your NSAW tables come out named and structured the way you expect.
Create a data ingestion sync
Follow the instructions in Create a data ingestion sync to create a sync and configure your source application.
Set up NSAW as your destination
- Select NetSuite Analytics Warehouse (NSAW) as the destination that will ingest and store all source data from the sync.
-
Choose an established connection, or select Create connection to create a new one (see Create a connection to an application).
Caution
Avoid sharing connections with flows scheduled at the same time, as running them simultaneously can reduce performance.
- Select the database that will store incoming data from the sync.
-
Name your destination schema - Celigo creates a schema based on the objects, exports, and fields you selected when configuring the source application. Give the schema a meaningful name to help you identify the destination tables that correspond to it later.
Note
This schema is for use only with this sync. Be careful when entering its name — you can't change it after you save and run the sync.
-
Enter a table prefix to customize the names of tables created in your destination database. A prefix is a brief label added to the start of each table name to help identify the source or type of data (for example, entering
sf_for Salesforce data produces tables likesf_accounts).
This sync names your destination tables using the following structure: <database>.<schema>.<prefix><table>
-
<database>- The destination database. -
<schema>- The custom schema name. -
<prefix>- The prefix label (if any). -
<table>- The specific object, export, or custom table name selected for sync.
Define sync settings
Name and describe your sync and choose whether to receive email notifications (see Edit or view a sync's settings). Next, decide how often the sync should run (see Schedule and run a sync for the full set of scheduling options).
What happens next
After you save your sync's settings, the wizard is complete and you're returned to the sync's dashboard. The dashboard shows a "Ready to run" state — your sync is active, but hasn't loaded any data yet. Select Run to trigger the first run yourself, or wait for its next scheduled run.