SingleStore to AWS S3

singlestore-to-s3.sql

CREATE DATABASE IF NOT EXISTS acme;

USE acme;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO messages (
  content
) VALUES (
  'hello from SingleStore'
);

SELECT id, content, createdate
FROM messages
INTO S3 'bucket-name/messages.csv'
CONFIG '{"region":"us-east-1"}'
CREDENTIALS '{"aws_access_key_id":"YOUR_KEY","aws_secret_access_key":"YOUR_SECRET"}';