The info in this doc is only applicable to Redshift data warehouses.
"Permission denied for schema [name]."
If you've received this error, the root cause is probably permissions-based. Whether there are insufficient permissions or permissions were revoked as a whole, it's likely the Redshift user that Stitch is using to load data is being restricted in a way that prevents successful data replication.
To successfully pipe your data to your Redshift data warehouse, the Stitch user must:
CREATEschemas, tables, and views
SELECTfrom systems tables
ALTER TABLEcommands to properly insert your data.
Restricting the Stitch user to a single schema or revoking public access to tables in the information schema will prevent Stitch from functioning properly.
For reference, you can find the full list of Redshift permissions here.
If you encounter this error, we recommend first verifying that the Redshift user has the permissions listed above. If the user does have these permissions and the error persists, reach out to support.