Request a Demo
Part III. Administration
Prev UpPostgres Pro AXE 1.1.1 DocumentationHome Next

Part III. Administration

This part describes the management of Postgres Pro AXE and its objects. For information about administering the Postgres Pro DBMS, refer to the official Postgres Pro documentation.

Table of Contents

18. Access Management
18.1. Stored Procedures and Privileges
18.2. Configuring the Postgres Pro AXE Administrator
18.3. Queries to Proxy Tables
18.4. Granting and Revoking Privileges (metastore.mgrant, metastore.mrevoke)
19. Secrets
19.1. Creating a Simple Secret (duckdb.create_simple_secret)
19.2. Retrieving Information about a Simple Secret (duckdb.show_simple_secret)
19.3. Deleting a Simple Secret (duckdb.drop_simple_secret)
20. Storages
20.1. Creating a Storage (metastore.add_storage)
20.2. Deleting a Storage (metastore.remove_storage)
20.3. Configuring the Parquet File Cache
20.4. Reading Storage Data
21. Analytical Tables
21.1. Creating an Analytical Table (metastore.add_table)
21.2. Renaming an Analytical Table (metastore.rename_table)
21.3. Creating a Postgres Pro View for an Analytical Table (metastore.create_view)
21.4. Deleting an Analytical Table (metastore.remove_table)
22. Columns
22.1. Creating a Column (metastore.add_column)
22.2. Renaming a Column (metastore.rename_column)
22.3. Changing Column Data Type (metastore.change_column_type)
22.4. Deleting a Column (metastore.delete_column)
23. Analytical Schemas
23.1. Creating an Analytical Schema (metastore.add_schema)
23.2. Deleting an Analytical Schema (metastore.remove_schema)
24. Shared Directories
24.1. Creating a Shared Directory (metastore.add_folder)
24.2. Deleting a Shared Directory (metastore.remove_folder)
25. Parquet Files
25.1. Adding Parquet Files to an Analytical Table (metastore.add_files)
25.2. Copying the Data from Heap Tables to an Analytical Table (metastore.copy_table)
25.3. Parquet File Storage Parameters
25.4. Marking Snapshots as Expired and Deleting Parquet Files
25.5. Deleting Intermediate Data (metastore.cleanup)
25.6. Retrieving Information About Cached Parquet Files
26. Metadata Catalog
26.1. Configuring the Metadata Catalog
26.2. Connecting to a Remote Server with the Metadata Catalog
26.3. Snapshot-Based Isolation and Atomicity
26.4. Configuring the Transaction Horizon
26.5. Metadata Tables
26.6. Reading Metadata
27. Hive Partitioning
Prev Up Next
17.2. Deleting Postgres Pro AXE Home Chapter 18. Access Management
epub pdf