AWS Fundamentals Logo
AWS Fundamentals
aws lakeformation

AWS AWS Lake Formation CLI Commands

61 CLI commands available for AWS Lake Formation.

CommandSample
add-lf-tags-to-resource

Attaches one or more LF-tags to an existing resource.

assume-decorated-role-with-saml

Allows a caller to assume an IAM role decorated as the SAML user specified in the SAML assertion included in the request. This decoration allows Lake Formation to enforce access policies against the SAML users and groups. This API operation requires SAML federation setup in the caller’s account as i

batch-grant-permissions

Batch operation to grant permissions to the principal.

batch-revoke-permissions

Batch operation to revoke permissions from the principal.

cancel-transaction

Attempts to cancel the specified transaction. Returns an exception if the transaction was previously committed.

commit-transaction

Attempts to commit the specified transaction. Returns an exception if the transaction was previously aborted. This API action is idempotent if called multiple times for the same transaction.

create-data-cells-filter

Creates a data cell filter to allow one to grant access to certain columns on certain rows.

create-lake-formation-identity-center-configuration

Creates an IAM Identity Center connection with Lake Formation to allow IAM Identity Center users and groups to access Data Catalog resources.

create-lake-formation-opt-in

Enforce Lake Formation permissions for the given databases, tables, and principals.

create-lf-tag

Creates an LF-tag with the specified name and values.

create-lf-tag-expression

Creates a new LF-Tag expression with the provided name, description, catalog ID, and expression body. This call fails if a LF-Tag expression with the same name already exists in the caller’s account or if the underlying LF-Tags don't exist. To call this API operation, caller needs the following Lake

delete-data-cells-filter

Deletes a data cell filter.

delete-lake-formation-identity-center-configuration

Deletes an IAM Identity Center connection with Lake Formation.

delete-lake-formation-opt-in

Remove the Lake Formation permissions enforcement of the given databases, tables, and principals.

delete-lf-tag

Deletes an LF-tag by its key name. The operation fails if the specified tag key doesn't exist. When you delete an LF-Tag: The associated LF-Tag policy becomes invalid. Resources that had this tag assigned will no longer have the tag policy applied to them.

delete-lf-tag-expression

Deletes the LF-Tag expression. The caller must be a data lake admin or have DROP permissions on the LF-Tag expression. Deleting a LF-Tag expression will also delete all LFTagPolicy permissions referencing the LF-Tag expression.

delete-objects-on-cancel

For a specific governed table, provides a list of Amazon S3 objects that will be written during the current transaction and that can be automatically deleted if the transaction is canceled. Without this call, no Amazon S3 objects are automatically deleted when a transaction cancels. The Glue ETL l

deregister-resource

Deregisters the resource as managed by the Data Catalog. When you deregister a path, Lake Formation removes the path from the inline policy attached to your service-linked role.

describe-lake-formation-identity-center-configuration

Retrieves the instance ARN and application ARN for the connection.

describe-resource

Retrieves the current data access role for the given resource registered in Lake Formation.

describe-transaction

Returns the details of a single transaction.

extend-transaction

Indicates to the service that the specified transaction is still active and should not be treated as idle and aborted. Write transactions that remain idle for a long period are automatically aborted unless explicitly extended.

get-data-cells-filter

Returns a data cells filter.

get-data-lake-principal

Returns the identity of the invoking principal.

get-data-lake-settings

Retrieves the list of the data lake administrators of a Lake Formation-managed data lake.

get-effective-permissions-for-path

Returns the Lake Formation permissions for a specified table or database resource located at a path in Amazon S3. GetEffectivePermissionsForPath will not return databases and tables if the catalog is encrypted.

get-lf-tag

Returns an LF-tag definition.

get-lf-tag-expression

Returns the details about the LF-Tag expression. The caller must be a data lake admin or must have DESCRIBE permission on the LF-Tag expression resource.

get-query-state

Returns the state of a query previously submitted. Clients are expected to poll GetQueryState to monitor the current state of the planning before retrieving the work units. A query state is only visible to the principal that made the initial call to StartQueryPlanning.

get-query-statistics

Retrieves statistics on the planning and execution of a query.

get-resource-lf-tags

Returns the LF-tags applied to a resource.

get-table-objects

Returns the set of Amazon S3 objects that make up the specified governed table. A transaction ID or timestamp can be specified for time-travel queries.

get-temporary-data-location-credentials

Allows a user or application in a secure environment to access data in a specific Amazon S3 location registered with Lake Formation by providing temporary scoped credentials that are limited to the requested data location and the caller's authorized access level. The API operation returns an error

get-temporary-glue-partition-credentials

