if the data stream does not exist, it will be created. (Optional) In the Stream Override text box, enter the data stream name you want to add data to.(Optional) From the Since Timestamp input, enter the earliest timestamp to import records from only records with a Timestamp Column after this date will be imported.(Optional) From the Record Timestamp Column input, select the timestamp column to use as event timestamps, if left blank the Timestamp Column will be used.From the Timestamp Column input, select the timestamp column to order the events.From the Table input, select the Redshift table to import data from.Leave blank to use the authorization's setting. (Optional) From the SSL mode input, select the SSL mode to use to connect to the database.Follow these instructions to obtain your DB URL copy the Endpoint from the general information page (the area as the JDBC URL in the Amazon instructions). (Optional) In the DB URL text box, enter the Redshift URL to connect to.Complete the configuration steps for your job.(Optional) Enter a Description for further context on your job.Enter a Label to identify this job you are creating in Lytics.Select the Authorization you would like to use or create a new one.Select the Import Redshift Table job type from the list.Select Amazon Web Services (AWS) from the list of providers.At this time Redshift RT is most helpful for scenes primarily made up of hard surface models and shaders due to current limitations for things like subsurface and hair shading commonly found with more organic assets. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information. Redshift Real Time - Redshift Documentation - Global Site Redshift Real Time Redshift Real Time is currently in beta. Configurationįollow these steps to set up and configure an import Redshift table job for Amazon Web Services (AWS) in the Lytics platform. By default the data will be added to the redshift_table_name data stream, where table_name is the name of the Redshift table imported. Repeat steps 2 and 3 until the entire temporary table is read.īecause of the nature of Redshift data, there is no default mapping defined.Query a batch of rows from the temporary table.Only rows that have a timestamp after the last import, or Since Date will be included.Adds a column for consistent ordering of data.Create a temporary table containing a snapshot of the database to query against.

This integration connects to your Redshift table through a PostgreSQL connection and then completes the following steps: Frequency: Batch with frequency configurable from hourly to weekly.Implementation Technique: PostgreSQL connection.Import user data directly from your AWS Redshift database into Lytics, resulting in new user profiles or updates to fields on existing profiles. Export Audience (Microsoft Advertising).Google Analytics: Setup Custom Dimensions.

Redshift documentation