Querying federated catalogs
After you grant permissions to other principals, they can sign in and start querying the tables in the federated catalogs by logging into the SQL tools using Amazon Redshift, Amazon EMR, Amazon Athena, and Amazon Glue ETL.
For more information on connecting to the Amazon Glue Data Catalog using Apache Iceberg Rest extension endpoint or standalone Spark application, see Accessing the Amazon Glue Data Catalog section in the Amazon Glue Developer Guide.
You can use the data definition language (DDL) queries to create and manage tables in the database using Apache Spark on Amazon EMR.
To create and delete tables in the Amazon Redshift database, the principal must have Lake Formation Create table
, Drop
permissions.
For more information on granting Data Catalog permissions, see Granting permissions on Data Catalog resources.
For more information on querying the catalog resources from Amazon Athena, see Querying Amazon Glue Data Catalog from Amazon Athena in Amazon Athena User Guide.