Access data in Redshift
Last updated
Was this helpful?
Last updated
Was this helpful?
In order to make the Data Observatory subscriptions accessible in your Redshift account, first of all CARTO needs to create and register your subscriptions in your CARTO account. Once this first step has been done, Admin users of your CARTO organization will be able to see the list of active subscriptions in the Data Observatory section in Settings.
Once your subscriptions have been created, the CARTO team will proceed with the data transfers so to make the data accessible directly on your Redshift account. Please contact your CARTO representative if you need to start this process on demand (e.g. public data subscriptions).
In order to make your subscriptions available in your Redshift account, CARTO will share you access to the data in an S3 bucket (which can be provisioned by you or by CARTO). We will give you the instructions in order to create the tables in the Redshift database by loading the files directly from the S3 bucket.
In order to be able to share access to the data via an S3 bucket in AWS we will need your AWS ID (12-digit number).
In order to use the data from your Data Observatory subscriptions that have been transferred directly to your Redshift account you should not use the Data Observatory tabs in Data Explorer, Workflows or Builder, but directly your own Redshift connections.
You need to ensure that the tables that you have created from the S3 buckets are accessible from your Redshift connections.
