Spark Catalogs
IOMETE offers a feature for configuring Spark Catalogs interface.
Catalog list
To view Spark Catalogs, navigate to the Settings
menu item and switch to the Spark Catalogs
tab.
In the list below, you'll find the Spark catalog. The default catalog created by the system is called spark_catalog
.
![Spark Catalogs | IOMETE](/resources/assets/images/spark-catalogs-efb74a37c75b201fe688281649d9d0fb.png)
![Spark Catalogs | IOMETE](/resources/assets/images/spark-catalogs-dark-55faa7e3b3df500d16cf7d45b96e4cf6.png)
Add catalog
To add new catalog item, click Add catalog
button. You'll see following inputs:
- Name
- Lakehouse directory
- Type - Currently, only 'iceberg' type is supported.
![Spark Catalog create | IOMETE](/resources/assets/images/catalog-create-af67c175e88350bc7fda6b9b237f1fbd.png)
![Spark Catalog create | IOMETE](/resources/assets/images/catalog-create-dark-0304790b70bcf90d5dc5d13eb9b9ffe6.png)
For custom credentials, click on the Configure credentials
radio button. Then, you'll see additional input fields for your credentials.
- Endpoint - If using AWS S3 you can omit the endpoint, for Minio and Dell ECS storage providers the endpoint is mandatory.
- Access key
- Secret key
![Spark Catalog create | IOMETE](/resources/assets/images/create-credentials-d6fc244dda2810d56c43360ef40ccf43.png)
![Spark Catalog create | IOMETE](/resources/assets/images/create-credentials-dark-ef12610ecaf16456aa6d74ab66afa7bf.png)
After filling all inputs click Add
.
![Spark Catalogs | IOMETE](/resources/assets/images/spark-catalog-list-ccad218e96b4c563c2300d81f33f7dd3.png)
![Spark Catalogs | IOMETE](/resources/assets/images/spark-catalog-list-dark-a53b4e48983e13b8fdd843386be34239.png)
Editing and deleting the default
catalog is not permitted; you can only make changes to other catalogs.
Catalog in SQL Editor.
Go to the SQL Editor to view the Spark catalog that has been created.
Check out the Database Explorer
section in the left panel. If you don't see the created catalog, please refresh by using the button.
In the given image, we have already created some databases and tables inside the catalog.
![Spark Catalogs in SQL Editor | IOMETE](/resources/assets/images/sql-editor-catalogs-412d25382b6430859f64735a4096e93d.png)
![Spark Catalogs in SQL Editor | IOMETE](/resources/assets/images/sql-editor-catalogs-dark-cd5c820526a2eeff4b45228e9a9c1cef.png)