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