New Statement: ALTER FOREIGN TABLE
Support for Named JSON Arrays
Updated JSON External Files.
Error Tables for Foreign Tables
Updated CREATE FOREIGN TABLE.
Google Cloud Authorizations for Foreign Tables
Fallback Subtables Not Compressed by Default
FAST MODE for ALTER TABLE Statement
Updated ALTER TABLE.
AUTHORIZATION for READ_NOS
USING Clause for CREATE AUTHORIZATION
INVOKER and DEFINER, which appear in the syntax of the following statements, are deprecated for NOS:
17.05 syntax is deprecated (supported but not recommended).
UDF Search Path
Native Object Store
Added CREATE FOREIGN TABLE, including syntax, options, usage notes, and examples. Updated DROP TABLE to add the FOREIGN keyword. Updated COLLECT STATISTICS (Optimizer Form) to add Example: Collecting Statistics on a Foreign Table Column. Added Example: SHOW TABLE for Foreign Table. Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION to include the USING clause, where you can specify security parameters for accessing remote repositories. Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING to add the EXTERNAL SECURITY clause . Updated CREATE storage_format SCHEMA to add Example: Schema for DATASET Type with CSV Storage Format.
JSON Auto Composition and Shredding
Updated CREATE TABLE and CREATE TABLE AS column attributes to add the AUTO COLUMN option. Added AUTO COLUMN and Examples: Creating a Table with a JSON Auto Column.
Updated ALTER TABLE column attributes to add the AUTO COLUMN option. Added AUTO COLUMN and Examples: Adding and Removing the JSON Auto Column Option.
Function Mapping Variable Substitution
Function Mapping for Native Functions
Algorithm 3 is the new default mode for DBQL Logging
The Database Query Log (DBQL) is enhanced for Advanced SQL Engine 17.00 with more complete and accurate logging. DBQL now uses Algorithm 3 by default, which includes collecting statistics on aborted and parallel steps, and results in more accurate resource usage statistics. Upgraded systems that were not previously using Algorithm 3 will not use Algorithm 3 until explicitly configured to do so. See BEGIN QUERY LOGGING m and REPLACE QUERY LOGGING m.