Skip to main content
Version: current [25.x]

ALTER SOURCE

Change the source.

Syntax
ALTER SOURCE <source_name>
{ CLEAR PERMISSION CACHE | REFRESH STATUS }

To run ALTER SOURCE, you need the MODIFY privilege on the source.

Parameters

<source_name> String

The name of the source to alter.


CLEAR PERMISSION CACHE Optional

Clears the AWS Lake Formation permission cache and applies only to the AWS Glue Data Catalog.

Dremio keeps a cache of permissions defined in AWS Lake Formation with a one-hour expiry time. When the cache for the queried table expires, Dremio requests permission information from AWS Lake Formation. After changing permissions on the AWS Lake Formation side, use CLEAR PERMISSION CACHE to immediately invalidate Dremio's AWS Lake Formation permission cache.

note

Any changes made to the AWS Glue Data Catalog settings also clears the Lake Formation permission cache.


REFRESH STATUS Optional

Refreshes the status for a given source.

Examples

Clear the Lake Formation permission cache for an AWS Glue source
ALTER SOURCE glue1
CLEAR PERMISSION CACHE
Refresh the status for an Amazon S3 source
ALTER SOURCE S3
REFRESH STATUS