This connector extracts column-level data profiles from a Redshift database using asyncpg library.
You must run the connector using a user with SELECT privilege to all tables.
You can use the following command against all schemas:
GRANT SELECT ON ALL TABLES IN SCHEMA [Schema] TO [User]The config file inherits all the required and optional fields from the general Redshift connector Config File.
See Sampling Config for details.
Follow the Installation instructions to install metaphor-connectors in your environment (or virtualenv). Make sure to include either all or postgresql extra.
Run the following command to test the connector locally:
metaphor redshift.profile <config_file>Manually verify the output after the run finishes.