Features guides

In this section:

• Saved queries
  • How saved queries work
  • Parameters support
  • Saving a query
    • Saving a simple query
    • Saving a parametrized query
  • Listing and executing saved queries
• External Tables
  • What kind of data is supported?
  • What kind of data staging is supported?
  • Using external tables - a practical example
    • Planning for data staging
    • Creating the external table
    • Querying external tables
    • Modifying data from staging
    • Converting an external table to a standard database table
  • Error handling and limitations
• Python UDF (user-defined functions)
  • A simple example
  • Why use UDFs?
  • SQream DB’s UDF support
    • Scalar functions
    • Python
    • Using modules
  • Finding existing UDFs in the catalog
  • Getting the DDL for a function
  • Error handling
  • Permissions and sharing
  • Best practices
• Deleting data
  • How does deleting in SQream DB work?
    • Phase 1: Logical Delete
    • Phase 2: Clean-up
  • Notes on data deletion
    • Deleting data does not free up space
    • Select performance on deleted rows
    • Use TRUNCATE instead of DELETE
    • Cleanup is I/O intensive
  • Example
    • Deleting values from a table
    • Deleting values based on more complex predicates
    • Identifying and cleaning up tables
      • List tables that haven’t been cleaned up
      • Identify predicates for clean-up
      • Triggering a cleanup
• Transactions
• Workload manager
  • Why use a workload manager?
  • Setting up service queues
  • Example - Allocating resources for ETL
    • Creating this configuration
    • Verifying the configuration
  • Configuring a client to connect to a specific service
    • Using sqream_sql_cli_reference
    • Using JDBC
    • Using odbc
    • Using pysqream
    • Using nodejs
• Concurrency and locks
  • Locking modes
  • When are locks obtained?
    • Global locks
  • Monitoring locks
  • Troubleshooting locks
    • Example
• Concurrency and scaling in SQream DB
  • Scaling when data sizes grow
  • Scaling when queries are queueing
  • What to do when queries are slow
• Access control
  • Overview
  • Roles
    • Creating a user
    • Dropping a user
    • Altering a user
    • Public Role
    • Groups
  • Permissions
    • GRANT
    • REVOKE
    • Default permissions
  • Departmental Example
• Seeing system objects as DDL
  • Dump specific objects
    • Tables
      • Getting the DDL for a table
      • Exporting table DDL to a file
    • Views
      • Listing all views
      • Getting the DDL for a view
      • Exporting view DDL to a file
    • User defined functions
      • Listing all UDFs
      • Getting the DDL for a function
    • Exporting function DDL to a file
    • Saved queries
  • Dump entire database DDLs
    • Exporting database DDL to a client
    • Exporting database DDL to a file