SingleStore to Google Cloud Storage

singlestore-to-gcs.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 GCS 'bucket-name/messages.csv'
CONFIG '{"region":"us-east1"}'
CREDENTIALS '{"access_id": "your_google_access_key", "secret_key": "your_google_secret_key"}';