Request a Demo
Part IV. Administration
Prev UpPostgres Pro AXE 1.1.0 DocumentationHome Next

Part IV. Administration

Table of Contents

22. Access Management
22.1. Stored Procedures and Privileges
22.2. Configuring the Postgres Pro AXE Administrator
22.3. Queries to Proxy Tables
22.4. Granting and Revoking Privileges (metastore.mgrant, metastore.mrevoke)
22.5. Privilege Management Scenario
23. Secrets
23.1. Creating a Simple Secret (duckdb.create_simple_secret)
23.2. Retrieving Information About a Simple Secret (duckdb.show_simple_secret)
23.3. Deleting a Simple Secret (duckdb.drop_simple_secret)
23.4. Scenario: Secret Management
23.5. Scenario: Separating Read and Write Access to an S3 Storage
24. Storages
24.1. Creating a Storage (metastore.add_storage)
24.2. Deleting a Storage (metastore.remove_storage)
24.3. Scenario: S3 Storage Connection
25. Analytical Tables
25.1. Creating an Analytical Table (metastore.add_table)
25.2. Renaming an Analytical Table (metastore.rename_table)
25.3. Creating a Postgres Pro View For an Analytical Table (metastore.create_view)
25.4. Deleting an Analytical Table (metastore.remove_table)
26. Columns
26.1. Creating a Column (metastore.add_column)
26.2. Renaming a Column (metastore.rename_column)
26.3. Changing Column Data Type (metastore.change_column_type)
26.4. Deleting a Column (metastore.delete_column)
27. Analytical Schemas
27.1. Creating an Analytical Schema (metastore.add_schema)
27.2. Deleting an Analytical Schema (metastore.remove_schema)
28. Shared Directories
28.1. Creating a Shared Directory (metastore.add_folder)
28.2. Deleting a Shared Directory (metastore.remove_folder)
29. OLAP Data
29.1. Adding Parquet Files to an Analytical Table (metastore.add_files)
29.2. Copying the OLAP Data from Heap Tables to an Analytical Table (metastore.copy_table)
29.3. Description of Parquet File Storage Parameters
29.4. Marking Snapshots as Expired and Deleting Parquet Files
30. Hive Partitioning
31. Configuring the Transaction Horizon
Prev Up Next
21.2. Deleting Postgres Pro AXE Home Chapter 22. Access Management
epub pdf