There are a few notable differences in how publish jobs are configured for Hadoop-HDFS and Hive and Amazon-S3 and Redshift targets.
When publishing to these target types users must provide directory filepaths to the file system target destination.
When publishing to these target types users also must provide a prefix that combined with the source name (prefix + SourceName) becomes the TableName in the case of
The following example details definition of an
1. TARGET definition
Select a dataset to publish.
Publish Job Name: Name the publish job.
Target: Choose a pre-defined Amazon-S3 and Redshift Target.
Target Directory Path: Enter an existing directory or create a new one. For this example, the newly created directory is "demo2".
Redshift Database Prefix: Enter a prefix, this will become the prefix of the table name. For this example, the prefix is "prefix3".
2. ENTITY, SCHEDULE, CONFIRM screens
Stage through screens to configure the publish job. Save and execute the job.
3.AWS Target Confirmation + Redshift View
Select that bucket to see the new folder that was defined in "Target Directory Path" ("demo2").
Select the folder "demo2" that was created by the publish job.
The name of the source(s) that were published (for this example, "INDEXSN") will display. Select the source name to view the published tables.
Drill in to view the partition (example: demo2/INDEXSN/CPI_OtherWest/20181210065143/good/000000_0)
Navigate to the
Select the view (eye) icon on any table of interest to auto-generate a query that will produce a table view that can be saved and downloaded.