This API is identical to GetTemporaryTableCredentials except that this is used when the target Data Catalog resource is of type Partition. Lake Formation restricts the permission of the vended credentials with the same scope down policy which restricts access to a single Amazon S3 prefix.

get-temporary-glue-table-credentials

Allows a caller in a secure environment to assume a role with permission to access Amazon S3. In order to vend such credentials, Lake Formation assumes the role associated with a registered location, for example an Amazon S3 bucket, with a scope down policy which restricts the access to a single pre

get-work-unit-results

Returns the work units resulting from the query. Work units can be executed in any order and in parallel.

get-work-units

Retrieves the work units generated by the StartQueryPlanning operation.

grant-permissions

Grants permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3. For information about permissions, see Security and Access Control to Metadata and Data.

list-data-cells-filter

Lists all the data cell filters on a table.

list-lake-formation-opt-ins

Retrieve the current list of resources and principals that are opt in to enforce Lake Formation permissions.

list-lf-tag-expressions

Returns the LF-Tag expressions in caller’s account filtered based on caller's permissions. Data Lake and read only admins implicitly can see all tag expressions in their account, else caller needs DESCRIBE permissions on tag expression.

list-lf-tags

Lists LF-tags that the requester has permission to view.

list-permissions

Returns a list of the principal permissions on the resource, filtered by the permissions of the caller. For example, if you are granted an ALTER permission, you are able to see only the principal permissions for ALTER. This operation returns only those permissions that have been explicitly granted.

list-resources

Lists the resources registered to be managed by the Data Catalog.

list-table-storage-optimizers

Returns the configuration of all storage optimizers associated with a specified table.

list-transactions

Returns metadata about transactions and their status. To prevent the response from growing indefinitely, only uncommitted transactions and those available for time-travel queries are returned. This operation can help you identify uncommitted transactions or to get information about transactions.

put-data-lake-settings

Sets the list of data lake administrators who have admin privileges on all resources managed by Lake Formation. For more information on admin privileges, see Granting Lake Formation Permissions. This API replaces the current list of data lake admins with the new list being passed. To add an admin, f

register-resource

Registers the resource as managed by the Data Catalog. To add or update data, Lake Formation needs read/write access to the chosen data location. Choose a role that you know has permission to do this, or choose the AWSServiceRoleForLakeFormationDataAccess service-linked role. When you register the f

remove-lf-tags-from-resource

Removes an LF-tag from the resource. Only database, table, or tableWithColumns resource are allowed. To tag columns, use the column inclusion list in tableWithColumns to specify column input.

revoke-permissions

Revokes permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3.

search-databases-by-lf-tags

This operation allows a search on DATABASE resources by TagCondition. This operation is used by admins who want to grant user permissions on certain TagConditions. Before making a grant, the admin can use SearchDatabasesByTags to find all resources where the given TagConditions are valid to verify w

search-tables-by-lf-tags

This operation allows a search on TABLE resources by LFTags. This will be used by admins who want to grant user permissions on certain LF-tags. Before making a grant, the admin can use SearchTablesByLFTags to find all resources where the given LFTags are valid to verify whether the returned resource

start-query-planning

Submits a request to process a query statement. This operation generates work units that can be retrieved with the GetWorkUnits operation as soon as the query state is WORKUNITS_AVAILABLE or FINISHED.

start-transaction

Starts a new transaction and returns its transaction ID. Transaction IDs are opaque objects that you can use to identify a transaction.

update-data-cells-filter

Updates a data cell filter.

update-lake-formation-identity-center-configuration

Updates the IAM Identity Center connection parameters.

update-lf-tag

Updates the list of possible values for the specified LF-tag key. If the LF-tag does not exist, the operation throws an EntityNotFoundException. The values in the delete key values will be deleted from list of possible values. If any value in the delete key values is attached to a resource, then API

update-lf-tag-expression

Updates the name of the LF-Tag expression to the new description and expression body provided. Updating a LF-Tag expression immediately changes the permission boundaries of all existing LFTagPolicy permission grants that reference the given LF-Tag expression.

update-resource

Updates the data access role used for vending access to the given (registered) resource in Lake Formation.

update-table-objects

Updates the manifest of Amazon S3 objects that make up the specified governed table.

update-table-storage-optimizer

Updates the configuration of the storage optimizers for a table.

Learn AWS the Practical Way

Our bi-weekly newsletter teaches hands-on AWS fundamentals. No certification fluff - just practical knowledge.

Subscribe to Newsletter

Learn AWS the Practical Way

Our bi-weekly newsletter teaches hands-on AWS fundamentals. No certification fluff - just practical knowledge.

Subscribe to Newsletter

Quick Stats

Total Commands61
ServiceLakeFormation