arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

Querying Redshift Data

Prerequisites:

  • Redshift integration configured with Immuta

  • Redshift tables registered as Immuta data sources

  • REVOKE users' access to raw tables

hashtag
Query data

  1. Use your tool of choice to connect to Redshift.

  2. Select the Immuta database name used when .

  3. Query the Immuta-protected data, which takes the form of immuta_database.backing_schema.table_name:

Immuta Database: The Immuta database name used when configuring the integration.

  • Backing Schema: The schema that houses the backing tables of your Immuta data sources.

  • Table Name: The name of the table backing your Immuta data sources.

  • Run your query (it is recommended that you use the catalog in the query). It should look something like this:

  • configuring the integration
    select * from immuta_database.backing_schema.table_name limit 100