Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic shows the different ways to export query results as an ND-JSON file. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
end-object ] end-object' dialect_option: { {"format": "parquet" } | {"compression": {"uncompressed" | "snappy" | "gzip" | "brotli" | "zstd" | "lz4"} } } Parameter Descriptions for URI Supported as of MySQL 9.3.1. Export the query results as a CSV, ... This topic shows the different ways to export query results to Parquet ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
The Lakehouse feature of MySQL HeatWave enables query processing on data in Object Storage. MySQL HeatWave Lakehouse reads the source data from Object Storage, transforms it to the memory optimized MySQL HeatWave format, saves it in the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-vector-store-load.html
This topic contains the following sections: VECTOR_STORE_LOAD Syntax Syntax Examples See Also To learn about the privileges you need to run this routine, see Section 7.3, “MySQL HeatWave GenAI Roles and Privileges”. In earlier versions of MySQL, ... The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are stored in the bucket, and loads the embeddings into a new vector store ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-restoring.html
The restored DB System uses the same MySQL Administrator user name and password that was in effect when the backup was created. To restore a backup to a new DB System: In the MySQL HeatWave Console, select the Resources tab. Click the name of the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-privatelink-egress.html
Creating an Egress PrivateLink 6.2.2 Creating an Egress PrivateLink Use the MySQL HeatWave Console to create an Egress PrivateLink for providing private connectivity to an external system running in your AWS account. It can be used to replicate ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-privatelink-query.html
Creating a Query PrivateLink 6.1.1 Creating a Query PrivateLink Use the MySQL HeatWave Console to create a Query PrivateLink to provide connectivity for applications running in your AWS account to MySQL HeatWave on AWS DB Systems using private IP ...This task requires the following: A DB System in the Active ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-manage-regions.html
Manage Regions 21.1 Manage Regions The AWS region is shown at the top of the MySQL HeatWave Console. To change regions, click on AWS region name , and select the preferred region. To add a new region: Click on AWS region name , and select Manage ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-updating-authorized-principals.html
Updating Authorized Principals for a Query PrivateLink 6.3.3 Updating Authorized Principals for a Query PrivateLink Use the MySQL HeatWave Console to update the authorized principals of a Query PrivateLink. Do the following to update the authorized ...This task requires the following: A PrivateLink in the Active ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-connpooling.html
Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to create and set up the connection. Setting up pooling of MySQL connections with Spring is as simple as changing the data source ...