In the third view, you should see a confirmation that your source was created.Finally, attach the policy you created to the role you created by copy pasting the command in the AWS CLI.Running this command grants the Mixpanel Service Account the necessary permissions to read and export data from your Redshift tables. After inputting a role name, you can either copy paste the JSON in the AWS UI or copy paste the inline command line version that we generate and run in the AWS CLI. Role Name - Input the name of the role.After inputting a policy name, you can either copy paste the JSON in the AWS UI or copy paste the inline command line version that we generate and run in the AWS CLI. (Optional) Policy Name - This is an optional name for the policy, which contains role permissions that you need to grant the Mixpanel Service Account.Database Name - Input the name of the Database where the tables you want to import are stored.Copy the command generated below in the AWS CLI to create the S3 Staging Bucket with the name you specified.We'll use it to extract data from your Redshift tables before importing the data into Mixpanel. S3 Staging Bucket - This is the name of S3 staging bucket you need to create.AWS Region - The region code in which your Redshift cluster resides.In the second view, you will need to add the following.Cluster ID - This is the name of the Redshift cluster.AWS Account ID - This is the AWS account ID that can be found in the dropdown in the AWS Redshift Console.In the first view, fill out the following fields before clicking Next: You should see a new page to create your Redshift connector.Click on + Add Connection and select Redshift.Navigate to Project Settings, then select Warehouse Sources.Complete the following steps to get your Redshift connector up and running:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |