Skip to main content

Prevent users from creating or using specific resource types

Self-hosted organizations can specify optional restrictions using environment variables that prevent users from creating or using certain resource types. The restrictions you set depend upon your use case. Configuring these restrictions does not remove or modify the configuration of an existing resource.

Any restrictions you set can be reverted at any time. This enables you to temporarily disable resources (e.g., if your security team needs to review an integration before it can be used).

Prevent users from creating certain resource types

Use the RESOURCE_TYPES_CREATION_DENY_LIST environment variable to specify a comma-separated list of resource integration types that cannot be created. Users can still interact with any existing resources of these types but they will not be able to create new ones.

RESOURCE_TYPES_CREATION_DENY_LIST=graphql,twilio,postgresql

Prevent users from creating or using certain resource types

In some cases, you may need to block all use of a certain resource type. You can use the RESOURCE_TYPES_DENY_LIST environment variable to provide a list of all resource integration types that are to be blocked. This effectively disables the resource type on the deployment instance, preventing users from creating and querying resources of these types.

RESOURCE_TYPES_DENY_LIST=graphql,twilio,postgresql

Once enabled, any queries for restricted resources will not run and return a query error.

The error message displayed in self-hosted Retool 3.300 and later also explains that that query failed due to the resource being restricted. Prior releases only return a query error.

Specify the environment variable values

Both environment variables can accept a comma-separated list containing any of the following resource type values. Refer to the self-hosted deployment tutorials to learn more about configuring environment variables for your instance.

ResourceType
PostgreSQLpostgresql
MySQLmysql
MSSQLmssql
OracleDBoracledb
Redshiftredshift
MCPmcp
MongoDBmongodb
Google Sheetsgooglesheets
Elasticsearchelasticsearch
Cassandracassandra
CosmosDBcosmosdb
CouchDBcouchdb
RethinkDBrethinkdb
REST APIrestapi
GraphQLgraphql
BigQuerybigquery
S3s3
GCSgcs
Slackslackopenapi
Salesforcesalesforce
Athenaathena
GitHubgithub
Stripestripe
Twiliotwilio
SendGridsendgrid
Firebasefirebase
DynamoDBdynamodb
Basecampbasecamp
Close.iocloseio
Snowflakesnowflake
Redisredis
Verticavertica
Prestopresto
SAP Hanasaphana
Lambdalambda
OpenAPIopenapi
Google Cloud Datastoredatastore
gRPCgrpc
SMTPsmtp
Jirajira
BigIDbigid
AlloyDBalloydb
Databricksdatabricks
Databricks LakebasedatabricksLakebase
JDBCjdbc
Kafkakafka
SQSsqs
SNSsns
Tavilytavily