mwellbro / exa-toolbox

exa-toolbox

Please note that this is an open source project which is not officially supported by Exasol. We will try to help you as much as possible, but can't guarantee anything since this is not an official Exasol product.

The EXA-toolbox is a collection of useful scripts and views that you can add to your Exasol installation. Copy the script load_scripts_from_github.sql into the SQL-editor of your choice and execute it. This will automatically pull all the scripts in this repository to your database and create them.

Table of Contents

• JSON
  • JSON table script
  • JSON flattening script
    • How it works
    • Examples
    • Behavior of the script
    • Limitations
  • json_value
  • isjson
• Geospatial functions
  • Generic geospatial functions
  • ST_HaversineDistance
  • ST_GeomFromGeoJSON
• Microsoft SQL Server compatibility
  • CONVERT_TO_DATE
  • DATEADD
  • DATEDIFF
  • DATENAME
  • DATEPART
  • GETUTCDATE
  • NEWID
  • JSON_VALUE
  • ISJSON
• System views
  • SCHEMA_SIZES
  • TABLE_SIZES_TOP_100
  • AUDITING_LONG_RUNNING_DML_LAST24HOURS
  • AUDITING_LONG_RUNNING_DQL_LAST24HOURS
  • PROFILE_OF_RUNNING_QUERIES
  • GENERAL_SYSTEM_INFO
  • SESSIONS
  • DB_SIZE_LAST_DAY
  • DB_SIZE_DAILY
• Utilities
  • bucketfs_ls
  • check_connectivity
  • check_tcp_listener_connection
  • upload_github_release_file_to_bucketfs
  • language_info
  • number_of_cores
  • pub2slack
  • database_warmup
  • session_watchdog
  • ldap_sync
  • create_table_ddl
  • create_view_ddl
  • create_db_ddl
  • 3rdLevelStatistics
  • Union_All_Optimization_-_generate_view
  • open_transactions
• Preprocessing